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
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.