AQA Core science automatic markbook

Automatically traffic lights against year 9 target grades and calculates Mock and ISA UMS as well as an end of Core UMS and Grade. I hope you will find it useful. Full KS4 department mark book (in the same format to follow shortly- for core, additional and triple science AQA) When inputting Yr 9 target grades please ensure you use the C3, C2, C1 format (for all grades) as the traffic lighting works with sub grades only. The mini test marks only do up to B (as this is for Yr 9 students only- however you can alter the grades/ make minitests longer or shorter in the LookUps Sheet.