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 www.insighttracking.com/va-calculator

**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.

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

ReplyDeleteLink 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.

ReplyDeleteHi 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?

ReplyDeleteThanks

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

ReplyDeleteWow, great post.

ReplyDeleteSummary 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.

ReplyDeleteThis 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.

ReplyDeleteMany 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.

ReplyDeleteThis 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. http://www.nursingresearch.biz/work-process/

ReplyDeleteAfter getting this Performance summary template from here. I will fix this template to use for the http://www.capstoneprojectideas.com/electronics-capstone-project-ideas/. All the thing is needed to be updated the downloading link.

ReplyDelete