To calculate your final grade with weights, multiply each category’s score (as a percentage) by its weight, then add the results together. If your homework is worth 30% of your grade and you earned 85%, that category contributes 0.30 × 85 = 25.5 points toward your final grade. Do the same for every category, add them up, and you have your weighted final grade.
The Weighted Grade Formula
Most syllabi break your grade into categories like homework, exams, participation, and a final project, each assigned a percentage weight that reflects how much it counts. A typical breakdown might look like this:
- Homework: 35%
- Midterms: 40%
- Final exam: 20%
- Participation: 5%
The formula is straightforward. Convert each weight to a decimal (35% becomes 0.35), multiply it by the percentage score you earned in that category, and add everything together:
(0.35 × homework score) + (0.40 × midterm score) + (0.20 × final exam score) + (0.05 × participation score) = final grade
Say you earned 88% on homework, 76% on midterms, 91% on the final exam, and 95% on participation. Plugging those in: (0.35 × 88) + (0.40 × 76) + (0.20 × 91) + (0.05 × 95) = 30.8 + 30.4 + 18.2 + 4.75 = 84.15%. That’s your weighted final grade.
Finding Your Category Scores
Before you can run the formula, you need a single percentage for each category. If you have multiple assignments within a category, add up the points you earned across all of them and divide by the total points possible. For example, if you completed four homework assignments worth 25 points each (100 total) and earned 22, 20, 25, and 18 points, your homework percentage is 85 out of 100, or 85%.
Some courses weight individual assignments within a category equally regardless of point values. Check your syllabus or your learning management system to see whether the category score is based on total points or on an equal average of each assignment’s percentage.
Calculating Your Grade Midway Through the Semester
If the semester isn’t over yet, you probably don’t have scores for every category. Maybe you’ve completed homework and one midterm, but the final exam hasn’t happened. You can still figure out where you stand by dividing by the sum of only the weights you’ve completed so far.
Using the same syllabus from above, suppose you only have homework (35%) and one midterm (40%) graded. Your completed weights add up to 0.75. Calculate the weighted sum of just those two categories, then divide by 0.75:
((0.35 × 88) + (0.40 × 76)) / 0.75 = (30.8 + 30.4) / 0.75 = 61.2 / 0.75 = 81.6%
That 81.6% represents your current standing based on the work graded so far. This is exactly the “running total” approach that most learning management systems use. They ignore categories with no grades entered and redistribute the math across the categories that do have scores.
How Learning Management Systems Handle It
If your course uses a platform like Canvas, the system calculates weighted grades automatically, but it helps to understand the logic so you can verify your own number. Canvas assigns the weight to the assignment group, not to individual assignments. Within each group, it divides your earned points by the total possible points to get a category percentage, then multiplies by the group’s weight.
When a category has no graded items yet, Canvas removes it from the equation entirely and divides by the combined weight of the remaining groups. So if a group worth 30% has no scores, the other groups (totaling 70%) become the denominator. This means your displayed grade reflects only the work that’s been scored, not zeros for things you haven’t done yet. That’s an important distinction: your current grade may look higher than your actual final grade if you’re missing work that simply hasn’t been counted yet.
One thing to watch for is assignment groups weighted at 0%. Any work placed in a zero-weight group won’t affect your final grade at all, which is sometimes used for extra credit or ungraded practice.
Using a Spreadsheet to Automate the Math
If you want a reusable calculator, a simple spreadsheet in Excel or Google Sheets does the job in seconds. Set up three columns: one for category names, one for weights, and one for your scores. Then use the SUMPRODUCT function to handle the multiplication and addition in one step.
Suppose your weights are in cells B2 through B5 and your scores are in cells C2 through C5. The formula is:
=SUMPRODUCT(B2:B5, C2:C5) / SUM(B2:B5)
SUMPRODUCT multiplies each weight by its corresponding score and adds the results together. Dividing by SUM of the weights ensures you get a correct answer even if your weights don’t add up to exactly 100%, which is useful for mid-semester calculations where you only include completed categories.
If you get a #VALUE error, it usually means your weight range and score range aren’t the same shape. Both need to be either rows or columns. You can fix a mismatch by wrapping one range in the TRANSPOSE function: =SUMPRODUCT(TRANSPOSE(B2:B5), C2:C5) / SUM(B2:B5).
Figuring Out What You Need on the Final
One of the most common reasons people search for this formula is to figure out what score they need on an upcoming exam to hit a target grade. You can solve for the unknown by rearranging the formula with basic algebra.
Say your target final grade is 90%. You already know your homework score (88%, weighted 35%), your midterm score (76%, weighted 40%), and your participation score (95%, weighted 5%). The final exam is worth 20%. Set up the equation:
(0.35 × 88) + (0.40 × 76) + (0.05 × 95) + (0.20 × X) = 90
Calculate the known portions: 30.8 + 30.4 + 4.75 = 65.95. Now solve for X:
0.20 × X = 90 − 65.95 = 24.05
X = 24.05 / 0.20 = 120.25%
In this case, you’d need a 120.25% on the final exam to reach a 90% overall, which is almost certainly impossible. That tells you a 90% isn’t realistic, and you can adjust your target downward or look for extra credit opportunities. Running this calculation early in the semester, while there’s still time to change your study habits, is far more useful than running it the night before the final.
Quick Reference Example
Here’s a complete worked example you can follow along with using your own numbers:
- Assignments (30% weight): You scored 210 out of 250 total points. Category score: 210 ÷ 250 = 84%. Weighted contribution: 0.30 × 84 = 25.2
- Quizzes (15% weight): You scored 72 out of 80. Category score: 90%. Weighted contribution: 0.15 × 90 = 13.5
- Midterm (25% weight): You scored 68 out of 100. Category score: 68%. Weighted contribution: 0.25 × 68 = 17.0
- Final exam (30% weight): You scored 85 out of 100. Category score: 85%. Weighted contribution: 0.30 × 85 = 25.5
Add the weighted contributions: 25.2 + 13.5 + 17.0 + 25.5 = 81.2%. That’s your final weighted grade. Notice that the midterm score of 68% dragged the average down, but because the final exam carried a heavier weight and you scored well on it, the damage was limited. That’s the whole point of weighted grading: categories your instructor considers more important have a bigger impact on your final number.