2018 KS2 VA Calculator free to download

I’ve updated the VA calculator to take account of changes to methodology this year. This includes new standard deviations and estimated outcomes, and the capping of extreme negative progress scores. I have referred to this as adjusted and unadjusted progress; and the tool shows both for pupils and for the whole cohort. Note that extreme positive progress scores are not affected.

You can use the tool to get up-to-date, accurate progress scores by removing pupils that will be discounted, and adding on points for special consideration (this should already be accounted for in tables checking data) and successful review outcomes due back via NCA Tools on 12th Sept.

You can also use it to get an idea of estimated outcomes for current Year 6 but please take be aware of usual warnings, namely that estimates change every year.

The tool can be download here.

It will open in Excel Online. Please download it to your PC before using by clicking on the 3 dots top right. Do not attempt to complete online as it is locked for editing. Please let me know ASAP if you have any issues or find any discrepancies.


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. Emma Harkins on September 6, 2018 at 9:43 pm

    Really find your calculators a valuable tool but this year, the progress is lower than the scores I have been shown in checking process. Have checked KS1 and KS2 entries… Any ideas?

  2. Unknown on September 12, 2018 at 10:22 am

    Also find this really helpful but getting a difference of -0.2 with our writing and can't work out why – any thoughts?

  3. Unknown on September 16, 2018 at 6:27 pm

    OK, I know this is going to be obvious but on SEN, what do the NES choices refer to? Guess no, EHCP or Support?

  4. Lisa Jones on January 15, 2019 at 2:26 pm

    Hi James,
    Are you going to produce an updated VA Calculator using the 2018 PAG groups which came out in December?
    I noted that your PAGs are slightly different to those published on the latest accountability doc. e.g Yours for PAG1 is R: 61.97 W:61.85 and M 62.07 The latest DfE doc is R:61.94 W:61.81 M: 61.98
    Happy to do it myself but its password protected.

    • James Pembroke on January 15, 2019 at 7:02 pm

      Yes, good point. I know they’ve changed a bit and did mean to update but not got round to it. Will do but do feel free to do it yourself if you want it done ASAP. Password to unlock is on notes page.

Leave a Comment