Tag: Google Sheets

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.

Confessions of a Google Sheets Junkie

Confessions of a Google Sheets Junkie – Getting started with Google Sheets

Hi. My name is Lara and I’m a Google Sheets junkie. It all started when I was looking for a way to streamline my planning and track student progress. From there, it’s really spun out of control. I now find myself using Sheets not just at work, but also at home, and it’s really started to affect me in ways I never imagined it would.

3 Options for Managing Google Drive Templates

f your organisation has recently transitioned to G Suite, you might be wondering about what to do with your document, spreadsheet and presentation templates. Existing templates can be converted to Google format (Docs, Sheets and Slides) and stored in Google Drive, but what’s the best way to manage the distribution and use or Google Drive templates?

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.