Attendance Data Definition 2009/2010
TOTEXP, TOTACT
DATA DEFINITION
1. Attendance variables are temporary variables, used in a number of data definitions.
PURPOSE
2. The attendance variables are used in the following data definitions.
- Current Year Guided Learning Hours
- Mode of attendance
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of termly attendance variables.
| Field Name |
Label |
Dataset |
| A17 |
A17 Delivery Mode |
Aims Standard File |
| A27 |
A27 Learning Start Date |
Aims Standard File |
| A28 |
A28 Learning Planned End Date |
Aims Standard File |
| A31 |
A31 Learning Actual End Date |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s) which are not permanently stored.
| Field Name |
Label |
Dataset |
| TOTEXP |
The expected number of days for the aim |
Aims Standard File |
| TOTACT |
The Actual number of days for the aim |
Aims Standard File |
DETAILED DEFINITION
5. The Actual current year guided learning hours (CYGLH) is calculated for ‘Active’ aims, where the actual time spent on the aim in the current year (Actual Learning end date – Learning start date = in days) is divided by the total actual time (TOTACT) spent in the aim , multiplied by the total planned GLH (A32) for that aim.
6. Where sandwich courses are actually greater than the period of 365 days it is assumed that the learner has spent some time on work experience i.e. not with the Provider. In this case the days (TOTACT) are modified to be the expected number of days in the current year by (Total actual days (TOTACT) minus (Total actual days (TOTACT) divided by 3 and rounded down).
7. Similarly, The Expected current year guided learning hours (CYGLH) is calculated for ‘Active’ aims, where the expected time spent on the aim in the current year (A_INYR_EXPECTED_GLH) is divided by the total expected time (TOTEXP) spent in the aim , multiplied by the total planned GLH (A32) for that aim.
8. Where sandwich courses are expected to be greater than the period of 365 days it is assumed that the learner has spent some time on work experience i.e. not with the Provider. In this case the days (TOTEXP) are modified to be the expected number of days in the current year by (Total expected days (TOTEXP) minus (Total expected days (TOTEXP) divided by 3 and rounded down).
ATTENDANCE SAMPLE CODE
1. The following pseudo code and SPSS code is provided to illustrate the Attendance data definition.
TOTEXP, TOTACT
2. The following table shows the steps required to derive TOTEXP, TOTACT
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
N/A |
Create date variableTOTACT = (A31 – A27) + 1, in days. Then go to 2. |
N/A |
| 2 |
N/A |
Create date variableTOTEXP = (A28 – A27) + 1, in days. Then go to 3. |
|
| 3 |
Does A_ACTIVE = 1 |
Then go to 4. |
Stop |
| 4 |
Does A17 = 4 and is TOTEXP > 365 days |
TOTEXP = TOTEXP-ROUND(TOTEXP/3).
Go to 5. |
Go to 5. |
| 5 |
Does A17 = 4 and is TOTACT > 365 days |
TOTACT = TOTACT-ROUND(TOTACT/3). |
|
3. The following SPSS code illustrates how to derive TOTEXP, TOTACT.
|
MATCH FILES /FILE=’..aims file’
/TABLE=’………..learner file’
/BY L01 L03.
/* CYGLH ROUTINE***.
/* There are two CYGLHs, expected and actual,
/* The expected CYGLH is equal to the expected time spent on the aim in the current year divided by the total expected time to be spent on the aim, multiplied by the total GLH for that aim.
/* Follows a similar methodology to previous years, but doesn't use census dates
/* Uses the dates for the current academic year, i.e. 1 Aug to 31 July
/*This is the start of the CYGLH routine.
comp totexp=datedif(a28, a27, “days”)+1.
comp totact=datedif(a31, a27, “days”)+1.
do if A_Active=1.
/* Sandwich courses. Modify the total expected duration if the sandwich course is greater than the period 365 days,
/* assumes that they have spent some time on work experience, i.e. not with the provider.
do if A17=4 and totexp>365 days.
comp totexp=totexp-rnd(totexp/3).
comp totact=totact-rnd(totact/3).
end if.
end if. |
4. The following SQL code illustrates how to derive TOTEXP, TOTACT:
|
select
L01, L03, A05
, case when A_ACTIVE=1 and A17=4 and TOTEXP>365 then TOTEXP-ROUND(TOTEXP/3,0) else TOTEXP end as TOTEXP
, case when A_ACTIVE=1 and A17=4 and TOTEXP>365 then TOTACT-ROUND(TOTACT/3,0) else TOTACT end as TOTACT
from
(
select
L01, L03, A05
, datediff(dd,A27,A31)+1 as TOTACT
, datediff(dd,A27,A28)+1 as TOTEXP
, A_ACTIVE, A17
from
ILR0910_L01_AIMS
)T |
Date last modified: 02nd December 2009
