Full Level Sample Code
Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.
1 The following SPSS code is provided to illustrate the Full Level 2 & 3 data definition.
L_FULLLEVEL2
2 The following table shows the steps required to derive L_FULLLEVEL2
|
| YES | NO |
1 | Is A_LIVE_B >1 | Go to 2 | Set A_L2WID to 0 |
2 | Does A_L2CAT = 1 or 4 | Set A_L2WID = A_L2PCT | Set A_L2WID to 0 |
3 | Set L_L2PCT= sum of all the A_L2WID for the learner |
4 | Is L_L2PCT>=100 | Set L_FULLLEVEL2 to 1 | Set L_FULLLEVEL2 to 0 |
3 The following SPSS code illustrates how to derive L_FULLLEVEL2
GET FILE ‘………..AIMS data set’
SELECT IF A_LIVE_B > 1.
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.
/* Aggregate to learner level.
AGGREGATE OUTFILE = *
/BREAK L01 L03
/L_L2PCT = SUM (A_L2WID).
/* Where the learner level percentage towards a full level 2 is 100 or more, then the learner is counted as a full level 2 learner.
COMPUTE L_FULLLEVEL2 = 0.
IF L_L2PCT >= 100 L_FULLLEVEL2 = 1.
VALUE LABELS L_FULLLEVEL2
1 'Full NVQ Level 2 Learner'
0 'Not Full NVQ Level 2 Learner'.
VARIABLE LABELS L_FULLLEVEL2 "DV - Full NVQ level 2 learner flag". |
L_FULLLEVEL3
4 The following table shows the steps required to derive L_FULLLEVEL3
|
| YES | NO |
1 | Is A_LIVE_B >1 | Go to 2 | Set A_L3WID to 0 |
2 | Does A_L3CAT = 1, 2 or 3 | Set A_L3WID = A_L3PCT | Set A_L3WID to 0 |
3 | Set L_L3PCT= sum of all the A_L3WID for the learner |
4 | Is L_L3PCT>=100 | Set L_FULLLEVEL3 to 1 | Set L_FULLLEVEL3 to 0 |
5 The following SPSS code illustrates how to derive L_FULLLEVEL3
GET FILE ‘…………AIMS data set’
SELECT IF A_LIVE_B > 1.
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.
/* Aggregate to learner level.
AGGREGATE OUTFILE = *
/BREAK L01 L03
/L_L3PCT = SUM (A_L3WID).
/* Where the learner level percentage towards a full level 3 is 100 or more, then the learner is counted as a full level 3 learner.
COMPUTE L_FULLLEVEL3 = 0.
IF L_L3PCT >= 100 L_FULLLEVEL3 = 1.
VALUE LABELS L_FULLLEVEL3
1 'Full NVQ Level 3 Learner'
0 'Not Full NVQ Level 3 Learner'.
VARIABLE LABELS “DV - Full NVQ level 3 learner flag". |
Last Modified: 26 Jan 06
