About the Teacher Gradebook
This teacher gradebook calculates weighted final grades for a whole class in one step. Name up to four grading categories — for example Homework 20%, Quizzes 20%, Tests 40% and Final exam 20% — then paste one line per student with their average in each category. The gradebook returns every student’s weighted percentage and letter grade, the class average and median, the highest and lowest grade, and how many students are passing.
It suits teachers, tutors and professors who keep scores in a spreadsheet but want a quick, private check of final grades, as well as homeschool parents who need a simple weighted gradebook without signing up for a platform. Nothing is uploaded: the calculation runs in your browser.
Scores can be percentages (88) or fractions (45/50). Leave a cell blank or type "ex" for an excused or not-yet-graded category: by default its weight is redistributed across the other categories, as most online gradebooks do, or you can count missing work as zero. Letter grades follow the common US plus/minus scale.
With the default inputs, the class average is 80.3%. Change any value above to recalculate instantly.
How to use the teacher gradebook
- 1Name your grading categories and set each weight.
- 2Paste one line per student: name, then a score for each category.
- 3Leave a cell blank or type "ex" for excused work.
- 4Choose whether missing work counts as zero.
- 5Review each student’s final grade, letter and the class summary.
Formula and method
Each student’s final grade is a weighted average of their category scores. Every category score (a percentage, or a fraction converted to a percentage) is multiplied by that category’s weight, the products are added, and the total is divided by the sum of the weights used. If the weights add up to 100% this is simply Σ(wᵢ × scoreᵢ) ÷ 100.
When a category is blank or excused, its weight is left out of both the top and the bottom of the fraction, so the remaining categories are scaled up — the way most school gradebooks handle ungraded work. Turn on "count missing scores as zero" to treat a blank as 0 instead. Letters use the US plus/minus scale (93+ A, 90 A−, 87 B+ … below 60 F) and the distribution counts the A–F bands.
- wᵢ
- Weight of category i (percent)
- scoreᵢ
- Student’s average score in category i (percent)
Worked examples
Six students, 20/20/40/20 weights
Ava earns 0.2×95 + 0.2×88 + 0.4×91 + 0.2×93 = 91.6%. Emma has no final yet, so her 88, 92 and 85 are averaged over the remaining 80% of weight: 70 ÷ 0.8 = 87.5%. Across all six students the average is about 80.3%, and only Farah (58.6%) is below 60%.
Count the missing final as zero
With the blank final counted as zero, Emma’s grade falls from 87.5% to 0.2×88 + 0.2×92 + 0.4×85 = 70.0%, pulling the class average down to 77.4%.
Two categories with fraction scores
Liam’s 45/50 converts to 90%, and averaging it 50/50 with 82% gives (90 + 82) ÷ 2 = 86%. Mia’s 38/50 is 76%, so her grade is (76 + 92) ÷ 2 = 84%. The class average is 85%, and the unused categories with 0% weight are ignored.
Frequently asked questions
How do I calculate weighted grades for a class?+
Multiply each category average by its weight, add the results and divide by the total weight. A student with 90 homework (20%), 80 quizzes (20%), 85 tests (40%) and 88 final (20%) earns 18 + 16 + 34 + 17.6 = 85.6%.
What happens if the weights do not add up to 100%?+
The gradebook divides by the sum of the weights, so weights of 2, 2, 4 and 2 work exactly like 20%, 20%, 40% and 20%. It also shows a note so you can spot a typo.
How should missing or excused assignments be handled?+
Excused work is normally left out and its weight shared by the other categories. Work that was simply not turned in is often recorded as zero — use the toggle to match your grading policy.
Is my students’ data uploaded anywhere?+
No. The gradebook runs entirely in your browser and nothing you paste is sent to a server, but avoid sharing screenshots that contain student names.
Can I paste scores straight from Excel or Google Sheets?+
Yes. Copy the rows with the name column first and one column per category; tab-separated cells from a spreadsheet are recognised, as are comma-separated lines.