Teacher Gradebook Spreadsheet, Weighted Grade Calculator for Excel and Google Sheets, Digital G

Grade faster and stop doing weighted averages by hand. This Teacher Gradebook calculates each student's weighted average, percentage and letter grade automatically.

WHAT'S INSIDE

• Setup: class name, up to 8 grade categories with weights (e.g. Homework 20%, Quizzes 30%, Tests 40%, Participation 10%) and your own letter grade scale

• Gradebook: up to 40 students and 30 assignments — name, category and points possible per assignment

• Weighted average and letter grade per student (ungraded work is ignored, not counted as zero)

• Students below 70% highlighted in red

• Class Summary: class average, number of students, students below 70% and a grade distribution chart

• Start Here tab with simple instructions

Duplicate the file for each class or term. Perfect for middle school, high school, tutors and homeschool.

YOU WILL RECEIVE

1 instant download: teacher_gradebook.xlsx (works in Microsoft Excel and Google Sheets).

NOTES

• Digital product — nothing will be shipped.

• Any currency works.

• Questions? Message us anytime.

Created with the help of AI tools and reviewed by our team.