In Learning Sample Code

Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

1 The following pseudo code and 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 if true

Action if false

1

Is A27 before or on 31/8/relevant academic year and either no A31 or A31 is after 1/8/relevant academic year

Set A_IL_P1 to 1

Set A_IL_P1 to 0

2

Is A27 before or on 30/9/relevant academic year and either no A31 or A31 is after 1/9/relevant academic year

Set A_IL_P2 to 1

Set A_IL_P2 to 0

3

Is A27 before or on 31/10/relevant academic year and either no A31 or A31 is after 1/10/relevant academic year

Set A_IL_P3 to 1

Set A_IL_P3 to 0

4

Is A27 before or on 30/11/relevant academic year and either no A31 or A31 is after 1/11/relevant academic year

Set A_IL_P4 to 1

Set A_IL_P4 to 0

5

Is A27 before or on 31/12/relevant academic year and either no A31 or A31 is after 1/12/relevant academic year

Set A_IL_P5 to 1

Set A_IL_P5 to 0

6

Is A27 before or on 31/1/relevant academic year + 1) and either no A31 or A31 is after 1/1/relevant academic year + 1

Set A_IL_P6 to 1

Set A_IL_P6 to 0

7

Is A27 before or on 28/2/relevant academic year + 1) and either no A31 or A31 is after 1/2/relevant academic year + 1

Set A_IL_P7 to 1

Set A_IL_P7 to 0

8

Is A27 before or on 31/3/relevant academic year + 1) and either no A31 or A31 is after 1/3/relevant academic year + 1

Set A_IL_P8 to 1

Set A_IL_P8 to 0

9

Is A27 before or on 30/4/relevant academic year + 1) and either no A31 or A31 is after 1/4/relevant academic year + 1

Set A_IL_P9 to 1

Set A_IL_P9 to 0

10

Is A27 before or on 31/5/relevant academic year + 1) and either no A31 or A31 is after 1/5/relevant academic year + 1

Set A_IL_P10 to 1

Set A_IL_P10 to 0

11

Is A27 before or on 30/6/relevant academic year + 1) and either no A31 or A31 is after 1/6/relevant academic year + 1

Set A_IL_P11 to 1

Set A_IL_P11 to 0

12

Is A27 before or on 31/7/relevant academic year + 1) and either no A31 or A31 is after 1/7/relevant academic year + 1

Set A_IL_P12 to 1

Set A_IL_P12 to 0

3 The following SPSS code illustrates how to derive A_IL_P1 to A_IL_P12.

IF A27 <= DATE.DMY(31,8,relevant academic year) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,8,relevant academic year) A_IL_P1=1.
IF A27 <= DATE.DMY(30,9,relevant academic year) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,9,relevant academic year) A_IL_P2=1.
IF A27 <= DATE.DMY(31,10,relevant academic year) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,10,relevant academic year) A_IL_P3=1.
IF A27 <= DATE.DMY(30,11,relevant academic year) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,11,relevant academic year) A_IL_P4=1.
IF A27 <= DATE.DMY(31,12,relevant academic year) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,12,relevant academic year) A_IL_P5=1.
IF A27 <= DATE.DMY(31,1,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,1,relevant academic year + 1) A_IL_P6=1.
IF A27 <= DATE.DMY(28,2,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,2,relevant academic year + 1) A_IL_P7=1.
IF A27 <= DATE.DMY(31,3,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,3,relevant academic year + 1) A_IL_P8=1.
IF A27 <= DATE.DMY(30,4,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,4,relevant academic year + 1) A_IL_P9=1.
IF A27 <= DATE.DMY(31,5,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,5,relevant academic year + 1) A_IL_P10=1.
IF A27 <= DATE.DMY(30,6,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,6,relevant academic year + 1) A_IL_P11=1.
IF A27 <= DATE.DMY(31,7,relevant academic year + 1) AND (SYSMIS(A31) OR A31 > DATE.DMY(1,7,relevant academic year + 1) A_IL_P12=1.

VARIABLE LABELS A_IL_P1 'DV - In-Learning in Period 1'
 A_IL_P2 'DV - In-Learning in Period 2'
 A_IL_P3 'DV - In-Learning in Period 3'
 A_IL_P4 'DV - In-Learning in Period 4'
 A_IL_P5 'DV - In-Learning in Period 5'
 A_IL_P6 'DV - In-Learning in Period 6'
 A_IL_P7 'DV - In-Learning in Period 7'
 A_IL_P8 'DV - In-Learning in Period 8'
 A_IL_P9 'DV - In-Learning in Period 9'
 A_IL_P10 'DV - In-Learning in Period 10'
 A_IL_P11 'DV - In-Learning in Period 11'
 A_IL_P12 'DV - 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.

Condition

Action

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.

Condition

Action

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_ILPAVY2=A_ILPY2D.
ELSE IF PERIOD=2.
 COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2.
 COMPUTE A_ILPAVY2=A_ILPY2D/2.
ELSE IF PERIOD=3.
 COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3.
 COMPUTE A_ILPAVY2=A_ILPY2D/3.
ELSE IF PERIOD=4.
 COMPUTE A_ILPY2D= A_IL_P1 + A_IL_P2 + A_IL_P3 + A_IL_P4.
 COMPUTE A_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=A_ILPY2D/12.
END IF.

VARIABLE LABELS A_ILPY2D 'DV - NUMBER OF PERIODS IN-LEARNING IN relevant academic year'
 A_ILAVY2 'DV - AVERAGE NUMBER OF PERIODS IN-LEARNING IN relevant academic year'.

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 if true

Action if false

1

Is E08 before or on 31/8/relevant academic year and either no E10 or E10 is after 1/8/relevant academic year

Set E_IL_P1 to 1

Set E_IL_P1 to 0

2

Is E08 before or on 30/9/relevant academic year and either no E10 or E10 is after 1/9/relevant academic year

Set E_IL_P2 to 1

Set E_IL_P2 to 0

3

Is E08 before or on 31/10/relevant academic year and either no E10 or E10 is after 1/10/relevant academic year

Set E_IL_P3 to 1

Set E_IL_P3 to 0

4

Is E08 before or on 30/11/relevant academic year and either no E10 or E10 is after 1/11/relevant academic year

Set E_IL_P4 to 1

Set E_IL_P4 to 0

5

Is E08 before or on 31/12/relevant academic year and either no E10 or E10 is after 1/12/relevant academic year

Set E_IL_P5 to 1

Set E_IL_P5 to 0

6

Is E08 before or on 31/1/relevant academic year + 1) and either no E10 or E10 is after 1/1/relevant academic year + 1

Set E_IL_P6 to 1

Set E_IL_P6 to 0

7

Is E08 before or on 28/2/relevant academic year + 1) and either no E10 or E10 is after 1/2/relevant academic year + 1

Set E_IL_P7 to 1

Set E_IL_P7 to 0

8

Is E08 before or on 31/3/relevant academic year + 1) and either no E10 or E10 is after 1/3/relevant academic year + 1

Set E_IL_P8 to 1

Set E_IL_P8 to 0

9

Is E08 before or on 30/4/relevant academic year + 1) and either no E10 or E10 is after 1/4/relevant academic year + 1

Set E_IL_P9 to 1

Set E_IL_P9 to 0

10

Is E08 before or on 31/5/relevant academic year + 1) and either no E10 or E10 is after 1/5/relevant academic year + 1

Set E_IL_P10 to 1

Set E_IL_P10 to 0

11

Is E08 before or on 30/6/relevant academic year + 1) and either no E10 or E10 is after 1/6/relevant academic year + 1

Set E_IL_P11 to 1

Set E_IL_P11 to 0

12

Is E08 before or on 31/7/relevant academic year + 1) and either no E10 or E10 is after 1/7/relevant academic year + 1

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,relevant academic year) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,8,relevant academic year) E_IL_P1=1.
IF E08 <= DATE.DMY(30,9,relevant academic year) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,9,relevant academic year) E_IL_P2=1.
IF E08 <= DATE.DMY(31,10,relevant academic year) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,10,relevant academic year) E_IL_P3=1.
IF E08 <= DATE.DMY(30,11,relevant academic year) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,11,relevant academic year) E_IL_P4=1.
IF E08 <= DATE.DMY(31,12,relevant academic year) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,12,relevant academic year) E_IL_P5=1.
IF E08 <= DATE.DMY(31,1,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,1,relevant academic year + 1) E_IL_P6=1.
IF E08 <= DATE.DMY(28,2,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,2,relevant academic year + 1) E_IL_P7=1.
IF E08 <= DATE.DMY(31,3,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,3,relevant academic year + 1) E_IL_P8=1.
IF E08 <= DATE.DMY(30,4,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,4,relevant academic year + 1) E_IL_P9=1.
IF E08 <= DATE.DMY(31,5,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,5,relevant academic year + 1) E_IL_P10=1.
IF E08 <= DATE.DMY(30,6,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,6,relevant academic year + 1) E_IL_P11=1.
IF E08 <= DATE.DMY(31,7,relevant academic year + 1) AND (SYSMIS(E10) OR E10 > DATE.DMY(1,7,relevant academic year + 1) E_IL_P12=1.

VARIABLE LABELS E_IL_P1 'DV - In-Learning in Period 1'
 E_IL_P2 'DV - In-Learning in Period 2'
 E_IL_P3 'DV - In-Learning in Period 3'
 E_IL_P4 'DV - In-Learning in Period 4'
 E_IL_P5 'DV - In-Learning in Period 5'
 E_IL_P6 'DV - In-Learning in Period 6'
 E_IL_P7 'DV - In-Learning in Period 7'
 E_IL_P8 'DV - In-Learning in Period 8'
 E_IL_P9 'DV - In-Learning in Period 9'
 E_IL_P10 'DV - In-Learning in Period 10'
 E_IL_P11 'DV - In-Learning in Period 11'
 E_IL_P12 'DV - 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_ILPAVY2

9 The following table shows the steps required to derive E_ILPY2D.

Condition

Action

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

Condition

Action

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_ILPAVY2=E_ILPY2D.
ELSE IF PERIOD=2.
 COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2.
 COMPUTE E_ILPAVY2=E_ILPY2D/2.
ELSE IF PERIOD=3.
 COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3.
 COMPUTE E_ILPAVY2=E_ILPY2D/3.
ELSE IF PERIOD=4.
 COMPUTE E_ILPY2D= E_IL_P1 + E_IL_P2 + E_IL_P3 + E_IL_P4.
 COMPUTE E_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=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_ILPAVY2=E_ILPY2D/12.
END IF.

VARIABLE LABELS E_ILPY2D 'DV - NUMBER OF PERIODS IN-LEARNING IN relevant academic year'
 E_ILAVY2 'DV - AVERAGE NUMBER OF PERIODS IN-LEARNING IN relevant academic year'.

Creator

Analysis and MI Team

Date issued

26 September 2006

Date created

8 December 2005

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\DataDefinitions\SampleCode\nat-inlearningsamplecode-report-29sep2006.doc

LSC office

Learning and Skills Council
Cheylesmore House Quinton Road Coventry CV1 2WT
T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk/