You can download the tool here.
I thought it would be useful to produce something that showed 4 years’ results against national figures for each statutory assessment – EYFS (GLD), phonics, KS1 and KS2 – in an easy to read format. I thought it’d be even better if it was free. The national figures are already entered into the tables; schools just need to add their own results for past 3 years (4 years once 2019 data is out). It shouldn’t take too long: once it’s done, it’s done and you’ll have all your key results in one place. The data in the tables generates the charts on the following tab, and I’ve set the print margins up so it should print on 4 pages. I hope it’s useful for governors especially.
I’ve added some guidance notes and included the password to unlock it in case you want to adapt it. You’ll need to unlock it to add the 2019 nationals when they are published (9th July for KS2; later for other assessments). I’ll add those 2019 results in but thought I’d publish it now in case schools want to start using it.
Constructive feedback welcome. Please let me know if you find any errors.
Hope it’s useful. If it’s not, remember it’s free ;-).