How to Set Up a Simple Gradebook (Teacher & Tutor Guide)
Disclosure: Some links below are affiliate links. If you sign up through them we may earn a commission at no extra cost to you. We only recommend tools we'd genuinely suggest to a friend. See our full disclosure.
A gradebook doesn’t need to be complicated to be good. It needs to be accurate, fast to update, and clear at a glance — so you spend your time teaching, not doing arithmetic. Whether you’re a classroom teacher, a private tutor, or a homeschooling parent, here’s how to set up a simple gradebook that calculates the boring parts for you.
Start with the structure
Every workable gradebook is the same shape: students down the side, assessments across the top. Build from there:
- Column A: student names.
- One column per assignment or assessment, with the score entered out of a consistent maximum — 100 is the easiest because the number is the percentage.
- An average column that updates automatically as you enter scores.
- A letter-grade column that converts the average to a grade using your scale.
That’s the entire backbone. Everything else is refinement.
Let the gradebook do the math
The single biggest time-saver is automatic calculation. In a spreadsheet:
- The average is one formula across each student’s scores — it recalculates the instant you type a new mark.
- The letter grade is a simple lookup against your thresholds (for example A 90+, B 80+, C 70+, D 60+, otherwise F). Set it once and it grades everyone for you.
Adjust the thresholds to match your school or course — the point is that you decide the scale once and never hand-grade an average again. (Our done-for-you templates include a Teacher Planner & Gradebook with the averages, letter grades and attendance percentages already wired up, but you can build the same thing in any spreadsheet.)
Decide how to weight assignments
If a final exam should count for more than a homework sheet, you need weighting. The clean way:
- Group work into categories (tests, quizzes, homework, participation).
- Give each category a percentage of the final grade.
- Make sure the percentages add up to 100%.
- The final grade is each category’s average times its weight, summed.
State the weights to students at the start of the term. Transparency here heads off most end-of-term grade disputes.
Keep attendance alongside grades
Attendance and performance tell a fuller story together. Keep a second sheet with students down the side and dates across the top, marking P (present), A (absent), or L (late) for each day, and let it total a present-percentage per student. When a grade dips, a glance at attendance often explains it — and you’ll have the record ready for any parent or administrator conversation.
Plan the term, not just the grades
A gradebook records what happened; a simple weekly lesson plan shapes what will. Sketch each day’s topic, objective, materials and homework, and your gradebook columns practically write themselves because you already know what’s being assessed and when. Keeping the plan and the gradebook in the same file means everything about a class lives in one place.
Practical habits that keep it reliable
- Enter scores promptly — a backlog of ungraded work is where errors and stress creep in.
- Use one consistent maximum (100) so averages are honest.
- Copy the tab each new term rather than overwriting, so you keep a clean history.
- Back it up to the cloud so a lost laptop never means lost grades.
- Decide your policies up front — late penalties, dropped scores, rounding — and apply them to everyone the same way.
The bottom line
A good gradebook is mostly about structure and letting the spreadsheet handle the math: students down the side, assessments across the top, automatic averages and letter grades, attendance beside it, and a weekly plan to drive it. Set it up once at the start of term, keep it updated, and it quietly does its job all year — leaving you free to focus on the students rather than the spreadsheet.
Related guides
- How to Actually Use a Planner (and Stick With It)
- How to Build a Habit Tracker That Works
- Browse our done-for-you templates and trackers
Frequently asked questions
What should a gradebook include?
At minimum: a row per student and a column per assignment or assessment, with each score entered out of a consistent maximum (usually 100). Add an automatic average and a letter-grade column, and ideally a separate attendance record. Keeping assignments, averages and attendance in one place gives you a full picture of each student at a glance.
How do I calculate a weighted grade?
Assign each category a percentage of the final grade (for example tests 50%, quizzes 30%, homework 20%), make sure the weights add up to 100%, then multiply each category average by its weight and sum the results. A spreadsheet does this automatically once you set the weights, which removes arithmetic mistakes.
What's the easiest way to keep a gradebook?
A spreadsheet is the easiest flexible option: it auto-calculates averages and letter grades, sorts and filters instantly, and you can copy a tab for each new term. It works offline, exports easily, and doesn't lock you into one school platform.
How can I track attendance and grades together?
Keep attendance on its own sheet with students down the side and dates across the top, marking present, absent or late, and let it total a present-percentage per student. Keeping it beside your grades means one file tells you both how a student is performing and whether attendance might explain a dip.
Should I drop the lowest score?
Many teachers drop each student's single lowest score to soften the impact of one bad day, which can improve fairness and reduce grade disputes. Decide the policy up front, state it clearly to students, and apply it consistently to everyone.