Last week I started collecting data from schools who had used the KS1/2 sample tests. I have been overwhelmed by the response, with the data for over 5000 pupils now available.
I’ve tried to draw some very simple conclusions on my blogpost here, but really what teachers want is to be able to compare their school to the national picture. Enter, Tarjinder Gill, who has put some considerable effort into turning the available data into something useful for schools to do exactly that.
Accessing the spreadsheets below will allow you to enter your own school’s data. Once you do, you can see how your scores compare to the collected data from the schools who have so willingly shared their results. You can also see simple graphs that compare your scores both at mark-level and in bands, so that you might spot patterns.
The school shown in the example here seems to be significant under-performing compared to the national picture indicated by my very dodgy collection of data.
Please be aware of all the usual caveats: this isn’t a reliable set of data, it isn’t a random sample, it hasn’t been checked for accuracy, it isn’t from a cross-section of schools, etc., etc. It’s just all we have at the moment, I’m afraid.
To access the spreadsheets, you can find them here on Google:
Key Stage 1 data comparison spreadsheet (NB: very limited national data so far)
You will not be able to edit these versions. To enter your own data, users with their own Google account can make a copy of the spreadsheets. If you do not have a Google account at all, then it is possible to download the spreadsheets, and then use them in Excel. However, these versions will only include a comparison to the data collected up to the point at which you downloaded the sheet.
If you find these sheets useful, and you haven’t already shared your school’s data with me to add to the “accuracy” of the project, please read here about how you can contribute.
Also, please thank Tarjinder Gill, as the work on these spreadsheets is all hers!