Notional NVQ Level Data Definition 2008/2009
A_NVQLEV, L_NVQLEV
DATA DEFINITION
1. Notional NVQ Level of Aim and Learner.
PURPOSE
2. To identify the Notional National Vocational Qualification (NVQ) Level of each aim undertaken by a learner. At learner level, the learner's aim with the highest Notional NVQ Level is then assigned to the learner. These derived variables are used to categorise and assess the range and type of provision in the sector to help monitor progress towards national and local targets. These are key fields for analysis.
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 Notional NVQ Level and Aim Type.
|
Field Name
|
Label
|
Dataset
|
| A09 |
A09 Aim Reference |
Aims Standard File |
| A_ENGLEV |
A_ENGLEV England FE HE Status |
Analytical LAD |
| A_LATYPE |
A_LATYPE Aim Type |
Analytical LAD |
| A_NOTION |
A_NOTION Notional NVQ Level |
Analytical LAD |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
|
Field Name
|
Label
|
Dataset
|
| A_NVQLEV |
A_NVQLEV Notional NVQ Level of the Aim |
Aims Standard File |
| L_NVQLEV |
L_NVQLEV Notional NVQ Level of Learner |
Learner Standard File, Aims Standard File |
VALUES
5. The table below outlines the categories for A_NVQLEV, L_NVQLEV
| A_NVQLEV, L_NVQLEV |
Label |
| -1 |
Not Applicable/Not Known* |
| 1 |
Level 1 and Entry |
| 2 |
Level 2 |
| 3 |
Level 3 |
| 4 |
Level 4, 5 or Higher |
| 9 |
Other |
*Applies to system missing values and where there are non-active aims. Only applicable at learner level.
DETAILED DEFINITION
6. A function that assigns the Notional NVQ Level (A_NOTION) from the LAD to a derived variable (A_NVQLEV). Some Learning Aim Types (A_LATYPE) need to be assigned separately to ensure accuracy. Notional NVQ Level (A_NOTION), is then used to categorise the remaining aims, to make broader frequently used categories.
| A_NOTION value |
A_NVQLEV value |
| 1 or E |
1 |
| 2 |
2 |
| 3 |
3 |
| 4 or 5 or H |
4 |
| M, U, X |
9 |
7. Any aims without a Notional NVQ Level (A_NOTION), either because it is not applicable or it is missing from the LAD, are coded as Other (A_NVQLEV=9).
8. The Notional NVQ Level of Learner (L_NVQLEV) is taken from the aim with the highest Notional NVQ Level of Aim (A_NVQLEV), excluding those aims that are not included for analytical purposes (using A_ACTIVE). There is an exception where Notional NVQ Level of Aim is Other (A_NVQLEV=9), then the aim has the lowest priority to all other values, i.e. A_NVQLEV=1 will have priority over A_NVQLEV=9.
Notional NVQ Level Sample Code
1. The following SPSS code is provided to illustrate the Notional NVQ Level data definition.
A_NVQLEV, L_NVQLEV
2. The following table shows the steps required to derive A_NVQLEV
| Step |
Condition
|
Action/Action if true
|
Action if false
|
| 1 |
Any |
Set A_NVQLEV to -1 |
|
| 2 |
Is A_LATYPE=0004 or 0005 or 0007 or 0017 or 0030 |
Set A_NOTION to 3 |
Go to 3 |
| 3 |
Is A_LATYPE=0028 or 0029 |
Set A_NOTION to 2 |
Go to 4 |
| 4 |
Does A_NOTION=X and A_ENGLEV=H |
Set A_NOTION to H |
Go to 5 |
| 5 |
Is A_NOTION 1 or E |
Set A_NVQLEV to 1 |
Go to 6 |
| 6 |
Is A_NOTION 2 |
Set A_NVQLEV to 2 |
Go to 7 |
| 7 |
Is A_NOTION 3 |
Set A_NVQLEV to 3 |
Go to 8 |
| 8 |
Is A_NOTION 4, 5, or H |
Set A_NVQLEV to 4 |
Go to 9 |
| 9 |
Else |
Set A_NVQLEV to 9 |
|
3. The following SPSS code illustrates how to derive A_NVQLEV.
|
GET FILE=’……….Aims dataset’.
SORT CASES A09.
MATCH FILES /FILE=*
/TABLE=’……….Analytical LAD dataset’
/BY A09.
/*set the notional level of certain aims according to their aim type, these were
/* included where the notional level was incorrect in historical LADs.
IF (A_LATYPE EQ '0017' OR A_LATYPE EQ '0004' OR A_LATYPE EQ '0005' OR A_LATYPE EQ '0007' OR A_LATYPE EQ '0030') A_NOTION='3'.
IF (A_LATYPE EQ '0028'OR A_LATYPE EQ '0029') A_NOTION='2'.
IF (A_NOTION='X' AND A_ENGLEV='H') A_NOTION='H'.
/* RECODE a_notion as appropriate into A_NVQLEV.
RECODE A_NOTION ('1','E'=1)('2'=2)('3'=3)('4','5','H'=4)(ELSE=9) INTO A_NVQLEV.
RECODE A_NVQLEV (SYSMIS=-1).
VARIABLE LABELS A_NVQLEV 'A_NVQLEV Notional NVQ level of aim'.
VALUE LABELS A_NVQLEV
1 'Level 1 & Entry'
2 'Level 2'
3 'Level 3'
4 'Level 4 or 5 or Higher'
9 'Other'.
|
L_NVQLEV
4. The following table shows the steps required to derive L_NVQLEV
|
Step
|
Condition
|
Action/Action if true
|
Action if false
|
| 1 |
Create Variable L_NVQLEV. |
Set L_NVQLEV to -1 |
|
| 2 |
Does any aim have A_ACTIVE=1 and A_NVQLEV=9 |
Set L_NVQLEV to 9 |
Go to 2 |
| 3 |
Does any aim have A_ACTIVE=1 and A_NVQLEV=1 |
Set L_NVQLEV to 1 |
Go to 3 |
| 4 |
Does any aim have A_ACTIVE=1 and A_NVQLEV=2 |
Set L_NVQLEV to 2 |
Go to 4 |
| 5 |
Does any aim have A_ACTIVE=1 and A_NVQLEV=3 |
Set L_NVQLEV to 3 |
Go to 5 |
| 6 |
Does any aim have A_ACTIVE=1 and A_NVQLEV=4 |
Set L_NVQLEV to 4 |
|
|
Step
|
Condition
|
Action/Action if true
|
Action if false
|
| 1 |
Does L_NVQLEV contain a value |
None |
Set L_NVQLEV = -1 |
| 2 |
Does L_ACTIVE=0 |
Set L_NVQLEV=-1 |
None |
4. The following SPSS code illustrates how to derive L_NVQLEV.
|
/*Change the categorisation of the NVQ other to 0 instead of 9, as we want to take the maximum level and in this regard Other is counted as the lowest level.
RECODE A_NVQLEV (9=0).
/*Only look at aims that the Activity of the aim for Inclusion in Analysis is greater than 1.
SELECT IF A_ACTIVE = 1.
/*Take the maximum value at learner level.
AGGREGATE OUTFILE=’….L_NVQLEV.SAV’
/BREAK=L01 L03
/L_NVQLEV ‘L_NVQLEV Notional NVQ Level of Learner‘=MAX(A_NVQLEV).
GET FILE ‘…………Learner data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_NVQLEV.SAV’
/BY L01 L03.
/*Reset the Other NVQ level category to 9.
RECODE L_NVQLEV (0=9), (SYSMIS=-1).
|
Date last modified: 20th January 2009
