{"id":324,"date":"2012-01-19T17:09:15","date_gmt":"2012-01-19T17:09:15","guid":{"rendered":"http:\/\/helpmeinvestigate.com\/education\/?p=324"},"modified":"2021-10-18T08:26:13","modified_gmt":"2021-10-18T08:26:13","slug":"education-open-data-sources","status":"publish","type":"post","link":"http:\/\/helpmeinvestigate.com\/education\/2012\/01\/education-open-data-sources\/","title":{"rendered":"Education &#8211; open data sources"},"content":{"rendered":"<p><span style=\"float: right;\" ><a class=\"twitter-share-button\"  data-via=\"\" data-count=\"none\" data-related=\"mohanjith:S H Mohanjith\" data-lang=\"en\" data-url=\"http:\/\/helpmeinvestigate.com\/education\/2012\/01\/education-open-data-sources\/\" data-text=\"Education &#8211; open data sources\" href=\"http:\/\/twitter.com\/share?via=&#038;count=none&#038;related=mohanjith%3AS%20H%20Mohanjith&#038;lang=en&#038;url=http%3A%2F%2Fhelpmeinvestigate.com%2Feducation%2F2012%2F01%2Feducation-open-data-sources%2F&#038;text=Education%20%26%238211%3B%20open%20data%20sources\" >Tweet<\/a><\/span>Before Christmas <a title=\"Simon Whitehouse\" href=\"http:\/\/siwhitehouse.co.uk\/\">myself<\/a> and Joy Gibara\u00a0from the Looked After Children Education Service\u00a0in Birmingham City Council attended the <a title=\"Hacking Education Data meetup\" href=\"http:\/\/meetupbirmingham.hackshackers.com\/events\/39483932\/\">Hacking education data<\/a>\u00a0meet up at Urban Coffee Company. \u00a0I worked in various admin and IT related education roles for quite a few years and Joy obviously has current knowledge in the area<\/p>\n<p>We talked to the group about\u00a0some of the data sources we know about and promised to write a post collecting them together for people. So, here it is. It is worth noting that these are predominantly school-based and sometimes relate specifically to Birmingham.<\/p>\n<p><a title=\"school tower by raider of gin, on Flickr\" href=\"http:\/\/www.flickr.com\/photos\/fairerdingo\/416449471\/\"><img loading=\"lazy\" src=\"http:\/\/farm1.staticflickr.com\/149\/416449471_0f286c1285.jpg\" alt=\"school tower\" width=\"375\" height=\"500\" \/><\/a><\/p>\n<p><!--more-->One of the main sources of data about schools is <a title=\"Edubase\" href=\"http:\/\/www.education.gov.uk\/edubase\/home.xhtml;jsessionid=CB31D63E6D0392C80A489929C0302ABF\">Edubase<\/a> &#8211; &#8220;the up to date database of educational establishments across England and Wales&#8221;. \u00a0It has some free and open web pages &#8211; these allow extracts of up to 150 records &#8211; \u00a0as well as the ability to create extracts of your own based upon a login.<\/p>\n<p>The data it holds includes: school address details, current headteacher, numbers of children in whole school and per year group, \u00a0the number of children with special educational needs, the type of school including if it is gender specific and\/or religious. You get the general idea.<\/p>\n<p>With a login there is a restriction on the number of times you can run reports from just 2 per year for a member of the public to an unlimited number, I believe, for local authority staff.<\/p>\n<p>A couple of years ago, HP Labs created a <a title=\"Edubase - Linked Data\" href=\"http:\/\/data.gov.uk\/blog\/using-sparql-our-education-datasets\">Linked Data version of Edubase<\/a>. However, it didn&#8217;t do that much linking, and it is now over two years out of date.<\/p>\n<p>Additionally, details of <a title=\"Birmingham Schools' Directory on BGfL\" href=\"http:\/\/services.bgfl.org\/cfpages\/schools\/searchpage.cfm\">schools and education centres managed by Birmingham<\/a> are also held on the <a title=\"BGfL\" href=\"http:\/\/www.bgfl.org\/\">Birmingham Grid for Learning (BGfL)<\/a>. These can sometimes be more up to date than Edubase, especially in relation to such things as a change in headteacher.<\/p>\n<p>Schools are subject to inspections by the Office for Standards in Education, or Ofsted. Beloved of educationalists nationwide, their school inspection reports are published online and can <a title=\"Ofsted - Inspection report search\" href=\"http:\/\/www.ofsted.gov.uk\/inspection-reports\/find-inspection-report\">be searched for on their site<\/a>.<\/p>\n<p>There are sites such as <a title=\"Schools In UK\" href=\"http:\/\/schooletc.co.uk\/\">Schools In UK<\/a>, which collate data from Edubase and Ofsted inspection reports.<\/p>\n<p>The <a title=\"Research and Statistics Gateway for Education Statistics\" href=\"http:\/\/www.education.gov.uk\/rsgateway\/index.shtml\">Research and Statistics Gateway<\/a>\u00a0is\u00a0invaluable for all sorts of aggregated education data. In particular attainment. exclusions, attendance etc are all broken down by individual LAs on there.\u00a0Joy points to some <a title=\"Statistical First Release (SFR) on Outcome Indicators for Children Looked After\" href=\"http:\/\/www.education.gov.uk\/rsgateway\/DB\/SFR\/s000930\/index.shtml\">statistical first releases<\/a>\u00a0(these ones relate to outcomes for Looked After Children) that she finds particularly useful.<\/p>\n<p>There is also the Department of Education&#8217;s <a title=\"DfE - Compare Schools Site\" href=\"http:\/\/www.education.gov.uk\/establishments\/compare?urns=133598,103332\">Compare schools<\/a>&#8216; site which allows you to compare up to 5 schools across a variety of data, which mostly appears to come from Edubase.<\/p>\n<p>The <a title=\"Pupil Premium Site\" href=\"http:\/\/www.education.gov.uk\/schools\/pupilsupport\/premium\/a0076063\/pupil-premium-what-you-need-to-know\">Pupil Premium<\/a> provides additional funding on top of the main funding a school receives. It is targeted at pupils from disadvantaged backgrounds to ensure they benefit from the same opportunities as pupils from less deprived families<\/p>\n<p>So, the <a title=\"Pupil Premium\" href=\"http:\/\/education.gov.uk\/schools\/adminandfinance\/financialmanagement\/schoolsrevenuefunding\/settlement2012pupilpremium\/a0075963\/pupil-premium-2011-12\">Schools&#8217; Funding Settlement<\/a>\u00a0section of the Pupil Premium\u00a0site is likely to\u00a0be a lot more useful a year down the line once schools have had a year of spending money in this way. It will be interesting to see what they are doing with it. For example, there may be schools receiving very similar pots of money but perhaps having very different outcomes in terms of attainment. attendance etc.<\/p>\n<p>The Pupil Premium is due to increase to \u00a3600 \u00a0next year. It has also been extended\u00a0to cover any child that has been registered for Free School Meals (FSM) in the past six years.<\/p>\n<p>The Department of Education performance site has a lot of data on such things as performance for all pupils, low attainers, medium attainers, high attainers (presumably based on their prior performance), staffing information (including average salaries, and ratio of pupil:staff), spend per pupil etc..<\/p>\n<p>An example of a Birmingham school is this page about <a title=\"Aston Tower Community Primary - DfE Performance site\" href=\"http:\/\/www.education.gov.uk\/cgi-bin\/schools\/performance\/school.pl?urn=103370&amp;superview=pri\">Aston Tower Community Primary<\/a><\/p>\n<p><a title=\"Schools' Budget Share\" href=\"http:\/\/services.bgfl.org\/cfpages\/budgetnew\/statement.cfm\">Schools&#8217; budget share<\/a> may well be of use to someone looking at Birmingham-specific issues. So, it can be used to look at Free School Meals rates and then compare them with attainment outcomes. (usually around grammar school intakes, and which populations the schools actually serve!).<\/p>\n<p>Many thanks to Joy, who has provided most of the links to data here. Please feel free to add any other resources you know about in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TweetBefore Christmas myself and Joy Gibara\u00a0from the Looked After Children Education Service\u00a0in Birmingham City Council attended the Hacking education data\u00a0meet up at Urban Coffee Company. \u00a0I worked in various admin and IT related education roles for quite a few years &hellip; <a href=\"http:\/\/helpmeinvestigate.com\/education\/2012\/01\/education-open-data-sources\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,1],"tags":[35,166,167,165],"_links":{"self":[{"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/posts\/324"}],"collection":[{"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/comments?post=324"}],"version-history":[{"count":8,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"predecessor-version":[{"id":1321,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/posts\/324\/revisions\/1321"}],"wp:attachment":[{"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/helpmeinvestigate.com\/education\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}