Monday, 9 July 2018

VA Calculator: excel version free to download

With KS2 results about to be released on NCA Tools (10th July, 07.30) I thought I'd publish a link to the latest excel version of my VA calculator. This version, with pupil group tables for progress and average scores, can be downloaded here

To use the VA calculator, you will need to download first (it will be read only in your browser). To download, click on the 3 dots found top right of browser tab window and select 'download'. This will open the tool in full excel mode on your laptop. Recommend reading the notes page first and also worth reading the primary accountability guidance for more information about nominal scores, p-scales and pre-key stage pupils. Progress measures were quite bit more complicated in 2017 with more prior attainment groups (24 instead of 21), closing of the loophole (pupils not scoring on test receive a nominal score of 79), and nominal scores assigned to individual p-scales (rather than blanket score of 70 assigned to BLW).

Which, in my opinion, means this year's progress data is not comparable with last year's, but hey ho.....

Hopefully we won't see too much change to methodology in autumn 2018 but we can't assume anything. 

and please, please note that this tool is for guidance only. The official progress data will benchmark pupils' scores against the national average score for pupils with the same prior attainment in the same year. Essentially, the estimated scores shown in the VA calculator WILL change. 

and if you want the online tool, which is very neat, easy to use, and GDPR compliant (i.e. it does not collect the data, the data is only stored in the cache memory of your browser and can't be accessed by Insight or anyone else), then you can find it here:


and let me know asap if you find any errors


  1. Hi,
    Really appreciate the VA calculator but we have 155 pupils and the sheet only goes down to 150. It won't let me add any more rows. Is there any way of adding some?

  2. Hi Jamie, just wondering whether you are aware of a KS2 Maths Question Analysis spreadsheet which you'd recommend? Thanks in advance!

  3. Question level analysis...

  4. What is the password to unlock as I wish to print selection etc. Thank you for sharing this - been really helpful!