In Learning Data Definition 2008/2009
A_IL_P1 to A_IL_P12, A_ILPY2D, A_ILAVY2, E_IL_P1-P12, E_ILPY2D and E_ILAVY2
DATA DEFINITION
1. In Learning in Period x.
PURPOSE
2. The In-Learning fields are used to indicate whether the learning aim is in learning for any given period for WBL data.
RELEVANT COLLECTIONS
- ILR (ER)
- ILR (ESF SR)
- ILR (LR)
SOURCE DATA
3. The following variables are used as source data for the calculation of In Learning.
| Field Name | Label | Dataset |
|---|
| A27 | A27 Learning start date | Aims Standard File |
| A31 | A31 Learning actual end date | Aims Standard File |
| E08 | E08 Date started ESF co-financing | ESF Standard File |
| E10 | E10 Date ended ESF co-financing | ESF Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| A_IL_P1 | A_IL_P1 In-Learning in Period 1 | ER Aims Standard File |
| to | To | |
| A_IL_P12 | A_IL_P12 In-Learning in Period 12 | ER Aims Standard File |
| A_ILPY2D | A_ILPY2D Number of Periods In-Learning In Current Year, Year To Date | ER Aims Standard File |
| A_ILAVY2 | A_ILAVY2 Average Number of Periods In Learning in Current Year to Date | ER Aims Standard File |
| E_IL_P1 | E_IL_P1 In Learning in Period 1 | ESF Aims Standard File |
| to | to | |
| E_IL_P12 | E_IL_P12 In Learning in Period 12 | ESF Aims Standard File |
| E_ILPY2D | E_ILPY2D Number of Periods In-Learning In Current Year | ESF Aims Standard File |
| E_ILAVY2 | E_ILAVY2 Average Number of Periods In-Learning in Current Year | ESF Aims Standard File |
VALUES
5. The table below outlines the categories for A_IL_P1 to A_IL_P12
DETAILED DEFINITION
6. If an ER programme aim is on any day within the month of the period (PERIOD) then the learner is regarded as being in learning for the aim for that period. This means that the Learning Start Date (A27) of the aim is before the end of the month (of the period) and the Learning Actual End Date (A31) is either during that period, after the period or has not been entered yet.
7. If an ESF SR programme aim is on any day within the month of the period (PERIOD) then the learner is regarded as being in learning for the aim for that period. This means that the Date started ESF co-financing (E08) of the aim is before the end of the month (of the period) and the Date ended ESF co-financing (E10) is either during that period, after the period or has not been entered yet.
8. In learning is only calculated up to the current period, for example if the data was for Period 6, then A_IL_P7 to A_IL_P12 would be set to zero.
In Learning Year to Date
9. The In Learning Year to Date (A_ILPY2D or E_ILPY2D) denotes the number of periods (months) that the aim had been in learning in the current year, up to the latest period.
Average In Learning Year to Date
10. The Average Number of Periods In Learning in Current Year to Date (A_ILAVY2 or E_ILAVY2) is simply the number of periods (months) in learning in the current year to date, divided by the current period.
In Learning Sample Code
1. The following SPSS code is provided to illustrate the In Learning data definition.
A_IL_P1 to A_IL_P12
2. The following table shows the steps required to derive A_IL_P1 to A_IL_P12
| Step | Condition | Action/Action if true | Action if false |
|---|
| Is A04<>35 | Go to 1 | Go to 13 |
| 1 | Is A27 before or on 31/8/current academic year and either no A31 or A31 is on or after 1/8/current academic year | Set A_IL_P1 to 1 | Set A_IL_P1 to 0 |
| 2 | Is A27 before or on 30/9/current academic year and either no A31 or A31 is on or after 1/9/current academic year | Set A_IL_P2 to 1 | Set A_IL_P2 to 0 |
| 3 | Is A27 before or on 31/10/current academic year and either no A31 or A31 is on or after 1/10/current academic year | Set A_IL_P3 to 1 | Set A_IL_P3 to 0 |
| 4 | Is A27 before or on 30/11/current academic year and either no A31 or A31 is on or after 1/11/current academic year | Set A_IL_P4 to 1 | Set A_IL_P4 to 0 |
| 5 | Is A27 before or on 31/12/current academic year and either no A31 or A31 is on or after 1/12/current academic year | Set A_IL_P5 to 1 | Set A_IL_P5 to 0 |
| 6 | Is A27 before or on 31/1/current academic year + 1) and either no A31 or A31 is on or after 1/1/current academic year + 1 | Set A_IL_P6 to 1 | Set A_IL_P6 to 0 |
| 7 | Is A27 before or on 28/2/current academic year + 1) and either no A31 or A31 is on or after 1/2/current academic year + 1 | Set A_IL_P7 to 1 | Set A_IL_P7 to 0 |
| 8 | Is A27 before or on 31/3/current academic year + 1) and either no A31 or A31 is on or after 1/3/current academic year + 1 | Set A_IL_P8 to 1 | Set A_IL_P8 to 0 |
| 9 | Is A27 before or on 30/4/current academic year + 1) and either no A31 or A31 is on or after 1/4/current academic year + 1 | Set A_IL_P9 to 1 | Set A_IL_P9 to 0 |
| 10 | Is A27 before or on 31/5/current academic year + 1) and either no A31 or A31 is on or after 1/5/current academic year + 1 | Set A_IL_P10 to 1 | Set A_IL_P10 to 0 |
| 11 | Is A27 before or on 30/6/current academic year + 1) and either no A31 or A31 is on or after 1/6/current academic year + 1 | Set A_IL_P11 to 1 | Set A_IL_P11 to 0 |
| 12 | Is A27 before or on 31/7/current academic year + 1) and either no A31 or A31 is on or after 1/7/current academic year + 1 | Set A_IL_P12 to 1 | Set A_IL_P12 to 0 |
| 13 | For programme aims A_IL_Px=maximum A_IL_Px of all the aims that make up that programme | | |
3. The following SPSS code illustrates how to derive A_IL_P1 to A_IL_P12.
DO IF A04<>35.
IF A27 <= DATE.DMY(31,8,current academic year) AND (MISSING(A31) OR A31 >= DATE.DMY(1,8,current academic year) A_IL_P1=1.
IF A27 <= DATE.DMY(30,9,current academic year) AND (MISSING(A31) OR A31 >= DATE.DMY(1,9,current academic year) A_IL_P2=1.
IF A27 <= DATE.DMY(31,10,current academic year) AND (MISSING(A31) OR A31 >= DATE.DMY(1,10,current academic year) A_IL_P3=1.
IF A27 <= DATE.DMY(30,11,current academic year) AND (MISSING(A31) OR A31 >= DATE.DMY(1,11,current academic year) A_IL_P4=1.
IF A27 <= DATE.DMY(31,12,current academic year) AND (MISSING(A31) OR A31 >= DATE.DMY(1,12,current academic year) A_IL_P5=1.
IF A27 <= DATE.DMY(31,1,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,1,current academic year + 1) A_IL_P6=1.
IF A27 <= DATE.DMY(28,2,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,2,current academic year + 1) A_IL_P7=1.
IF A27 <= DATE.DMY(31,3,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,3,current academic year + 1) A_IL_P8=1.
IF A27 <= DATE.DMY(30,4,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,4,current academic year + 1) A_IL_P9=1.
IF A27 <= DATE.DMY(31,5,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,5,current academic year + 1) A_IL_P10=1.
IF A27 <= DATE.DMY(30,6,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,6,current academic year + 1) A_IL_P11=1.
IF A27 <= DATE.DMY(31,7,current academic year + 1) AND (MISSING(A31) OR A31 >= DATE.DMY(1,7,current academic year + 1) A_IL_P12=1.
END IF.
RECODE A_IL_P1 to A_IL_P12 (SYSMIS=0).
AGGREGATE OUTFILE=*
MODE=ADDVARIABLES
/BREAK=L01 L03 A15 A26
/P_IL_P1=MAX(A_IL_P1)
/P_IL_P2=MAX(A_IL_P2)
/P_IL_P3=MAX(A_IL_P3)
/P_IL_P4=MAX(A_IL_P4)
/P_IL_P5=MAX(A_IL_P5)
/P_IL_P6=MAX(A_IL_P6)
/P_IL_P7=MAX(A_IL_P7)
/P_IL_P8=MAX(A_IL_P8)
/P_IL_P9=MAX(A_IL_P9)
/P_IL_P10=MAX(A_IL_P10)
/P_IL_P11=MAX(A_IL_P11)
/P_IL_P12=MAX(A_IL_P12) DO IF A04=35.
COMP A_IL_P1=P_IL_P1.
COMP A_IL_P2=P_IL_P2.
COMP A_IL_P3=P_IL_P3.
COMP A_IL_P4=P_IL_P4.
COMP A_IL_P5=P_IL_P5.
COMP A_IL_P6=P_IL_P6.
COMP A_IL_P7=P_IL_P7.
COMP A_IL_P8=P_IL_P8.
COMP A_IL_P9=P_IL_P9.
COMP A_IL_P10=P_IL_P10.
COMP A_IL_P11=P_IL_P11.
COMP A_IL_P12=P_IL_P12.
END IF.
EXE.
DELETE VARIABLES P_IL_P1 TO P_IL_P12. VARIABLE LABELS A_IL_P1 'A_IL_P1 In-Learning in Period 1'
A_IL_P2 'A_IL_P2 - In-Learning in Period 2'
A_IL_P3 'A_IL_P3 - In-Learning in Period 3'
A_IL_P4 'A_IL_P4 - In-Learning in Period 4'
A_IL_P5 'A_IL_P5 - In-Learning in Period 5'
A_IL_P6 'A_IL_P5 - In-Learning in Period 6'
A_IL_P7 'A_IL_P8 - In-Learning in Period 7'
A_IL_P8 'A_IL_P8 - In-Learning in Period 8'
A_IL_P9 'A_IL_P9 - In-Learning in Period 9'
A_IL_P10 'A_IL_P10 - In-Learning in Period 10'
A_IL_P11 'A_IL_P11 - In-Learning in Period 11'
A_IL_P12 'A_IL_P12 - In-Learning in Period 12'. VALUE LABELS A_IL_P1 to A_IL_P12 1 'Yes' 0 'No'. /* Reset future in learning periods to 0 and calculate the in learning year to date and average in learning.DO IF PERIOD=1.
RECODE 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 (ELSE=0).
ELSE IF PERIOD=2.
RECODE 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 (ELSE=0).
ELSE IF PERIOD=3.
RECODE 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 (ELSE=0).
ELSE IF PERIOD=4.
RECODE A_IL_P5 A_IL_P6 A_IL_P7 A_IL_P8 A_IL_P9 A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=5.
RECODE A_IL_P6 A_IL_P7 A_IL_P8 A_IL_P9 A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=6.
RECODE A_IL_P7 A_IL_P8 A_IL_P9 A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=7.
RECODE A_IL_P8 A_IL_P9 A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=8.
RECODE A_IL_P9 A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=9.
RECODE A_IL_P10 A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=10.
RECODE A_IL_P11 A_IL_P12 (ELSE=0).
ELSE IF PERIOD=11.
RECODE A_IL_P12 (ELSE=0)
END IF. |
A_ILPY2D and A_ILPAVY2
4. The following table shows the steps required to derive A_ILPY2D
| Step | Condition |
|---|
| Period 1 | Set A_ILPY2D= A_IL_P1 |
| Period 2 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 |
| Period 3 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 |
| Period 4 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 |
| Period 5 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 |
| Period 6 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 |
| Period 7 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 + A_IL_P7 |
| Period 8 | Set A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 + A_IL_P7 + A_IL_P8 |
| Period 9 | Set A_ILPY2D= 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 |
| Period 10 | Set A_ILPY2D= 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 |
| Period 11 | Set A_ILPY2D= 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 |
| Period 12 | Set A_ILPY2D= 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 |
5. The following table shows the steps required to derive A_ILAVY2.
| Step | Condition |
|---|
| Period 1 | Set A_ILAVY2=A_ILPY2D |
| Period 2 | Set A_ILAVY2=A_ILPY2D/2 |
| Period 3 | Set A_ILAVY2=A_ILPY2D/3 |
| Period 4 | Set A_ILAVY2=A_ILPY2D/4 |
| Period 5 | Set A_ILAVY2=A_ILPY2D/5 |
| Period 6 | Set A_ILAVY2=A_ILPY2D/6 |
| Period 7 | Set A_ILAVY2=A_ILPY2D/7 |
| Period 8 | Set A_ILAVY2=A_ILPY2D/8 |
| Period 9 | Set A_ILAVY2=A_ILPY2D/9 |
| Period 10 | Set A_ILAVY2=A_ILPY2D/10 |
| Period 11 | Set A_ILAVY2=A_ILPY2D/11 |
| Period 12 | Set A_ILAVY2=A_ILPY2D/12 |
6. The following SPSS code illustrates how to derive A_ILPY2D and A_ILAVY2.
DO IF PERIOD=1.
COMPUTE A_ILPY2D= A_IL_P1.
COMPUTE A_ILAVY2=A_ILPY2D.
else IF PERIOD=2.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2.
COMPUTE A_ILAVY2=A_ILPY2D/2.
else IF PERIOD=3.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3.
COMPUTE A_ILAVY2=A_ILPY2D/3.
else IF PERIOD=4.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4.
COMPUTE A_ILAVY2=A_ILPY2D/4.
else IF PERIOD=5.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5.
COMPUTE A_ILAVY2=A_ILPY2D/5.
else IF PERIOD=6.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6.
COMPUTE A_ILAVY2=A_ILPY2D/6.
else IF PERIOD=7.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 + A_IL_P7.
COMPUTE A_ILAVY2=A_ILPY2D/7.
else IF PERIOD=8.
COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4 + A_IL_P5 + A_IL_P6 + A_IL_P7 + A_IL_P8.
COMPUTE A_ILAVY2=A_ILPY2D/8.
else IF PERIOD=9.
COMPUTE A_ILPY2D= 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.
COMPUTE A_ILAVY2=A_ILPY2D/9.
else IF PERIOD=10.
COMPUTE A_ILPY2D= 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.
COMPUTE A_ILAVY2=A_ILPY2D/10.
else IF PERIOD=11.
COMPUTE A_ILPY2D= 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.
COMPUTE A_ILAVY2=A_ILPY2D/11.
else IF PERIOD=12.
COMPUTE A_ILPY2D= 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.
COMPUTE A_ILAVY2=A_ILPY2D/12.
END IF.
VARIABLE LABELS A_ILPY2D 'A_ILPY2D NUMBER OF PERIODS IN-LEARNING IN year, year to date
A_ILAVY2 'A_ILAVY2 AVERAGE NUMBER OF PERIODS IN-LEARNING IN current year to date. |
E_IL_P1 to E_IL_P12
7. The following table shows the steps required to derive E_IL_P1 to E_IL_P12
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Is E08 before or on 31/8/current academic year and either no E10 or E10 is after 1/8/current academic year | Set E_IL_P1 to 1 | Set E_IL_P1 to 0 |
| 2 | Is E08 before or on 30/9/current academic year and either no E10 or E10 is after 1/9/current academic year | Set E_IL_P2 to 1 | Set E_IL_P2 to 0 |
| 3 | Is E08 before or on 31/10/current academic year and either no E10 or E10 is after 1/10/current academic year | Set E_IL_P3 to 1 | Set E_IL_P3 to 0 |
| 4 | Is E08 before or on 30/11/current academic year and either no E10 or E10 is after 1/11/current academic year | Set E_IL_P4 to 1 | Set E_IL_P4 to 0 |
| 5 | Is E08 before or on 31/12/current academic year and either no E10 or E10 is after 1/12/current academic year | Set E_IL_P5 to 1 | Set E_IL_P5 to 0 |
| 6 | Is E08 before or on 31/1/current academic year + 1) and either no E10 or E10 is after 1/1/current academic year + 1 | Set E_IL_P6 to 1 | Set E_IL_P6 to 0 |
| 7 | Is E08 before or on 28/2/current academic year + 1) and either no E10 or E10 is after 1/2/current academic year + 1 | Set E_IL_P7 to 1 | Set E_IL_P7 to 0 |
| 8 | Is E08 before or on 31/3/current academic year + 1) and either no E10 or E10 is after 1/3/current academic year + 1 | Set E_IL_P8 to 1 | Set E_IL_P8 to 0 |
| 9 | Is E08 before or on 30/4/current academic year + 1) and either no E10 or E10 is after 1/4/current academic year + 1 | Set E_IL_P9 to 1 | Set E_IL_P9 to 0 |
| 10 | Is E08 before or on 31/5/current academic year + 1) and either no E10 or E10 is after 1/5/current academic year + 1 | Set E_IL_P10 to 1 | Set E_IL_P10 to 0 |
| 11 | Is E08 before or on 30/6/current academic year + 1) and either no E10 or E10 is after 1/6/current academic year + 1 | Set E_IL_P11 to 1 | Set E_IL_P11 to 0 |
| 12 | Set E_IL_P12 to 1 | Set E_IL_P12 to 0 | |
8. The following SPSS code illustrates how to derive E_IL_P1 to E_IL_P12.
IF E08 <= DATE.DMY(31,8,current academic year) AND (MISSING(E10) OR E10 > DATE.DMY(1,8,current academic year) E_IL_P1=1.
IF E08 <= DATE.DMY(30,9,current academic year) AND (MISSING(E10) OR E10 > DATE.DMY(1,9,current academic year) E_IL_P2=1.
IF E08 <= DATE.DMY(31,10,current academic year) AND (MISSING(E10) OR E10 > DATE.DMY(1,10,current academic year) E_IL_P3=1.
IF E08 <= DATE.DMY(30,11,current academic year) AND (MISSING(E10) OR E10 > DATE.DMY(1,11,current academic year) E_IL_P4=1.
IF E08 <= DATE.DMY(31,12,current academic year) AND (MISSING(E10) OR E10 > DATE.DMY(1,12,current academic year) E_IL_P5=1.
IF E08 <= DATE.DMY(31,1,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,1,current academic year + 1) E_IL_P6=1.
IF E08 <= DATE.DMY(28,2,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,2,current academic year + 1) E_IL_P7=1.
IF E08 <= DATE.DMY(31,3,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,3,current academic year + 1) E_IL_P8=1.
IF E08 <= DATE.DMY(30,4,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,4,current academic year + 1) E_IL_P9=1.
IF E08 <= DATE.DMY(31,5,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,5,current academic year + 1) E_IL_P10=1.
IF E08 <= DATE.DMY(30,6,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,6,current academic year + 1) E_IL_P11=1.
IF E08 <= DATE.DMY(31,7,current academic year + 1) AND (MISSING(E10) OR E10 > DATE.DMY(1,7,current academic year + 1) E_IL_P12=1. VARIABLE LABELS E_IL_P1 'E_IL_P1 In-Learning in Period 1'
E_IL_P2 'E_IL_P2 - In-Learning in Period 2'
E_IL_P3 'E_IL_P3 - In-Learning in Period 3'
E_IL_P4 'E_IL_P4 - In-Learning in Period 4'
E_IL_P5 'E_IL_P5 - In-Learning in Period 5'
E_IL_P6 'E_IL_P6 - In-Learning in Period 6'
E_IL_P7 'E_IL_P7 - In-Learning in Period 7'
E_IL_P8 'E_IL_P8 - In-Learning in Period 8'
E_IL_P9 'E_IL_P9 - In-Learning in Period 9'
E_IL_P10 'E_IL_P10 - In-Learning in Period 10'
E_IL_P11 'E_IL_P11 - In-Learning in Period 11'
E_IL_P12 'E_IL_P12 - In-Learning in Period 12'. VALUE LABELS E_IL_P1 to E_IL_P12 1 'Yes' 0 'No'. /* Reset future in learning periods to 0 and calculate the in learning year to date and average in learning.
DO IF PERIOD=1.
RECODE E_IL_P2 E_IL_P3 E_IL_P4 E_IL_P5 E_IL_P6 E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=2.
RECODE E_IL_P3 E_IL_P4 E_IL_P5 E_IL_P6 E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=3.
RECODE E_IL_P4 E_IL_P5 E_IL_P6 E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=4.
RECODE E_IL_P5 E_IL_P6 E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=5.
RECODE E_IL_P6 E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=6.
RECODE E_IL_P7 E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=7.
RECODE E_IL_P8 E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=8.
RECODE E_IL_P9 E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=9.
RECODE E_IL_P10 E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=10.
RECODE E_IL_P11 E_IL_P12 (ELSE=0).
ELSE IF PERIOD=11.
RECODE E_IL_P12 (ELSE=0)
END IF. |
E_ILPY2D and E_ILAVY2
9. The following table shows the steps required to derive E_ILPY2D
| Step | Condition |
|---|
| Period 1 | Set E_ILPY2D= E_IL_P1 |
| Period 2 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 |
| Period 3 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 |
| Period 4 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 |
| Period 5 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 |
| Period 6 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 |
| Period 7 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 |
| Period 8 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 |
| Period 9 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 |
| Period 10 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10 |
| Period 11 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10 + E_IL_P11 |
| Period 12 | Set E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10 + E_IL_P11 + E_IL_P12 |
10. The following table shows the steps required to derive E_ILAVY2
| Step | Condition |
|---|
| Period 1 | Set E_ILAVY2=E_ILPY2D |
| Period 2 | Set E_ILAVY2=E_ILPY2D/2 |
| Period 3 | Set E_ILAVY2=E_ILPY2D/3 |
| Period 4 | Set E_ILAVY2=E_ILPY2D/4 |
| Period 5 | Set E_ILAVY2=E_ILPY2D/5 |
| Period 6 | Set E_ILAVY2=E_ILPY2D/6 |
| Period 7 | Set E_ILAVY2=E_ILPY2D/7 |
| Period 8 | Set E_ILAVY2=E_ILPY2D/8 |
| Period 9 | Set E_ILAVY2=E_ILPY2D/9 |
| Period 10 | Set E_ILAVY2=E_ILPY2D/10 |
| Period 11 | Set E_ILAVY2=E_ILPY2D/11 |
| Period 12 | Set E_ILAVY2=E_ILPY2D/12 |
11. The following SPSS code illustrates how to derive E_ILPY2D and E_ILAVY2.
DO IF PERIOD=1.
COMPUTE E_ILPY2D= E_IL_P1.
COMPUTE E_ILAVY2=E_ILPY2D.
ELSE IF PERIOD=2.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2.
COMPUTE E_ILAVY2=E_ILPY2D/2.
ELSE IF PERIOD=3.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3.
COMPUTE E_ILAVY2=E_ILPY2D/3.
ELSE IF PERIOD=4.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4.
COMPUTE E_ILAVY2=E_ILPY2D/4.
ELSE IF PERIOD=5.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5.
COMPUTE E_ILAVY2=E_ILPY2D/5.
ELSE IF PERIOD=6.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6.
COMPUTE E_ILAVY2=E_ILPY2D/6.
ELSE IF PERIOD=7.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7.
COMPUTE E_ILAVY2=E_ILPY2D/7.
ELSE IF PERIOD=8.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8.
COMPUTE E_ILAVY2=E_ILPY2D/8.
ELSE IF PERIOD=9.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9.
COMPUTE E_ILAVY2=E_ILPY2D/9.
ELSE IF PERIOD=10.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10.
COMPUTE E_ILAVY2=E_ILPY2D/10.
ELSE IF PERIOD=11.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10 + E_IL_P11.
COMPUTE E_ILAVY2=E_ILPY2D/11.
ELSE IF PERIOD=12.
COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4 + E_IL_P5 + E_IL_P6 + E_IL_P7 + E_IL_P8 + E_IL_P9 + E_IL_P10 + E_IL_P11 + E_IL_P12.
COMPUTE E_ILAVY2=E_ILPY2D/12.
END IF. VARIABLE LABELS E_ILPY2D 'E_ILPY2D NUMBER OF PERIODS IN-LEARNING IN current year'
E_ILAVY2 'E_ILAVY2 AVERAGE NUMBER OF PERIODS IN-LEARNING IN current year'. |
Date last modfied: 20th January 2009
