A_FULLLEVEL2, A_FULLLEVEL3
DATA DEFINITION
1. Defines the Learning Aim Full Level 2 and Full Level 3
SOURCE DATA
2. The following variables are used as a source data for the calculation of these variables.
| Field Name |
Label |
Dataset |
| A_L2WID |
Full Level 2 Width |
|
| A_L2CAT |
Full Level 2 Category |
|
| A_L2PCT |
Full Level 2 Percentage |
|
| A_L3WID |
Full Level 3 Width |
|
| A_L3CAT |
Full Level 3 Category |
|
| A_L3PCT |
Full Level 3 Percentage |
|
| A15 |
Programme Type |
ILR Learning Aim Dataset |
| A10 |
LSC Funding Stream |
ILR Learning Aim Dataset |
DERIVED VARIABLES AND DATASETS
3. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_FULLLEVEL2 |
|
|
| A_FULLLEVEL3 |
|
|
A_FULLLEVEL2, A_FULLLEVEL3 Sample Code
1. The following SPSS code is provided to illustrate the A_FULLLEVEL2, A_FULLLEVEL3 data definition.
A_FULLLEVEL2, A_FULLLEVEL3
2. The following table shows the steps required to derive A_FULLLEVEL2
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
IF the full level 2 category = 1 or 4 (A_L2CAT = 1,4) |
Set A_LEVEL2 = 1 |
Set A_LEVEL2 = 0 |
| 2 |
IF A_LEVEL2 = 1 |
Set A_L2WID = AL2PCT |
|
| 3 |
IF A_L2WID >= 100 OrThe Programme Type is ‘Apprenticeship’ (A15=3) And the Funding Stream if Framework (A10=50 |
Set A_FULLLEVEL2 = 1 |
Set A_FULLLEVEL2 = 0 |
Where the aim counts towards a full level 2 assign the percentage towards a full level 2 to the variable A_L2WID.
Where the aim level percentage towards a full level 2 is 100 or more, then the aim is counted as a full level 2.
3. The following SPSS code illustrates how to derive A_FULLLEVEL2.
|
RECODE A_L2CAT ('1', '4' = 1) (ELSE = 0) INTO A_LEVEL2.
COMPUTE A_L2WID = 0.
IF A_LEVEL2 = 1 A_L2WID = A_L2PCT.
COMPUTE A_FULLLEVEL2 = 0.
IF (A_L2WID >= 100 OR (A15=3 AND A10=50)) A_FULLLEVEL2= 1. |
4. The following table shows the steps required to derive A_FULLLEVEL3
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
IF the full level 3 category = 1,2 or 3 (A_L3CAT = 1,2,3) |
Set A_LEVEL3 = 1 |
Set A_LEVEL3 = 0 |
| 2 |
IF A_LEVEL3 = 1 |
Set A_L3WID = AL3PCT |
|
| 3 |
IF A_L3WID >= 100 OrThe Programme Type is ‘Advanced Apprenticeship’ (A15=2) And the Funding Stream if Framework (A10=50 |
|
|
Where the aim counts towards a full level 3 assign the percentage towards a full level 2 to the variable A_L3WID.
Where the aim level percentage towards a full level 3 is 100 or more, then the aim is counted as a full level 3.
5. The following SPSS code illustrates how to derive A_FULLLEVEL3.
|
RECODE A_L3CAT ('1', '2', '3' = 1) (ELSE = 0) INTO A_LEVEL3.
COMPUTE A_L3WID = 0.
IF A_LEVEL3 = 1 A_L3WID = A_L3PCT.
COMPUTE A_FULLLEVEL3 = 0.
IF (A_L3WID >= 100 OR (A15=2 AND A10=50)) A_FULLLEVEL3= 1.
/IL_Flag_TotalApp=sum(IL_All_YearApp) |
Date last modfied: 23rd October 2008