xlsm, 228.29 KB
xlsm, 228.29 KB
xlsm, 233.64 KB
xlsm, 233.64 KB

Free Version has over 23 000 downloads on the TES, a rating of 4.6 with 35 reviews. Try here for free

https://www.tes.com/teaching-resource/teacher-markbook-the-ultimate-excel-markbook-updated-for-2019-11177885

Simple to use but extremely powerful

No experience of Excel needed

Individual Student Summaries

Filtering by different types of work

Adjustable Grade Boundaries

Grade Boundaries for percentages and raw scores

Enter raw score and the spreadsheet calculates everything else for you.

Access to all worksheets and file will never expire.

For more customised markbook or access to the VBA, please contact tompowell@educationexcelsolutions.co.uk

Reviews

5

Something went wrong, please try again later.

needsi

6 months ago
5

This is an excellent markbook. With students who have a target of an 'A' and achieve an 'A*' the progress column reads as '0' and is coloured yellow/amber. Is there a way of changing that so that it records '1' for progress and is green?

matthewmcgrath12345

4 years ago
5

The full version of the Ultimate Excel Markbook has many more columns for assessments. Definitely enough for a whole year of topic tests and homework e.t.c. The programming is excellent. Colour coding as I enter data gives me an immediate impression of who needs more practise and who is repeatedly getting higher marks (and therefore needs stretching) as well as class averages. The printout analysis for parents evening is swift -every student an individual analysis at the touch of a button. Just hand it to parents at parents evening. It's so clear how well the student is doing and saves about five minutes of conversation. My class overview is better, conversations with parents are more meaningful and focus more on action. It's way better than any of the online portals I've seen. Highly recommended.

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.