Aim Contribution to Full level 2 and Full level 3 Data Definition 2008/2009
A_L2WID, A_L3WID
DATA DEFINITION
1. Percentage aim contribution to full level 2 and full level 3.
PURPOSE
2. It is designed to identify the percentage contribution of the aim towards full level 2 and full level 3.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ESF SR)
- ILR (ER)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Aim contribution to full level 2 and full level 3.
| Field Name |
Label |
Dataset |
| A_L2CAT |
A_L2CAT Full Level 2 Category |
Analytical LAD |
| A_L2PCT |
A_L2PCT Full Level 2 Pct |
Analytical LAD |
| A_L3CAT |
A_L3CAT Full Level 3 Category |
Analytical LAD |
| A_L3PCT |
A_L3PCT Full Level 3 Pct |
Analytical LAD |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_L2WID |
A_L2WID Level 2 Width For Full Level 2 and GCSE Aims |
Aims Standard File |
| A_L3WID |
A_L3WID Level 3 Width For Full Level 3 and AS A2 Aims |
Aims Standard File |
DETAILED DEFINITION
5. Aim contribution towards full level 2 (A_L2WID) is calculated for those aims that count towards full level 2 according to the LAD (A_L2CAT=1 or 2) or the Programme type is an apprenticeship (A15 = 2).
6. Aim contribution towards full level 3 (A_L3WID) is calculated for those aims that count towards full level 3 according to the LAD (A_L3CAT=1, 2 or 3) or the Programme type is an Advanced apprenticeship (A15 = 3).
Aim Contribution to Full level 2 and Full level 3 Sample Code
1. The following SPSS code is provided to illustrate the Aim Contribution to Full level 2 and Full level 3 data definition.
A_L2WID
2. The following table shows the steps required to derive A_L2WID
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_L2CAT = 1 or 4 |
Set A_L2WID = A_L2PCT |
Set A_L2WID to 0 |
| 2 |
Does A15 = 3 |
Set A_L2WID = 100 |
Set A_L2WID = 0 |
| 3 |
Does A15 = 10 |
Set A_L2WID to 0 |
|
3. The following SPSS code illustrates how to derive A_L2WID.
|
GET FILE ‘………..AIMS data set’.
SORT CASES BY A09.
MATCH FILES
/FILE = *
/TABLE = …..Analytical LAD data set
/BY A09.
/* Aims where A_L2CAT=1 or 4 are aims that count towards a full level 2.
RECODE A_L2CAT ('1', '4' = 1) (ELSE = 0) INTO A_LEVEL2.
/* Create a variable A_L2WID which will contain the percentage contribution towards a full level 2 for each aim.
COMPUTE A_L2WID = 0.
/* Where the aim counts towards a full level 2 assign the percentage towards a full level 2 to the variable A_L2WID.
IF A_LEVEL2 = 1 A_L2WID = A_L2PCT.
/* An Apprenticeship counts as a full level 2, A_L2WID is set to 100%.
/* A Higher Level Apprenticeship does not count as a full level 2 as it is level 4, A_L2WID is 0%.
IF A15=3 A_L2WID=100.
IF A15=10 A_L2WID=0. |
A_L3WID
4. The following table shows the steps required to derive A_L3WID
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_L3CAT = 1, 2 or 3 |
Set A_L3WID = A_L3PCT |
Set A_L3WID to 0 |
| 2 |
Does A15 = 2 |
Set A_L3WID = 100 |
Set A_L3WID to 0 |
| 3 |
Does A15 = 10 |
Set A_L3WID = 0 |
|
5. The following SPSS code illustrates how to derive A_L3WID.
|
GET FILE ‘…………AIMS data set’.
SORT CASES BY A09.
MATCH FILES
/FILE=*
/TABLE=Analytical LAD data set
/BY A09.
/* Aims where A_L3CAT=1, 2 or 3 are aims that count towards a full level 3.
RECODE A_L3CAT ('1', '2', '3' = 1) (ELSE = 0) INTO A_LEVEL3.
/* Create a variable A_L3WID which will contain the percentage contribution towards a full level 3 for each aim.
COMPUTE A_L3WID = 0.
/* Where the aim counts towards a full level 3 assign the percentage towards a full level 3 to the variable A_L3WID.
IF A_LEVEL3 = 1 A_L3WID = A_L3PCT.
/* An Advanced Apprenticeship counts as a full level 3, A_L3WID is set to 100%.
/* A Higher Level Apprenticeship does not count as a full level 3 as it is level 4, A_L3WID is 0%.
IF A15=2 A_L3WID=100.
IF A15=10 A_L3WID=0. |
Date last modified: 20th January 2009
