Top State vs Indie Schools - Visualised
Posted: Mon Nov 19, 2012 11:56 am
I originally created a visual dashboard that showed the top state schools for sending pupils to Russell Group universities (http://public.tableausoftware.com/views ... ateSchools).
Some people have since asked about how the top state schools compared to the independent schools so I thought I would post another dashboard I have created, which includes both Indie and Grammar (and every other type of school) in England.
I originally posted this as a reply on someone's thread, but feel that there is benefit in bringing it to the qider audience.
http://public.tableausoftware.com/views ... s2007-2009
This dashboard has quite a lot of information, so I feel that I need to explain it a bit.
Firstly, the data is a bit older, at least a year out from the currently (possibly - I have not found it) available data. It's based on data from 2007-2009 and the government takes quite a while to compile where everyone goes after that.
It is based on Sutton Trust 30 destinations, rather than Russell Group.
The dashboard is highly interactive, you can filter by Local Authority or School Type. You can also filter by clicking on an item in the dashboard. Hovering over a particular school will give you additional statistics.
The Trend visual shows how the different types of schools (indie, grammar, comprehensive etc) compare to each other for UCAS points AND % heading to ST30 universities. The trend line shows how widespread or compact the range is for that type of school achieving UCAS points compared to ST30 entry.
You can see from the chart that the schools that score the highest average UCAS points per pupil are not necessarily as successful as others. Typically, indies are more successful at getting pupils into ST30 schools on lower UCAS points that grammars.
I hope you find this useful information.
Thanks
Some people have since asked about how the top state schools compared to the independent schools so I thought I would post another dashboard I have created, which includes both Indie and Grammar (and every other type of school) in England.
I originally posted this as a reply on someone's thread, but feel that there is benefit in bringing it to the qider audience.
http://public.tableausoftware.com/views ... s2007-2009
This dashboard has quite a lot of information, so I feel that I need to explain it a bit.
Firstly, the data is a bit older, at least a year out from the currently (possibly - I have not found it) available data. It's based on data from 2007-2009 and the government takes quite a while to compile where everyone goes after that.
It is based on Sutton Trust 30 destinations, rather than Russell Group.
The dashboard is highly interactive, you can filter by Local Authority or School Type. You can also filter by clicking on an item in the dashboard. Hovering over a particular school will give you additional statistics.
The Trend visual shows how the different types of schools (indie, grammar, comprehensive etc) compare to each other for UCAS points AND % heading to ST30 universities. The trend line shows how widespread or compact the range is for that type of school achieving UCAS points compared to ST30 entry.
You can see from the chart that the schools that score the highest average UCAS points per pupil are not necessarily as successful as others. Typically, indies are more successful at getting pupils into ST30 schools on lower UCAS points that grammars.
I hope you find this useful information.
Thanks