Notional NVQ 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 pseudo code and SPSS code is provided to illustrate the Notional NVQ Level data definition.

A_NVQLEV

2 The following table shows the steps required to derive A_NVQLEV

Step

Condition

Action if true

Action if false

1

Is A_LATYPE=0004 or 0005 or 0007 or 0017 or 0030

Set A_NOTION to 3

Go to 2

2

Is A_LATYPE=0028 or 0029

Set A_NOTION to 2

Go to 3

3

Does A_NOTION=X and A_ENGLEV=H

Set A_NOTION to H

Go to 4

4

Is A_NOTION 1 or E

Set A_NVQLEV to 1

Go to 5

5

Is A_NOTION 2

Set A_NVQLEV to 2

Go to 6

6

Is A_NOTION 3

Set A_NVQLEV to 3

Go to 7

7

Is A_NOTION 4, 5, or H

Set A_NVQLEV to 4

Go to 8

8

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 notioinal 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.

VARIABLE LABELS A_NVQLEV 'DV - Notional NVQ level of the 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 if true

Action if false

1

Does any aim have A_LIVE_B>1 and A_NVQLEV=4

Set L_NVQLEV to 4

Go to 2

2

Does any aim have A_LIVE_B>1 and A_NVQLEV=3

Set L_NVQLEV to 3

Go to 3

3

Does any aim have A_LIVE_B>1 and A_NVQLEV=2

Set L_NVQLEV to 2

Go to 4

4

Does any aim have A_LIVE_B>1 and A_NVQLEV=1

Set L_NVQLEV to 1

Go to 5

5

Does any aim have A_LIVE_B>1 and A_NVQLEV=9

Set L_NVQLEV to 9

5 The following SPSS code illustrates how to derive L_NVQLEV

/*Change the categorisation of the NVQ other to -1 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=-1).

/*Only look at aims that the Status of Aim for Inclusion in Analysis is greater than 1.
SELECT IF A_LIVE_B > 1.

/*Take the maximum value at learner level.
AGGREGATE OUTFILE *
 /BREAK=L01 L03
 /L_NVQLEV=MAX(A_NVQLEV).

/*Reset the Other NVQ level category to 9.
RECODE L_NVQLEV (-1=9).

VALUE LABELS L_NVQLEV
 1 'Level 1 & Entry'
 2 'Level 2'
 3 'Level 3'
 4 'Level 4 or 5 or Higher'
 9 'Other'.

Creator

Analysis and MI Team

Date issued

11 January 2006

Date created

7 December 2005

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-notionalnvqlevelsamplecode-report-11jan2006.doc

LSC office

Learning and Skills Council
Cheylesmore House Quinton Road Coventry CV1 2WT
T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk/

Last Modified: 12 Jan 06