Tuesday 13 October 2015

School's own data in the Ofsted inspection data dashboard

Hopefully if you are involved in secondary school data you will already be aware of the publication of the Ofsted "Inspection dashboards" which are available via the RAISEonline website.

However there is an issue with the data that will be shown in these dashboards as for many schools in 2014 there is a difference between best and first entry, meaning that the dashboards may distort the picture. For some schools this may also be the case for 2015.

Furthermore the dashboards published so far do not allow comparison of the latest data - potentially imminent in its release, however it's useful to know what to expect.

To try to overcome some of these issues while still presenting the data in a format very similar to the official dashboard I have thrown together a spreadsheet that emulates the Ofsted layout as much as I can (given Excel's limitations).

The file can be downloaded here: http://bit.ly/Inspdashboard.


The file as shared contains dummy data (mostly derived from the anonymised version of the dashboard that is available in the RAISEonline library), which you can overtype with data from your school. Obviously you'll need to do the actual calculations for the numbers yourselves, or with whatever package your school uses to process/estimate the stats for your figures. The sheet simply presents the data in a way that is similar to Ofsted's official version. Note this was made so that I could present data within my school so I'm afraid that some of the sheets are a bit fiddly to use - afraid I've not had chance to make it slick, but it does work if you take the time to enter your data! Most of the sheets are fairly obvious where the data entry goes - I'm sure you'll figure it out with a bit of trial & error.

My perferred way to print the file is to get Excel to print the entire workbook. It does come out with a blank page on P6 when doing it this way - not been able to fix that so either ignore it or don't print that one.

Hope this is useful!

No comments:

Post a Comment