Widening Participation Uplift Factors Data Definition 2009/2010
L_UPLF78, L_UPLF0910, L_UPLF89
DATA DEFINITION
1. The Widening Participation Uplift factor assigned to the learner’s home postcode.
PURPOSE
2. For analysis of deprivation based on location and not deprivation funding
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of the Widening Participation Uplift Factors data definition.
| Field Name |
Label |
Dataset |
| L17 |
Learner Home Postcode |
Learner Standard Files |
| UPLIFT |
Widening Participation Uplift |
Postcode file |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
Y = Current Academic Year.
| Field Name |
Label |
Dataset |
| L_UPLFYY |
L_UPLFYY YYYY Widening Participation Uplift Factor Based on Learner Postcode |
Learner, Aims and HE Standard Files |
DETAILED DEFINITION
5. The learner’s Home Postcode (L17) is matched to a postcode file for that year, containing the list of postcodes that generate a Widening Participation Uplift for that year. The information in the postcode file is based on the link between postcodes and local authority wards.
6. The Widening Participation Uplift fields are based solely on the learner’s postcode prior to enrolling and do not reflect Widening Participation Uplift factors assigned to learners for other reasons that are reflected in 'eligibility for disadvantage uplift' (L32).
Widening Participation Uplift Factors Sample Code
1. The following SPSS code is provided to illustrate the Widening Participation Uplift Factors data definition.
L_UPLFYY
2. The following table shows the steps required to derive L_UPLFYY.
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does Postcode exist in Postcode file |
Set L_UPLFYY to value of L_UPLFYY in Postcode file |
Set L_UPLFYY to -1 |
3. The following SPSS code illustrates how to derive L_UPLF0910, L_UPLF78, L_UPLF89.
|
GET FILE ‘………………………..LEARNER data set’.
/*Match on the postcode file, which contains the uplift factors, to the learner file, by the learners home postcode.
SORT CASES BY L17.
RENAME VARIABLES (L17 = postcode).
MATCH FILES /FILE = *
/TABLE = ‘…………………………………postcode dataset.sav’
/BY postcode.
RECODE uplift67 (SYSMIS = 0).
RENAME VARIABLES (postcode = L17) (upliftYY,‘current academic year’) = (L_UPLFYY,’current academic year’).
VARIABLE LABELS L_UPLFYY "L_UPLFYY YYYY Widening Participation Uplift Factor Based on Learner Postcode". |
3. The following SPSS code illustrates how to derive L_UPLF0910, L_UPLF78, L_UPLF89.
|
select
L01, L03
, A.upliftYY as L_UPLFYY -- where YY is the current academic year.
from
postcode_file A
join
LEARNER_FILE B
on A.postcode=B.L17 |
Date last modified: 07th January 2010
