2019 VA Calculator: beta version

A beta version of the VA calculator can be downloaded here.

PLEASE DOWNLOAD IT FIRST. ANY DATA ENTERED ONTO THE ONLINE VERSION WILL VISIBLE TO ALL AND WILL BE DELETED.

Please note that in addition to the usual issues at this time of year – estimates and standard deviations will change – we also have the issue of new pre-key stage assessments, for which we do not currently have the nominal scores. In the absence of any guidance (which will be issued alongside the tables checking data at start of autumn term) I have made a best guess based on those used last year.

Feel free to download and use but treat any data with caution, especially that relating to pupils with pre-key stage assessments.

I’ll update it in autumn term when guidance is released.

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. Steph on July 3, 2019 at 8:02 am

    Hi,
    This is a very cheeky question but would it be possible to have an unprotected version so that it is possible to copy out some of the data to use?
    Thanks,
    Steph

    • James Pembroke on July 4, 2019 at 2:02 pm

      Hi. Password is on the notes pages. J

  2. Tim on July 8, 2019 at 7:18 pm

    Great work, struggling to get it to calculate PP and Non PP progress scores, just says #DIV/0! I have input all manually, rather than cutting and pasting, have you any suggestions? Thanks again for your great work.

    • James Pembroke on July 9, 2019 at 6:43 am

      Hi. Did you enter the PP indicators in the pupil groups column on main data entry page?

      • James Pembroke on July 9, 2019 at 6:44 am

        Probably best email me

    • James Pembroke on July 9, 2019 at 7:21 am

      Have just checked and it definitely works. You need to complete the pupil group indicators on main ‘pupil VA calculator’ sheet – columns C-F. This should then show progress scores for groups on the ‘pupil groups’ tab.

Leave a Comment