Tag: Google Sheets

Google Sheets

Three simple tips for working with data in Google Sheets

We can get frustrated with spreadsheets because they don’t do what we want them to do, or we just think that they are used by statisticians. With more data around than ever before, especially in schools, it can be hard to use the data well. Here are three simple hints in Google Sheets that allow you to be able to analyse and display your data like an expert.

Top 7 Mail Merge Add-Ons for Gmail & Google Drive

Mail merge is one of those great time-saving features that people love. That’s probably why we get heaps of questions about the best way to do it in Gmail and Google Drive. In this blog post we’ll share the top five mail merge add-ons available in G Suite and help you choose the best one for your situation.

spreadsheet_8

Spreadsheet Copy Down Chaos

By understanding what the spreadsheet is doing and learning a couple of handy hints, you will be creating spreadsheets quicker and using them more effectively to improve your workflow.

Keep track of student grades in Google Classroom

In Google Classroom, you can assign grades to question and assignment tasks given to your students. Although Classroom does not yet have an in-built gradebook, it is still possible to keep track of student grades across different tasks using a linked Google Sheet. This shows students’ grades for each task, as well as average grades for individual students and the class.

G-Suite_6

3 Steps to creating grade books in Google Workspace

You may have been to a workshop or conference, heard and learnt a vast array of new things and you head back to school full of enthusiasm to implement all that you have learnt. In your head you have all these ideas about how to revolutionise your classroom, until the reality of being back in the classroom hits home. Time tends to fly and good intentions slowly erode.

Conditional formatting: Tracking student progress with Google Sheets

With Google sheets you can track student progress and easily visualise how students are progressing.

The most common ways for teachers to visually represent student progress is through graphing the data. However with conditional formatting in Google sheets, teachers have another option for graphically representing student progress.

Here is a step by step guide to easily using conditional formatting to tract student progress.

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

Country:

Choose Industry:

Which Skills Checklist?

 

Pop in your details below and we'll send you the PLD Checklist 📧

First time applying for MoE Funded PLD?
 

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: