First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Data Definition 2009/2010

L_ FIRST_FULLLEVEL2, L_ FIRST_FULLLEVEL2_ACHIEVE, L_FIRST_FULLLEVEL3, L_FIRST_FULLLEVEL3_ACHIEVE

DATA DEFINITION

1. First Full NVQ Level 2 and First Full NVQ Level 3 Learner Flags, and First Full NVQ Level 2 and First Full NVQ Level 3 Achievement Learner Flags.

PURPOSE

2. It is designed to identify the volume of Learners who are undertaking their first full National Vocational Qualification (NVQ) of level 2 or 3. And also to identify the volume of Learners who have achieved their first full National Vocational Qualification (NVQ) of level 2 or 3.

RELEVANT COLLECTIONS

ILR (LR)
ILR (ER)
ILR (UFI)
ILR (ASL)

SOURCE DATA
3. The following variables are used as source data for the calculation of the First Full NVQ Level 2 and First Full NVQ Level 3 Learner Flags, and the First Full NVQ Level 2 and First Full NVQ Level 3 Achievement Learner Flags

Field Name	Label	Dataset
L35	L35 Prior Attainment Level	Learner Standard File
L_FULLLEVEL2	L_FULLLEVEL2 Full Level 2 Learner	Learner Standard File
L_FULLLEVEL3	L_FULLLEVEL3 Full Level 3 Learner	Learner Standard File
L_FULLLEVEL2 _ACHIEVE	L_FULLLEVEL2_ACHIEVE Full Level 2 Achievement Learner	Learner Standard File
L_FULLLEVEL3 _ACHIEVE	L_FULLLEVEL3_ACHIEVE Full Level 3 Achievement Learner	Learner Standard File
L_ACTIVE	L_ACTIVE Learner Active for Current Academic Year	Learner Standard File, Aims Standarrd File

DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)

Field Name	Label	Dataset
L_FIRST_FULLLEVEL2	L_FIRST_FULLLEVEL2 First Full Level 2 Learner	Learner, Aims, ESF and HE Standard Files
L_FIRST_FULLLEVEL2 _ACHIEVE	L_FIRST_FULLLEVEL2 _ACHIEVE First Full Level 2 Achievement Learner	Learner, Aims, ESF and HE Standard Files
L_FIRST_FULLLEVEL3	L_FIRST_FULLLEVEL3 First Full Level 3 Learner	Learner, Aims, ESF and HE Standard Files
L_FIRST_FULLLEVEL3 _ACHIEVE	L_FIRST_FULLLEVEL3 _ACHIEVE First Full Level 3 Achievement Learner	Learner, Aims, ESF and HE Standard Files

VALUES

5. The table below outlines the categories for L_ FIRST_FULLLEVEL2, L_ FIRST_FULLLEVEL2_ACHIEVE, L_FIRST_FULLLEVEL3, L_FIRST_FULLLEVEL3_ACHIEVE

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. First Full NVQ Level 2 Learner Flag (L_FIRST_FULLLEVEL2) is calculated for learners who are flagged as Full NVQ Level 2 Learners and have not previously attained a Full NVQ Level 2

7. First Full NVQ Level 2 Achievement Learner Flag (L_FIRST_FULLLEVEL2_ACHIEVE ) is calculated for learners who are flagged as achieving a Full NVQ Level 2 and have not previously attained a Full NVQ Level 2

8. First Full NVQ Level 3 Learner Flag (L_FIRST_FULLLEVEL3) is calculated for learners who are flagged as Full NVQ Level 3 Learners and have not previously attained a Full NVQ Level 3

9. First Full NVQ Level 3 Achievement Learner Flag (L_FIRST_FULLLEVEL3_ACHIEVE ) is calculated for learners who are flagged as achieving a Full NVQ Level 3 and have not previously attained a Full NVQ Level 3

First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Sample Code

1. The following SPSS code is provided to illustrate the First Full Level 2 and 3 and First Full Level 2 and 3 Achievement data definition.

L_ FIRST_FULLLEVEL2, L_ FIRST_FULLLEVEL2_ACHIEVE

