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