TES Maths ROTW: Ultimate Excel markbook
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 is a secondary maths teacher in the North of England.