Learner Level In Learning Data Definition 2008/2009

L_IL_P1 to L_IL_P12

DATA DEFINITION

1. Learner In-Learning Programme Type.

PURPOSE

2. Identifies whether a learner is in learning or not in a particular period.

RELEVANT COLLECTIONS

  • ILR (ER)
  • ILR (ESF SR)
  • ILR (LR)

SOURCE DATA

3. The following variables are used as source data for the calculation of the Learner Level In Learning Programme Type.

Field NameLabelDataset
A_IL_P1 to A_IL_P12A_IL_P(xx) In-Learning in Period 1 to 12Aims Standard File
A_ACTIVEA_ACTIVE Aim Active for the Current Academic YearAims Standard File

DERIVED VARIABLES AND DATASETS

4. The definition produces the following derived variable(s)

Field NameLabelDataset
L_IL_P1L_IL_P1 Learner In-Learning Period 1Learner Standard Files
toto 
L_IL_P12L_IL_P1 2 Learner In-Learning Period 12Learner Standard Files

VALUES

5. The table below outlines the categories for L_IL_Px

L_IL_PxLearner In-Learning 
Period
-1Not Applicable/Not Known*
0No
1Yes

*Applies to system missing values and where there are non-active aims.

DETAILED DEFINITION

6. The learner in learning is calculated by looking at all the aims of a learner, and if any aim was in learning in that period, then the learner was in learning in that period


Learner Level In Learning Sample Code

1. The following SPSS code is provided to illustrate the Learner Level In Learning data definition.

L_IL_P1 to L_IL_P12

2. The following table shows the steps required to derive L_IL_P1 to L_IL_P12

StepConditionAction/Action if trueAction if false
1Does L_ACTIVE = 1Go to 2.Set L_IL_P1 to L_IL_P12=-1
2Does the learner have any aims where A_IL_P1=1Set L_IL_P1=1Set L_IL_P1=0
3Does the learner have any aims where A_IL_P2=1Set L_IL_P2=1Set L_IL_P2=0
4Does the learner have any aims where A_IL_P3=1Set L_IL_P3=1Set L_IL_P3=0
5Does the learner have any aims where A_IL_P4=1Set L_IL_P4=1Set L_IL_P4=0
6Does the learner have any aims where A_IL_P5=1Set L_IL_P5=1Set L_IL_P5=0
7Does the learner have any aims where A_IL_P6=1Set L_IL_P6=1Set L_IL_P6=0
8Does the learner have any aims where A_IL_P7=1Set L_IL_P7=1Set L_IL_P7=0
9Does the learner have any aims where A_IL_P8=1Set L_IL_P8=1Set L_IL_P8=0
10Does the learner have any aims where A_IL_P9=1Set L_IL_P9=1Set L_IL_P9=0
11Does the learner have any aims where A_IL_P10=1Set L_IL_P10=1Set L_IL_P10=0
12Does the learner have any aims where A_IL_P11=1Set L_IL_P11=1Set L_IL_P11=0
12Does the learner have any aims where A_IL_P12=1Set L_IL_P12=1Set L_IL_P12=0

3. The following SPSS code illustrates how to derive L_IL_P1 to L_IL_P12.

GET FILE ‘….aims file’.

*/Active aims only.
SELECT IF A_ACTIVE=1.

*/Total number of aims a learner is in learning in each period.
AGGREGATE OUTFILE=……L_IL_PX.Sav
  /BREAK=L01 L03
  /L_IL_P1=MAX(A_IL_P1)
  /L_IL_P2=MAX(A_IL_P2)
  /L_IL_P3=MAX(A_IL_P3)
  /L_IL_P4=MAX(A_IL_P4)
  /L_IL_P5=MAX(A_IL_P5)
  /L_IL_P6=MAX(A_IL_P6)
  /L_IL_P7=MAX(A_IL_P7)
  /L_IL_P8=MAX(A_IL_P8)
  /L_IL_P9=MAX(A_IL_P9)
  /L_IL_P10=MAX(A_IL_P10)
  /L_IL_P11=MAX(A_IL_P11)
  /L_IL_P12=MAX(A_IL_P12).

GET FILE ‘…………LEARNER data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’……L_IL_PX.SAV’
/BY L01 L03.

RECODE L_IL_P1 L_IL_P2 L_IL_P3 L_IL_P4 L_IL_P5 L_IL_P6 L_IL_P7 L_IL_P8 L_IL_P9 L_IL_P10 L_IL_P11 L_IL_P12 (SYSMIS=-1).



Date last modified: 15th January 2009