Home/Blog/Teachers & Tutors
Teachers & Tutors · 10 min read

How to Calculate Weighted Grades Fairly: A Teacher's Method

The short answer

To calculate a weighted grade, average each student's scores as percentages within each category, multiply each category average by its weight, add the results and divide by the total weight of the categories that have marks. Leave out categories with no marks yet, record missing work separately unless policy requires zeros, then apply your grade boundaries and check any student near a boundary against the evidence.

Want the tools, not just the method? The The Classroom Assessment and Report Card Kit kit turns this guide into ready-to-use templates, spreadsheets and printables, with an instant download.

Key takeaways
  • Convert every mark to a percentage before averaging, so a 10-mark quiz and a 40-mark test are comparable.
  • Weights are relative: what matters is each category's share of the total weight.
  • Leave categories with no marks out, and share their weight across the others, until they have marks.
  • A zero for missing work can drag an average down far more than the learning justifies; follow your school's policy and make the effect visible.
  • Report achievement in the grade; report lateness, effort and behaviour separately.
  • Look at the evidence for any student close to a boundary before you report.

What are the steps to calculate a weighted grade?

Weighted grading gives some kinds of work more influence on the final grade than others. A unit test that covers four weeks of learning usually counts for more than a homework set that is mainly practice. The calculation is simple once the decisions are made, and the decisions are where fairness lives. Here is the method, in order.

  • 1. Decide which work counts. Diagnostic checks and most formative quizzes inform teaching and do not belong in a grade. Summative tasks do.
  • 2. Group summative work into categories, such as classwork, homework, unit tests, projects and practicals, and an end-of-term exam.
  • 3. Agree a weight for each category with your department, for example 10, 10, 40, 15 and 25. Write the weights down in your assessment policy.
  • 4. Convert every mark to a percentage of its maximum before averaging.
  • 5. Average the percentages within each category for each student, leaving out work that was excused or not yet marked.
  • 6. Multiply each category average by its weight, add them, and divide by the total weight of the categories that have marks.
  • 7. Apply your grade boundaries to the weighted percentage.
  • 8. Before reporting, check any student near a boundary, any student with missing work and any result that surprises you against the evidence.

What is a weighted grade, and why do schools use weights?

A weighted grade is a weighted average: each part contributes in proportion to its weight rather than equally. Schools use weights because not all evidence is equally strong. A carefully blueprinted, moderated unit test is better evidence of what a student has learned than a homework set that may have been done with help, in a hurry or not at all.

Weights also express values. A department that weights projects heavily is saying that sustained work, research and presentation matter. A department that weights the end-of-term exam heavily is saying that what students can do independently at the end matters most. Neither is wrong, but the choice should be made deliberately, agreed by colleagues so grades are comparable across classes, and explained to students and families.

Weights should also match the quality of the evidence in each category. If homework is often completed with help from family, tutors or AI tools, it tells you less about independent learning, and a light weight is honest. If classwork quizzes are short retrieval checks, they may be better left out of the grade altogether and used to plan teaching.

Weights are relative. Weights of 10, 10, 40, 15 and 25 behave exactly like 0.10, 0.10, 0.40, 0.15 and 0.25. What matters is each category's share of the total, which is why the method divides by the total weight rather than assuming it is 100.

What does a worked example look like?

Take one Grade 8 student, mid-term, in a department that uses the weights above. The end-of-term exam has not happened yet. The student's category averages so far are 85% for classwork, 70% for homework, 62% for unit tests and 78% for projects and practicals. The grade scale is A from 85%, B from 70%, C from 55%, D from 40% and E below that.

Multiply each average by its weight and add: 8.5 + 7.0 + 24.8 + 11.7 = 52.0. The categories with marks carry 75 of the 100 weight points, so the weighted percentage is 52.0 / 75 = 69.3%. That is a C on this scale, just under the B boundary.

Two common shortcuts give different answers. Averaging the four category averages without weights gives 73.8%, a B, because it lets classwork and homework count as much as unit tests. Dividing by 100 instead of 75 gives 52.0%, a D, because it treats the missing exam as a zero. Neither reflects what the student has shown.

When the exam happens, suppose the student scores 74%. The total becomes 52.0 + 18.5 = 70.5 out of 100, a weighted percentage of 70.5%, which is a B.

CategoryWeightAverage so farWeight x average
Classwork1085%8.5
Homework1070%7.0
Unit tests4062%24.8
Projects1578%11.7
End of term exam25not sat yetleft out
Total75 (of 100)52.0

How should missing and late work affect the grade?

Missing work is the most common reason a grade stops describing learning. On a percentage scale, a single zero pulls an average down much further than a single low mark, because the gap between 0 and a typical score is so large. Grading researchers such as Thomas Guskey have argued for many years that zeros on a percentage scale distort averages for this reason.

In the example, suppose the homework average of 70% came from two marked sets (80% and 60%) with a third set missing. If the missing set is left out, the homework average is 70% and the weighted grade is 69.3%. If it is entered as zero, the homework average falls to 46.7% and the weighted grade falls to 66.2%. Nothing about the student's understanding of the unit changed.

Your school's policy decides how missing work counts. Whatever the rule, three practices keep grades honest: record missing work as missing, separately from marks; chase it with reminders, a conversation and support, and log what you tried; and record lateness beside the grade, not inside it, so a late but strong piece of work still shows what the student knows. If your school reports effort, attendance or behaviour, report them in their own place.

What happens when a category has no marks yet?

Mid-term grades often go wrong because the end-of-term exam or a project has not happened yet. If you divide by the full 100 weight points, the empty category acts like a zero for every student. If you leave it out and divide by the weight of the categories that do have marks, each existing category's share grows in proportion, and the mid-term grade is a fair estimate of where the student stands on the evidence so far.

