TES Maths ROTW: Ultimate Excel markbook

Craig Barton
25th January 2016


TES Maths Resource of the Week

Resource title: Ultimate Excel markbook

Resource author: tompowell2468

What is it?

This week's Resource of the Week is a little bit different. It's a markbook. But it's no ordinary markbook. This is the ultimate Excel markbook, and it certainly lives up to its name.

At our school, we regularly record our homework scores centrally on a spreadsheet on the school network and it just ends up being a load of numbers that don't really mean anything. But with this markbook, you get clear insights and, crucially, a picture of progress. There is the facility to instantly print off individual pupil record sheets in order to get a view of their progress over time and also to identify their areas of weakness.

And it takes no longer to record your results than any equivalent markbook.

How can it be used?

This markbook can be used in a variety of ways. If used by an individual teacher it will be invaluable for tracking progress, getting an instant overview of class performance and as a handy aid for things like parents evening and report writing. You can easily add students, sort data and print out reports.

But there's real power if all teachers in a department choose to use it, as results can be compared and contrasted to develop key insights across entire year groups.


Craig Barton

Craig is a secondary maths teacher in the North of England.

Contact us

Visit our forums

Latest education news

New to TES Resources ? Find out more about becoming an author on TES, or dive straight in and start downloading.