1 Termly attendance are temporary variables used in a number of other data definitions.
Purpose
2 The termly attendance variables are used in the following data definitions-
Relevant Collections
ILR (FE)
ILR (UfI)
ILR (ACL)
Source Data
3 The following variables are used as source data for the calculation of termly attendance variables,
Field Name | Label |
A17 | Delivery mode |
A27 | Learning start date |
A28 | Learning planned end date |
A31 | Learning actual end date |
A32 | Guided learning hours |
A34 | Completion status |
Derived Variables and Datasets
4 The definition produces the following derived variable(s) which are not permanently stored.
Field Name | Label |
TEMPACT | Actual end date (if the aim is completed and there is no end date the planned end date is used instead) |
PRD_ACT | Number of terms a learner was actually present on the aim in the relevant academic year |
TOTPDACT | Number of terms a learner was actually present over the whole of the aim |
TEMPEXP | Planned end date (if the aim is completed and there is no end date the actual end date is used instead) |
PRD_EXP | Number of terms a learner was expected to be present on the aim in the relevant academic year |
TOTPDEXP | Number of terms a learner was expected to be present over the whole of the aim |
Detailed definition
5 The Actual current year guided learning hours (CYGLH) is calculated by apportioning the actual guided learning hours (GLH) for the whole aim over all the tri-annual terms that the aim is actually active for in the current academic year, number of terms the aim is active for is calculated by looking at start and actual end dates against census dates.
6 For example if an aim is active for 6 terms between the start and end date, and 2 of those terms are in the current year, then the actual CYGLH will be 2/6ths of the total actual GLH of the aim.
7 Similarly, the Expected current year guided learning hours (CYGLH) is calculated by apportioning the expected GLH for the whole aim, over all the tri-annual terms that the aim is expected to be active for in the current academic year, the number of terms the aim is active is calculated by looking at start and planned end dates against census dates.
8 For example if an aim is expected to be active for 6 terms between the start and planned end date, and 2 of those terms are in the current year, then the expected CYGLH will be 2/6ths of the total expected GLH of the aim.
9 For actual CYGLH the start and actual end dates are compared with the three census dates 1st October (November), 1st February and 15th May. Note that if the aim is completed and there is no end date, then the planned end date is used as the actual end date. A temporary variable, TEMPACT, is created to contain these values.
10 For expected CYGLH the start and planned end dates are compared with the three census dates 1st October (November), 1st February and 15th May. Note that if the aim is completed and there is no end date, then the planned end date is used as the actual end date. A temporary variable, TEMPACT, is created to contain these values.
11 If the start date of the aim is before one of these dates and the end date, or planned end date is the same as, or after, the census date, i.e. the aim crosses the census date, then the aim is said to be active for that term.
12 Note that census date of 1st October is used in the ILR, but previously to that i.e. pre 2002/03 in ISR days, the funding policy had been that the funding census date was 1st November.
13 The actual lifetime of the aim, from the start date to the actual end date is used to calculate the number of terms a learner was actually present over the whole of the aim (TOTPDACT).
14 Then the start and actual end date are used to see how many terms a learner was actually present on the aim in the relevant academic year (PRD_ACT).
15 The expected lifetime of the aim, from the start date to the planned end date is used to calculate the number of terms a learner was expected to be present over the whole of the aim (TOTPDEXP).
16 Then the start and planned end date are used to see the number of terms a learner was expected to be present on the aim in the relevant academic year (PRD_EXP).
17 So if the aim was active for 5 terms before the start of this current academic year, and the planned end date is 4 terms after the end of the academic year then the total expected terms would be 12., including the 3 for the current academic year, i.e. 5 before the current year, 3 in the current year and 4 terms after the current year.
Sample Code
18 The following sample code is available
