Analyse School Performance summary template (primary)

Many of you will have downloaded this already but I thought it’d be useful to put it on my blog. For those who don’t already have it, it’s a rather low tech and unexciting word document designed to guide you through ASP and pull out the useful data. Aim is to summarise the system down to a few pages.

You can download it here

The file should open in Word Online. Please click on the 3 dots top right to access the download option. Please don’t attempt to edit online (it should be view only anyway). Also, chances are it will be blocked by schools computers (schools always block my stuff).

A couple of points about the template:

1) Making sense of confidence intervals
Only worry about this is progress is significantly below average, or if data is in line but high and close to being significantly above.

If your data is significantly below average, take the upper limit of the confidence interval (it will be negative e.g. -0.25). This shows how much each pupils score needs to increase by for your data to be in line (0.25 points per pupil, or 1 point for every 4th pupil). Tip: multiply this figure by the number of pupils in the cohort (eg. -0.25 x 20 pupils = -5). If you have a pupil – for whom you have a solid case study on – that has a score at least equal to the result (i.e. -5 in this case), removing that pupil from the data should make your data in line with national average.

If your data is in line and you are interested to know how far it would need to shift to be significantly above, note the lower part of the confidence interval (it will be negative, e.g. -0.19). This again shows how much your data needs to shift up by, but in this case to be significantly above. In this case, each child’s score needs to increase by 0.2 points for the overall progress to be significantly above (we need to get the lower limit of the confidence interval above 0 so it needs to rise by slightly more than the lower confidence limit). Obviously pupils cannot increase their scores by 0.2, so best to think of it as 1 point for every 5th child. Or. as above, multiply the lower confidence limit by the number of pupils in the cohort (e.g. -0.2 x 30 pupils = -6). If you have a pupil with a score at least equal to this result (i.e. -6) then removing them from the data should make the data significantly above average.

Easiest thing to do is model it using the VA calculator, which you can download from my blog (see August) or use the online version

2) Difference no. pupils
This has caused some confusion. It’s the same concept as applied in last year’s RAISE and dashboards. Simply take the percentage gap between your result and national average (e.g. -12%), turn it into a decimal (e.g. -0.12) and multiply that by the number of pupils in the cohort (e.g. 30). In this case we work out ‘diff no. pupils’ as follows: -0.12 x 30 = -3.6. This means the schools result equates to 3 pupils below average. If the school result is above national then it works in the same way, it’s just that the decimal multiplier is positive.

If you are calculating this for key groups, then multiply by the number in the group, not the cohort. For example, the 80% of the group achieved the result against a national group result of 62%, which means the group’s result in 18% above national. There are 15 pupils in the group so we calculate ‘diff no. pupils’ as follows: 0.18 x 15 = 2.7. The group result therefore equates to 2 pupils above national.

I hope that all makes sense.

Happy analysing.

Subscribe to receive email updates when new blog posts are published.

Share this article

15 thoughts on “Analyse School Performance summary template (primary)

  1. Giles
    on November 21, 2017 at 11:40 am

    Hi James! Link isn't working. Can you send to me electronically please?

  2. James Pembroke
    on November 21, 2017 at 12:58 pm

    Link works for me. Suspect it’s because it’s blocked by school system. Try it on a home device. If still doesn’t work let me know.

  3. Unknown
    on November 22, 2017 at 9:49 am

    Hi James, I know you have posted about this before but I can't find it! Are the prior attainment groups for EYFS to KS1 based on the individual ELG or overall GLD?

  4. James Pembroke
    on November 22, 2017 at 10:49 am

    Based on individual ELG (lower of the 2 in maths). GLD not considered, which is problematic in my view. GLD is a good indicator.

  5. Emma Glour
    on February 2, 2018 at 1:58 pm

    Wow, great post.

  6. Emma Glour
    on February 3, 2018 at 4:55 pm

    Summary is the best key to understand a article very quickly and short time. I see the school performance summary. I read here this main part of the article. I request james for giving next article about paper summarizer online help information.

  7. Riley
    on February 22, 2018 at 2:04 pm

    This summery is having all the things that are basically required for the purpose of convert m4a to text and working. I am sure to get more people to take interest in the type of blogs that you have been sharing in this website.

  8. Abdul Waheed
    on February 27, 2018 at 8:30 pm

    Many of the students are just download template and create an Assignment it to the hire someone to write bio of management team. Try to create own template then you Assignment will be looking like Performance summary.

  9. joe
    on February 28, 2018 at 8:21 am

    This data is based on best research that is performed very well. The template you shared is based in facts so we should appreciate the efforts and must continue it.

  10. mike son
    on March 8, 2018 at 6:23 pm

    After getting this Performance summary template from here. I will fix this template to use for the All the thing is needed to be updated the downloading link.

  11. jonathon
    on May 27, 2018 at 8:20 am

    People make analysis the situation of school performance by getting the results. The working style and results of children are important for good uses. This mention in for good needs.

  12. jahidul islam
    on May 30, 2018 at 2:34 am

    You need to know the service and their all sort of facilities before admit you child in a school and this is why the performance of them is important. and you'll be get an better idea about academic papers writing.

  13. NAINA
    on June 27, 2018 at 7:36 am

    I think first you have to take their details then should Analyse School Performance or any presentation what you want read post. I hope it can help you. thanks

  14. Troy Ramirez
    on June 27, 2018 at 10:57 am

    This performance report content is very special to read as it has many points for teachers, students and parents to consider.Its important for all to read this post.I really liked this effort.

  15. shivam mourya
    on July 2, 2018 at 10:00 am

    This post is amazing i agree this post advice than you for sharing this you see more post like this
    positive attitude

Leave a Reply

Your email address will not be published.

© 2024 Sig+ for School Data. All Rights Reserved.