Excel Markbook Template

An Excel spreadsheet that can be used for any subject to easily input marks for assessments. The full spreadsheet is on my page.

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.