How to Calculate a Weighted Grade (Formula and Worked Example)

A weighted grade is an overall percentage built from several graded items, quizzes, assignments, midterms, a final exam, where each item counts a different amount toward the total rather than counting equally. Learning how to calculate a weighted grade by hand is mostly a matter of understanding what a "weight" actually represents and then applying one formula consistently, and this guide walks through both with real numbers.

What does weight mean in grades, and what is a weighted grade?

Most courses do not treat every graded item the same. A ten-minute reading quiz and a three-hour final exam both produce a score out of some maximum, but they rarely count the same amount toward the grade printed at the end of the term. A weight is simply the share of the final grade that one item is worth, almost always written as a percentage. When a syllabus says "homework is 20%, midterms are 30%, and the final is 50%," those three numbers are weights, and across a whole course they are expected to add up to 100%.

Weighting exists because a single low-stakes quiz should not be able to move a grade as much as a cumulative final exam. Without it, a course would have no way to signal that some assessments matter more than others.

The weighted grade formula

For a single item, its own percentage is straightforward:

Combining several weighted items into one overall grade uses this formula:

Here s_i is the score on item i, m_i is its maximum, p_i is its percentage, w_i is its weight and G is the overall grade. That is the weighted average formula for grades in full.

Two things matter about that second line. First, each item's percentage is multiplied by its own weight before anything is added together, so a high score on a low-weight item contributes less than the same score on a high-weight item. Second, the division is by the total weight actually in play, not by a fixed 100. That second detail is what keeps the formula correct even midway through a term, when only some items have been graded and their weights do not yet reach 100%.

How to calculate a weighted grade step by step

So, how are weighted grades calculated in practice? Six steps cover every case, and the worked example in the next section follows them exactly.

1. List every graded item, or every category, with the score you earned and the maximum possible.
2. Turn each one into a percentage by dividing the score by the maximum and multiplying by 100.
3. Write down each item's weight from the syllabus, as a percentage of the final grade.
4. Multiply each percentage by its weight, which gives that item's weighted contribution.
5. Add the contributions together.
6. Divide the sum by the total of the weights in play, and by 100 more if the weights are written as whole percentages.

Steps four to six are the whole trick. Steps one to three are where most mistakes happen, because a wrong max score or a weight read off the wrong line of the syllabus will carry straight through to the answer.

A weighted grade example with real numbers

Suppose a course has three graded items so far:

Adding the weighted contributions gives 16.8 + 23.4 + 45.5 = 85.7. The three weights already sum to 100%, so no adjustment is needed, and the overall grade is 85.7%.

Notice what the weighting actually did here. The midterm score, 78%, was the lowest of the three, but it only pulled the overall grade down by a small amount because it carried just 30% of the total. The final exam's 91% did far more work toward the final number, because it carried half the grade. A simple, unweighted average of the same three scores, (84 + 78 + 91) ÷ 3, would have given 84.33%, a noticeably different answer, because a plain average silently assumes every item matters equally, and here they clearly do not.

Do grade weights need to add up to 100?

Add a fourth item, say a participation score of 90% worth 10%, and the total weight becomes 110%. The formula does not break; it simply divides by 110 instead of 100:

• Weighted contributions: 16.8 + 23.4 + 45.5 + (90 × 0.10 = 9) = 94.7
• Overall grade = 94.7 ÷ 110 × 100 = 86.09%

This is exactly why dividing by the actual total weight, rather than assuming it is always 100, matters. A student checking their grade in week six of a fifteen-week course might have only 40% of the course's total weight graded so far; dividing by that real 40% rather than a fixed 100 is what makes the running grade mathematically honest at every point in the term, not just at the very end.

Do grade weights need to add up to 100? Not for the arithmetic, only for the answer to describe the whole course. What if my weights don't add up to 100 at the end of term? Then something is mistyped or the syllabus has a hidden rule, so go back and check. How to normalize grade weights is the same division as above: add up the weights you have and divide by that total instead of by 100. Three items weighted 10, 10 and 20 sum to 40, so a score of 90 on the 20 item counts for half of the running grade, not a fifth of it.

Missing work needs one decision. How to calculate grade when some grades are missing depends on whether the missing item is ungraded, excused or a zero. Ungraded and excused items are left out, which is what the normalizing division does for you. A zero is a score like any other and is included at 0 percent.

Can a weighted grade be over 100?

Can a weighted grade be over 100 in a course with no extra credit? No. If every score is at most its maximum, every item percentage is at most 100, and a weighted average of numbers that are all at most 100 cannot be higher than 100. A grade above 100 needs bonus points that lift an item above its stated maximum. With 5 bonus points on a 100 point exam, the exam's percentage becomes 105, and the overall grade rises by the exam's weight times that 5 point excess. Some instructors cap the final grade at 100 and others record the higher number, which is a policy to read in the syllabus.

Weighted vs points grading, and weighted vs unweighted grades

