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.
- List the categories and their weights from your syllabus or school policy.
- Turn every score into a percentage: points earned ÷ points possible × 100.
- Average the scores inside each category.
- Multiply each category average by its weight.
- Add the results and divide by the sum of the weights you used.
Worked example
| Category | Weight | Category average | Average × weight |
|---|---|---|---|
| Tests | 50% | 82 | 82 × 0.50 = 41.0 |
| Homework | 30% | 95 | 95 × 0.30 = 28.5 |
| Participation | 20% | 90 | 90 × 0.20 = 18.0 |
| Total | 100 | 41.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 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:
| Step | Calculation |
|---|---|
| Tests | 82 × 50 = 4,100 |
| Homework | 95 × 30 = 2,850 |
| Sum | 4,100 + 2,850 = 6,950 |
| Weights used | 50 + 30 = 80 |
| Weighted grade | 6,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.
| Assessment | Score (%) | Weight | Score × weight |
|---|---|---|---|
| Test 1 | 78 | 1 | 78 |
| Test 2 | 86 | 1 | 86 |
| Final exam | 90 | 2 | 180 |
| Total | 4 | 344 |
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
- The weights in the gradebook match the ones in your syllabus.
- Excused work is left out, not entered as zero.
- Missing work is handled the way your policy says (see our guide to zero or 50 for missing assignments).
- Rounding happens once, at the end, not at every step.
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.
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 PlayiPhone version coming soon
More guides
- Letter Grade Percentage Scale: A–F Chart With Plus and MinusThe usual A–F percentage cut-offs, a plus/minus chart, the 7-point variant, how to round borderline scores and how to turn points into a letter.
- Standards-Based Grading Scale: 1–4 Levels and Percentage ConversionWhat each level on a 1–4 standards-based grading scale means, example conversion charts to percentages and letters, and ways to combine several scores into one.
- Total Points vs Weighted Grades: Which Gradebook Setup to UseTotal points lets every point count the same; weighted grades fix each category's share. A side-by-side example, the hidden weights in points grading, and how to choose.
- Zero for Missing Assignments or a 50 Minimum? The Math and the OptionsHow a zero, a 50 minimum or leaving work out changes a student's average, with worked numbers, the arguments on each side and ways to record missing work.
Published by Zoranta, the developer of Gradeleaf.