Adrian Francis

Adrian lives the passion and intuitive pedagogy of contemporary education and is a full-time trainer at Using Technology Better. He is accredited as a Microsoft Peer Coaching Master Facilitator, a Microsoft Master Educator, a Google Certified Innovator, a Level 1 and 2 Google Certified Educator an Apple Learning Specialist and an Apple Distinguished Educator. With over 30 years experience working in Schools with an ICT and Curriculum focus, Adrian has lead teams in using digital tools to transform teaching and learning.

Custom Number Formatting in Sheets

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

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.

How the April 2018 Microsoft Windows 10 Update helps you become more efficient

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.

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