How to Calculate a Weighted Average for University Grades

Last updated: August 2025 · 10 min read

A weighted average is the most accurate way to calculate your overall university grade because it accounts for the fact that different modules carry different credit values. A 40-credit dissertation should have twice the impact on your final average as a 20-credit elective, and a weighted average ensures that is exactly what happens.

This guide explains the weighted average formula step by step, walks through multiple examples of increasing complexity, shows you how to factor in year weightings, and covers the most common mistakes students make when calculating manually. If you just want the answer quickly, use our weighted grade calculator to compute it automatically.

What Is a Weighted Average?

A weighted average is a calculation where each value contributes to the final result in proportion to its assigned weight. In the context of UK university grades, the "values" are your module percentages and the "weights" are the credit values of each module.

This is different from a simple (arithmetic) average, where every value counts equally. With a simple average of 65%, 70%, and 80%, the result is (65 + 70 + 80) / 3 = 71.67%, regardless of whether those modules were worth 10 credits or 60 credits. A weighted average corrects for this by giving higher-credit modules proportionally more influence. You can also check our degree classification calculator to see which band your weighted average corresponds to.

The Weighted Average Formula

The formula for a credit-weighted average is:

In plain English: multiply each module grade by its credit value, add up all those products, then divide by the total number of credits.

Example 1: Basic Calculation (Equal Credits)

Let's start with a simple case where all modules have the same credit value:

Total (Grade × Credits) = 1,360 + 1,440 + 1,300 + 1,420 + 1,180 + 1,260 = 7,960
Total Credits = 120
Weighted Average = 7,960 ÷ 120 = 66.33% = Upper Second Class (2:1)

When all modules have the same credit value, the weighted average equals the simple average. The distinction becomes important when credit values differ, as in the next example. If you need to convert raw marks to percentages before plugging them in, our percentage grade calculator can help.

Example 2: Mixed Credit Values

Now let's look at a more realistic scenario with different credit values:

Total (Grade × Credits) = 2,960 + 1,240 + 1,360 + 1,160 + 1,420 = 8,140
Total Credits = 120
Weighted Average = 8,140 ÷ 120 = 67.83% = Upper Second Class (2:1)

Compare this to the simple average: (74 + 62 + 68 + 58 + 71) ÷ 5 = 66.6%. The weighted average is 1.23 percentage points higher because the highest grade (74% on the dissertation) carries double weight. In this case, the difference keeps the student comfortably in the 2:1 range. In borderline cases, that difference can change your degree classification.

Adding Year Weightings

Most UK universities weight final-year marks more heavily than second-year marks. To calculate your overall degree average with year weightings, follow this two-step process:

1. Step 1: Calculate the credit-weighted average for each year separately.
2. Step 2: Multiply each year's average by its year weighting, then add the results.

The formula becomes:

Example 3: Full Degree Calculation with Year Weightings

Let's calculate a complete degree classification using a 33/67 year weighting (Year 2 = 33%, Year 3 = 67%). This is the most common split at UK universities, used by institutions such as Leeds and Manchester Metropolitan:

Year 2 Modules

Year 2 Average = 7,320 ÷ 120 = 61.0%

Year 3 Modules

Year 3 Average = 8,360 ÷ 120 = 69.67%

Applying Year Weightings (33/67)

Overall Average = (61.0 × 0.33) + (69.67 × 0.67)
= 20.13 + 46.68
= 66.81% = Upper Second Class (2:1)

Note how the 33/67 weighting pulls the overall average closer to the Year 3 average (69.67%) than the Year 2 average (61.0%). This student improved significantly between years, and the weighting rewards that improvement. Without year weighting, the simple average of both years would be 65.33%, a lower result. Use our weighted grade calculator to run this calculation with your own marks.

Weighted vs Simple Average: Why It Matters

The difference between a weighted and simple average can change your degree classification. Consider this scenario:

Simple average: (75 + 55 + 58 + 52) ÷ 4 = 60.0% (borderline 2:1)
Weighted average: (75×60 + 55×20 + 58×20 + 52×20) ÷ 120 = (4,500 + 1,100 + 1,160 + 1,040) ÷ 120 = 65.0% (comfortable 2:1)

The weighted average is 5 percentage points higher because the 60-credit dissertation (where the student excelled) dominates. This is why you should always use a weighted average for UK degree calculations, and why our university grade calculator uses credit-weighted calculations by default.

How to Calculate in Excel or Google Sheets

If you prefer to use a spreadsheet, follow these steps:

1. Create a column for module names (column A), grades (column B), and credits (column C).
2. In an empty cell, enter the formula: =SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)
3. Replace B2:B10 and C2:C10 with the actual ranges of your grade and credit cells.
4. The result is your credit-weighted average.

For year weightings, calculate each year's average in separate cells, then use: =(Year2Cell * 0.33) + (Year3Cell * 0.67)

Alternatively, skip the spreadsheet entirely and use our free weighted grade calculator, which handles all of this automatically.

Common Mistakes to Avoid

These are the errors students most frequently make when calculating their weighted average:

