xlsx, 28.53 KB
xlsx, 28.53 KB

An Excel spreadsheet that can be used for any subject to easily input marks for assessments.

This sheet really saves me a lot of time, and could save you a lot of time too.

Key features:

  • Automatically works out percentage, grade, and residual (grade - target grade)
  • Colour coded based on students in the top/bottom 10%
  • Calculates average residual over multiple assessments.
  • Ranks students from highest residual to lowest residual.
  • Displays average residuals for males, females, HAP+, HAP, MAP, LAP, EAL, SEN, PP.

Easily print out spreadsheet and use for parents evening.

Get this resource as part of a bundle and save up to 20%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Review

5

Something went wrong, please try again later.

TES Resource Team

a month ago
5

We are pleased to let you know that your resource Excel Markbook Template, 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.

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.