Ward Level Data

This technical note outlines the sources of the data, describes how it has been compiled and any limitations. We have used publicly available data, in the main using the Office for National Statistics’ (ONS) information.

1. We have used the most up to date data available. In some cases this relates to the 2011 Census information.
2. For some wards there have been boundary changes since the 2011 Census. This has led to a lack of information for those wards.

Population for age 0-19

This is calculated from the ONS ward level mid-year population estimates. This data was released on 26 October 2016.

The data provides mid-year population estimates for electoral wards in England and Wales (part of the set of Small Area Population Estimates). Electoral wards are subject to annual updates and boundary changes. Mid-2015 population estimates are therefore provided for the 8,564 electoral wards in England and Wales as at 31 December 2012, excluding the 18 wards that do not meet the minimum population requirements for data confidentiality (40 resident households and 100 resident people in the 2011 Census).

The England national average for the 0-19 population is 23.69%. We have defined those with a high percentage as those wards with greater than 28.69% of residents aged 0-19 years. We have defined those with a low percentage as those wards with less than 18.69% of residents aged 0-19 years.

Available at https://www.ons.gov.uk/peoplepopula... (Downloaded June 2017)

Social class - socio-economic data

This is provided by the ONS.

This dataset provides 2011 estimates that classify usual residents aged 16 to 74 in England and Wales by National Statistics Socio-economic Classification (NS-SEC). The estimates are as at census day, 27 March 2011. The National Statistics Socio-economic Classification (NS-SEC) provides an indication of socio-economic position based on occupation and is coded to Standard Occupational Classification. To assign a person (aged 16 to 74) to an NS-SEC category, their occupation title is combined with information about their employment status, whether they are employed or self-employed and whether or not they supervise other employees. Full-time students are recorded in the 'full-time students' category regardless of whether they are economically active or not. We have grouped the lower social classes NSEC 4 to 8 to gain an indication of deprivation.

The England national average for those in the lower social classes is 35.37%. We have defined those with a high percentage as those wards with greater than 45.37% of residents classed NSEC 4 to 8. We have defined those with a low percentage as those wards with less than 25.37% of residents classed NSEC 4 to 8.

Available at

https://www.nomisweb.co.uk/cen...

(Downloaded June 2017).

Qualification level

This is provided by the ONS.

This dataset provides 2011 Census estimates that classify usual residents aged 16 and over in England and Wales by highest level of qualification. The estimates are as at census day, 27 March 2011.

We have looked at those with Level 4 qualifications and above. This includes degree (for example BA, BSc), Higher Degree (for example MA, PhD, PGCE), NVQ Level 4-5, HNC, HND, RSA Higher Diploma, BTEC Higher level, Foundation degree (NI), and professional qualifications (for example teaching, nursing, accountancy).

The England national average for those with Level 4 qualifications or above is 27.2%. We have defined those with a high percentage as those wards with greater than 32.2% of residents with Level 4 qualifications. We have defined those with a low percentage as those wards with less than 22.2% of residents with Level 4 qualifications.

We have also considered those with no qualifications ‘no formal qualifications held’. The England national average for those with no qualifications is 22.7%. We have defined those with a high percentage as those wards with greater than 27.7% of residents with no qualifications. We have defined those with a low percentage as those wards with less than 17.7% of residents with no qualifications.

Available at

https://www.nomisweb.co.uk/census/2011/all_tables?release=3.5b

(Downloaded June 2017)

Claimants as a proportion of residents aged 16-64

Since June 2015 the Claimant Count has included out of work Universal Credit claimants as well as Jobseeker's Allowance claimants. This is updated regularly and the data we have is from July 2017.

The England national proportion of claimants is 1.1. We have defined those with a high proportion as those wards with greater than 1.6 of claimants. We have defined those with a low proportion as those wards with less than 0.6 of claimants.

Available at:

https://www.ons.gov.uk/employm...

(Downloaded July 2017).

Access to a Car

This data is provided by the ONS and is based on the 2011 census.

This dataset provides 2011 Census estimates that classify usual residents in households in England and Wales by car or van availability. The estimates are as at census day, 27 March 2011.

The England national average for those no car or van availability is 25.80%. We have defined those with a high percentage as those wards with greater than 30.8% of residents with no available car or van. We have defined those with a low percentage as those wards with less than 20.8% with no available car or van.

Available at:

https://www.nomisweb.co.uk/census/2011/lc4109ew

(Downloaded June 2017)

Schools

This information is provided by the Higher Education Funding Council for England based on National Pupil Database statistics.

Local areas are identified at 2001 census ward level. A ward is linked a school where more than five Key Stage 4 pupils from a ward attend the school, based on the 2013-14 cohort. Where fewer than five pupils go to any school, no schools will be highlighted.

The schools included are state-maintained secondary schools that taught Key Stage 4 (GCSE-level) pupils in 2013-14. They include academies, free schools, city technology colleges and state-funded special schools.

We have identified the schools where the highest proportion of students from that ward attended and listed the main two schools (this may be extended to three if there is an equal proportion).

Available at:

http://www.hefce.ac.uk/analysis/yp/secondary/

(Downloaded July 2017)

Ofsted ranking

This information is published by Ofsted and the last update was 11 August 2017.

The information is updated monthly and is designed to provide an up to date picture of the most recent inspection of each school.

The data provides the overall effectiveness judgement for schools, as it stands on the 31 July 2017.

The inspection judgements are:

0 = Insufficient evidence

1 = Outstanding

2 = Good

3 = Requires improvement (previously satisfactory)

4 = Inadequate (these schools will be designated with serious weaknesses or put into special measures).

We have translated the numerical judgement information and provided the status.

Available at:

https://www.gov.uk/government/...

(Downloaded August 2017)

The income deprivation affecting children index (IDACI)

Deprivation is based on the Income Deprivation Affecting Children Index (IDACI) 2015. The deprivation of a provider is based on the mean of the deprivation indices associated with the home postcodes of the pupils attending the school rather than the location of the school itself.

This measures the proportion of all children aged 0 to 15 living in income deprived families. The more deprived an area, the higher the IMD score. The schools are divided into five equal groups (quintiles), from ‘most deprived’ (quintile 5) to ‘least deprived’ (quintile 1). We have defined a low proportion of students for those in the quintiles 1 and 2. We have defined a high proportion of students for those in quintiles 4 and 5.

Ward LEvel Data produced by Nursaw Associates (www.nursawassociates.com) on behalf of Festival Bridge (August 2017)