Expected Daytime On-Site Guided Learning Hours Data Definition 2008/2009
L_OSEGLH, L_OS1200
DATA DEFINITION
1. Expected Daytime On-Site Guided Learning Hours.
PURPOSE
2. Determines the amount of expected on site Guided Learning Hours (GLH), i.e. the expected GLH delivered on site by the provider during normal hours. This measure is used to estimate the amount of space-usage by providers during peak teaching hours. This excludes factors such as time in workplace, by distance learning, by a franchised partner etc. as these are activities that do not take place on the provider's premises during day-time.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Expected Daytime On-Site Guided Learning Hours.
| Field Name | Label | Dataset |
|---|
| A17 | A17 Delivery Mode | Aims Standard File |
| A18 | A18 Main Delivery Method | Aims Standard File |
| A19 | A19 Employer Role | Aims Standard File |
| A21 | A21 Franchised Out and Partnership Arrangements | Aims Standard File |
A_INYR_
EXPECTED_GLH | A_INYR_EXPECTED_GLH Aim Expected Current Year GLH | Aims Standard File |
| 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 |
|---|
| L_OSEGLH | L_OSEGLH Expected daytime on-site GLH | Learner Standard File |
| L_OS1200 | L_OS1200 Learner has more than 1200 Expected Onsite GLH | Learner Standard File |
VALUES
5. The table below outlines the categories for L_OS1200
L_OS1200
Values | Label |
|---|
| -1 | Not Applicable/Not Known* |
| 0 | No |
| 1 | Yes |
*Applies to system missing values and where there are non-active aims.
DETAILED DEFINITION
6. The code is more easily read if you consider all of the students hours studied, and then remove those hours that are not carried out in the provider's premises during peak usage time i.e. during the daytime.
7. The definition looks at all aims apart from those where the Activity of the aim for inclusion in analysis is set as 'Not Included' (using A_ACTIVE) and the Delivery Mode (A17) of the aims is either day time or undefined continuous delivery, sandwich or block release (A17 = 1, 3, 4 or 5). This removes learning hours studied during the evening and hours from those students who are absent for the year.
8. The Employer Role (A19) needs to be that the learner is employed and either released by the employer to study a vocational learning aim relevant to that employment (A19=1), studying a vocational learning aim relevant to that employment (A19=2) or the category None of the above (A19=9). This removes learner hours where the learning is taking place on employer's premises.
9. Franchised Out and Partnership Arrangements (A21) need to be delivered by an FE sector provider under franchised out provision (A21=99) or have a missing value (A21=0 or missing). This removes franchised hours carried out at other premises.
10. If Main Delivery Method (A18) is class contact (A18=1) or NVQ delivered entirely at the institution (A18=14), then that aim's Expected Current Year Guided Learning Hours (A_INYR_EXPECTED_GLH) is included in the learner's L_OSEGLH. If the aim is NVQ delivered mainly at the workplace (A18=15), then half of the aim's Expected Current Year Guided Learning Hours (A_INYR_EXPECTED_GLH) is included in the learner's Expected Daytime On-Site Guided Learning Hours (L_OSEGLH). This removes hours carried out by the learner off-site. Also, adults (19 plus) learners are now returned under the Employer Responsive collection. Therefore these will not be included in the LR calculation.
11. The flag that indicates whether the learner has more than 1200 expected onsite Guided Learning Hours (L_OS1200) is derived by flagging those learners whose Expected Daytime On-Site Guided Learning Hours (L_OSEGLH) is greater than 1200. In this case (L_OS1200=1). This reduces those learners who have unfeasible amounts of contact hours to a more reasonable amount of contact hours.
Expected Daytime On-Site Guided Learning Hours Sample Code
1. The following SPSS code is provided to illustrate the Expected Daytime On-Site Guided Learning Hours data definition.
L_OSEGLH, L_OS1200
2. The following table shows the steps required to derive L_OSEGLH, L_OS1200
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | N/A | Create Numeric Variable ENROL=0.
Create Numeric Variable TEMPHRS=0.
Go to 2. | |
| 2 | Does A_ACTIVE=1, | Go to 3 | Set A_TEMPHRS to 0. |
| 3 | Does A17 =1 or 3 or 4 or 5 | Go to 4 | Set A_TEMPHRS to 0. |
| 4 | Does A19 = 1 or 2 or 9 | Go to 5 | Set A_TEMPHRS to 0. |
| 5 | Does A21=99 or 0 or is missing | Go to 6 | Set A_TEMPHRS to 0. |
| 6 | Does a18=1 or 14 | Set A_TEMPHRS to A_INYR_EXPECTED_GLH.
Set ENROL=1.
Go to 8 | Go to 7 |
| 7 | Does a18=15 | Set A_TEMPHRS to A_INYR_EXPECTED_GLH * 0.5.
Set ENROL=1.
Go to 8 | Set A_TEMPHRS to 0.
Go to 8 |
| 8 | (Aggregation) For all aims where Provider (L01) and Learner (L03) are the same. | L_OSEGLH is the sum of A_TEMPHRS for all of the aims rounded to the nearest integer.
ENROLS is the sum of ENROL for all of the aims.
Go to 9 | |
| 9 | Is L_OSEGLH > 1200 | Set L_OS1200 to 1.Go to 10 | Set L_OS1200 to 0. |
| 10 | Is L_OSEGLH >= 1200 | Set L_OSEGLH to 1200 | |
| 11 | Does L_OSEGLH have a value | | Set L_OSEGLH to -1 |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_OS1200 contain a value | None | Set L_OS1200 to -1 |
| 2 | Does L_ACTIVE = 0 | Set L_OS1200 to -1
Set L_OSEGLH to -1 | None |
3. The following SPSS code illustrates how to derive L_OSEGLH, L_OS1200.
GET FILE ‘……..AIMS data set.SAV’.
COMPUTE A_TEMPHRS=0.
COMPUTE ENROL=0. /* Only include aims that are active, provision is on site and are not franchised.
DO IF (A_ACTIVE=1) and (ANY(A17,1,3,4,5) AND ANY(A19,1,2,9) AND ANY(A18,1,14,15)) AND
(MISSING(A21) or any(A21,99,0,-1)). /* changes NVQ hours done partially on site by factor of 0.5.
COMPUTE A_TEMPHRS=A_INYR_EXPECTED_GLH.
IF(A18 = 15) A_TEMPHRS = (A_TEMPHRS * 0.5).
END IF. /* Aggregate the file to learner level.
SORT CASES BY L01, L03.
AGGREGATE
/OUTFILE=*
/PRESORTED
/BREAK=L01 L03
/UPIN=first(L01)
/L_OSEGLH=SUM(A_TEMPHRS). /* 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 i.e. values
/* 1,200 glh or more cap to 1,200 hours.
RECODE L_OSEGLH (1200 THRU HI=1200) (ELSE=COPY). SAVE OUTFILE ‘……..L_OSEGLH.SAV’. GET FILE ‘…………Learner data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_OSEGLH.SAV’
/BY L01 L03. RECODE L_OSEGLH L_OS1200 (SYSMIS=-1). VARIABLE LABELS L_OSEGLH ‘L_OSEGLH Expected daytime on-site GLH’
L_OS1200 ‘L_OS1200 more than 1200 Expected Onsite GLH’ . VALUE LABELS L_OS1200
-1 ‘Not Applicable/Not Known’
0 ‘less than or equal to 1200 expected onsite glh’
1 ‘more than 1200 expected onsite glh’. |
Date last modified: 10th February 2009
