Learner Level 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 Learner Level In Learning data definition.

L_IL_P1 to L_IL_P12

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

recode A15 (2=4) (3=5) (7=3) (6=4) (5=5) (4=6) (9=7) (99=8) (10=4) into A_PROG.
VALUE LABELS A_PROG 03 'NVQ level 4 within WBL programme'
 04 'AMA/NVQ level 3 within WBL programme'
 05 'FMA/ NVQ level 2 within WBL programme'
 06 'NVQ level 1 within WBL programme'
 07 'entry to employment (E2E) within WBL programme'
 08 'Other'.

COMPUTE MA=any(A15,2,3,10).
recode A10 (40 thru 42=1) (99=2) (else=3) into fund.
COMPUTE A31_1=A31.
if sysmis(A31) A31_1=date.dmy(1,1,!thisyr+50).

COMPUTE L_IL_P1 A_IL_P1*A15.
sort cases L01 L03 (A) A_IL_P1 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P1.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P1 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P1).

COMPUTE L_IL_P2 A_IL_P2*A15.
sort cases L01 L03 (A) A_IL_P2 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P2.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P2 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P2).

COMPUTE L_IL_P3 A_IL_P3*A15.
sort cases L01 L03 (A) A_IL_P3 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P3.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P3 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P3).

COMPUTE L_IL_P4 A_IL_P4*A15.
sort cases L01 L03 (A) A_IL_P4 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P4.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P4 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P4).

COMPUTE L_IL_P5 A_IL_P5*A15.
sort cases L01 L03 (A) A_IL_P5 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P5.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P5 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P5).

COMPUTE L_IL_P6 A_IL_P6*A15.
sort cases L01 L03 (A) A_IL_P6 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P6.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P6 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P6).

COMPUTE L_IL_P7 A_IL_P7*A15.
sort cases L01 L03 (A) A_IL_P7 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P7.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P7 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P7).

COMPUTE L_IL_P8 A_IL_P8*A15.
sort cases L01 L03 (A) A_IL_P8 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P8.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P8 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P8).

COMPUTE L_IL_P9 A_IL_P9*A15.
sort cases L01 L03 (A) A_IL_P9 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P9.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P9 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P9).

COMPUTE L_IL_P10 A_IL_P10*A15.
sort cases L01 L03 (A) A_IL_P10 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P10.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P10 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P10).

COMPUTE L_IL_P11 A_IL_P11*A15.
sort cases L01 L03 (A) A_IL_P11 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P11.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P11 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P11).

COMPUTE L_IL_P12 A_IL_P12*A15.
sort cases L01 L03 (A) A_IL_P12 (D) A31_1 (D) A_PROG (A) MA (D) fund (A).
aggregate outfile=’………IL_P12.sav'
 /presorted 
 /break=L01 L03
 /L_IL_P12 ‘DV - Learner In-Learning Programme Type Period 1=first(L_IL_P12).

Match files /file=’………IL_P1.sav'
 /file=’………IL_P2.sav'
 /file=’………IL_P3.sav'
 /file=’………IL_P4.sav'
 /file=’………IL_P5.sav'
 /file=’………IL_P6.sav'
 /file=’………IL_P7.sav'
 /file=’………IL_P8.sav'
 /file=’………IL_P9.sav'
 /file=’………IL_P10.sav'
 /file=’………IL_P11.sav'
 /file=’………IL_P12.sav'.
 /by L01 L03 .

recode L_IL_P1 to L_IL_P12 (sysmis=0).
val labs L_IL_P1 to L_IL_P12 0 'Not in Learning'
 02 "Advanced Apprenticeship"
 03 "Apprenticeship"
 04 "NVQ level 1 within WBL programme"
 05 "NVQ level 2 within WBL programme"
 06 "NVQ level 3 within WBL programme"
 07 "NVQ level 4 within WBL programme"
 09 "entry to employment (E2E) within WBL programme"
 99 "none of the above".

Creator	Analysis and MI Team
Date issued	20 December 2005
Date created	20 December 2005
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-learnerlevelinlearningsamplecode-report-20dec2005.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/

Last Modified: 21 Dec 05