VA Calculator and Floor Standards tool: links to download

Warning: this blog post contains no opinions or rants whatsoever.

I recently shared my VA calculator and floor standard tool on Twitter and thought it’d be useful to put the links into a blog so people can find them easily.

PLEASE NOTE: the tools are stored in my One Drive so don’t edit the online versions (think I set them to view only but just in case). Please download and save them to a local drive before getting to work, otherwise everyone will be able to see your data and i’ll have to delete it. Also, it’s likely that the links will be blocked on school PCs so you might need to access at home.

So, here are the links:


Click here to download the VA calculator

I’ve updated the VA calculator to include an Actual vs Estimated results page. You can now use this to get an idea of percentages ‘expected’ to achieve EXS and high standard for current cohorts. It will also calculate actual results once you have entered Y6 test scores and TAs; and compare actual to estimates.

Many people have asked me for the password for this spreadsheet, which is understandable. The spreadsheet is still locked but to save you the hassle of contacting me, the password is ‘primary‘. PLEASE don’t unlock and edit the online version.

Note: new version calculated low/middle/high bands


Floor standards tool can be downloaded here

Please read the notes on the first tab of both tools for instructions and get in touch (@jpembroke) if you have any questions or comments.

Have fun!

Subscribe to receive email updates when new blog posts are published.

Share this article

19 thoughts on “VA Calculator and Floor Standards tool: links to download

  1. Unknown
    on September 20, 2016 at 9:00 am

    Is there any chance you could share the password please? I would like to set a print area and repeat the top rows but I can't do that when the sheet is protected.

  2. James Pembroke
    on September 20, 2016 at 5:44 pm

    Happy tp share but prefer not to put it on the blog. Tweet me and I'll DM it to you.

  3. jo
    on September 20, 2016 at 5:46 pm

    Does the value added calculator only work on Y6 actual data, or can it be set to predict what value added would be if the predicted scores were attained?

  4. James Pembroke
    on September 20, 2016 at 6:39 pm

    If predicted scores were attained then VA would be zero.

  5. James Pembroke
    on September 20, 2016 at 6:41 pm

    You can enter KS1 for any cohort to get end key stage estimates by the way.

  6. Emiley Davies
    on October 4, 2016 at 5:22 am

    Thank you for making this and sharing it.

  7. James Pembroke
    on October 4, 2016 at 6:10 am

    You're welcome

    on October 18, 2016 at 5:23 am

    Essays are of four kinds like expository, persuasive, argumentative and analytical. Writing them demands focus and skills which need to be developed with due attention. It is good to take guidance while writing essays at advanced level. See more accounting homework helper

  9. DiLina
    on April 19, 2017 at 9:53 am

    A Free Online Calculator, Quick and Easy, and Full Screen!

  10. shoronts3
    on July 23, 2017 at 5:34 pm


  11. shoronts3
    on July 23, 2017 at 5:39 pm

    Thanks for showing some important info that can help calculate. I would like to download your va calculator today! I also got some better calculators that are free to use. You might me interested to use here – Free online calculators

  12. blog
    on August 29, 2017 at 5:02 pm

    If you are looking to buy best printing calculator for accountants, then take a look at Best Calculator Guide.

  13. Seth Smith
    on November 2, 2017 at 5:49 pm

    website cost calculator is a creative tool to check the price range, and understood if that suitable for you.

  14. awsome logo design
    on January 17, 2018 at 5:29 pm

    A right actor is one who can take your direction and feedback in the right way. Sometimes the ego of the actor comes in the way and they are not able to grasp your feedback and get into the character properly, which ultimately mars the essence of the movie. flooring

  15. Daim Malik
    on March 28, 2018 at 2:23 pm

    from where i should download VA Calculater/?

  16. mandar singh
    on April 4, 2018 at 11:15 am

    [url=]hardwood floor cleaning[/url]

  17. john sun
    on April 6, 2018 at 1:21 pm

    You completely duplication our mean and the difference of our information.

  18. Daim Malik
    on August 10, 2018 at 7:21 pm

    This comment has been removed by the author.

  19. Watching Highlights
    on November 10, 2018 at 1:51 pm

    This comment has been removed by the author.

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2024 Sig+ for School Data. All Rights Reserved.