Active Data Definition 2009/2010
A_ACTIVE, P_ACTIVE, L_ACTIVE
DATA DEFINITION
1. Activity of the aim, programme and learner for inclusion in analysis.
PURPOSE
2. This is a definition for analysis purposes and determines whether or not a learner is actually there participating in the aim or was not there at all in the relevant academic year.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (UFI)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Active aims and learners.
| Field Name |
Label |
Dataset |
| A27 |
A27 Learning start date |
Aims Standard File |
| A34 |
A34 Completion Status |
Aims Standard File |
| A31 |
A31 Learning actual end date |
Aims Standard File |
| A17 |
A17 Delivery mode |
Aims Standard File |
| A15 |
A15 Programme Type |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definitions produce the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
| P_ACTIVE |
P_ACTIVE Programme Active |
Aims Standard File |
| L_ACTIVE |
L_ACTIVE Learner Active for the current academic year |
Learner Standard File, Aims Standard File |
VALUES
5. The table below outlines the values for L_ACTIVE, P_ACTIVE and A_ACTIVE
L_ACTIVE, P_ACTIVE
and A_ACTIVE value |
Label |
| -1 |
Not Applicable/Not Known* |
| 0 |
Not Included |
| 1 |
Included |
*Applies to system missing values and where there are non-active aims. Only applicable at programme level.
DETAILED DEFINITION
6. The Status of the Aim is identified by looking at the academic year.
Aim Level
7. If the learning start date (A27) sits within the current academic year (1 Aug to 31 Jul), status is set to 1 – Included.
8. Or if the learning start date (A27) is before the start of the current academic year and the aim is continuing or has a learning actual end date on/after the start of the academic year (1 Aug), status is set to 1 – Included.
9. If a learner is absent for the year (A17 = 6) or does not meet any of the above criteria then their active status in the current academic year (A_ACTIVE) is set to 0 – Not Included.
Programme Level
10. Programme level (P_ACTIVE) is the highest value of Is the aim active in the current academic year (A_ACTIVE) for all of the learner’s aims.
Learner Level
11. Learner level (L_ACTIVE) is the highest value of Is the aim active in the current academic year (A_ACTIVE) for all of the learner’s aims.
Activity of the aim and learner Sample Code
1. The following pseudo code and SPSS code is provided to illustrate the Active data definition.
P_ACTIVE A_ACTIVE L_ACTIVE
2. The following tables show the steps required to derive P_ACTIVE, A_ACTIVE and L_ACTIVE
A_ACTIVE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is range(a27,(1,8,current academic year),(31,7,current academic year+1)) or (a27<(1,8,current academic year) and (A34=1 or a31>=(1,8,current academic year)))). |
Set A_ACTIVE 1.
Go to 2 |
Set A_ACTIVE 0. |
| 2 |
Does A17=6 |
Set A_ACTIVE 0. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_ACTIVE contain a value |
None |
Set A_ACTIVE = -1. |
P_ACTIVE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A15 MISSING or A15=-1 or A15=99 |
Set P_ACTIVE to -1 |
Go to 2 |
| 2 |
(Aggregate)
For all aims where the learner (L03), Provider (L01), Programme Type (A15) and Framework Code (A26) are the same. |
Set P_ACTIVE to the maximum value of A_ACTIVE. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does P_ACTIVE contain a value |
None |
Set P_ACTIVE = -1. |
L_ACTIVE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
(Aggregate)For all aims where the learner (L03) and Provider (L01) are the same. |
Set L_ACTIVE to the maximum value of A_ACTIVE |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_ACTIVE contain a value |
None |
Set L_ACTIVE = 0. |
3. The following SPSS code illustrates how to derive A_ACTIVE, P_ACTIVE and L_ACTIVE.
|
COMPUTE A_ACTIVE=(range(a27, date.dmy(1,8,current academic year),date.dmy(31,7,current academic year+1)) or (a27<date.dmy(1,8,current academic year) and (A34=1 or a31>=date.dmy(1,8,current academic year)))).
IF A17=6 A_ACTIVE=0.
VARIABLE LABELS A_ACTIVE ‘A_ACTIVE Aim Active for the current academic year‘.
VALUE LABELS A_ACTIVE
0 'Not Active’
1 'Active'.
SORT CASES L01 L03 A15 A26.
*/Aggregate to Programme level.
*/P_ACTIVE.
aggregate
/outfile = *
mode=addvar
/presorted
/break = L01 L03 A15 A26
/P_ACTIVE = max(A_ACTIVE).
VARIABLE LABELS P_ACTIVE ‘P_ACTIVE Programme Active‘.
Do if missing(A15) or A15=-1 or A15=99.
+comp P_ACTIVE=-1.
end if.
*/Aggregate to learner and Provider level.
*/L_ACTIVE.
aggregate
/outfile = *
/presorted
/break = L01 L03
/L_ACTIVE = max(A_ACTIVE).
VARIABLE LABELS L_ACTIVE ‘L_ACTIVE Learner Active for the current academic year‘. |
4. The following SQL code illustrates how to derive A_ACTIVE, P_ACTIVE and L_ACTIVE.
|
--A_ACTIVE
select
L01, L03, A05
, case when (A27>='1 august 2009' and A27<='31 july 2010') or (A27<'1 august 2009' and (A34=1 or A31>='1 august 2009')) then 1
when A17=6 then 0
else 0 end as A_ACTIVE
from
ILR0910_E_AIMS
--P_ACTIVE
select
L01, L03, A15, A26
, case when A15 is NULL or A15 in (-1,99) then -1
else max(A_ACTIVE) end as P_ACTIVE
from
ILR0910_E_AIMS
group by
L01, L03, A15, A26
order by
L01, L03, A15, A26
--L_ACTIVE
select
L01, L03, count(A05) as aims
, max(A_ACTIVE) as L_ACTIVE
from
ILR0910_E_AIMS
group by
L01, L03
order by
L01, L03 |
Date last modified: 01st December 2009
