Weighted grade calculator: what you need on the final exam

Halfway through a course, most students ask the same two questions: where do I stand, and what do I need on the final? Both have exact answers once you know the weights. This guide shows the arithmetic, so you can check any calculator, including your own spreadsheet.

Weights: what each part is worth

A syllabus usually says how the grade is made up, for example homework 20 per cent, quizzes 15, midterm 25 and final 40. The weights should add up to 100. Each category has its own percentage score: points earned divided by points possible in that category. The course grade is the weighted average of those percentages.

Always take the weights from your syllabus, not from a guess. Some courses drop the lowest quiz or give extra credit. Those rules change the arithmetic, so write them down.

Where you stand now

When only some categories have grades, the question "where do I stand" has two meanings. One is the average of what has been graded. The other is your grade if everything not yet graded counted as zero. The first is the better measure of how you are doing so far.

Here is a worked example with invented scores. Homework is at 90 per cent, quizzes at 80 and the midterm at 75. The final is still to come.

The current grade is 48.75 divided by 60, which is 81.25 per cent. This is the weighted average of the graded categories only. The weights of those categories are rescaled to 60, not 100.

What you need on the final

The final is worth 40. The grade you will have at the end is

48.75 + 0.40 x (score on the final)

and you want it to reach a target. Solve for the final:

needed = (target - 48.75) / 0.40

Try some targets:

The last line is a result worth noticing. A needed score above 100 means that 90 is out of reach on the final alone, unless the course has extra credit. Knowing that in October is better than finding out in December, because you can aim at 85, or ask your teacher what is possible.

Two cautions. First, grades are rounded in different ways. A teacher might round 89.6 up to 90 or might not, so treat a result that close to a limit as uncertain. Second, some courses require a minimum score on the final or in a category to pass, whatever the average. The calculation does not know about those rules. Read your syllabus.

From percentages to letters to GPA

A letter comes from a scale: a table that says, for example, that 93 per cent and above is an A, and that 90 to 92.99 is an A-. Each letter has grade points. A common US plus and minus scale gives A 4.0, A- 3.7, B+ 3.3, B 3.0 and so on, but your school's scale decides. Use the one in your handbook.

Semester GPA is credit-weighted: multiply each course's grade points by its credits, add them up and divide by the total credits.

Here is an invented semester:

The semester GPA is 42.7 / 12 = 3.56. Notice that the 4-credit course counts twice as much as the 2-credit one. A single bad grade in a big course moves the GPA more than a bad grade in a small one.

The cumulative GPA works the same way over all semesters: total grade points divided by total credits. If you began tracking part-way through your studies, start with the credits and the GPA you had before and add the new courses to them.

What to do with the numbers

A calculator tells you what is needed. It cannot tell you how to get it. Two findings from learning research bear on a final exam. Dunlosky and colleagues (2013) reviewed ten study techniques and rated practice testing and distributed practice, meaning study spread over several sessions, as the most useful. Karpicke and Roediger (2008) found that retrieving material from memory helped learning more than repeated study of the same material. These papers are not about grade targets, so take them as a method and not as a promise.

In practice: look at your needed score, then divide the material of the final into parts, test yourself on each part without notes, and come back to the parts you missed on a later day. A needed score of 90.6 per cent says how good your recall of the final's material has to be, which is useful to know when you plan how many days to give it.

Keep your own record

Schools show grades in their own system, but not always promptly, and they may not show the weights the way you need. Keeping your own list of every graded item, with the score, the maximum and the category, takes a minute after each return. It lets you catch mistakes in the school's records and answer the "what do I need" question yourself at any time.

Extra credit, dropped scores and rounding

Three rules can change the answer. If the lowest quiz is dropped, remove it before you average the category. If extra credit adds points above the maximum, the category percentage can exceed 100, and the course total can too. If the school rounds the final course percentage, a result of 89.6 may count as 90, but only if the syllabus says so. Write the rules in your notes and apply them in your sums, because a calculator cannot know them.

A quick check by hand

Before you trust any tool, test it on a case you can do by hand, such as the example above. Put in the same scores and weights and see whether it returns 81.25 per cent now, and 90.6 per cent needed for 85. If the tool disagrees, find out why: it may rescale the weights differently, or ignore ungraded categories. Agreement on a small case is good evidence that the tool follows the method you expect.

Tool that fits

The GPA & Grade Tracker (Excel, EUR 8, paid once) has room for 20 courses and 300 graded items. You enter courses with credits, set the weights for each category, and log scores. It shows each course's current percentage and letter, weighting only the categories that already have grades, as in the example above. The Final exam sheet takes a course and a target and shows the score needed on the final, and also the score needed for each letter on your scale. The GPA sheet gives semester and cumulative GPA on a 4.0 scale, including credits and GPA from before you started, with a chart. The grading scale is a table you can edit to match your school. Example data is included and can be cleared. It works in Excel 2016 and later, Google Sheets and LibreOffice, with no macros. It is a planning aid: your school's own rules and official transcript always apply.

Questions people ask

Sources

1. Dunlosky, Rawson, Marsh, Nathan and Willingham (2013), Improving students' learning with effective learning techniques, Psychological Science in the Public Interest 14(1), 4-58
2. Karpicke and Roediger (2008), The critical importance of retrieval for learning, Science 319(5865), 966-968
3. HiddenWay worked example: our own arithmetic, assumptions listed in the text

We checked each source on 17 October 2026. If a fact here is out of date, tell us at hello@hiddenway.info.

Keep reading

• Student study planner: a weekly system and an exam countdown
• Math practice at home for ages 5-10: short and regular
• More in Study and school