Weighted vs points grading is the first thing to settle before any arithmetic. In points grading every assignment adds its points to a running total, and the grade is points earned divided by points possible, so a 100 point exam automatically counts four times as much as a 25 point quiz. In weighted grading, categories such as homework and exams are given fixed percentages, and each category is averaged on its own before the weights apply. The two can agree, but they do not have to. Suppose homework is worth 400 points and exams 100 points, and a student earns 90 percent on homework and 70 percent on exams.

That gap is why total points vs weighted grades is worth checking against the syllabus: the same scores give 86 percent under one scheme and 78 percent under the other, purely because exams count for 20 percent of the points but 60 percent of the weights. Weighted vs unweighted grades is a separate question. Here unweighted means a plain average in which every item counts equally, and weighted means each item or category has its own share. The earlier example shows the difference: a plain average of 84, 78 and 91 is 84.33, while the weighted result is 85.7.

How to calculate weighted grades in Excel

A spreadsheet does all six steps in one line. Put the item percentages in column B and the weights in column C, rows 2 to 4, and use this formula:

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

SUMPRODUCT multiplies each percentage by its weight and adds the products, and dividing by SUM of the weights is the same normalizing step the calculator performs. With 84, 78 and 91 against weights of 20, 30 and 50, it returns 85.7. That is how to calculate weighted grades in Excel, and the identical formula works in Google Sheets. The Excel formula for weighted grades also survives partial terms, because the division uses whatever weights are actually in the range.

How does Canvas calculate weighted grades?

How does Canvas calculate weighted grades when an instructor weights assignment groups? Broadly, each group's percentage is worked out from the points earned and possible inside that group, multiplied by the group's weight, and the results are added. Canvas also leaves out groups that have no graded work yet and scales the remaining weights up, which is the same normalizing step described above. Gradebooks differ in how they treat missing, excused, muted and ungraded work, and some let students switch to a view that counts ungraded work as zero. That is the usual answer to why doesn't my grade match my gradebook: the calculator and the portal are applying different rules to the same scores. Check for muted assignments, unposted grades, excused items and dropped scores before deciding that either number is wrong.

Extra credit, dropped scores and zeros

How does extra credit affect your grade? It depends on where it is recorded. Bonus points added to a category lift that category's percentage, sometimes above 100, and the lift reaches the overall grade in proportion to the category's weight. How does dropping the lowest grade work? The lowest score in a category is removed before the category average is taken, so each remaining score carries more weight. Three quiz scores of 60, 80 and 100 average 80, but with the lowest dropped the average is 90.

How much will a zero affect my grade? Suppose everything else in the course averages 90. A zero on an item worth 10 percent leaves 90 × 0.90 = 81, a fall of 9 points. The same zero on a 25 percent item leaves 90 × 0.75 = 67.5, and on a 2 percent item it leaves 88.2. The damage is the zero's weight times the score you would otherwise have earned, which is why one missed high-weight item matters far more than several small ones.

Weighted grade vs weighted GPA

A weighted grade and a weighted GPA answer different questions. The weighted grade, which this guide covers, is one course's percentage built from its own components. A weighted GPA combines several courses, and some schools give extra grade points for honors, AP or IB classes, so that an A can count as 5.0 instead of 4.0. Which courses earn the bonus, and by how much, is school policy. The grade calculator vs GPA calculator question therefore comes down to scope: use a grade calculator to find the percentage and letter for one course, then a GPA tool to combine courses. If you need that second step, the CGPA calculator takes grade points and credit hours and returns the average across courses.

How to find grade weights in syllabus documents

How to find grade weights in syllabus documents is usually simple: look under a heading such as grading, assessment or evaluation near the start. It will list either percentages per category or points per assessment. If it lists only points, how to find weights when grades are in points is a division: each assessment's points over the course total. A 150 point midterm in a 1,000 point course is worth 15 percent. Grade weighting can also hide in policy text, such as a lowest quiz being dropped or a strong final replacing a weak midterm, so read the policies section as well. When the syllabus is ambiguous, ask the instructor in writing and keep the reply.

Common mistakes worth checking

Mixing raw points with percentages. If one assignment is out of 25 points and another is out of 200, always convert each to its own percentage using its own max score before applying weights. Treating both as if they were out of 100 quietly produces the wrong answer.

Forgetting a dropped-lowest-score policy. Some courses drop a student's lowest quiz or homework grade automatically. If that policy applies, leave the dropped item out of the calculation entirely rather than entering it with a zero, since a zero still counts toward a weighted average.

Assuming weights always sum to 100 exactly. Near the end of a course this is usually true, but a mistyped weight is a common source of a grade that looks slightly off; recheck the syllabus's published weights if the total is meant to be 100% and is not.

Using the wrong letter-grade boundaries. A generic illustrative scale (A grades in the 90s, B grades in the 80s, and so on) is a useful reference point, but it is not necessarily your instructor's actual cutoffs. Some courses shift a boundary a few points, skip plus/minus grades, or apply a curve afterward.

Once the formula and the worked example above make sense, plugging your own scores and weights into the grade calculator is mostly a matter of getting each item's score, max score, and weight typed in correctly, the arithmetic itself is exactly what was shown above. If you already know your current grade and just need to know what a still-unknown final exam has to score, the final exam grade calculator solves that backward instead.