Author: Adrian Francis

Reflective teaching using the time-lapse feature on iPad

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

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.

Create your own personalised translator in Google sheets

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.

The line of best fit and scatterplots in Google Sheets

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.

Immersive reader and accessibility tool

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.

Conditional formatting and data validation in a Google Sheet

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.

Download your skills checklist to see how you score...

 

Get the Latest Blog Posts, New Tips And Tricks

 

NSW DoE Leadership Webinars

 

NSW DoE Leadership Webinars

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: