Mode of Attendance Sample Code

/* Create a temporary variable tempmode, and if the main delivery method is set to open learning, the value is set to to 3,
/* if the delivery method is set to distance learning it is assigned the value 3,
/* if neither of these conditions are relevant and the delivery mode is set to evening only the value is set to 1.
COMPUTE TEMPMODE=0.
DO IF (A18=2).
 COMPUTE TEMPMODE=3.
ELSE IF (A18=3).
 COMPUTE TEMPMODE=2.
ELSE IF (A17=2).
 COMPUTE TEMPMODE=1.
END IF.

VALUE LABELS TEMPMODE 3 'Open Learning' 2 ' distance learning' 1 'Evening' 0 'Not opendistance or evening'.

RECODE PRD_EXP PRD_ACT A_EXP_B A_ACT_B GLHACT1 GLHACT2 GLHACT3 GLHEXP1 GLHEXP2 GLHEXP3 A_LIVE_B (sysmis=0).
SORT CASES L01 L03.

/* On the aggregate we select where A_LIVE_B>0 rather than the usual A_LIVE_B>1. To get round this a new variable ACT is created, which is equal to A_ACT_B, but has the value 0 when A_LIVE_B=1.
COMP ACT=A_ACT_B.
IF A_LIVE_B=1 ACT=0.
IF (ACT=0) ACT=0.01.
IF A_EXP_B=0 A_EXP_B=0.01.

/*Create a variable comp which will have a value 1 if the aim has been completed.
COMPUTE comp=(A34=2).

/* Exclude those aims which are not included for analytical purposes and aggregate individual aim records up to learner level.
/* Create two variables at learner level comp, which is the number of completed aims, and LALIVE_B the total number of included aims.
TEMPORARY.
SELECT IF (A_LIVE_B > 0).
AGGREGATE OUTFILE=’……………………..TEMP.SAV’
 /BREAK=l01 l03
 /L_EXP_B=SUM(A_EXP_B)
 /L_ACT_B=SUM(A_ACT_B)
 /EXPER=MEAN(PRD_EXP)
 /ACTPER=MEAN(PRD_ACT)
 /GLHACT1=SUM(GLHACT1)
 /GLHACT2=SUM(GLHACT2)
 /GLHACT3=SUM(GLHACT3)
 /GLHEXP1=SUM(GLHEXP1)
 /GLHEXP2=SUM(GLHEXP2)
 /GLHEXP3=SUM(GLHEXP3)
 /COMP=SUM(COMP)
 /LALIVE_B =N
 /A27=MIN(A27)
 /A28=MAX(A28)
 /A31=MAX(A31)
 /TEMPMODE=MAX(TEMPMODE).

GET FILE=’……………………..TEMP.SAV’
DO IF L_LIVE_B >1.

/* calculate expected weeks and expected weekly glh, for the learner using the minimum start date and the maximum planned end date of all the aims. 
 DO IF EXPER=1.
  COMPUTE WEEKS=CTIME.DAYS(A28-A27) + 1.
  RECODE WEEKS (1 THRU 7=1) (8 THRU 14=2) (15 THRU 21=3)
(22 THRU 28=4) (29 THRU 35=5) (36 THRU 42=6)
(43 THRU 49=7) (50 THRU 56=8) (57 THRU 63=9)
(64 THRU 120=10) (ELSE=9999).
  COMPUTE GLHWEEKB=(L_EXP_B/WEEKS).
 END IF.

/* calculate duration of learning in weeks and the expected glh per week for.
/* learners with a mean actual period of 1 and where all qualifications are completed i.e. number of live aims=number of completed aims.

 DO IF ACTPER=1 AND (LALIVE_B=COMP).
  COMPUTE WEEKS=CTIME.DAYS(A31-A27) + 1.
  RECODE WEEKS (1 THRU 7=1) (8 THRU 14=2) (15 THRU 21=3)
(22 THRU 28=4) (29 THRU 35=5) (36 THRU 42=6)
(43 THRU 49=7) (50 THRU 56=8) (57 THRU 63=9)
(64 THRU 120=10) (ELSE=9999).
  COMPUTE GLHWEEKB=(L_ACT_B/WEEKS).
 END IF.

/* A new variable L_MODE_B is created with the default value 3.
 COMPUTE L_MODE_B=3.

/* full-time full-year is based on actual or expected current year guided learning
/* hours=450 or more.
 IF (L_MODE_B=3 AND L_ACT_B >= 450) L_MODE_B=1.
 IF (L_MODE_B=3 AND L_EXP_B >=450) L_MODE_B=1.

/* Other full-time is based on a learner attending for
/* 150 guided (actual or expected) learning or more in any one period.
 IF (L_MODE_B=3 AND (GLHACT1 >= 150 OR GLHACT2 >= 150 OR GLHACT3 >= 150)) L_MODE_B=2.
 IF (L_MODE_B=3 AND (GLHEXP1 >= 150 OR GLHEXP2 >= 150 OR GLHEXP3 >= 150)) L_MODE_B=2.
 IF (L_MODE_B=3 AND GLHWEEKB > 16) L_MODE_B)=2.

VARIABLE LABELS L_MODE_B 'DV - Learners mode of attendence using 1 Oct 1 Feb 15 May (method B)'.

/* do some changes to take account of any learners who are open distance or evening. Note that if a learner
/* has any of these aims they are classified as one of these modes rather than part-time-other.
/* note also that if a learner has both/all 3 types the priority order is open then distance then evening, hence
/* the max value of tempmode was taken.
 DO IF (L_MODE_B)=3).
  DO IF (TEMPMODE=3).
   COMPUTE L_MODE_B)=4.
  ELSE IF (TEMPMODE=2).
   COMPUTE L_MODE_B)=5.
  ELSE IF (TEMPMODE=1).
    COMPUTE L_MODE_B)=6.
  END IF.
 END IF.
END IF.
VALUE LABELS L_MODE_B
 1 'Full-time full-year'
 2 'Full-time part-year'
 3 'Part-time - other including e-learning'
 4 'Part-time - open'
 5 'Part-time - distance learning'
 6 'Part-time - evening'.

Creator

Analysis and MI Team

Date issued

3 January 2006

Date created

22 December 2005

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-modeofattendancesamplecode-report-03jan2006.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/