Many of us are tentative to use spreadsheets because we are unsure of what they can do and how to use them. Google Sheets can save you time and provide valuable insights into the data you have. When you pair this with the capacity to work collaboratively, then the power of sheets is fully utilised. This video will show you how.
Author: Adrian Francis
There are some useful functions native in Microsoft Office 365 that help you research and create great presentations that can make learning easier. In the classroom, helping students research and summarise is a skill we need to develop. These tools will help stem the cut and paste epidemic.
The custom number format allows you to have text and numbers in the same cell in a Google Sheet. This adds visual clarity to your spreadsheet and helps the user enter data. Calculations are still possible as Google Sheets ignores the text you have entered and uses the numerical data in the cell.
Time has become a precious commodity and when I ask teachers about what they would like, they reply ‘more time’. The lack of time is a constant issue. The good news is, you can win back some time by putting into place these four practices.
There are many uses for Google Sheets in the classroom. I like to be able to have my own class list where I can keep track of my students. I would use a sheet for attendance, recording homework, anecdotal notes and marks. Many LMS’s can do this, but I like the ability to customise what I see and enter, Google Sheets allow me to do this easily.
A major sticking point with moving from Excel to Google Sheets was the lack of ability to use macros. A macro will let you automate calculations and other aspects in spreadsheets. For instance, if you regularly tally up marks, allocate a grade and then draw a graph or chart of the results for your class, the you can create a macro to do this for you. Google Sheets now have the capacity to write and run you own macros. This will increase your efficiency and save you time.
With more documentation being digital, occasionally the need arises to be able to add notes or sign a PDF. Previously this involved printing the document, signing it, uploading it and then scanning it before sending it. Markup solves this problem and can be used easily on an iPad or iPhone.
Before laptops were common, when I was working on a project I would have several books open and many pieces of paper all on a big table. Nowadays we can have the same experience by using multiple desktops to multi task.