MYGRADEPLAN GUIDE

How to calculate a weighted grade (with examples)

Weighted grade = sum of (category percentage × category weight) ÷ sum of weights. Step-by-step method, a three-category worked example, and the mistakes that throw the answer off.

Weighted grade =Σ (category % × weight) ÷ Σ weights.Homework 92% at 30%, quizzes 85% at 20% and exams 78% at 50% gives 83.6%.

A weighted grade gives each part of your course a fixed share of the result. Exams might be worth 50% no matter how many points they contain, while homework is 30% even if it has hundreds of points. Here is the method, by hand and in the calculator.

The four steps

  1. Find each category’s percentage

    Add the points you earned in the category, divide by the points possible, multiply by 100. Homework: 276 of 300 points = 92%.

  2. Multiply by the category weight

    Use the syllabus weight as a decimal. Homework 92 × 0.30 = 27.6.

  3. Add the contributions

    Homework 27.6 + quizzes (85 × 0.20 = 17.0) + exams (78 × 0.50 = 39.0) = 83.6.

  4. Divide by the total weight you used

    If every category has grades, the weights total 1.0 and the grade is 83.6%. If a category has no grades yet, divide by the weights of the categories that do.

Worked example

CategoryEarned / possiblePercentWeightContribution
Homework276 / 30092.00%30%27.60
Quizzes170 / 20085.00%20%17.00
Exams156 / 20078.00%50%39.00
Weighted grade100%83.60%

When a category is empty

Say the exams haven’t happened yet. Your grade so far uses homework and quizzes only: (27.6 + 17.0) ÷ 0.50 = 89.2%. That number is real, but it only describes half of the course. Once the exams land at 78%, the result is 83.6%. MyGradePlan labels these two situations separately so you never mistake a half-course grade for a final one.

Common mistakes

Open the weighted grade calculator

A FEW THINGS YOU MIGHT BE WONDERING

Questions about this

What is the weighted grade formula?
Weighted grade = (category 1 % × weight 1 + category 2 % × weight 2 + …) ÷ (weight 1 + weight 2 + …). Weights are usually written as decimals that add up to 1.
How do I calculate a weighted grade in Excel or Sheets?
Put percentages in one column and weights in another, then use =SUMPRODUCT(percentages, weights)/SUM(weights). The calculator here does the same thing without a spreadsheet, and keeps ungraded work out automatically.
Is a weighted grade the same as a weighted average?
Yes. A weighted grade is a weighted average where the weights are the category percentages from your syllabus.