Age Data Definition 2009/2010
A_AGEST A_AGESTB L_AGE L_AGEB L_AGEBAND A_AGESTBAND A_AGE_31AugStYr* A_FUNDED_AGE_BAND
DATA DEFINITION
1. Age of Learner, Age at Start of Aim, Age at 31st August in the academic year the learning aim started*, and Funded Age band.
* This variable is used only in LR success rates and does not appear in the list of Derived Variables as it is not included in the standard files, or calculated by the Learner Information Suite (LIS). This variable has historically been called L_AGE in the success rate methodology for 2007/08 and previous years although it is calculated diffently from the L_AGE derived variable. From 2008/09 it has been renamed to A_AGE_31AugStYr.
PURPOSE
2. Learner’s age, as at 31st August of the current academic year, is used to ensure consistency in analysis and over time. Learner's age at the 31st August in the academic year the learning aim started is used in Learner Responsive success rate calculations.
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 DLF 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 and HE Standard Files |
| L_AGEB |
L_AGEB Age of learner as at 31 August banded |
Learner, Aims 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 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 Standard File |
| A_AGE_31AugStYr |
A_AGE_31AugStYr Age of the Learner as on 31/08 of the academic year the learning aim started |
Success Rates Methodologies |
VALUES
5. The table below outlines the categories for A_AGEST, A_GESTB, L_AGE, L_AGEB, L_AGEBAND, A_AGESTBAND and 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+ |
| -1 |
Not available/Missing Value |
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.
* - This variable is not treated as a Derived Variable and does not appear on the DV list but is used in the calculation of success rates. This variable had been used as L_AGE for the calculation of success rates methodologies in 07/08 although it is not the same as L_AGE in the derived variables section. It has been renamed to A_AGE_31AugStYr from 2008/09.
Age Sample Code
1. The following SPSS code is provided to illustrate the Age data definition.
L_AGE
2. The following table illustrates the step(s) how to derive L_AGE.
| Step |
Condition |
Action if True |
Action if False |
| 1 |
Does L11 contain a value? |
Set L_AGE to difference between L11 and 31/08/current academic year. |
Set L_AGE as -1. |
3. 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). |
4. The following SQL code illustrates how to derive L_AGE:
|
select
L01, L03
--use of datediff function to calculate difference in dates
, case when L11 is not NULL then datediff(mm,L11,'31 august 2009')/12
else -1 end as L_AGE
from
ILR0910_E_LEARNER |
L_AGEB
5. 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 |
6. 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'. |
7. The following SQL code illustrates how to derive L_AGEB:
|
select
L01, L03
--use of case statement to determine range age falls in
, case when L_AGE between 0 and 15 then 1
when L_AGE between 16 and 18 then 2
when L_AGE between 19 and 20 then 3
when L_AGE between 21 and 24 then 4
when L_AGE between 25 and 59 then 5
when L_AGE between 60 and 120 then 6
else 9 end as L_AGEB
from
ILR0910_E_LEARNER |
L_AGEBAND
8. The following table shows the steps required to derive L_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 > 19 |
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 |
9. The following SPSS code illustrates how to derive L_AGEBAND.
|
RECODE L_AGE (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+'. |
10. The following SQL code illustrates how to derive L_AGEBAND:
|
select
L01, L03
--use of case statement to determine range
, case when L_AGE between 0 and 18 then 1
when L_AGE>=19 then 2
else 2 end as L_AGEBAND
from
ILR0910_E_LEARNER |
A_AGEST
11. The following table illustrayes the Steps how to derive A_AGEST.
| Step |
Condition |
Action if True |
Action if False |
| 1 |
Does A27 contain a value? |
Go to 2. |
Set A_AGEST as -1. |
| 2 |
Does L11 contain a value? |
Set A_AGEST to difference between L11 and A27. |
Set A_AGEST as -1. |
12. 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). |
13. The following SQL code illustrates how to derive A_AGEST:
|
select
L01, L03, A05
, case when L11 is not null and A27 is not null
then
case when datepart(m,L11)=datepart(m,A27) and datepart(dd,A27)<datepart(dd,L11) then (datediff(mm,L11,A27)/12)-1
else datediff(mm,L11,A27)/12 end
when L11 is null or A27 is null then -1
end as A_AGEST
from
ILR0910_L01_AIMS |
A_AGESTB
14. 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 |
15. The following SPSS code illustrates how to derive A_AGESTB.
|
RECODE A_AGEST (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'. |
16. The following SQL code illustrates how to derive A_AGESTB:
|
select
L01, L03, A05
, case when A_AGEST between 0 and 15 then 1
when A_AGEST between 16 and 18 then 2
when A_AGEST between 19 and 20 then 3
when A_AGEST between 21 and 24 then 4
when A_AGEST between 25 and 59 then 5
when A_AGEST between 60 and 120 then 6
else 9 end as A_AGESTB
from
ILR0910_E_AIMS |
A_AGESTBAND
17. 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 >19 |
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 |
18. 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+'. |
19. The following SQL code illustrates how to derive A_AGESTBAND:
|
select
L01, L03, A05
, case when A_AGEST between 0 and 18 then 1
when A_AGEST>=19 then 2
else 2 end as A_AGESTBAND
from
MISVS001.LSC_MI_db_pub.dbo.ILR0910_E_AIMS |
A_AGE_31AugStYr
20. The following sample SPSS code illustrates how to derive A_AGE_31AugStYr used in Learner Responsive success rates calculations:
|
do IF ( XDATE.MONTH(A27) LE 7).
do IF ( XDATE.MONTH(L11) LE 8).
COMPUTE A_AGE_31AugStYr=(XDATE.YEAR(A27)-1) - XDATE.YEAR(L11).
ELSE.
COMPUTE A_AGE_31AugStYr=(XDATE.YEAR(A27)-2)-XDATE.YEAR(L11).
end IF.
Else if ( XDATE.MONTH(A27) GT 7).
do IF ( XDATE.MONTH(L11) LE 8).
COMPUTE A_AGE_31AugStYr=XDATE.YEAR(A27) - XDATE.YEAR(L11).
ELSE.
COMPUTE A_AGE_31AugStYr=(XDATE.YEAR(A27)-1)-XDATE.YEAR(L11).
end IF.
end IF.
end IF.
RECODE A_AGE_31AugStYr (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_AGE_31AugStYr_B.
RECODE A_AGE_31AugStYr_B (1,2=1) (else=2) into A_AGE_31AugStYr_BAND.
VARIABLE LABELS
A_AGE_31AugStYr 'DV - Age of the learner as at 31 August of start year'
A_AGE_31AugStYrB 'DV - Age of the learner as at 31 August of start year banded'
A_AGE_31AugStYr_Band 'DV - Age of the learner as at 31 August of start year 16-18 19+ Bands'.
VALUE LABELS A_AGE_31AugStYr_B
1 'Under 16'
2 '16-18'
3 '19-20'
4 '21-24'
5 '25-59'
6 '60 AND over'
9 'missing age'
/ A_AGE_31AugStYr_Band
1 ‘16-18’
2 ‘19+’. |
A_FUNDED_AGE_BAND
21. 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 = -1 |
| 1 |
If A_FUNDED_AGE_BAND in Aims DLF File=2 |
Set A_FUNDED_AGE_BAND = 2 |
| 2 |
If A_FUNDED_AGE_BAND in Aims DLF File=1 |
Set A_FUNDED_AGE_BAND = 1 in Aims File |
22. 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+'. |
23. The following SQL code illustrates how to derive A_FUNDED_AGE_BAND:
|
select
A.L01, A.L03, A.A05
--copies over value from the Aims DLF file
, case when B.A_FUNDED_AGE_BAND=1 then 1 else 0 end as A_FUNDED_AGE_BAND
from
ILR0910_E_AIMS A
left outer join
ILR0910_E_AIMS_DLF B
on A.L01=B.L01 and A.L03=B.L03 and A.A05=B.A05 |
Date last modified: 01st December 2009
