TES Maths ROTW: Ultimate Excel markbook

Craig Barton

TES Maths ROTW Ultimate Excel Markbook,tes Maths,rotw,mats Resources,markbook,marking,secondary Marking,ks4

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.