Age Data Definition 2008/2009
A_AGEST A_AGESTB L_AGE L_AGEB L_AGEBAND A_AGESTBAND A_FUNDED_AGE_BAND
DATA DEFINITION
1. Age of Learner and Age at Start of Aim and Funded Age band.
PURPOSE
2. Learner’s age, as at 31st August for the current academic year, is used to ensure consistency in analysis and over time.
Age at the start of each aim is mainly used for ER analysis but is calculated for all aims.
Funded age band is used to determine the age band at which an aim record should be funded.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ASL)
- ILR (ER)
- ILR (ESF SR)
SOURCE DATA
3. The following variables are used as source data for the calculation of Age of Learner and Age at Start of Aim.
| Field Name | Label | Dataset |
|---|
| L11 | L11 Date of Birth | Learner Standard File |
| A27 | A27 Learning Start Date | Aims Standard File |
| A_FUNDED_AGE_BAND | A_FUNDED_AGE_BAND Age Band Used in DLF Funding Calc | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| L_AGE | L_AGE Age of learner as at 31 August | Learner, Aims, ESF and HE Standard Files |
| L_AGEB | L_AGEB Age of learner as at 31 August banded | Learner, Aims, ESF and HE Standard Files |
| A_AGEST | A_AGEST Age of Learner as at the Start Date of Aim | Aims Standard File |
| A_AGESTB | A_AGESTB Age of Learner as at the Start Date of Aim Banded | Aims Standard File |
| L_AGEBAND | L_AGEBAND Age of Learner as at 31 August 16-18 19+ Bands | Learner, Aims, ESF and HE Standard Files |
| A_AGESTBAND | A_AGESTBAND Age of the Learner as at the Start Date of Aim Banded as 16-18 and 19+ | Aims Standard File |
| A_FUNDED_AGE_BAND | A_FUNDED_AGE_BAND Age Band Used in DLF Funding Calc | Aims DLF Standard File |
VALUES
5. The table below outlines the categories for A_AGEST A_GESTB L_AGE L_AGEB L_AGEBAND A_AGESTBAND A_FUNDED_AGE_BAND
| L_AGE or A_AGEST values | L_AGEB or A_AGESTB value | Label |
|---|
| 0-15 | 1 | Under 16 |
| 16-18 | 2 | 16-18 |
| 19-20 | 3 | 19-20 |
| 21-24 | 4 | 21-24 |
| 25-59 | 5 | 25-59 |
| 60-120 | 6 | 60 and over |
| Any other value, including missing values | 9 | Missing age |
| L_AGE or A_AGEST values | L_AGEBAND or A_AGESTBAND value | Label |
|---|
| 0-18 | 1 | 16-18 |
| 19+ | 2 | 19+ |
| Any other value, including missing values | 2 | 19+ |
| A_FUNDED_AGE_BAND Value | Label |
|---|
| 1 | 16-18 |
| 2 | 19+ |
DETAILED DEFINITION
6. The Age of the Learner (L_AGE) is derived by calculating their age as of 31st August of the current academic year, using their Date of Birth (L11). So if the data set is 2004/05, then the Age of the Learner (L_AGE) would be as at 31st August 2004. It is calculated in this way to ensure consistency in analysis across the LSC and over time.
7. The Age of Learner at Start of Aim (A_AGEST) is derived by calculating the learner’s age at the Learning Start Date (A27) of the aim, using their Date of Birth (L11). A learner with multiple aims, can have multiple Age of Learner at Start of Aim (A_AGEST), assuming that they start their aims at different times.
8. Where a learner has not got a date of birth the Age of the Learner (L_AGE) and Age of Learner at Start of Aim (A_AGEST) values will be missing.
9. The Age of the Learner Banded (L_AGEB) is derived from Age of Learner (L_AGE) and put into one of the bands shown in the first values table above.
10. The Age of Learner at Start of Aim Banded (A_AGESTB) is derived from Age of Learner at Start of Aim (A_AGEST) and put into the same bands as Age of the Learner Banded (L_AGEB), shown in the first values table above.
11. The Age of the Learner Banded (L_AGEBAND) is derived from Age of Learner (L_AGE) and put into one of the bands shown in the second values table above.
12. The Age of Learner at Start of Aim Banded (A_AGESTBAND) is derived from Age of Learner at Start of Aim (A_AGEST) and put into the same bands as Age of the Learner Banded (16-18 19+) (L_AGEBAND), shown in the first values table above .
13. The values in Age of the Learner Banded (L_AGEB) and Age of Learner at Start of Aim Banded (A_AGESTB) are inclusive (i.e., 21-24 includes the values 21, 22, 23 or 24).
14. A_FUNDED_AGE_BAND is matched in from the Demand Led Funding (DLF) Aims Standard File. For further information please refer to documentation available on the Funding Policy page.
Age Sample Code
1. The following SPSS code is provided to illustrate the Age data definition.
L_AGE
2. The following SPSS code illustrates how to derive L_AGE.
/* SPSS Code to calculate the learner’s age as at 31 AUGUST current academic year. /*current academic year is the start year of the academic year current to the standard file COMPUTE #date=DATE.DMY(31,8,current academic year). COMPUTE L_AGE=DATEDIF(#date, L11, "years"). RECODE L_AGE (SYSMIS=-1). |
L_AGEB
3. The following table shows the steps required to derive L_AGEB
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Any | Set L_AGEB to 9 | |
| 2 | Is L_AGE in the range of 0-15 (inclusive) | Set L_AGEB to 1 | Go to 3 |
| 3 | Is L_AGE in the range of 16-18 (inclusive) | Set L_AGEB to 2 | Go to 4 |
| 4 | Is L_AGE in the range of 19-20 (inclusive) | Set L_AGEB to 3 | Go to 5 |
| 5 | Is L_AGE in the range of 21-24 (inclusive) | Set L_AGEB to 4 | Go to 6 |
| 6 | Is L_AGE in the range of 25-59 (inclusive) | Set L_AGEB to 5 | Go to 7 |
| 7 | Is L_AGE in the range of 60-120 (inclusive) | Set L_AGEB to 6 | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_AGEB contain a value | None | Set L_AGEB=9 |
L_AGEB
4. The following SPSS code illustrates how to derive L_AGEB.
RECODE L_AGE (0 thru 15=1) (16 thru 18=2) (19 thru 20=3) (21 thru 24=4)(25 thru 59=5) (60 thru 120=6) (else=9) into L_AGEB. VARIABLE LABELS L_AGE 'L_AGE - Age of the learner as at 31 August'
/L_AGEB 'L_AGEB - Age of the learner as at 31 August banded'. VALUE LABELS L_AGEB
1 'Under 16'
2 '16-18'
3 '19-20'
4 '21-24'
5 '25-59'
6 '60 and over'
9 'missing age'. |
A_AGEBAND
5. The following table shows the steps required to derive A_AGEBAND
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Any | Set L_AGEBAND to 2 | |
| 2 | Is L_AGE in the range 0-18 (inclusive) | Set L_AGEBAND to 1 | Go to 3 |
| 3 | Is L_AGE in the range 19-999 (inclusive) | Set L_AGEBAND to 2 | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_AGEBAND contain a value | None | Set L_AGEBAND = 2 |
6. The following SPSS code illustrates how to derive L_AGEBAND.
RECODE L_AGE (SYSMIS=9) (0 thru 18=1) (19 thru Hi=2) (else=2) into L_AGEBAND. VARIABLE LABELS L_AGEBAND 'L_AGEBAND Age of the learner as at 31 August 16-18 19+ Bands'. VALUE LABELS L_AGEBAND
1 '16-18'
2 '19+'. |
A_AGEST
7. The following SPSS code illustrates how to derive A_AGEST.
/* SPSS Code to calculate the learner’s age at start of aim. /*The code looks at the difference in years between the date the learner started the learning aim and the Learners Date of Birth. COMPUTE A_AGEST = DATEDIF(A27, L11, "years"). RECODE A_AGEST (SYSMIS=-1). |
A_AGESTB
8. The following table shows the steps required to derive A_AGESTB
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Any | Set A_AGESTB to 9 | |
| 2 | Is A_AGEST in the range 0-15 (inclusive) | Set A_AGESTB to 1 | Go to 3 |
| 3 | Is A_AGEST in the range 16-18 (inclusive) | Set A_AGESTB to 2 | Go to 4 |
| 4 | Is A_AGEST in the range 19-20 (inclusive) | Set A_AGESTB to 3 | Go to 5 |
| 5 | Is A_AGEST in the range 21-24 (inclusive) | Set A_AGESTB to 4 | Go to 6 |
| 6 | Is A_AGEST in the range 25-59 (inclusive) | Set A_AGESTB to 5 | Go to 7 |
| 7 | Is A_AGEST in the range 60-120 (inclusive) | Set A_AGESTB to 6 | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_AGESTB contain a value | None | Set A_AGESTB = 9 |
9. The following SPSS code illustrates how to derive A_AGESTB.
RECODE A_AGEST (SYSMIS=9) (0 thru 15=1) (16 thru 18=2) (19 thru 20=3) (21 thru 24=4) (25 thru 59=5) (60 thru 120=6) (else=9) into A_AGESTB. VARIABLE LABELS A_AGEST 'A_AGEST Age of the learner as at the start date of aim'
/A_AGESTB 'A_AGESTB Age of the learner as at the start date of aim banded'. VALUE LABELS A_AGESTB
1 'Under 16'
2 '16-18'
3 '19-20'
4 '21-24'
5 '25-59'
6 '60 and over'
9 'missing age'. |
A_AGESTBAND
10. The following table shows the steps required to derive A_AGESTBAND
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Any | Set A_AGESTBAND to 2 | |
| 2 | Is A_AGEST in the range 0-18 (inclusive) | Set A_AGESTBAND to 1 | Go to 3 |
| 3 | Is A_AGEST in the range 19-999 (inclusive) | Set A_AGESTBAND to 2 | Go to 4 |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_AGESTBAND contain a value | None | Set A_AGESTBAND = 2 |
11. The following SPSS code illustrates how to derive A_AGESTBAND.
RECODE A_AGEST (0 thru 18=1) (19 thru Hi=2) (else=2) into A_AGESTBAND. VARIABLE LABELS A_AGESTBAND 'A_AGESTBAND Age of the learner as at the start date of aim banded (16-18 19+)'. VALUE LABELS A_AGESTBAND
1 '16-18'
2 '19+'. |
A_FUNDED_AGE_BAND
12. The following table shows the steps required to derive A_FUNDED_AGE_BAND
| Step | Condition | Action/Action if true |
|---|
| 1 | Any | Set A_FUNDED_AGE_BAND=0 |
| 2 | If A_FUNDED_AGE_BAND in Aims DLF File=1 | Set A_FUNDED_AGE_BAND = 1 in Aims File |
13. The following SPSS code illustrates how to match A_FUNDED_AGE_BAND onto the Aims data set.
SORT CASES BY L01 L03 A15 A26 A05.
MATCH FILES
/FILE = *
/TABLE = …..Aims DLF data set
/BY L01 L03 A15 A26 A05.
RECODE A_FUNDED_AGE_BAND (SYSMIS=-1)
VALUE LABELS A_FUNDED_AGE_BAND
1 '16-18'
2 '19+'. |
Date last modified: 20th January 2009