2. The following table shows the steps required to derive L_ FIRST_FULLLEVEL2, L_ FIRST_FULLLEVEL2_ACHIEVE

L_FIRST_FULLLEVEL2

Step	Condition	Action/Action if true	Action if false
1	Does L_ACTIVE = 1	Go to 2	Set L_FIRST_FULLLEVEL2 = -1
2	L_FULLLEVEL2 = 1 and does L35= one of 1, 7, 9 or 99.	Set L_FIRST_FULLLEVEL2=1	Set L_FIRST_FULLLEVEL2=0

Step	Condition	Action/Action if true	Action if false
1	Does L_FIRST_FULLLEVEL2 contain a value	None	Set L_FIRST_FULLLEVEL2 = -1

L_FIRST_FULLLEVEL2_ACHIEVE

Step	Condition	Action/Action if true	Action if false
1	Does L_ACTIVE = -1	Go to 2	Let L_FIRST_FULLLEVEL2_ ACHIEVE = -1
2	Does L_FULLLEVEL2_ACHIEVE = 1 AND L_FIRST_FULLLEVEL2 = 1).	Set L_FIRST_FULLLEVEL2 _ACHIEVE = 1	Set L_FIRST_FULLLEVEL2 _ACHIEVE = 0

Step	Condition	Action/Action if true	Action if false
1	Does L_FIRST_FULLLEVEL2 _ACHIEVE contain a value	None	Set L_FIRST_FULLLEVEL2 _ACHIEVE = -1

3. The following SPSS code illustrates how to derive L_ FIRST_FULLLEVEL2, L_ FIRST_FULLLEVEL2_ACHIEVE

GET FILE ‘…………LEARNER data set’.
COMPUTE L_FIRST_FULLLEVEL2=-1.
COMPUTE L_FIRST_FULLLEVEL2_ACHIEVE=-1.

DO IF L_ACTIVE=1.
COMPUTE L_FIRST_FULLLEVEL2 = (L_FULLLEVEL2 = 1 AND ANY(L35,1,7,9,99)).
COMPUTE L_FIRST_FULLLEVEL2_ACHIEVE =(L_FULLLEVEL2_ACHIEVE = 1 AND L_FIRST_FULLLEVEL2 = 1).
END IF
VARIABLE LABELS L_FIRST_FULLLEVEL2 ‘L_FIRST_FULLLEVEL2 First Full Level 2 Learner’
 /L_FIRST_FULLLEVEL2_ACHIEVE ‘L_FULLLEVEL2_ACHIEVE First Full Level 2 Achievement Learner’.
VALUE LABELS L_FIRST_FULLLEVEL2_ACHIEVE
-1 'Not Applicable/Not Known'
0 ‘No’
1 ‘Yes’.

L_ FIRST_FULLLEVEL3, L_ FIRST_FULLLEVEL3_ACHIEVE

4. The following table shows the steps required to derive L_ FIRST_FULLLEVEL3, L_ FIRST_FULLLEVEL3_ACHIEVE

L_FIRST_FULLLEVEL3

Step	Condition	Action/Action if true	Action if false
1	Does L_ACTIVE = 1	Go to 2	Set L_FIRST_FULLLEVEL3 = -1
2	L_FULLLEVEL3 = 1 and does L35= one of 1, 2, 7, 9 or 99.	Set L_FIRST_FULLLEVEL3=1	Set L_FIRST_FULLLEVEL3=0

Step	Condition	Action/Action if true	Action if false
1	Does L_FIRST_FULLLEVEL3 contain a value	None	Set L_FIRST_FULLLEVEL3 = -1

L_FIRST_FULLLEVEL3_ACHIEVE

Step	Condition	Action/Action if true	Action if false
1	Does L_ACTIVE = 1	Go to 2	Set L_FIRST_FULLLEVEL3 _ACHIEVE = -1
2	Does L_FULLLEVEL3_ACHIEVE = 1 AND L_FIRST_FULLLEVEL3 = 1).	Set L_FIRST_FULLLEVEL3 _ACHIEVE = 1	Set L_FIRST_FULLLEVEL3 _ACHIEVE = 0

