Full Level 2 and 3 Completion Data Definition 2009/2010
L_FULLLEVEL2_COMPLETE, L_FULLLEVEL3_ COMPLETE
DATA DEFINITION
1. Full NVQ Level 2 and Full NVQ Level 3 Completion Learner Flags.
PURPOSE
2. It is designed to identify the volume of Learners completing a full National Vocational Qualification (NVQ) of level 2 and 3
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (UFI)
- ILR (ASL)
- ILR (ESF SR)
SOURCE DATA
3. The following variables are used as source data for the calculation of Full NVQ Level 2 and Full NVQ Level 3 Learner Completion Flags.
| Field Name |
Label |
Dataset |
| A_ACTIVE |
A_ACTIVE Aim Active for the Current Academic Year |
Aims Standard File |
| A_L2WID |
A_L2WID Level 2 Width for Full Level 2 Aims |
Aims Standard File |
| A_L3WID |
A_L3WID Level 3 Width for Full Level 3 Aims |
Aims Standard File |
| A04 |
A04 Data set identifier code |
Aims Standard File |
| A15 |
A15 Programme type |
Aims Standard File |
| A34 |
A34 Completion Status |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
L_FULLLEVEL2
_COMPLETE |
L_FULLLEVEL2_COMPLETE - Full Level 2 Completion Learner |
Learner, Aims, ESF and HE Standard Files |
L_FULLLEVEL3
_COMPLETE |
L_FULLLEVEL3_COMPLETE - Full Level 3 Completion Learner |
Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_FULLLEVEL2_COMPLETE, L_FULLLEVEL3_ COMPLETE
| Value |
Label |
| -1 |
Not Applicable/Not Known* |
| 0 |
No |
| 1 |
Yes |
*Applies to system missing values and where there are non-active aims.
DETAILED DEFINITION
6. Full NVQ Level 2 Completion Learner Flag (L_FULLLEVEL2_COMPLETE) is calculated for learners whose aims are in the Full Level 2 Entitlement Category (A_L2CAT) and have completed that aim. If the sum of the aims Full Level 2 % (L_L2PCT) is greater than 100, then they have a value of 1 for Full NVQ Level 2 Completion Learner Flag (L_ FULLLEVEL2_COMPLETE).
7. When calculating the learner level flag (L_FULLLEVEL2_COMPLETE), aims that are not active are excluded (where A_ACTIVE=0).
8. Full NVQ Level 3 Learner Completion Flag (L_FULLLEVEL3_COMPLETE) is calculated in the same way but for learners whose aims are in the Full Level 3 Entitlement Category (A_L3CAT). If the sum of the aims Full Level 3 % (L_L3PCT) is greater than 100, then they have a value of 1 for Full NVQ Level 3 Completion Learner Flag (L_FULLLEVEL3_COMPLETE).
Full Level 2 and 3 Completion Sample Code
1. The following table shows the steps required to illustrate the Full Level 2 3 Completers definitions
L_FULLLEVEL2_COMPLETE
2. The following table shows the steps required to derive L_FULLLEVEL2_COMPLETE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A15 = 3 and A04=35 and A34=2 |
Set A_L2WID_COMP = 100 |
Go to 2 |
| 2 |
Does A15<>2,3 or 10 |
Go to 3 |
Set A_L2WID_COMP to 0 |
| 3 |
Does A34=2 |
Set A_L2WID_COMP = A_L2WID.
Go to 4 |
Go to 4 |
| 4 |
(Aggregation)
For all aims where the learner (L03) and provider (L01) are the same and A_ACTIVE=1. |
Set L_L2PCT_COMP to the sum of A_L2WID_COMP.
Go to 5 |
|
| 5 |
Is L_L2PCT_COMP >=100 |
Set L_FULLLEVEL2_COMPLETE to 1 |
Set L_FULLLEVEL2_COMPLETE to 0 |
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_FULLLEVEL2
_COMPLETE contain a value |
None |
Set L_FULLLEVEL2
_COMPLETE = -1 |
3. The following SPSS code illustrates how to derive L_FULLLEVEL2_ COMPLETE.
|
GET FILE ‘…………AIMS data set’.
COMP A_L2WID_COMP = 0.
IF NOT ANY (A15, 2, 3, 10) and A34=2 A_L2WID_COMP=A_L2WID.
IF A15=3 and A04=35 and A34=2 A_L2WID_COMP=100.
SELECT IF A_ACTIVE=1.
AGG OUT *
/PRESORTED
/BREAK = L01 L03 L35
/L_L2PCT_COMP = SUM (A_L2WID_COMP).
COMPUTE L_FULLLEVEL2_COMPLETE = (L_L2PCT_COMP>= 100).
Var labels L_FULLLEVEL2_COMPLETE ‘L_FULLLEVEL2_COMPLETE Full Level 2 Completion Learner’.
SAVE OUTFILE=……L_L2PCT_COMP.SAV’
GET FILE=’…...LEARNER Dataset’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_L2PCT_COMP.SAV’.SAV’
/BY L01 L03.
RECODE L_FULLLEVEL2_COMPLETE (SYSMIS=-1).
VALUE LABELS L_FULLLEVEL2_COMPLETE
-1 'Not Applicable/Not Known'
0 'No’
1 'Yes’. |
4. The following SQL code illustrates how to derive L_FULLLEVEL2_COMPLETE:
|
select
B.L01, B.L03
, case when L_L2PCT_COMP>=100 then 1
when L_L2PCT_COMP=-1 then -1
else 0 end as L_FULLLEVEL2_COMPLETE
from
(
select
L01, L03, count(A05) as aims
, sum(A_L2WID_COMP) as L_L2PCT_COMP
from
(
select
L01, L03, A05
, case when A15=3 and A04=35 and A34=2 then 100
when A15 not in (2,3,10) and A34=2 then A_L2WID
else 0 end as A_L2WID_COMP
from
ILR0910_E_AIMS
where A_ACTIVE=1
)T
group by
L01, L03
)T2
right outer join
ILR0910_L01_LEARNER B
on T2.L01=B.L01 and T2.L03=B.L03
order by
B.L01, B.L03 |
L_FULLLEVEL3_ COMPLETE
5. The following table shows the steps required to derive L_FULLLEVEL3_ COMPLETE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A15 = 2 and A04=35 and A34=2 |
Set A_L3WID_COMP = 100 |
Go to 2 |
| 2 |
Does A15<>2,3 or 10 |
Got to 3 |
Set A_L3WID_COMP to 0 |
| 3 |
Does A34=2 |
Set A_L3WID_COMP = A_L3WID. Go to 4 |
Go to 4 |
| 4 |
(Aggregation)
For all aims where the learner (L03) and provider (L01) are the same and A_ACTIVE=-1 |
Set L_L3PCT_COMP to the sum of A_L3WID_COMP.
Go to 5 |
|
| 5 |
Is L_L3PCT_COMP >=100 |
Set L_FULLLEVEL3_COMPLETE to 1 |
Set L_FULLLEVEL3_COMPLETE to 0 |
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_FULLLEVEL3_COMPLETE contain a value |
None |
Set L_FULLLEVEL3_COMPLETE = -1 |
6. The following SPSS code illustrates how to derive L_FULLLEVEL3_ COMPLETE.
|
GET FILE ‘…………AIMS data set’.
COMPUTE A_L3WID_COMP=0.
IF NOT ANY (A15, 2, 3, 10) and A34=2 A_L3WID_COMP=A_L3WID.IF A15=2 and A04=35 and A34=2 A_L3WID_COMP=100.
SELECT IF A_ACTIVE=1.
AGG OUT *
/PRESORTED
/BREAK = L01 L03
/L_L3PCT_COMP = SUM (A_L3WID_COMP).
COMPUTE L_FULLLEVEL3_COMPLETE = (L_L3PCT_COMP>= 100).
Var labels L_FULLLEVEL3_COMPLETE ‘L_FULLLEVEL3_COMPLETE Full Level 3 Completion Learner’
SAVE OUTFILE=……L_L3PCT_COMP.SAV’
GET FILE=’…...LEARNER Dataset’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_L3PCT_COMP.SAV’.SAV’
/BY L01 L03.
RECODE L_FULLLEVEL3_COMPLETE (SYSMIS=-1).
VALUE LABELS L_FULLLEVEL3_COMPLETE
-1 'Not Applicable/Not Known'
0 'No’
1 'Yes’. |
7. The following SQL code illustrates how to derive L_FULLLEVEL3_COMPLETE:
|
select
B.L01, B.L03
, case when L_L3PCT_COMP>=100 then 1
when L_L3PCT_COMP is null then -1
else 0 end as L_FULLLEVEL3_COMPLETE
from
(
select
L01, L03, count(A05) as aims
, sum(A_L3WID_COMP) as L_L3PCT_COMP
from
(
select
L01, L03, A05
, case when A15=3 and A04=35 and A34=2 then 100
when A15 not in (2,3,10) and A34=2 then A_L3WID
else 0 end as A_L3WID_COMP
from
ILR0910_E_AIMS
where A_ACTIVE=1
)T
group by
L01, L03
)T2
right outer join
ILR0910_L01_LEARNER B
on T2.L01=B.L01 and T2.L03=B.L03
order by
B.L01, B.L03 |
Date last modified: 02nd December 2009
