If you are looking for a Google Sheets gradebook that will help you easily record and calculate grades, then you have come to the right place!
Here you will find very useful and easy to use Google Sheets gradebook templates that will allow you to keep track of your class grades in a very organized and streamlined way.
This page contains the Google Sheets gradebook templates. Click here to get the Excel version of the gradebook templates.
Points based vs. percentage based version
This page has two different gradebook templates that you can choose from, depending on whether you want to record points, or percentages.
Points based (+ Automatic percentage tab)
This version of the gradebook template will allow you to enter points possible / earned on one tab, and has an additional tab that will calculate the percentage of each assignment for you.
This version of the gradebook template allows you to record the percentages of each assignment.
*Note: Cells that should not be edited will display a warning if you try to edit them.
See more Google Sheets templates
Click here to get your Google Sheets cheat sheet
Or click here to take the dashboards course
Excused Assignments
You now have the option to mark assignments as “Excused” in the points-based gradebook template. If you have a student that you would like to excuse an assignment for, simply enter the letter “E” into the appropriate cell for that assignment / student, and that assignment will not factor into the calculations.
Gradebook conditional formatting
You will notice that both templates have automatic color coding for the average grades of each student (Column B), and the average grades for each assignment (Row 1). This conditional formatting will allow you to easily identify students who are struggling or assignments that may have been too difficult or too easy.
Points based gradebook template (With automatic percentage tab)
In this template, you can set the “Points Possible” for each assignment, and then record the points that were earned for each student, on each assignment. After entering the points possible and the points earned, the total points earned for each student/ assignment will calculate, and so will the average percentage.
In this template you can excuse a student from an assignment by entering the letter “E” for the score, and that assignment for that student will not factor into the calculations.
You will also be able to see the overall class average.
Instructions:
- Enter student names in column A
- Enter assignment names in row 4
- Enter the points possible for each assignment in row 3
- Enter the points earned for each student, on each assignment
- Optional- Click the second tab to view assignment percentages
This points based template also has a second tab, that doesn’t require any editing, and will automatically calculate the percentage of each individual assignment for you, as shown below.
The total number of students on the sheet will display at the top.
This template was created by and is owned by Corey Bustos / SpreadsheetClass.com
Percentage based gradebook template
In this template, you will be able to directly record the percentage that is earned for each assignment. Whether you calculate the percentages yourself or if you have a learning platform that reports percentages directly, this will allow you to record the percentage based scores for your students.
After entering the percentages earned for each assignment, the average score for each student, each assignment, and for the class overall, will calculate automatically.
Instructions:
- Enter student names in column A
- Enter assignment names in row 3
- Enter the percentage earned for each student, on each assignment
The total number of students on the sheet will display at the top.