The same logic applies to a single student who was excused from a whole category, for example a project missed through a long medical absence approved by the school. Leaving the category out for that student, rather than entering zeros, keeps the grade about learning. Record the reason in your notes so the decision is visible at moderation and to leaders.

Say which approach you use when you share mid-term grades, and label them as interim. A mid-term grade built mostly from classwork and homework is less certain than one that includes a unit test, so treat it as a conversation starter rather than a verdict.

Measure where you are

Reading helps; measuring tells you what to work on. These AI-graded assessments on AssessAll pair with this topic:

How do grade boundaries turn a percentage into a grade?

Boundaries convert the weighted percentage into the grade your school reports. Systems differ widely. In England, GCSEs are graded 9 to 1. IB Diploma subjects are graded 1 to 7. Western Australia, for example, requires plain-language semester reports with A to E grades for Years 3 to 10. Many US districts use letter grades, and many have moved to standards-based reporting, where each standard is reported separately on a scale such as 1 to 4. In India, the CBSE reports marks and grades for board examinations, and NEP 2020 and the Holistic Progress Card approach move school-based assessment toward competencies.

Two rules help whatever your system. First, write boundaries down once, from the lowest minimum to the highest, and use them for every student in the department. Second, treat any student within a percentage point or two of a boundary as a professional judgement, not a decimal: look at the most recent evidence, the moderated marks and the student's work on the most important outcomes. Where your system reports by criterion or competency, do not average across criteria at all; report each one.

What are the common mistakes when calculating grades?

  • Averaging raw marks from tasks with different maximums instead of converting to percentages first.
  • Counting diagnostic and formative checks, so students are graded on the day they were still learning.
  • Dividing by 100 when a weighted category has no marks yet.
  • Letting zeros for missing work dominate the average without the policy requiring it, and without chasing the work.
  • Penalising lateness inside the attainment mark, so the grade no longer says what the student knows.
  • Mixing effort, behaviour or neatness into an achievement grade.
  • Different teachers using different weights or boundaries for the same course.
  • Reporting a grade on a boundary without looking at the evidence again.
  • Using unmoderated marks from different markers as if they were comparable.

How do you check a grade is fair before reporting it?

A calculation is only as fair as the evidence behind it. Before grades go on a report, run four checks. Are the marks comparable? Common assessments should have been standardised before marking and moderated afterwards, with any pattern of difference corrected across the whole set. Is the evidence complete? Every missing piece should have been chased and recorded under your policy. Are access arrangements applied? Students entitled to extra time or other arrangements should have had them in class tests as well as exams. And do the numbers match what you see? If a grade surprises you, look at the student's work before you change anything.

Feedback matters as much as the grade. The Education Endowment Foundation's Teaching and Learning Toolkit rates feedback as high impact for very low cost, estimating about six months of additional progress on average. A grade with no next step attached does far less than a grade with one specific action.

Finally, protect the data. Grades are personal data about children. In the US, FERPA gives parents rights over education records, which pass to the student at 18 or on entering postsecondary education, and other countries have their own rules. Keep gradebooks in school-approved systems, record students by code where you can, and never paste identifiable student data into a public AI tool. The UK Department for Education's guidance on generative AI in education makes the same point: avoid entering personal data, and check every output with professional judgement.

If you want the whole method in ready-made tools, The Classroom Assessment and Report Card Kit from Bodhih Training includes a gradebook that applies these rules from a Settings sheet, a calculator for item analysis and a 128-comment report bank. To check your own marking consistency, AssessAll's Marking Consistency and Assessment Design Assessment is one option, and a Jobulary individual development plan can turn what you learn into a measured plan for the year.

The Classroom Assessment and Report Card Kit e-book cover
Bodhih Pro Kit

Grade fairly without building the spreadsheet yourself

The Classroom Assessment and Report Card Kit gives you a weighted gradebook driven by a Settings sheet, item analysis, rubrics, moderation forms and 128 report comments, ready to use the same day.

Common questions

Questions people ask next

How do I calculate a weighted grade in Excel or Google Sheets?

Put each category average in a cell and each weight beside it. Multiply each average by its weight, add the results with SUM, and divide by the SUM of the weights for categories that have marks. Wrap it in IFERROR so a student with no marks shows a blank, not an error.

Do weights have to add up to 100?

No. Weights are relative. 1, 1, 4 behaves the same as 10, 10, 40 as long as you divide by the total weight used. Many departments use weights that add to 100 because they are easier to explain.

Should missing work count as zero?

Follow your school's policy. Many schools now record missing work separately and chase it, because a single zero can pull a percentage average down far more than the learning justifies. If your policy requires zeros, make sure the work has been chased first.

Should homework count toward the grade?

It depends on its purpose. Homework that is practice is better used formatively, with little or no weight. Homework that is an independent summative task can count. Many departments weight homework lightly because it may not be the student's unaided work.

How do I handle a student exactly on a grade boundary?

Look at the evidence again: the most recent work, moderated marks and performance on the most important outcomes. Decide on the evidence, record why, and apply the same approach to every student near a boundary.

What is the difference between weighted and standards-based grading?

Weighted grading combines categories into one percentage. Standards-based grading reports each standard or criterion separately on a scale, without averaging across them. Some schools use both: standards for reporting, weighted categories for an overall summary.

Can I use AI to calculate or decide grades?

A spreadsheet should do the arithmetic. AI tools can help draft explanations or feedback wording, but they should not decide grades, and you should never enter identifiable student data into a public AI tool.