Tuesday, 4 September 2018

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.



  1. 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. Also find this really helpful but getting a difference of -0.2 with our writing and can't work out why - any thoughts?

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