Achievement of NVQs 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 Achievement of NVQs data definition.

A_ACHIEVE

2 The following table shows the steps required to derive A_ACHIEVE

Step

Condition

Action if true

Action if false

1

Is A15=4, 5, 6 or 7

Go To 2

Set A_ACHIEVE to Missing Value

2

Does A10 not equal 41, or 42

Go To 3

Set A_ACHIEVE to Missing Value

3

Is A31 missing

Set A_ACHIEVE to 0

Go to 4

4

Does A34 not equal 1, 4, 5 or 6 and A50 not equal 1, 2, 6 or 7

Set A_ACHIEVE to –2 Go to 9

Go to 5

5

Does A50=2

Set A_ACHIEVE to -4 Go to 9

Go to 6

6

Does A50=7

Set A_ACHIEVE to -5 Go to 9

Go to 7

7

Does A34=6

Set A_ACHIEVE to -6 Go to 9

Go to 8

8

Does A34=4 or 5

Set A_ACHIEVE to -3 Go to 9

Go to 9

9

Does A40 have a value

Set A_ACHIEVE to 1

Go to 10

10

Does A35=1

Set A_ACHIEVE to 1

Value

Label

-6

Learner is taking a planned break from learning

-5

Transfer to a new provider caused by LSC intervention

-4

Transfer to a new provider

-3

Transfer to a new programme at the same provider

-2

No Achievement / Withdrawn

0

Continuing

1

NVQ Achieved

3 The following SPSS code illustrates how to derive A_ACHIEVE.

GET FILE=’……….Aims dataset’.

/*Give a value of –99 to null values in Completion status (A34) and Reason learning ended (A50), they need to have a value for SPSS as null values will be ignored on any if command.
RECODE A34 A50 (SYSMIS=-99).

/* Only calculated for aims that are NVQs and are not classed as WBL technical certificates or
/* keys skills.
DO IF ANY(A15,4,5,6,7) AND NOT(ANY(A10,41,42)).
 COMPUTE A_ACHIEVE=-99.
 DO IF SYSMIS(A31).
  COMPUTE A_ACHIEVE=0.

/** Only calculated for aims that have a leave date
 ELSE.
  DO IF (NOT (ANY(A34,1,4,5,6) OR ANY(A50,1,2,6,7))) AND NOT SYSMIS(A31).

/** Assign different categories to aims that have been transferred.
   COMPUTE A_ACHIEVE=-2.
  ELSE IF A50=2.
   COMPUTE A_ACHIEVE=-4.
  ELSE IF A50=7.
   COMPUTE A_ACHIEVE=-5.
  ELSE IF A34=6.
   COMPUTE A_ACHIEVE=-6.
  ELSE IF ANY(A34, 4, 5).
   COMPUTE A_ACHIEVE=-3.
  END IF.

/* If the learning outcome is set to achieved, or there is an achievement date, then assign the value 1.
  IF A35=1 OR NOT(SYSMIS(A40)) A_ACHIEVE=1.
 END IF.
END IF.
RECODE A34 A50 (-99=SYSMIS).

VALUE LABELS A_ACHIEVE
 -6 'Learner is taking a planned break from learning'
 -5 'Transfer to a new provider caused by  LSC intervention'
 -4 'Transfer to a new provider'
 -3 'Transfer to a new programme at the same provider'
 -2 'No Achievement / Withdrawn'
 0 'Continuing'
 1 'NVQ Achieved'.

Creator

Analysis and MI Team

Date issued

26 September 2006

Date created

8 December 2005

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-achievementofnvqssamplecode-report-26sep2006.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: 26 Sep 06