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.

Google Sheets – Sorting, filtering and formatting

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.

Researcher and Outline in Office 365

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.

Customising Google Sheets cells to display text and numbers

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.

Winning back time

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.

Google Sheet tips

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.

Macros in Google Sheets

Macros in Google Sheets

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.

Using Markup and annotation in iOS

Using Markup and annotation in iOS

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.

Multiple Desktops (1)

Multiple desktops allow you to multitask

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.

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