Combine Exam Scores with Explicit Percentage Weights

Write weights as a separate column

Use scores in a common percentage scale and record each exam’s independent weight. A midterm worth 25% of the course and a final worth 50% are not equally weighted, even if each exam has 100 possible marks. Avoid treating a weight of 25 as 0.25 in a field that expects percentage numbers.

Normalize the supplied subset

Scores of 80% and 92%, with weights 25 and 50, have weighted sum 80 × 25 + 92 × 50 = 6,600. Dividing by supplied weight 75 gives an 88% average for that subset. Its full-course contribution is instead 66 percentage points: 6,600/100. The distinction matters because another 25% of the course remains outside the supplied rows.

Complete the remaining category

If the remaining 25% category averages 76%, it contributes 19 points. The final course grade is 66 + 19 = 85%. It is neither the normalized exam average of 88% nor the simple average of all three scores. Labeling the outputs keeps an incomplete record from appearing to be a full final grade.

Read the effect of a score change

Raising the final exam from 92% to 96% adds 4 × 0.50 = 2 full-course percentage points. Raising the midterm by the same four points adds only one full-course point. A normalized subset changes by a different amount because its denominator is 75 rather than 100.

Check category and replacement rules

A weight total below 100 is not automatically an error when deliberately examining a subset. A total above 100 may indicate duplicate categories or a bonus-weight policy; check the syllabus. If one exam replaces another, edit the affected rows before calculating instead of adding both versions of the same grade.

Work through three examinations and an incomplete course

Take scores of 70%, 90% and 80% with course weights of 20%, 40% and 10%. Their score-times-weight products are 1,400, 3,600 and 800, totaling 5,800. Supplied weight totals seventy, so the weighted-exam calculator reports 5,800/70 = 82.857142…% for the supplied subset. The subset contributes 58 percentage points to the complete course. Writing both outputs prevents a normalized average from masquerading as an already complete course grade.

If the remaining 30% category finishes at 75%, it contributes 22.5 points. The completed course result is therefore 58 + 22.5 = 80.5%. Normalizing the three examinations to 82.857142… first and then treating that number as a 100% course contribution would count their influence incorrectly. Keep the supplied seventy-percent block and its missing thirty-percent block separate until the full-course contributions are combined.

Compare changes using the correct denominator

Raise the forty-percent examination from 90 to 96 while leaving all other inputs fixed. Its six-point score improvement contributes 6 × 0.40 = 2.4 additional course points, so the complete result rises from 80.5 to 82.9%. The subset average instead rises by 240/70 = 3.428571… points to 86.285714…%. Both changes are correct; they divide the same additional weighted sum by different denominators.

Raising the twenty-percent examination by six points adds only 1.2 course points. This comparison explains why equally sized score changes need not have equal influence. It does not imply that preparation time translates into an equal score improvement in both examinations. A sensitivity calculation holds the other scores and weights constant, whereas an actual revised study plan may change several outcomes together.

Convert raw marks before entering percentage scores

An exam result of 35 out of fifty is 70%; forty-five out of fifty is 90%; sixteen out of twenty is 80%. Those percentage scores reproduce the preceding three-row example when the independent weights are 20, 40 and 10. Entering raw marks of 35, 45 and 16 as though they were percentages would yield a different answer even though every individual field falls inside a superficially reasonable numerical range.

Possible marks determine a score percentage, not its syllabus weight. If the instructor truly uses total points across the exams, use the points model instead of explicit course weights. If weights are normalized relative values such as two and one, convert them to the intended percentage shares before using a form that caps covered course weight at one hundred. A zero-weight row contributes nothing, but an all-zero weight set has no normalized average.

Check replacement rules and record covered weight

A separate complete example, scores of 50% and 100% weighted thirty and seventy, yields 50 × 0.30 + 100 × 0.70 = 85%. Its covered weight is one hundred, so the normalized average and full-course result agree. This is a useful check of a rebuilt grade record after all components are known. Agreement is not expected when the supplied weights intentionally cover only part of the course.

Inspect duplicated category names, replacement examinations and bonus rules before totaling the weights. A later examination that replaces an earlier one should update the affected contribution rather than silently adding another full-weight row. Save the covered-weight value beside every result. The tool does not choose dropped examinations, assume missing categories are zero, or predict a curve; each of those decisions requires a separately stated grading rule.