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.

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.


Why school is like Monopoly

By utilising the wisdom and experience of staff and creating blended learning environments, students should be able to operate in their preferred modality of learning whilst controlling certain aspects of their learning pathway.
Some of our kids are stuck in a game of educational Monopoly, losing motivation and having nowhere to go as it is raining outside. It is our responsibility to maybe pack away the Monopoly board and introduce a new paradigm to them.

Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike


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...


Sign Up Now
To Get The Latest Updates


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: