|
GET FILE ‘…..FRAMEWORK AND AIMS data set’.
/* Create a variable NVQACH that has a value of 1 if the NVQ aim has been achieved.
COMPUTE NVQACH=0.
IF (A10=40 AND (A40>0 OR A35=1)) NVQACH=1.
SORT CASES L01 L03 A15 A26.
/*Select all the component aims of the framework, and not the framework record, and for each framework create a variable A_NVQACH which takes the max value in NVQACH.
TEMPORARY.
SELECT IF ANY(A15,2,3,10) AND A10 <> 50.
AGGREGATE OUTFILE=’………………NVQACH.SAV’*
/PRESORTED
/BREAK= L01 L03 A15 A26
/A_NVQACH = MAX(NVQACH).
/* Match the value in A_NVQACH back on to the file.
MATCH FILE /FILE=*
/TABLE=’…………………NVQACH.SAV’*
/BY L01 L03 A15 A26.
/* Create a variable A_STATUS.
COMPUTE A_STATUS=0.
/* Calculates the status of the framework, A_STATUS, following some logical rules. These calculations are
/* only carried out on framework records and in a specific order, so that all conditions are covered.
DO IF A10=50.
/*If the framework doesn't have a leave date, then set status to continuing.
IF SYSMIS(A31) A_STATUS=0.
/* If the framework doesn't have a leave date, but they have achieved an NVQ, then set status to
/* NVQ achieved, continuing.
IF SYSMIS(A31) AND SYSMIS(A43) AND A_NVQACH > 0 A_STATUS=5.
/* If the framework has a leave date, no framework achievement date, but has achieved the
/* NVQ, then set status to NVQ Achieved.
IF A31>0 AND SYSMIS(A43) AND A_NVQACH > 0 A_STATUS=4.
/* If the framework has a leave date, no framework achievement date, and not achieved the
/* NVQ, then set status to No Achievement.
IF A31>0 AND SYSMIS(A43) AND A_NVQACH=0 A_STATUS=6.
/* If the learner destination is set to continuing/ awaiting, and there is no framework leave date,
/* then set status to continuing/ awaiting accordingly.
IF(L39=93) AND SYSMIS(A31) A_STATUS=2.
IF(L39=94) AND SYSMIS(A31) A_STATUS=3.
/* Set framework to transfer.
IF (A_STATUS = 6 AND TRAN_DATE = A31) A_STATUS = 7.
/* If the framework has an achievement date, then set status to Framework Achieved.
IF(NOT(SYSMIS(A43))) A_STATUS=1.
/* Next look at the status of NVQs.
ELSE IF ANY(A15,4,5,6,7) and NOT ANY(A10,41,42).
IF A_ACHIEVE=-6 A_STATUS=11
IF A_ACHIEVE=-6 AND A_NVQACH>0 A_STATUS=12
IF A_ACHIEVE=-5 A_STATUS=10
IF A_ACHIEVE=-4 A_STATUS=9
IF A_ACHIEVE=-3 A_STATUS=8
IF A_ACHIEVE=-2 A_STATUS=6
IF A_ACHIEVE=0 A_STATUS=0
IF A_ACHIEVE=1 A_STATUS=4
END IF.
VARIABLE LABELS A_STATUS 'Status of Framework'.
VALUE LABELS A_STATUS 0 ‘Continuing’
1 ‘Framework achieved’
2 ‘Continuing framework awaiting aim start’
3 ‘Framework complete awaiting onfirmation of achievements’
4 ‘NVQ achieved’
5 ‘NVQ achieved, continuing framework’
6 ‘No achievement’
7 ‘Transfer’
8 ‘Transfer to a new programme at the same provider’
9 ‘Transfer to a new provider’
10 ‘Transfer to a new provider forced by LSC intervention’
11 ‘Learner is taking a planned break from learning’
12 ‘NVQ achieved but learner is now taking a planned break from learning on the ramework’.
|
