Scoring 90% on an assignment does not add 90 points to your course result. If that assignment is worth 20% of the course, its contribution is 18 percentage points.
Weighted Course Grade makes those contributions visible. Use the assessment weights in your course outline, including practical work or a final examination where the outline assigns them a separate share.
Convert raw assessment marks first
The score field takes a percentage. A quiz result of 16 out of 20 should be entered as 80, not 16. The weight field takes the assessment’s share of the entire course.
Every row should represent an assessment or assessment group with a known final weight. If several quizzes together make up 20% of the course, calculate their group percentage according to the lecturer’s rules before entering that row.
A course ending at 77%
Suppose quizzes score 80% with a 20% weight, assignments score 90% with a 20% weight, the midterm scores 75% with a 20% weight, and the final scores 70% with a 40% weight.
Those contributions are 16, 18, 15 and 28 course points. Their total is 77%. The higher final weight means its score has more influence than any one of the other rows.
The weights add to 100%. The tool rejects a worksheet whose weights do not total 100%, rather than silently stretching an incomplete list into a full course grade.
| Assessment | Score | Weight | Course points |
|---|---|---|---|
| Quizzes | 80% | 20% | 16 |
| Assignments | 90% | 20% | 18 |
| Midterm | 75% | 20% | 15 |
| Final | 70% | 40% | 28 |
Do not treat an unfinished course as complete
Leaving out a pending final examination changes the meaning of the result. Entering zero for that exam gives a scenario in which it earns zero, not a forecast of how you will perform.
If you want to know what score you still need, use Final Exam Marks Needed. It works backwards from secured course points, the final weight and your chosen target.
Check the rules outside the arithmetic
Some courses require a separate pass in the final, laboratory or practical component. A weighted course percentage does not prove that each separate requirement has been met.
Likewise, the percentage does not automatically establish a letter grade or grade point. Use the published grading method for your own institution, especially where relative grading is used.
Before sharing the worksheet, compare its rows with the course outline and the instructor’s recorded scores. Exporting a clear contribution ledger is useful, but it does not replace the official grade record.