An Excel spreadsheet which I have been working on (on and off) for the better part of 10 years.
This sheet really saves me a lot of time, and could save you a lot of time too.
What can it do that a paper markbook can’t?
- Calculate a % from a raw score (and total)
- Apply a custom grade boundaries to this %, and assign a grade automatically.
- Colour-code the grade to show whether it is above, on, or below the student’s target.
- Provides a handy report with a graph showing the student’s progress over time compared with their target grade. A real time saver for parent’s evening!
I suggest making one copy of this sheet per class you teach. Max number of students supported per class = 32 for weird reasons.
Something went wrong, please try again later.
We are pleased to let you know that your resource Digital Markbook Calculator, has been hand-picked by the Tes resources content team to be featured in https://www.tes.com/teaching-resources/blog/making-marking-efficient-and-meaningful in November 2024 on https://www.tes.com/teaching-resources/blog. Congratulations on your resource being chosen and thank you for your ongoing contributions to the Tes Resources marketplace.
I have figured out the A* issue, it's a great resource
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.50