Home / Guides
Teacher Gradebook Spreadsheet: How to Set Up Automatic Grades
How to build a simple gradebook in Excel or Google Sheets that averages scores and assigns letter grades automatically.
The basic layout
Put one student per row and one assignment per column. Add a row at the top for the points possible on each assignment so averages stay accurate when assignments are worth different amounts.
Formulas to automate grades
- Percentage: total points earned divided by total points possible
- Letter grade: a lookup against your grading scale (for example 90 and up is an A)
- Missing work: COUNTBLANK across the assignment columns to flag students who are behind
Keep it private
Use student initials or ID numbers if the file lives in a shared drive, and follow your school's data policy.
Free download
Free Weekly Lesson Plan Template
A printable weekly lesson plan grid, daily plan and checklist.
Download free →Related templates
Free Weekly Lesson Plan Template
A printable weekly lesson plan grid, daily plan and checklist.
Download free →