1 Actual and Expected Current Year Guided Learning Hours (CYGLH).
Purpose
2 To identify the Guided Learning Hours (GLH) that are carried out in the relevant academic year for each aim, and for the learner.
Relevant Collections
-
ILR (FE)
-
ILR (UfI)
-
ILR (ACL)
Source Data
3 The following variables from the ILR Aims dataset and also as derived according to the Termly Attendance data definition are used as source data for the calculation of Actual and Expected Current Year Guided Learning Hours.
|
Field Name |
Label |
|
A17 |
Delivery mode |
|
A32 |
Guided learning hours |
|
A34 |
Completion status |
|
A_LIVE_B |
DV - Status of Aim for Inclusion in Analysis Using 1 Oct as First Census Date |
|
TOTPDEXP |
the expected number of terms for the aim |
|
PRD_EXP |
the expected number of terms for the aim in the current academic year |
|
TEMPEXP |
Planned end date (if the aim is completed and there is no end date the actual end date is used instead) |
|
TOTPDACT |
the actual number of terms the learner was present for the aim |
|
PRD_ACT |
the actual number of terms the learner was present for the aim in the current academic year |
|
TEMPACT |
Actual end date (if the aim is completed and there is no end date the planned end date is used instead) |
Derived Variables and Datasets
4 The definition produces the following derived variable(s)
|
Field Name |
Label |
Dataset |
|
A_ACT_A |
DV - Actual current year GLH using 1 Nov as first census date |
Success Rate Tri-files |
|
A_EXP_A |
DV - Expected current year GLH using 1 Nov as first census date |
Success Rate Tri-files |
|
A_ACT_B |
DV - Actual current year GLH using 1 Oct as first census date |
Aims Standard File |
|
A_EXP_B |
DV - Expected current year GLH using 1 Oct as first census date |
Aims Standard File |
|
L_ACT_B |
DV - Actual current year GLH using 1 Oct 1 Feb 15 May |
Learner Standard Files & Aims Standard Files |
|
L_EXP_B |
DV - Expected current year GLH using 1 Feb 15 May |
Learner Standard Files & Aims Standard Files |
Detailed definition
5 The ILR collects the number of Guided Learning Hours (GLH), (A32), in which it is planned to deliver the learning aim. This figure relates to the GLH for the lifetime of the aim, irrespective of the relevant academic year.
6 The Current Year Guided Learning Hours (CYGLH) determines those GLH that are relevant to the current academic year from the total GLH, by calculating the ratio of time taken for the aim in the current academic year to the total time taken to complete the aim.
7 The actual current year guided learning hours for an aim (A_ACT_A and A_ACT_B) are generally calculated using the GLH (A32) for the aim multiplied by the ratio of the number of terms in the current year to the total number of terms for the aim, subject to the following cases-
a If the aim was withdrawn before the first census date then the actual CYGLH will be zero.
b If the aim is completed then the actual number of terms for the year (PRD_ACT) and the actual number of terms for the aim (TOTPDACT) are used.
c If the aim is completed and is a sandwich course of actual duration greater than 3 terms then the ratio is modified slightly to be the actual number of terms in the current year (PRD_ACT) divided by (the actual total number of terms for the aim (TOTPDACT) minus the actual number of terms or the aim divided by three and rounded down).
d If the aim hasn’t been completed then the expected number of terms for the year (PRD_EXP) and the expected number of terms for the aim (TOTPDEXP) are used.
e If the aim hasn’t been completed and is a sandwich course of actual duration greater than 3 terms then the ratio is modified slightly to be the expected number of terms in the current year (PRD_EXP) divided by (the expected total number of terms for the aim (TOTPDEXP) minus the expected number of terms or the aim divided by three and rounded down).
f If the collection is not ACL and the learner is marked as being absent for the year, then the actual CYGLH is set to zero.
8 The expected current year guided learning hours for an aim (A_EXP_A and A_EXP_B) are generally calculated using the GLH (A32) for the aim multiplied by the ratio of the number of terms in the current year to the total number of terms for the aim subject to the following cases-
a If the aim was withdrawn before the first census date then the expected CYGLH will be zero.
b If the aim is completed then the expected number of terms for the year (PRD_EXP) and the actual number of terms for the aim (TOTPDACT) are used.
c If the aim is completed and is a sandwich course of actual duration greater than 3 terms then the ratio is modified slightly to be the expected number of terms in the current year (PRD_EXP) divided by (the actual total number of terms for the aim (TOTPDACT) minus the actual number of terms or the aim divided by three and rounded down).
d If the aim hasn’t been completed then the expected number of terms for the year (PRD_EXP) and the expected number of terms for the aim (TOTPDEXP) are used.
e If the aim hasn’t been completed and is a sandwich course of actual duration greater than 3 terms then the ratio is modified slightly to be the expected number of terms in the current year (PRD_EXP) divided by (the expected total number of terms for the aim (TOTPDEXP) minus the expected number of terms or the aim divided by three and rounded down).
f If the collection is not ACL and the learner is marked as being absent for the year, then the expected CYGLH is set to zero.
9 The Learner level Actual CYGLH (L_ACT_B) is the summation of the aim Actual CYGLH (A_ACT_B) for all the Learners aims, except those aims where the status of aim for inclusion in analysis is set to not included (using A_LIVE_B)
10 The Learner level Expected CYGLH (L_EXP_B) is the summation of the aim Expected CYGLH (A_EXP_B) for all the Learners aims, except those aims where the status of aim for inclusion in analysis is set to not included (using A_LIVE_B)
11 Note that first funding census date of 1st October is used in the ILR, but previously to that i.e. pre 2002/03 in the ISR, the funding policy had been that the first funding census date was 1st November. To reflect these differences A_ACT_B is derived using the 1st October census date, whereas A_ACT_A uses the 1st November census date, likewise for A_EXP_B and A_EXP_A, they are both derived exactly the same apart from the different first census dates.
Sample Code
12 The following sample code is available
