Keep track of student grades in Google Classroom

22 June 2017
Samantha Garrett

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.

Did you know you can keep track of student grades in Google Classroom? Click To Tweet

Here’s how to do it:

1. Open any question or assignment task that you have given to your students using Google Classroom.
2. Click the Cog button in the top right corner of the screen and select the Copy all grades to Google Sheets option.

A new Google Sheet will be created. This sheet lists all your students, all the assignment tasks that you have created to date and the grades for the task you just copied from.

You can add grades from other tasks to the spreadsheet by repeating steps 1 and 2. A new version of the spreadsheet is created each time, showing the grades for all tasks that you have copied to Sheets. The Sheets are stored within the Classroom folder in Google Drive.
Tip: If you change the grade a student receives for a task, be sure to repeat step 2 above to update the spreadsheet.

Recent Posts

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

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


Choose Industry:

Which Skills Checklist?


Sign Up Now
To Get The Latest Updates


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: