A gradebook only has to answer three questions well: what each student's grade is, why it is that number, and what is missing. Set it up correctly in the first week and report cards become a printout instead of a weekend.
Check any score instantly with the free Grade Percentage Calculator.
Decide the categories and weights first
Before you enter a single score, write down your categories and what each is worth. A common middle-school split is homework 15%, quizzes 15%, tests 35%, projects 20%, participation 5% and the final exam 10%. The weights must add to 100%. Publish them in the syllabus so students and families know a test matters more than a worksheet.
Points versus weighted categories
In a points gradebook every point counts the same: a 100-point test outweighs a 20-point worksheet five to one. In a weighted gradebook each category is averaged first, then multiplied by its weight. Weighted grades stop a single large project from swamping everything else. Example: homework 84%, tests 92% and a project 100% with weights 50/30/20 give (84×0.5 + 92×0.3 + 100×0.2) = 89.6%. The free Weighted Grade Calculator shows the same working.
Separate missing from not yet due
The most common gradebook error is treating a blank as zero, or a zero as blank. Keep them distinct: a blank cell means missing and should be flagged; a score of zero means the work was handed in and earned nothing. Count missing work per student every week; it predicts falling grades better than any average does.
One row per score
Spreadsheets work best with one row per student per assignment, plus a separate assignments list holding the points possible. Then the percentage, the category and every average calculate on their own, and adding a new assignment never breaks a formula.
Check the weights total
If your weights add to 95% or 110%, every weighted grade is subtly wrong. Put a check cell that adds the weights and look at it whenever you change the syllabus.
Keep a paper backup and a contact log
Many teachers still keep a paper record for the classroom and a parent-contact log for conferences. The Teacher Gradebook & Assignment Tracker handles the weighted averages and missing-work flags; the Printable Classroom Record Sheets are the binder version.
This guide is general information. Follow your school's grading policy and data-privacy rules for storing student records.