3 Steps to creating grade books in G-Suite

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.

The key is to implement one thing. It may be small, but take one thing that you have learnt and apply it. It takes time to bring about the changes you imagine. When you hear a keynote speaker they are often condensing many years of trials and experiments into a candy-coated 40 minutes. Don’t be put off by the perceived void between what you are doing and what others tell and show you.

A handy hint is to find something that you normally do and embed it in a digital format. I often suggest finding a task that is repetitive and time consuming and trying to use simple tools to make the workflow better. I like to use the example of a teacher’s grade book. If you haven’t got an integrated LMS at your school, filling in a grade book, collating final marks and trying to see trends quickly is one of the less enviable teaching tasks we face.

In Google Sheets, you can easily make a grade book that is functional and can quickly identify students at risk or those needing extension. Here are 3 things you can try.

1.Use a Template

The easiest way to start the process is to go to Google Sheets and look in the template gallery. Here you will find a grade book template that you can use. It is well designed and allows you to see the progress of each student easily as well as create graphs mapping progress.

2.Build one yourself

Start simply and then build more functions into it as you feel comfortable. In your spreadsheet, start with a column with student names, if you start your list in the second row you can use the first row for headers. Then as you move across you can add marks and calculate percentages by dividing the score received by the total the task is out of. To make a formula in Google sheets that will perform a calculation you want to carry out, just type in ‘=’ and then the formula.

G-SuiteFor example, let’s imagine the task is out of 25 and the result of the student is 14. If is entered in cell B2, in cell C3 type =B2/25. This will perform the calculation and display the result of 0.56.




To display this as a percentage, click on the ‘format as percentage’ icon on the top menu bar. You can copy and paste this formula foG-Suite_2r the rest of the rows.

3.Use conditional formatting to highlight information

When you have several tasks entered and the results are calculated, you can end up with a spreadsheet full of numbers. This can make it hard to visualise the progress of individual students. However, in Google Sheets there is a function called conditional formatting. This allows you to colour a cell based on a condition, like the percentage received. To activate this:

1. Highlight the cells you wish to colour.
2. At the bottom of that menu will be conditional formatting.
3. Click on that and a menu called ‘Conditional format rules’ will appear on the right hand side of the screen.
4. The tab on the right allows you to create a colour scale for your results. By default it uses the minimum, median and maximum value to apple shades of green. You can customise this to possibly reflect your data better by changing the Minpoint to be 0, the Midpoint to be 50 and the Maxpoint 100. You are able to assign colours for these settings, red for 0, yellow for 50 and green for 100. This creates a visual snapshot of how each student is progressing.


A simple example of a Grade Book can be accessed via this link.

By taking something that you already do and using the tools in G-Suite, you are able to create a better workflow and, more importantly, visually see trends within your data easily.


Favourite Classroom iPad App_2

Why Book Creator is my favourite classroom iPad app

When you’re describing your favourite of something there’s always the tension of ‘What am I leaving out?’ There are probably 10 or so iPad apps that I regularly use the most but if you were going to ask, which iPad app should a teacher start with and master first, it would be Book Creator…hands down!


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.


Do Rewards Dull Creativity In The Classroom?

Carl Dunker devised an experiment called the candle problem in the 1950’s.  In it he gathered a group of individuals, gave them  a candle, some thumb tacks and a box arranged in the way pictured above and told them that their job was to attach the candle to the wall


Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to


Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices