Polar 3

The participation of local areas (POLAR) classification groups areas across the UK based on the proportion of the young population that participates in higher education (HE).

The POLAR classification looks at how likely young people are to participate in HE across the UK and shows how this varies by area. Last updated July 2015 The data on young people is taken from those reaching 18 between 2005 and 2009. The census data is from the 2001 census, post code data from 2015.

Data Content

Format

Two zipped CSV files Key entities and code lists (integration and data-linking potential) Postcode to Area Groups: This file provides a lookup between unit postcode and a classification of 2001 Census area statistics wards by young participation and adult qualification levels.

Casward to Area Groups: This file provides a lookup between 2001 Census area statistic wards and a classification of 2001 Census area statistics wards by young participation and adult qualification levels

Data issues

Postcode to Area Groups is too large to import into excel so other tools are required to open if any cleansing is required. Postcodes are written without the central space so either cleansing or scripting may be required to link with other data sources that contain postcodes.

Scale

Postcode to Area Groups: 2557414 records (July 2015) Casward to Area Groups: 10654 data records (September 2012)

Heidi Labs Information

Relevance to existing user story

Relevant to any user story relating to students! So most of them. User Stories 1,2,3,4,9,11,12,15, 16,17,18 and 19

Known relevant BI use

This has been designed as a set of statistic of interest to universities in developing strategic planning with relation to student admission, retention and attainment.

Tableau data-source labels

Heidi labs POLAR3 Data (Postcode to Area Group)

Outstanding Issues

None at this stage

Possible Action in the Context of the Jisc Agile BI Projects

  • Scott Wilson has written SQL to flatten this data set, this can be found on github
  • The postcode space issues could be resolved at a data source level making linking easier.

Data and Resources

Additional Info

Field Value
Source http://www.hefce.ac.uk/analysis/yp/POLAR/
Last Updated 3 June 2016, 11:27 (UTC)
Created 19 May 2016, 13:13 (UTC)