Skip to content
Assessment

How to Calculate Quiz Grades (Including Weighted Averages)

Share:XLinkedIn

TL;DR. Quiz grades are easier than they look. This covers percentage, letter grade conversion, weighted averages, dropping the lowest score, extra credit, and curve-fitting.

Percentage from raw score

Points earned ÷ Points possible × 100.

Example: 17/20 = 85%.

Letter grade (US standard)

| % | Letter |

|---|---|

| 90–100 | A |

| 80–89 | B |

| 70–79 | C |

| 60–69 | D |

| <60 | F |

Many schools use +/-: A− 90–92, A 93–100, etc.

Weighted average across multiple quizzes

(Q1×W1 + Q2×W2 + … + Qn×Wn) ÷ (W1 + W2 + … + Wn)

Example: 80% (W1), 85% (W1), 90% (W2), 75% (W1):

= (80 + 85 + 180 + 75) / 5 = 84%.

Dropping the lowest score

  • Compute mean with all quizzes.
  • Compute mean dropping lowest.
  • Use the higher.
  • Example: 60, 70, 80, 90, 100. Mean = 80. Without 60: 85. Final = 85%.

    Curve-fitting

    If a quiz was harder than intended, curve scores.

    Simplest curve: add a constant. Highest = 78 → add 22 to everyone, top becomes 100.

    Extra credit

    Two approaches:

  • Add to numerator only. 17 + 2 = 19, possible stays 20 → 95%.
  • Add to both. 19 / 22 → 86%.
  • Most teachers use the first, capping at 100%.

    Excel formula

    Percentage: ROUND(POINTS_EARNED / POINTS_POSSIBLE * 100, 2)

    Letter: IF(P>=90,"A",IF(P>=80,"B",IF(P>=70,"C",IF(P>=60,"D","F"))))

    Auto-scoring in SimpleQuizMaker

    SimpleQuizMaker computes percentage and letter grade automatically. Set your scale, configure weighting and drop-lowest at the gradebook level.

  • [Quiz Grading Rubric Examples](/blog/quiz-grading-rubric-examples)
  • [Excel Quiz Template with Scoring](/blog/excel-quiz-template-with-scoring)
  • [Quiz Grading Time Savers](/blog/quiz-grading-time-savers)
  • Use SimpleQuizMaker for auto-scoring →

    Get weekly study & quiz tips

    Join teachers and students who get practical tips on quizzing, active recall, and AI-powered learning.

    Share:XLinkedIn

    Sarah Mitchell

    Curriculum Designer & Former High School Teacher

    More articles by Sarah

    Ready to create your first quiz?

    Use AI to generate quizzes from your own study materials in seconds.

    Try SimpleQuizMaker Free