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 ;-).
Subscribe to receive email updates when new blog posts are published.
Hi James
Thank you so much for this. How do we unlock it?
Helen x
@helenanndavis1
right click on the tab and enter the password
Great summary thanks James! Graphs useful too especially for governors .
Thanks. Pleased to hear that.
Can I just ask, in 2016 for KS2 combined at EXS+, I have the National figure as 53%. The spreadsheet says 57%. Is this correct?
James, thanks for providing this spreadsheet – has saved me a lot of time and effort creating tables and graphs for governing body next week!
Pleased to hear it. Made it with governors in mind. Think it’s definitely useful for them.
Very useful, simple and easy to use, and much appreciated! I made a small adaptation: for the tables (and therefore automatically the charts also) for all results except KS2, I added the current NC year group after the calendar year to make it clear which current cohort the chart refers to, so it’s not just historical data but can also more proctively inform discussion about current provision for those cohorts – e.g. “2016 (Y5)”.
Thanks so much for making this – incredibly good value! 😉
That’s a great idea. Was thinking this last night whilst trying to work out what year group those KSq results now relate to. Thanks.
This is terrific, thank you James! Great for governors and as an overview.
This is brilliant, thank you!
I noticed on the charts page that the GPS table is labelled as maths. I was able to change it, but was just confused for a few minutes.
Thanks again.
Ha! Yes, just noticed same whilst sat in a governor meeting. Changed on main version. Also noticed that %GDS 2019 cells for reading and maths are not formatted as percentage. Will need to change that too when you enter that data. Glad I supplied the password 🙂
Thank you so much!
I missed that one! I’ll sort it now though. ?
Thanks again for sharing these ?