Grade / Marks Calculator
Grade / Marks Calculator
Knowing your current standing helps you focus your effort. This free Grade / Marks Calculator works out your weighted grade from each assessment's mark and weighting, and tracks your running average — so you always know where you stand and what you need on what's left.
How to use it: enter each assessment with its mark and weighting, and the calculator shows your weighted average. Use it to track progress across a course and to work out the grades you need on remaining assessments to hit your target.
Key features
- Calculate weighted grades
- Track your running average
- Plan grades you still need
- Per subject or course
- Works in Excel and Google Sheets
This template is designed for professionals and teams working in Education & Learning who want to manage Students tasks efficiently in Microsoft Excel — without the need for expensive specialist software.
The Grade / Marks Calculator is part of our Education & Learning collection — downloaded 12 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is it free?
Yes, free download with no sign-up.
What does it calculate?
Your weighted grade and running average.
Can it plan grades I still need?
Yes, work out what's needed to hit a target.
Is it editable?
Fully editable in Excel or Google Sheets.