Click to follow me on TpT to be notified of sales and new resources.

Close this search box.
Pin title "Setting Up Your Google Sheets Gradebook" over a screenshow of a report card from the teacher gradebook

Gradebook Tutorial Videos

So you’re ready to jump in and start setting up your gradebook? Congratulations! You’re on your way to get organized and finally, stay on top of your grades. This Google Drive gradebook template will have you all set to input grades, automatically calculate averages, control assignment weighting, and general student reports.

Gradebook Set Up

The gradebook videos below are intended to support you along the way through the initial setup of your gradebook. Watch and follow along and you’ll be ready to input grades in less than 30 minutes!

Setting Up Subjects

Enter your subjects on the settings tab & each subject grading sheet.

Add Students

Type in your students’ names on the student list sheet. It’s up to you if you’d like to type their first or last name first. You can sort them from A to Z, if you’d like them to appear alphabetically. Once you’ve entered data, you cannot re-sort to your students as the data will become scrambled (will not match the correct students).

Add Icons

Icons are optional. If you’d like to see them, you can copy and paste them in from the settings tab and use the fill colour button to select the matching background colour.


The settings sheet is where you’ll find all the main settings including options for turning assignment weight on or off, naming your subjects, adjusting percentages and how they relate to grades, colour coding settings, and the copy & paste icons.

Grade Colour Coding

How to adjust the colour coding, through the settings sheet, that will show up on reports.

Term Dates & Settings

How to set your term dates and adjust the terms’ weight, if desired.

Subject Settings

How to assign categories to subjects and enter in subject units.

Using Weighting

An overview of three ways to assign weighting: by term, category, or on individual assignments.

Turning Weighting Off

How to turn weighting off to use a simple average calculation.

Entering Grades

How to enter grades using percentages, fractions, and a 4-point, or 5-point scale.

Using Reports

An overview of the four reports included and how to print them or download them as a PDF.

Have additional questions? Shoot me an email at [email protected], I’m more than happy to help! 🙂

Amber Evancio

Amber Evancio

I'm Amber Evancio and I currently teach grade four in Northern Canada. I'm passionate about helping teachers lead their classes with efficiency and love.


I’m Amber Evancio and I currently teach grade four in Northern Canada. I’m passionate about helping teachers lead their classes with efficiency and love.

Daily and monthly behaviour tracking resource


Behaviour tracking tools are my favourite classroom management strategy. Try one out today, for free. I promise, it’ll be a game changer in your elementary classroom!

Thank you for subscribing!

Featured Resources

You Might Also Enjoy...

One Response

Leave a Reply

Where would you like to shop?