Learner Level In Learning Data Definition 2009/2010
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 Name |
Label |
Dataset |
| A_IL_P1 to A_IL_P12 |
A_IL_P(xx) In-Learning in Period 1 to 12 |
Aims Standard File |
| A_ACTIVE |
A_ACTIVE Aim Active for the Current Academic Year |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| L_IL_P1 |
L_IL_P1 Learner In-Learning Period 1 |
Learner Standard Files |
| to |
to |
|
| L_IL_P12 |
L_IL_P1 2 Learner In-Learning Period 12 |
Learner Standard Files |
VALUES
5. The table below outlines the categories for L_IL_Px
| L_IL_Px |
Learner In-Learning
Period |
| -1 |
Not Applicable/Not Known* |
| 0 |
No |
| 1 |
Yes |
*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
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_ACTIVE = 1 |
Go to 2. |
Set L_IL_P1 to L_IL_P12=-1 |
| 2 |
Does the learner have any aims where A_IL_P1=1 |
Set L_IL_P1=1 |
Set L_IL_P1=0 |
| 3 |
Does the learner have any aims where A_IL_P2=1 |
Set L_IL_P2=1 |
Set L_IL_P2=0 |
| 4 |
Does the learner have any aims where A_IL_P3=1 |
Set L_IL_P3=1 |
Set L_IL_P3=0 |
| 5 |
Does the learner have any aims where A_IL_P4=1 |
Set L_IL_P4=1 |
Set L_IL_P4=0 |
| 6 |
Does the learner have any aims where A_IL_P5=1 |
Set L_IL_P5=1 |
Set L_IL_P5=0 |
| 7 |
Does the learner have any aims where A_IL_P6=1 |
Set L_IL_P6=1 |
Set L_IL_P6=0 |
| 8 |
Does the learner have any aims where A_IL_P7=1 |
Set L_IL_P7=1 |
Set L_IL_P7=0 |
| 9 |
Does the learner have any aims where A_IL_P8=1 |
Set L_IL_P8=1 |
Set L_IL_P8=0 |
| 10 |
Does the learner have any aims where A_IL_P9=1 |
Set L_IL_P9=1 |
Set L_IL_P9=0 |
| 11 |
Does the learner have any aims where A_IL_P10=1 |
Set L_IL_P10=1 |
Set L_IL_P10=0 |
| 12 |
Does the learner have any aims where A_IL_P11=1 |
Set L_IL_P11=1 |
Set L_IL_P11=0 |
| 12 |
Does the learner have any aims where A_IL_P12=1 |
Set L_IL_P12=1 |
Set 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). |
4. The following SQL code illustrates how to derive L_IL_P1-12:
|
select
B.L01, B.L03
, case when L_IL_P1_qry is NULL then -1 else L_IL_P1_qry end as L_IL_P1
, case when L_IL_P2_qry is NULL then -1 else L_IL_P2_qry end as L_IL_P2
, case when L_IL_P3_qry is NULL then -1 else L_IL_P3_qry end as L_IL_P3
, case when L_IL_P4_qry is NULL then -1 else L_IL_P4_qry end as L_IL_P4
, case when L_IL_P5_qry is NULL then -1 else L_IL_P5_qry end as L_IL_P5
, case when L_IL_P6_qry is NULL then -1 else L_IL_P6_qry end as L_IL_P6
, case when L_IL_P7_qry is NULL then -1 else L_IL_P7_qry end as L_IL_P7
, case when L_IL_P8_qry is NULL then -1 else L_IL_P8_qry end as L_IL_P8
, case when L_IL_P9_qry is NULL then -1 else L_IL_P9_qry end as L_IL_P9
, case when L_IL_P10_qry is NULL then -1 else L_IL_P10_qry end as L_IL_P10
, case when L_IL_P11_qry is NULL then -1 else L_IL_P11_qry end as L_IL_P11
, case when L_IL_P12_qry is NULL then -1 else L_IL_P12_qry end as L_IL_P12
from
(
select
L01, L03, count(A05) as aims
, max(A_IL_P1) as L_IL_P1_qry
, max(A_IL_P2) as L_IL_P2_qry
, max(A_IL_P3) as L_IL_P3_qry
, max(A_IL_P4) as L_IL_P4_qry
, max(A_IL_P5) as L_IL_P5_qry
, max(A_IL_P6) as L_IL_P6_qry
, max(A_IL_P7) as L_IL_P7_qry
, max(A_IL_P8) as L_IL_P8_qry
, max(A_IL_P9) as L_IL_P9_qry
, max(A_IL_P10) as L_IL_P10_qry
, max(A_IL_P11) as L_IL_P11_qry
, max(A_IL_P12) as L_IL_P12_qry
from
MISVS001.LSC_MI_db_pub.dbo.ILR0910_L01_AIMS
where A_ACTIVE=1
group by
L01, L03, A_ACTIVE
)T
right outer join
ILR0910_L01_LEARNER B
on T.L01=B.L01 and T.L03=B.L03
order by
B.L01, B.L03 |
Date last modified: 02nd December 2009
