It is easier to see trends in data when you have icons and colour. This can be done using custom number formats in Google Sheets
Author: Adrian Francis
It would be great if we could observe our own classes from a distance and then analyse what is going on and reflect, identify areas of strength and growth. By using the time lapse feature on an iPad (or on iPhone) you can easily reflect on your teaching practice.
Using named ranges in Google Sheets will stop cell references being messed up inside formulas when you copy or move cells. They also help you become more efficient in creating great, functional spreadsheets.
How could you combine a language lesson with mathematics and spreadsheets? The magic of Google sheets allows us to be able to use certain functions to create our own language translating spreadsheet using Google translate. Follow these three steps to create your own personalised translator for you and your students.
Collecting data and finding the strength of the relationship between the variables, a method used in statistics. Making a scatterplot and finding the line of best fit or trendline in Excel was a piece of cake. I could never do it in Google Sheets until I found a solution! It is easy to build a meaningful scatterplot, put in a trendline and find the correlation coefficient within a couple of clicks.
There are some great functions native in Microsoft O365 that assist people to access technology making learning easier. Not only can handwriting be converted to text and read to you in OneNote, but the Immersive reader can assist access to the information on your screen. Additionally, the accessibility tool informs you if what you have written is easily accessible to others.
A Google Sheet can have a lot of data and it can be hard to quickly find what you want. Sometimes the data that has been entered is not in a format you can use easily. By using colour and restricting the data that can be entered into the Google Sheet this hurdle can be removed.
With the latest update of Windows 10 there are some great new functions built in to the operating system that help us to be more efficient with how we work and manage our digital workflow.