Aim Contribution to Full level 2 and Full level 3 Data Definition 2009/2010
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 |
| A15 |
A15 Programme Type |
Aims Standard File |
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.
/* Create a variable A_L2WID which will contain the percentage contribution towards a full level 2 for each aim.
COMPUTE A_L2WID = 0.
/* Aims where A_L2CAT=1 or 4 are aims that count towards a full level 2 and assign the percentage towards a full level 2 to the variable A_L2WID.
IF ANY(A_L2CAT,'1','4') 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. |
4. The following SQL code illustrates how to derive A_L2WID:
|
select
L01, L03, A05
, case when A15=10 then 0
when A_L2CAT in ('1','4') then A_L2PCT
when A15=3 then 100
else 0 end as A_L2WID_qry, A_L2WID, A15, A_L2CAT, A_L2PCT
from
--left outer join is used to get all rows from the Aims table and only the matching rows from the LAD table
ILR0910_E_AIMS A
left outer join
LAD_0910 B
on A.A09 = B.A09 |
A_L3WID
5. 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 |
|
6. 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.
/* Create a variable A_L3WID which will contain the percentage contribution towards a full level 3 for each aim.
COMPUTE A_L3WID = 0.
/* Aims where A_L3CAT=1, 2 or 3 are aims that count towards a full level 3 and assign the percentage towards a full level 3 to the variable A_L3WID.
IF ANY(A_L3CAT,'1', '2', '3') 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. |
7. The following SQL code illustrates how to derive A_L3WID:
|
select
L01, L03, A05
, case when A15=10 then 0
when A15=2 then 100
when A_L3CAT in ('1','2','3') then A_L3PCT
else 0 end as A_L3WID_qry, A_L3WID, A15, A_L3CAT, A_L3PCT
from
--left outer join is used to get all rows from the Aims table and only the matching rows from the LAD table
ILR0910_E_AIMS A
left outer join
LAD_0910 B
on A.A09 = B.A09 |
Date last modified: 02th December 2009
