Primary school results summary tool

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.

Share this article

James Pembroke

Data Analyst and Advisor with 10 years experience in primary, secondary and post-16 sectors. Follow me on Twitter: @jpembroke

  1. Helen Langeveld on July 2, 2019 at 4:08 pm

    Hi James
    Thank you so much for this. How do we unlock it?
    Helen x
    @helenanndavis1

    • James Pembroke on July 4, 2019 at 2:02 pm

      right click on the tab and enter the password

  2. Duncan S on July 3, 2019 at 3:47 pm

    Great summary thanks James! Graphs useful too especially for governors .

    • James Pembroke on July 4, 2019 at 2:03 pm

      Thanks. Pleased to hear that.

  3. Dom Hughes on July 9, 2019 at 6:50 pm

    James, thanks for providing this spreadsheet – has saved me a lot of time and effort creating tables and graphs for governing body next week!

    • James Pembroke on July 9, 2019 at 7:44 pm

      Pleased to hear it. Made it with governors in mind. Think itโ€™s definitely useful for them.

  4. Yitzchak Freeman on July 9, 2019 at 10:58 pm

    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! ๐Ÿ˜‰

    • James Pembroke on July 10, 2019 at 7:52 am

      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.

  5. Sinead on July 11, 2019 at 8:46 am

    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.

    • James Pembroke on July 11, 2019 at 10:21 am

      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 ๐Ÿ™‚

      • Sinead on July 11, 2019 at 2:49 pm

        Thank you so much!

        I missed that one! Iโ€™ll sort it now though. ๐Ÿ˜Š

        Thanks again for sharing these ๐Ÿ‘

Leave a Comment