Custom Number Formatting in Google Sheets
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
Menu
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
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.
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.
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.
