For teachers
Teacher Gradebook
Teacher gradebook spreadsheet for one class of up to 40 students and 60 assignments. Type the scores and the overall percent, letter grade, missing work count and every category average fill in by themselves. Works in Excel and in Sheets.
C$9CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- Weighted categories (up to 6, for example Homework 15%, Quizzes 20%, Tests 35%) or total points: pick the mode on the Setup tab
- Enter points earned, M for missing (counts as zero) or EX for exempt (left out). Blank means not graded yet
- Overall %, letter grade from your own scale (A+ to F, cut-offs editable), missing count and each category average for every student
- Class average for every assignment, every category and overall
- Missing work in red, exempt in grey, low scores in red, each letter grade in its own colour
- Student Progress Report: pick a student and get every assignment with points, score, percent and status, the category averages and a comments box. Print it or save it as a PDF for conferences
- Class Summary: students, class average, highest and lowest, students below 70%, students with missing work, a count per letter grade with a chart, and category averages
What you get
- XLSXTeacher-Gradebook.xlsx (blank, ready for your class)
- XLSXTeacher-Gradebook-with-Sample-Data.xlsx (a filled-in example class: 24 made-up students, 12 assignments)
- PDFQuick-start guide (PDF)
Good for
Teachers, tutors and homeschool families who want weighted grades, missing work and a parent-ready report in one file.
Please note
Overall grades are rounded to one decimal place and the letter follows the rounded number; check your school's rounding policy. For your own classes; please don't resell or share the files.
Disclaimer
This template is a record-keeping tool. Check the results against your school's grading policy before you report grades.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
