Excel Gradebook Template for Teachers
A free interactive Excel gradebook that automatically calculates weighted averages, letter grades, and class statistics. Edit scores below to see formulas in action — then get the template for your class.
| Student | HW 1 (20%) | HW 2 (20%) | Midterm (25%) | Final (35%) | Weighted % | Grade |
|---|---|---|---|---|---|---|
| Alice Johnson | 89.1% | B | ||||
| Bob Smith | 78.2% | C | ||||
| Carol Lee | 95.3% | A | ||||
| David Park | 69.2% | D | ||||
| Emma Wilson | 59.2% | F | ||||
| Class Average: | 78.2% | C | ||||
Get the Free Excel Gradebook Template
Download the fully formatted .xlsx template with all formulas pre-built, including VLOOKUP grade lookup, conditional formatting, and a class summary dashboard.
Download Free Template →Excel Formulas Used in This Gradebook
1. Weighted Average
=B2*0.2 + C2*0.2 + D2*0.25 + E2*0.35Or use SUMPRODUCT for flexible weight management:
=SUMPRODUCT(B2:E2, {0.2, 0.2, 0.25, 0.35})2. Letter Grade from Score
=IFS(F2>=90,"A", F2>=80,"B", F2>=70,"C", F2>=60,"D", TRUE,"F")3. Class Average
=AVERAGE(F2:F30)4. Count by Grade
=COUNTIF(G2:G30,"A")5. Conditional Formatting for Failing Grades
Select the grade column → Conditional Formatting → New Rule → Formula:
=G2="F"Set a red fill to highlight failing students automatically.
Frequently Asked Questions
What is an Excel gradebook template for teachers?
A pre-built Excel spreadsheet with formulas to track student scores, automatically calculate weighted averages and letter grades, and display class statistics.
How do I calculate weighted grades in Excel?
Multiply each score by its weight percentage and sum the results: =(HW*0.2)+(Midterm*0.3)+(Final*0.5). See our weighted grade formula guide.
Can I use this template in Google Sheets?
Yes. All formulas used (IFS, AVERAGE, COUNTIF, SUMPRODUCT) are fully compatible with Google Sheets.