This weighted gradebook turns a spreadsheet of scores into final grades for a whole class. Paste or drop a CSV with a student column and one column per assessment (add a Max row for points possible), set your categories and weights — homework, quizzes, exams, projects — and choose how many low scores to drop. It calculates each student's category percentages, final percentage and letter grade, with class average, median and grade distribution, and exports the results to CSV. It runs in your browser.
| Homework | Quizzes | Exams | Final | Grade |
|---|---|---|---|---|
| 95% | 80% | 85% | 85.5% | B |
| 100% | 95% | 92% | 94.5% | A |
| 70% | 65% | 58% | 62.5% | D |
Average each category, multiply by its weight and add: 95% homework × 20% + 80% quizzes × 30% + 85% exams × 50% = 85.5%.
It's left out and the other weights are re-scaled, so a student's grade reflects only completed work.
Blank or 'ex' means not counted; 0 counts as a zero.
No. Only your category and grade-scale settings are remembered in this browser.
No. Everything runs in your browser; class lists and scores never leave your device.
Assessment columns are assigned to categories (guessed from names like HW, Quiz or Midterm, and editable) with a maximum from a Max row or entered by hand. Each category's percentage is points earned ÷ points possible across assessments with scores, after dropping the lowest N by percentage; blank and 'ex' cells are excluded while 0 counts. The final percentage is the weighted average of categories with scores, re-scaled so the weights in use total 100%, and mapped to a letter on your scale. Class mean, median, range and grade distribution are shown.