In Learning in Year Data Definition 2008/2009
A_IL_IY, P_IL_IY, L_IL_IY
DATA DEFINITION
1. In-Learning in year at learner, aim or programme level.
PURPOSE
2. To identify whether the aim, programme or learner is in learning in year.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (UFI)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of the In Learning in Year data definition.
| Field Name | Label | Dataset |
|---|
| A_IL_P1 to P12 | A_IL_P1 In Learning in Period X | Aims Standard File |
| A_IL_IY | A_IL_IY Aim in Learning in Year | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| A_IL_IY | A_IL_IY Aim in Learning in Year | Aims Standard File |
| P_IL_IY | P_IL_IY Programme in Learning in Year | Aims Standard File |
| L_IL_IY | L_IL_IY Learner in Learning in Year | Aims and Learner Standard File |
VALUES
5. The table below outlines the categories for A_IL_IY, P_IL_IY, L_IL_IY
| Value | Label |
|---|
| -1 | Not Applicable/Not Known* |
| 0 | No |
| 1 | Yes |
*Applies to system missing values and where there are non-active aims. Only applicable at learner level.
DETAILED DEFINITION
Aim Level
6. The Aim level In learning is the sum of all the periods that the aim is in learning for.
Programme Level
7. Programme level (P_IL_IY) is the highest value of has the aim been in learning (A_IL_IY) for all of the learner’s aims within a programme.
Learner Level
8. Learner level (L_IL_IY) is the highest value of has the aim been in learning (A_IL_IY) for all of the learner’s aims.
IN LEARNING IN YEAR SAMPLE CODE
1. The following SPSS code is provided to illustrate the In Learning in Year data definition.
A_IL_IY, P_IL_IY, L_IL_IY
2. The following tables show the steps required to derive A_IL_IY, P_IL_IY, L_IL_IY
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_IL_P1 to A_IL_P12 have any missing values. | Set A_ILP1 to A_IL_P12 to 0.
Go to 2 | Go to 2 |
| 2 | Is the Sum of A_IL_P1 to A_IL_P12 greater than 0. | SET A_IL_IY=1 | Set A_IL_IY=0
Go to 3 |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Is A15 MISSING or A15=-1 or A15=99 | Set P_IL_IY to -1 | Go to 2 |
| 2 | (Aggregate)
For all aims where the learner (L03), Provider (L01), Programme Type (A15) and Framework Code (A26) are the same. | Set P_IL_IY to the maximum value of A_IL_IY. | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | (Aggregate)
For all aims where the learner (L03) and Provider (L01) are the same. | Set L_IL_IY to the maximum value of A_IL_IY | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_IL_IY contain a value | None | Set L_IL_IY = -1 |
3. The following SPSS code illustrates how to derive A_IL_IY, P_IL_IY, L_IL_IY.
GET FILE = …………Aims Data set. RECODE A_IL_P1 to A_IL_P12 (SYSMIS=0). *Calculate A_IL_IY variable.
COMP A_IL_IY=(SUM(A_IL_P1 to A_IL_P12)>0). *Aggregate to programme level taking the maximum in learning value.
SORT CASES L01 L03 A15 A26.
AGGREGATE
/OUTFILE = *
MODE=ADDVARIABLES
/PRESORTED
/BREAK = L01 L03 A15 A26
/P_IL_IY= max(A_IL_IY). Do if MISSING(A15) or A15=-1 or A15=99.
+comp P_IL_IY=-1.
end if. VALUE LABELS P_IL_IY
-1 'Not Applicable/Not Known'
0 'No’
1 'Yes’ /A_IL_IY
0 'No’
1 'Yes’. *Aggregate to Learner level taking the maximum in learning value.
SORT CASES L01 L03.
AGGREGATE
/OUTFILE = *
/PRESORTED
/BREAK = L01 L03
/L_IL_IY= max(A_IL_IY).
RECODE L_IL_IY (SYSMIS=-1)
VALUE LABELS L_IL_IY
0 'No’
1 'Yes’. |
Date last modified: 14th January 2009
