ZorantaGuides
Gradeleaf

Gradeleaf › Guides

How to Calculate Weighted Grades for a Class, Step by Step

To calculate a weighted grade, work out the average for each category, multiply each average by the category's weight, add those results together and divide by the total of the weights. If Tests count 50%, Homework 30% and Participation 20%, a student averaging 82, 95 and 90 has a weighted grade of 87.5.

The steps below show the calculation by hand, what to do when a category has no scores yet, how to make one assessment count double, and the spreadsheet formula if you keep grades in Excel or Google Sheets.

A balance scale weighing an exam booklet against homework sheets

How to calculate weighted grades by hand

The formula is the same whatever the subject or grade level:

Weighted grade = (average₁ × weight₁ + average₂ × weight₂ + …) ÷ (weight₁ + weight₂ + …)

When the weights add up to 100, dividing by the total changes nothing, so you can multiply by the weight as a decimal (50% = 0.5) and add. Dividing by the total matters when the weights do not add up to 100, or when one category is left out.

  1. List the categories and their weights from your syllabus or school policy.
  2. Turn every score into a percentage: points earned ÷ points possible × 100.
  3. Average the scores inside each category.
  4. Multiply each category average by its weight.
  5. Add the results and divide by the sum of the weights you used.

Worked example

CategoryWeightCategory averageAverage × weight
Tests50%8282 × 0.50 = 41.0
Homework30%9595 × 0.30 = 28.5
Participation20%9090 × 0.20 = 18.0
Total10041.0 + 28.5 + 18.0 = 87.5

The student's weighted grade is 87.5. A plain average of the three categories would be 89, because it treats participation as if it mattered as much as tests.

Gradeleaf

Gradeleaf calculates weighted averages from the category shares you set, lets one assessment count ×2 inside its category, and leaves out categories that have no scores yet. Get it on Google Play

How to calculate weighted grade categories

Each category average comes from the assessments inside it. There are two common ways to get it, and they give different numbers when assessments have different point totals.

Average the percentages

Convert each assessment to a percentage and average those. Test 1 at 78 out of 100 and Test 2 at 86 out of 100 give a Tests average of (78 + 86) ÷ 2 = 82. Every test counts the same, whatever it was marked out of.

Add up the points

Add the points earned and divide by the points possible. A homework category of five 10-point assignments scored 9, 10, 9, 10 and 9.5 gives 47.5 ÷ 50 = 95%. Here a 20-point task would count twice as much as a 10-point one.

Pick one approach per category and tell students which one you use. Mixing them partway through a term changes averages that students have already seen.

When one category has no scores yet

Early in a term, a category may be empty. Counting it as zero would drag every student's grade down for something nobody has done yet. The usual fix is to leave the empty category out and divide by the weights that remain.

If Participation has no scores yet in the example above:

StepCalculation
Tests82 × 50 = 4,100
Homework95 × 30 = 2,850
Sum4,100 + 2,850 = 6,950
Weights used50 + 30 = 80
Weighted grade6,950 ÷ 80 = 86.9 (rounded)

This is why the formula divides by the total of the weights. Tests and Homework keep their relative importance (50 to 30), and the grade is on the same 0 to 100 range as before.

Making one assessment count double

Sometimes one assessment inside a category should count more, such as a final exam inside Tests. Give it a weight of 2 and the others a weight of 1, then take a weighted average inside the category.

AssessmentScore (%)WeightScore × weight
Test 178178
Test 286186
Final exam902180
Total4344

The Tests average becomes 344 ÷ 4 = 86. That figure then goes into the category calculation with the 50% weight, the same as before.

How to calculate weighted grades in Excel or Google Sheets

Put the category averages in one column and the weights in the next. If the averages are in B2:B4 and the weights in C2:C4, this formula gives the weighted grade:

=SUMPRODUCT(B2:B4, C2:C4) / SUM(C2:C4)

SUMPRODUCT multiplies each pair and adds the results. Dividing by SUM(C2:C4) means the formula still works if the weights are written as 50, 30, 20 instead of 0.5, 0.3, 0.2. For a category with no scores, delete its weight for now so it drops out of both parts of the formula.

Checks before you share grades

If you are deciding whether to weight categories at all, our comparison of total points vs weighted grades shows how the same scores can end up with different grades.

Gradeleaf

Let the gradebook do the arithmetic

In Gradeleaf you enter scores as points out of any total, and each student's average updates with the weights you chose, per category and for the term.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Published by Zoranta, the developer of Gradeleaf.