1. Using a simple average instead of weighted. This is the most common mistake and can produce results that differ by several percentage points from the correct answer.
2. Entering the wrong credit values. Double-check your module credits in your student handbook or transcript. Dissertations are commonly 40 or 60 credits, not 20.
3. Including Year 1 grades. At most UK universities, first-year marks are excluded from the classification calculation. Do not include them unless your university specifically says otherwise.
4. Forgetting to apply year weightings. If your university uses a 33/67 split, calculating a flat average across all modules will give the wrong result.
5. Using uncapped resit marks. If a module mark was capped at 40% due to a resit, use the capped mark (40%), not your actual resit score.
6. Mixing percentage scales. If some modules are marked out of 100 and others use a different scale, convert everything to the same scale first.
7. Including pass/fail modules. Some modules (such as placements or professional skills) are graded pass/fail and do not have a percentage mark. Exclude these from the average calculation.

Special Cases

Modules with Multiple Assessment Components

If a single module has multiple assessments (e.g., 50% coursework and 50% exam), you first need to calculate the overall module grade using the component weightings. For example, 65% on coursework (50% weight) and 72% on the exam (50% weight) gives a module grade of (65 × 0.5) + (72 × 0.5) = 68.5%. Use our module grade calculator for this step.

Modules at Different Levels

If you take modules at different FHEQ levels (e.g., some Level 5 and some Level 6 modules in your final year), your university may weight them differently. Level 6 modules typically carry more importance than Level 5 modules taken in the same year. Check your programme regulations.

Study Abroad or Placement Year

If you completed a year abroad or a placement year, the marks from that year may be included, excluded, or weighted differently. Some universities treat the placement year as pass/fail, while others include it with a reduced weighting (e.g., 10%). The same weighted average principle applies to postgraduate degrees, though the pass mark is 50% rather than 40%.

Tips for Using Weighted Averages Effectively

• Track your running average throughout the year. Do not wait until results day to calculate. Regular tracking helps you identify where to focus effort.
• Use the target grade feature in our grade calculator to find out exactly what marks you need on remaining modules to achieve a specific classification.
• Prioritise high-credit modules. An improvement of 5% on a 40-credit module is worth the same as a 10% improvement on a 20-credit module.
• Understand your university's specific algorithm. Some universities use additional rules, such as the best 100 out of 120 credits, or dual algorithms that take the higher of two calculations. Check our university-specific calculators for details on individual institutions.
• Keep a record of all your marks. Module marks, credit values, and assessment component weightings should all be documented in one place for easy calculation.

Weighted Average Formula Explained

The weighted average formula is: sum of (each grade × its weight) ÷ sum of weights. For a credit-weighted university average, the weight is each module's credits. This is also called a weighted mean. The credit weighted average formula prevents a small module from influencing your result as much as a dissertation or double module.

For example, imagine two modules: 64% on a 20-credit module and 72% on a 40-credit module. Multiply first: 64 × 20 = 1,280 and 72 × 40 = 2,880. Add the products (4,160), then divide by 60 credits. The answer is 69.33%, not the 68% simple average. This is the method to use whenever you need to calculate a weighted grade with unequal credits.

Weighted Average Calculator: Automate the Calculation

A weighted average calculator makes the same calculation without the risk of arithmetic or rounding mistakes. Enter every completed module once, add its percentage and credit value, and check that the total credits match your transcript. Our free weighted average calculator shows the result immediately and can help you model target marks for remaining work. A weighted mean calculator is especially useful when you have a 40- or 60-credit dissertation, optional modules with different values, or a mix of assessed components.

Use a calculator as a planning tool, not as official confirmation. Universities can apply special rules for resits, condonement, study abroad, and borderline classification decisions. Always compare the result with your course regulations.

How to Work Out a Weighted Average in Excel

A spreadsheet is useful if you want to keep a running record of results. Put percentage marks in cells A2:A10 and the corresponding credits in B2:B10. In a new cell, enter =SUMPRODUCT(A2:A10,B2:B10)/SUM(B2:B10). SUMPRODUCT multiplies each mark by its credit value and adds the products; dividing by total credits gives the weighted average.

1. Enter each module once, with no pass/fail modules unless your regulations give them a numeric value.
2. Verify the credits total 120 for a typical full-time year, or use your actual programme total.
3. Use the recorded capped mark for a resit, even if the raw resit score was higher.
4. Calculate Years 2 and 3 separately before applying year weighting, if your university uses it.
5. Keep decimals in the spreadsheet and round only the final displayed value.

Key Takeaways

• A weighted average multiplies each grade by its credit value, giving higher-credit modules proportionally more influence. If you have a GPA requirement instead, use our GPA calculator to convert.
• The formula is: Σ(Grade × Credits) ÷ ΣCredits.
• Year weightings add another layer: calculate each year's average separately, then combine using the year weights.
• The difference between a weighted and simple average can be large enough to change your classification.
• Common mistakes include using simple averages, wrong credit values, and including Year 1 marks.
• Use our free weighted grade calculator to avoid manual calculation errors.

How to Work Out University Grades Without Mixing Up Weights

To work out university grades accurately, complete the calculation in order: convert raw assessment marks where necessary, calculate each module mark, apply credits to get each year's credit-weighted average, and only then apply year weighting. A credit weighted average formula and a year-weighting formula solve different stages of the problem.

The weighted average calculator handles the credit stage, while the final grade calculator helps when you need a remaining-mark target. Keep your programme regulations beside you for special rules on capped resits, excluded modules, or classification algorithms.