Quick tips

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.

How to use Spell Check in Google Docs, Slides and Sheets

With the development of digital technologies, the mistakes you make in your spelling are becoming easier and easier to fix. Did you realise Google not only has the little red line to help you fix these mistakes, it also has a spell checker built right into Docs, Slides and Sheets.

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.

ClassroomScreen – A great, free tool for you and your students!

ClassroomScreen is a brilliant, FREE tool that allows you to customise a screen with widgets (tools) that will support classroom management and engagement. Your and your students will love how easily and quickly you can communicate with it. The symbols are great for learning about visual literacy too.

Create animations and Pecha Kucha presentations in Google Slides

Publishing your Google Slides to the web allows you control over how viewers see your slides. Go a step further and customise the auto-advance speed to create fun animations and timed Pecha Kucha style presentations.

How to create a Hyperdoc to encourage independent learning in your classroom

Encouraging our students to work independently can be a challenge at the best of times. By introducing hyperdocs into our class programmes we can begin to move our students towards working more self sufficiently. Here’s a beginners guide to creating effective hyperdocs to use in your classroom.

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.

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