Weighted Gradebook

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.

Example: weights 20 / 30 / 50

HomeworkQuizzesExamsFinalGrade
95%80%85%85.5%B
100%95%92%94.5%A
70%65%58%62.5%D

When to use it

  1. Calculate end-of-term grades from a scores export.
  2. Check grades from a learning management system.
  3. Try different category weights before publishing a syllabus.
  4. Drop each student's lowest homework.
  5. Report a class's grade distribution.

How to Use

  1. Paste or drop the scores CSV.
  2. Set categories, weights and drops.
  3. Check each assessment's category and maximum.
  4. Read grades and download the CSV.

Features

  1. Weighted categories
  2. Drop lowest scores
  3. Custom grade scale
  4. Max-points row
  5. Class statistics
  6. CSV import and export

FAQs

How is a weighted grade calculated?

Average each category, multiply by its weight and add: 95% homework × 20% + 80% quizzes × 30% + 85% exams × 50% = 85.5%.

What if a category has no scores yet?

It's left out and the other weights are re-scaled, so a student's grade reflects only completed work.

How do blank and zero scores differ?

Blank or 'ex' means not counted; 0 counts as a zero.

Is the class data saved?

No. Only your category and grade-scale settings are remembered in this browser.

Is anything uploaded?

No. Everything runs in your browser; class lists and scores never leave your device.

Technical Details

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.

Education Tools

Education Tools

  • Rubric Maker
  • Seating Chart Generator
  • Attendance Register and Percentage Calculator
  • Math Worksheet Generator
  • Flashcard Maker
  • OMR Answer Sheet Maker and Grader
  • Chemical Equation Balancer
  • Centrifuge RPM to RCF Calculator