Expected daytime on-site Guided Learning Hours 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 Expected daytime on-site GLH data definition.
L_OSEGLH and L_OS1200
2 The following table shows the steps required to derive L_OSEGLH and L_OS1200.
Step | Condition | Action if true | Action if false |
1 | Is A_LIVE_B>1, | Go to 2 | Set A_TEMPHRS to 0 |
2 | Does A17 =1 or 3 or 4 or 5 | Go to 3 | Set A_TEMPHRS to 0 |
3 | Does A19 = 1 or 2 or 9 | Go to 4 | Set A_TEMPHRS to 0 |
4 | Does A21=1 or 0 or is missing | Go to 5 | Set A_TEMPHRS to 0 |
5 | Does a18=1 or 11 | Set A_TEMPHRS to A_EXP_B | Go to 6 |
6 | Does a18= 12 | Set A_TEMPHRS to A_EXP_B * 0.5 | Set A_TEMPHRS to 0 |
7 | Set L_OSEGLH = Sum of all A_TEMPHRS for a learner rounded to the nearest integer. |
8 | Is L_OSEGLH > 1200 | Set L_OS1200 to 1 | Set L_OS1200 to 0 |
9 | Is L_OSEGLH > 1200 | Set L_OSEGLH to 1200 | |
3 The following SPSS code illustrates how to derive L_OSEGLH and L_OS1200.
GET FILE ‘……..AIMS data set.SAV’
/* Select aims that are Included on Actual, or Always Included for analysis purposes
SELECT IF (A_LIVE_B > 1).
/* Select on site provision .
SELECT IF (ANY(A17,1,3,4,5) AND ANY(A19,1,2,9) AND ANY(A18,1,11,12)).
/* changes NVQ hours done partially on site by factor of 0.5.
RENAME VARIABLES(A_EXP_B = TEMPHRS).
IF(A18 = 12) TEMPHRS = TEMPHRS * 0.5.
/* Recodes franchised field and just selects those that are not franchised.
RECODE A21 (99=1) (00=1) (MISSING=1) (ELSE=0) INTO OCP_FLAG .
SELECT IF (OCP_FLAG = 1).
/* Aggregate the file to learner level.
SORT CASES BY L01, L03.
AGGREGATE
/OUTFILE=*
/PRESORTED
/BREAK=L01 L03
/UPIN=first(L01)
/L_OSEGLH=SUM(TEMPHRS)
/ENROLS = N.
/* Round up each student's total expected daytime onsite
/* GLH to remove decimal place.
COMPUTE L_OSEGLH = RND(L_OSEGLH) .
RECODE L_OSEGLH (LOWEST THRU 1200=0) (1201 THRU HI=1) (ELSE=0) INTO L_OS1200 .
/* Recode rounded expected total GLH to avoid skewing data ie values
/* 1,200 glh or more cap to 1,200 hours.
RECODE L_OSEGLH (1200 THRU HI=1200) (ELSE=COPY).
VARIABLE LABELS L_OSEGLH ‘DV – expected daytime on-site glh’
L_OS1200 ‘DV – 1/0 flag to indicate whether the learner has more than 1200 expected onsite glh’ .
VALUE LABELS L_OS1200 0 ‘Learner has less than 1200 expected onsite glh’
1 ‘Learner has more than 1200 expected onsite glh’. |
Last Modified: 12 Jan 06
