Electronic Mark Book - Automatically Calculates Percentages and Grades!

This electronic mark book automatically calculates percentages and GCSE grades for assessments. I have been using it for years and it saves lots of time sitting with a calculator and a sheet of grade boundaries. Contains tabs for 15 classes, each with room for 15 assessments throughout the year. You set your own grade boundaries on the first tab, enter the maximum score for each assessment and then simply enter each student’s score. The mark book does the rest! I’ve included a set of instructions explaining how to use it. It’s incredibly user friendly and you can make a new copy every year so all of your assessment data is conveniently saved on your computer. Some of my colleagues have uploaded it to Google Sheets and it works fine on there too if you would like it in the cloud.

It took a long time to make and to figure out the formulae but now it is an intrinsic part of my teaching practice. Enjoy!