Step	Condition	Action/Action if true	Action if false
1	Does L_FIRST_FULLLEVEL3 _ACHIEVE contain a value	None	Set L_FIRST_FULLLEVEL3 _ACHIEVE = -1

5. The following SPSS code illustrates how to derive L_ FIRST_FULLLEVEL3, L_ FIRST_FULLLEVEL3_ACHIEVE

GET FILE ‘…………LEARNER data set’.
COMPUTE L_FIRST_FULLLEVEL3 = -1.
COMPUTE L_FIRST_FULLLEVEL3_ACHIEVE=-1.
DO IF L_ACTIVE=1
COMPUTE L_FIRST_FULLLEVEL3 = (L_FULLLEVEL3 = 1 AND ANY(L35,1,2,7,9,99)).
COMPUTE L_FIRST_FULLLEVEL3_ACHIEVE =(L_FULLLEVEL3_ACHIEVE = 1 AND L_FIRST_FULLLEVEL3 = 1).
END IF
VARIABLE LABELS L_FIRST_FULLLEVEL3 ‘L_FIRST_FULLLEVEL3 First Full Level 3 Learner’
  /L_FIRST_FULLLEVEL3_ACHIEVE ‘L_FIRST_FULLLEVEL3_ACHIEVE First Full Level 3 Achievement Learner’.
VALUE LABELS L_FULLLEVEL3_ACHIEVE
-1 'Not Applicable/Not Known'
0 ‘No’
1 ‘Yes’.

6. The following SQL code illustrates how to derive L_FIRST_FULLLEVEL2 and L_FIRST_FULLLEVEL3:

select L01, L03 , case when L_ACTIVE = 0 then -1 when L_ACTIVE = 1 and L_FULLLEVEL2 = 1 and L35 in (1,7,9,99) then 1 else 0 end as L_FIRST_FULLLEVEL2 , case when L_ACTIVE = 0 then -1 when L_ACTIVE = 1 and L_FULLLEVEL3 = 1 and L35 in (1,2,7,9,99) then 1 else 0 end as L_FIRST_FULLLEVEL3 from ILR0910_E_LEARNER

select

     L01, L03
     , case when L_ACTIVE = 0 then -1
     when L_ACTIVE = 1 and L_FULLLEVEL2 = 1 and L35 in (1,7,9,99) then 1
     else 0 end as L_FIRST_FULLLEVEL2

     , case when L_ACTIVE = 0 then -1
     when L_ACTIVE = 1 and L_FULLLEVEL3 = 1 and L35 in (1,2,7,9,99) then 1
     else 0 end as L_FIRST_FULLLEVEL3

from

ILR0910_E_LEARNER

7. The following SQL code illustrates how to derive L_FIRST_FULLLEVEL2_ACHIEVE and L_FIRST_FULLLEVEL3_ACHIEVE:

select L01, L03 , case when L_ACTIVE = 0 then -1 when L_FIRST_FULLLEVEL2 = 1 and L_FULLLEVEL2_ACHIEVE = 1 then 1 else 0 end as L_FIRST_FULLLEVEL2_ACHIEVE , case when L_ACTIVE = 0 then -1 when L_FIRST_FULLLEVEL3 = 1 and L_FULLLEVEL3_ACHIEVE = 1 then 1 else 0 end as L_FIRST_FULLLEVEL3_ACHIEVE from dbo.ILR0910_E_LEARNER

select

     L01, L03
     , case when L_ACTIVE = 0 then -1
     when L_FIRST_FULLLEVEL2 = 1 and L_FULLLEVEL2_ACHIEVE = 1 then 1
     else 0 end as L_FIRST_FULLLEVEL2_ACHIEVE

     , case when L_ACTIVE = 0 then -1
     when L_FIRST_FULLLEVEL3 = 1 and L_FULLLEVEL3_ACHIEVE = 1 then 1
     else 0 end as L_FIRST_FULLLEVEL3_ACHIEVE

from

dbo.ILR0910_E_LEARNER

Date last modified: 02nd December 2009