In Learning in Year Data Definition 2009/2010

A_IL_IY, P_IL_IY, L_IL_IY

DATA DEFINITION

1. In-Learning in year at learner, aim or programme level.

PURPOSE

2. To identify whether the aim, programme or learner is in learning in 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 the In Learning in Year data definition.

Field Name Label Dataset
A_IL_P1 to P12 A_IL_P1 In Learning in Period X Aims Standard File
A_IL_IY A_IL_IY Aim in Learning in Year Aims Standard File

DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)

Field Name Label Dataset
A_IL_IY A_IL_IY Aim in Learning in Year Aims Standard File
P_IL_IY P_IL_IY Programme in Learning in Year Aims Standard File
L_IL_IY L_IL_IY Learner in Learning in Year Aims and Learner Standard File

VALUES

5. The table below outlines the categories for A_IL_IY, P_IL_IY, L_IL_IY

Value Label
-1 Not Applicable/Not Known*
0 No
1 Yes

*Applies to system missing values and where there are non-active aims. Only applicable at learner level.

DETAILED DEFINITION

Aim Level

6. The Aim level In learning is the sum of all the periods that the aim is in learning for.

Programme Level

7. Programme level (P_IL_IY) is the highest value of has the aim been in learning (A_IL_IY) for all of the learner’s aims within a programme.

Learner Level
8. Learner level (L_IL_IY) is the highest value of has the aim been in learning (A_IL_IY) for all of the learner’s aims.

IN LEARNING IN YEAR SAMPLE CODE

1. The following SPSS code is provided to illustrate the In Learning in Year data definition.

A_IL_IY, P_IL_IY, L_IL_IY

2. The following tables show the steps required to derive A_IL_IY, P_IL_IY, L_IL_IY

Step Condition Action/Action if true Action if false
1 Does A_IL_P1 to A_IL_P12 have any missing values. Set A_ILP1 to A_IL_P12 to 0.
Go to 2		 Go to 2
2 Is the Sum of A_IL_P1 to A_IL_P12 greater than 0. SET A_IL_IY=1 Set A_IL_IY=0
Go to 3

Step Condition Action/Action if true Action if false
1 Is A15 MISSING or A15=-1 or A15=99 Set P_IL_IY 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_IL_IY to the maximum value of A_IL_IY.  

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_IL_IY to the maximum value of A_IL_IY  

Step Condition Action/Action if true Action if false
1 Does L_IL_IY contain a value None Set L_IL_IY = -1

3. The following SPSS code illustrates how to derive A_IL_IY, P_IL_IY, L_IL_IY.

GET FILE = …………Aims Data set.

RECODE A_IL_P1 to A_IL_P12 (SYSMIS=0).

*Calculate A_IL_IY variable.
COMP A_IL_IY=(SUM(A_IL_P1 to A_IL_P12)>0).

*Aggregate to programme level taking the maximum in learning value.
SORT CASES L01 L03 A15 A26.
AGGREGATE
   /OUTFILE = *
   MODE=ADDVARIABLES
  /PRESORTED
  /BREAK = L01 L03 A15 A26
   /P_IL_IY= max(A_IL_IY).

Do if MISSING(A15) or A15=-1 or A15=99.
+comp P_IL_IY=-1.
end if.

VALUE LABELS P_IL_IY
 -1 'Not Applicable/Not Known'
  0 'No’
  1 'Yes’

/A_IL_IY
  0 'No’
  1 'Yes’.

*Aggregate to Learner level taking the maximum in learning value.
SORT CASES L01 L03.
AGGREGATE
    /OUTFILE = *
   /PRESORTED
   /BREAK = L01 L03
   /L_IL_IY= max(A_IL_IY).

RECODE L_IL_IY (SYSMIS=-1)

VALUE LABELS L_IL_IY
  0 'No’
  1 'Yes’.



4. The following SQL code illustrates how to derive A_IL_IY:

select

      L01, L03, A05
      , case when (A_IL_P1 = NULL or A_IL_P2 = NULL or A_IL_P3 = NULL or A_IL_P4 = NULL or A_IL_P5 = NULL or A_IL_P6 = NULL or A_IL_P7 = NULL or A_IL_P8 = NULL or A_IL_P9 = NULL or A_IL_P10 = NULL or A_IL_P11 = NULL or A_IL_P12 = NULL) then 0
      when A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 + A_IL_P7 + A_IL_P8 + A_IL_P9 + A_IL_P10 + A_IL_P11 + A_IL_P12 >0 then 1
      else 0 end as A_IL_IY

from

     ILR0910_E_AIMS



5. The following SQL code illustrates how to derive P_IL_IY:

select

      L01, L03, A15, A26
      , case when A15 is NULL or A15 in (-1,99) then -1 else max(A_IL_IY) end as P_IL_IY

from

     ILR0910_E_AIMS

group by

      L01, L03, A15, A26

order by

      L01, L03, A15, A26



6. The following SQL code illustrates how to derive L_IL_IY:

select

      L01, L03, count(A05) as aims
      , case when max(A_IL_IY) is not NULL then max(A_IL_IY) else -1 end as L_IL_IY

from

     ILR0910_E_AIMS

group by

      L01, L03

order by

      L01, L03



Date last modified: 02nd December 2009