Mode of Attendance Data Definition 2008/2009

L_MODE_B

DATA DEFINITION

1. Learner Mode of Attendance.

PURPOSE

2. Mode of attendance identifies attendance arrangements for a learner to monitor trends and funding.

RELEVANT COLLECTIONS

ILR (FE)
ILR (UfI)
ILR (ASL)

SOURCE DATA

3. The following variables are used as source data for the calculation of Learner Mode of Attendance.

Field Name	Label	Dataset
A17	A17 Delivery Mode	Aims Standard File
A18	A18 Main Delivery Method	Aims Standard File
A27	A27 Learning Start Date	Aims Standard File
A28	A28 Learning Planned End Date	Aims Standard File
A31	A31 Learning Actual End Date	Aims Standard File
A34	A34 Completion Status	Aims Standard File
L_INYR_ACTUAL_GLH	L_INYR_ACTUAL_GLH Actual In Year GLH	Learner Standard File
A_INYR_ACTUAL_GLH	A_INYR_ACTUAL_GLH Aim Actual Current Year GLH	Aims Standard File
A_INYR_EXPECTED_GLH	A_INYR_EXPECTED_GLH Aim Expected Current Year GLH	Aims Standard File
L_INYR_EXPECTED_GLH	L_INYR_EXPECTED_GLH Expected In Year GLH	Learner Standard File
A_ACTIVE	A_ACTIVE Aim Active for the current academic year	Aims Standard File
L_ACTIVE	L_ACTIVE Learner Active for the current academic year	Learner Standard File
TOTACT	TOTACT The Actual number of days for the aim	Aims Standard File
TOTEXP	TOTEXP The Expected number of days for the aim	Aims Standard File

DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)

Field Name	Label	Dataset
L_MODE_B	L_MODE_B Learners mode of attendance	Learner Standard File, Aims Standard File

VALUES

5. The table below outlines the categories for L_MODE_B

L_MODE_B Value	Label
-1	Not Applicable/Not Known*
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.

*Applies to system missing values and where there are non-active aims.

DETAILED DEFINITION

6. If the Learners Actual Current Year Guided Learning Hours (L_INYR_ACTUAL_GLH) is greater or equal to 450, then they are regarded as being Full-time full-year, and Learners Mode of Attendance (L_MODE_B) equals 1.

7. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and the learners Expected Current Year Guided Learning Hours (L_INYR_EXPECTED_GLH) is greater or equal to 450, then they are regarded as being Full-time full-year, and Learners Mode of Attendance (L_MODE_B) equals 1.

8. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and if the learner actually attends for more than 150 guided learning hour in any one of the tri-annual periods (terms), then the learner is regarded as being Full-time part-year, and Learners Mode of Attendance (L_MODE_B) equals 2.

9. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and if the learner is expected to attend for more than 150 guided learning hour in any one of the tri-annual periods (terms), then the learner is regarded as being Full-time part-year, and Learners Mode of Attendance (L_MODE_B) equals 2

10. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and if the learner has expected weekly guided learning hours of more than 16, then the learner is regarded as being Full-time part-year, and Learners Mode of Attendance (L_MODE_B) equals 2

11. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and if the learner has any aims that are marked as being open learning (using Main Delivery Method, A18=2), then the learner is classified as being Part-time – open, Learners Mode of Attendance (L_MODE_B) equals 4.

12. If the learner has no value for Learners Mode of Attendance (L_MODE_B) and if the learner has any aims that are marked as being distance learning (Other than e-learning) (using Main Delivery Method, A18=3), then the learner is classified as being Part-time - distance learning, Learners Mode of Attendance (L_MODE_B) equals 5.

13. If the learner has any aims that are marked as continuous delivery – evening only (using Delivery Mode, A17=2), then the learner is classified as being Part-time - evening, Learners Mode of Attendance (L_MODE_B) equals 6.

14. Any learners who haven't been classified yet are marked as Part-time - other including e-learning, Learners Mode of Attendance (L_MODE_B) equals 3.

Mode of Attendance Sample Code

1. The following SPSS code is provided to illustrate the Mode of Attendance data definition.

L_MODE_B

2. The following table shows the steps required to derive L_MODE_B

Note: For the following conditions Start Date refers to the actual start date of the aim, or the 1 August, of the current academic year, if the Start Date is before this.
Similarly the Actual End Date refers to the Actual End Date, or the 31 July, of the current academic year, if the Actual End Date is after this date, and the Expected End Date refers to the Expected End Date, or the 31 July, of the current academic year, if the Expected End Date is after this date.

Step	Condition	Action/Action if true	Action if false
1	Any	Create date variable A31_1 = A31. Go to 4
2	Any	Create date variable A28_1 = A28. Got to 5
3	Any	Create date variable A27_1 = A27. Go to 6
4	Is A31_1 > 31/07/Current Academic Year	Set A31_1 = 31/07/Current Academic Year. Go to 7
5	Is A28 > 31/07/Current Academic Year	Set A28_1 = 31/07/Current Academic Year. Go to 7
6	Is A27_1 < 01/08/Current Academic Year	Set A27_1 = 01/08/Current Academic Year. Go to 7
7	Does A_ACTIVE = 1	Go to 8	Ignore those records.
8	Is A31 Not Missing	Go to 9	Go to 12
9	Does A31_1 fall within the period (Range 01/08 – 31/12) in the current academic Year	Set ACTPER1 = Difference in days between the start and the actual end date divided by the Total Actual Days of the whole course multiplied by the Actual In Year Guided Learning Hours	Go to 10
10	Does A31_1 fall within the period (Range 01/01 – 31/03) in the current academic year	Set ACTPER2 = the (minimum of the difference in days between the start and the actual end date, or the difference between the 1 January and the actual end date), divided by the Total Actual Days of the whole course multiplied by the Actual In Year Guided Learning Hours	Go to 11
11	Does A31_1 fall within the period (Range 01/04 – 31/07) in the current academic year	Set ACTPER3 = the (minimum of the difference in days between the start and the actual end date, or the difference between the 1 April and the actual end date), divided by the Total Actual Days of the whole course multiplied by the Actual In Year Guided Learning Hours	Go to 16
12	Is A31 Missing	Go to 13
13	Does A28_1 fall within the period (Range 01/08 – 31/12) in the current academic Year	Set ACTPER1 = Difference in days between the start and the expected end date divided by the Total Expected days of the whole course multiplied by the Expected In Year Guided Learning Hours	Go to 14
14	Does A31_1 fall within the period (Range 01/01 – 31/03) in the current academic year	Set ACTPER2 = the (minimum of the difference in days between the start and the expected end date, or the difference between the 1 January and the expected end date), divided by the Total Expected Days of the whole course multiplied by the Expected In Year Guided Learning Hours	Go to 15
15	Does A31_1 fall within the period (Range 01/04 – 31/07) in the current academic year	Set ACTPER3 = the (minimum of the difference in days between the start and the expected end date, or the difference between the 1 April and the expected end date), divided by the Total Expected Days of the whole course multiplied by the Expected In Year Guided Learning Hours	Go to 16
16	Does A_ACTIVE=1	Got to 17	Go to 21
17	Does A18=2	Set A_TEMPMODE=3 Go to 20	Go to 18
18	Does A18=3	Set A_TEMPMODE=2 Go to 20	Go to 19
19	Does A17=2	Set A_TEMPMODE=1 Go to 20	Go to 20
20	N/A	Create numeric variable A_COMPLETE = (A34=2). Go to 21	Go to 21
21		Set L_ACTPER1=Sum of the ACTPER1 for all of the aims where A_ACTIVE=1	Go to 22
22		Set L_ACTPER2=Sum of the ACTPER2 for all of the aims where A_ACTIVE=1	Go to 23
23		Set L_ACTPER2=Sum of the ACTPER3 for all of the aims where A_ACTIVE=1	Go to 24
24		Set L_A27_1=maximum value of A27_1 for all of the aims where A_ACTIVE=1	Go to 25
25		Set L_A28_1=maximum value of A28_1 for all of the aims where A_ACTIVE=1	Go to 26
26		Set L_A31_1=maximum value of A31_1 for all of the aims where A_ACTIVE=1	Go to 27
27		Set L_COMPLETE to the sum of A_COMPLETE for all of the aims where A_ACTIVE=1	Go to 28
28		Set N=Number of Aims where A_ACTIVE=1 AT Learner Level	Go to 29
29	N/A	Set L_MODE_B = -1. Go to 30
30	Does L_ACTIVE = 1	Set L_MODE_B = 3. Go to 31	Ignore those records
31	Are all the active aims completed (L_COMPLETE = N)	Go to 32.	Go to 33
32	Is the learner level actual GLH divided by the difference between the start and actual end date in weeks greater than 16	Set L_MODE_B = 2. Go to 39	Go to 33
33	Is the learner level expected GLH divided by the difference between the start and expected end date in weeks greater than 16	Set L_MODE_B = 2. Go to 39	Go to 34
34	Are any of L_ACTPER1, L_ACTPER2 and L_ACTPER3>150	Set L_MODE_B = 2. Go to 39	Go to 35
35	Does L_MODE_B = 3	Go to 36	Go to 39
36	Does L_TEMPMODE = 3	Set L_MODE_B = 4. Go to 39.	Go to 37
37	Does L_TEMPMODE = 2	Set L_MODE_B = 5. Go to 39	Go to 38
38	Does L_TEMPMODE = 1	Set L_MODE_B = 6. Go to 39.	Go to 39
39	IS L_INYR_EXPECTED_GLH >= 450	Set L_MODE_B = 1. Go to 40.	Go to 40
40	IS L_INYR_ACTUAL_GLH >= 450	Set L_MODE_B = 1.

Step	Condition	Action/Action if true	Action if false
1	Does L_MODE_B contain a value	None	Set L_MODE_B = -1
2	Does L_ACTIVE=1	Set L_MODE B = -1	None

3. The following SPSS code illustrates how to derive L_MODE_B.

/* MODE OF ATTENDANCE.
/*Uses Current Year Guided Learning Hours to determine a learners mode of attendance.
*/Compute new variables that copy across the Learning actual end date, Learning planned end date and Learning start date.
*/ Where the actual or planned end dates are after the end of the current academic year 31/07 is used in the calculation.
*/ Where the start date is before the start of the current academic year, 01/08 is used in the calculation. 
comp A31_1=A31.
comp A28_1=A28.
comp A27_1=A27.
if A31>DATE.DMY(31,7,current academic year+1) A31_1=DATE.DMY(31,7,current academic year+1).
if A28>DATE.DMY(31,7,current academic year+1) A28_1=DATE.DMY(31,7,current academic year+1).
if A27<DATE.DMY(1,8,current academic year) A27_1=DATE.DMY(1,8,current academic year).
*/Only incude those where staus for inclusion of aim is ‘include’.
DO IF A_ACTIVE=1.
*/ When the learning actual end date is not missing the total actual days are used (TOTACT).
*/If the Learning actual end date is not missing.
*/if the end date falls within Period 1 then Set ACTPER1 = 
Difference in days between the start and the actual end date divided by the Total Actual Days of the whole course multiplied by the Actual In Year Guided Learning Hours. 
*/Repeat calculation for periods 2 and 3.
*/If the Learning actual end date is missing the same calculations as above are performed but the planned end date and total expected days are used (TOTEXP).
  DO IF NOT MISSING(A31).
     DO IF RANGE(A31_1, DATE.DMY(1,8,current academic year), DATE.DMY(31,12,current academic year)).
      COMP ActPer1=(MAX((DATEDIFF(A31_1,A27_1,"days")+1),0)/totact)*A_InYr_Actual_GLH.
    ELSE IF RANGE(A31_1, DATE.DMY(1,1,current academic year+1), DATE.DMY(31,3,current academic year+1)).
      COMP ActPer2=(MAX(MIN((DATEDIFF(A31_1,A27_1,"days")+1),(DATEDIFF(A31_1,DATE.DMY(1,1,current academic year+1),"days")+1)),0)/totact)*A_InYr_Actual_GLH.
    ELSE IF RANGE(A31_1, DATE.DMY(1,4,current academic year+1), DATE.DMY(31,7,current academic year+1)).
      COMP ActPer3=(MAX(MIN((DATEDIFF(A31_1, A27_1, "days")+1), (DATEDIFF(A31_1, DATE.DMY(1,4,current academic year+1), "days")+1)),0)/totact)*A_InYr_Actual_GLH.
    END IF.
  ELSE.
    DO IF RANGE(A28_1, DATE.DMY(1,8,current academic year), DATE.DMY(31,12,current academic year)).
      COMP ActPer1=((MAX((DATEDIFF(A28_1,A27_1,"days")+1),0))/totexp)*A_InYr_Expected_GLH.
    ELSE IF RANGE(A28_1, DATE.DMY(1,1,current academic year+1), DATE.DMY(31,3,current academic year+1)).
      COMP ActPer2=(MAX(MIN((DATEDIFF(A28_1,A27_1,"days")+1),(DATEDIFF(A28_1,DATE.DMY(1,1,current academic year+1),"days")+1)),0)/totexp)*A_InYr_Expected_GLH.
    ELSE IF RANGE(A28_1, DATE.DMY(1,4,current academic year+1), DATE.DMY(31,7,current academic year+1)).
      COMP ActPer3=(MAX(MIN((DATEDIFF(A28_1,A27_1,"days")+1),(DATEDIFF(A28_1,DATE.DMY(1,4,current academic year+1),"days")+1)),0)/totexp)*A_InYr_Expected_GLH.
    END IF.
  END IF.
END IF.
*/New variable showing those aims that have been completed.
comp A_COMPLETE=(A34=2).
 /* 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 A_TEMPMODE=0.
DO IF A_ACTIVE=1.
  DO IF A18=2.
    COMPUTE A_TEMPMODE=3.
  ELSE IF A18=3.
    COMPUTE A_TEMPMODE=2.
  ELSE IF A17=2.
    COMPUTE A_TEMPMODE=1.
  END IF.
END IF.
SELECT IF A_ACTIVE=1.
AGGREGATE OUT *
   OVER=YES
   /BREAK=L01 L03
   /L_InYr_Actual_GLH=sum(A_InYr_Actual_GLH)
   /L_InYr_Expected_GLH=sum(A_InYr_Expected_GLH)
   /L_ACTIVE=max(A_ACTIVE)
   /L_ACTPER1=SUM(ACTPER1)
   /L_ACTPER2=SUM(ACTPER2)
   /L_ACTPER3=SUM(ACTPER3)
   /L_A27_1=MAX(A27_1)
   /L_A28_1=MAX(A28_1)
   /L_A31_1=MAX(A31_1)
   /L_COMPLETE=sum(A_COMPLETE)
   /N=sum(A_ACTIVE)
   /L_TEMPMODE=max(A_TEMPMODE).
/* A new variable L_MODE_B is created with the default value -1.
COMPUTE L_MODE_B=-1.
*/Only incude active learners.
DO IF L_ACTIVE=1.
 /* Assign a value of 3 to all learners who are active
  COMPUTE L_MODE_B=3.
*/If learner has completed aims and the difference between the Leaners maximum start and actual end dates is for more than 16 GLH per week then the mode of attendance is full time part year. 
  DO IF L_COMPLETE=n.
    IF L_InYr_Actual_GLH/(DATEDIFF(L_A31_1, L_A27_1, "Weeks")+1)>16 L_MODE_B=2.
  END IF.
*/If for the learner the difference between the Leaners maximum start and expected end dates is more than 16 glh per week then the mode of attendance is full time part year.
  IF L_InYr_Expected_GLH/(DATEDIFF(L_A28_1, L_A27_1, "Weeks")+1)>16 L_MODE_B=2.
*/If a learners is undertaking 150 plus GLH in any period then the mode of attendance is full time part year.
  IF L_ACTPER1>150 OR L_ACTPER2>150 OR L_ACTPER3>150 L_MODE_B=2.
*/Adjustment to learners If the Mode of attendance is set to ‘Part-time - other including e-learning’ and any of the following are true
*/If Main delivery method is ‘Open Learning’, Mode of attendance equals ‘Part-time – Open’.
*/If Main delivery method is ‘distance learning (other than e-learning)’, Mode of attendance equals 'Part-time - distance learning'.
*/If delivery mode is ‘continuous delivery – evening only’, Mode of attendance equals 'Part-time - evening'.
  DO IF (L_MODE_B)=3.
    DO IF (L_TEMPMODE =3).
    COMPUTE L_MODE_B=4.
    ELSE IF (L_TEMPMODE =2).
    COMPUTE L_MODE_B=5.
    ELSE IF (L_TEMPMODE =1).
    COMPUTE L_MODE_B=6.
    END IF.
  END IF.
*/Where Learner level Expected or Actual CYGLH is greater than or equal to 450, Mode of attendance is Full-time full year.
  IF L_InYr_Expected_GLH GE 450 L_MODE_B=1.
  IF L_InYr_Actual_GLH GE 450 L_MODE_B=1.
END IF.
IF L_ACTIVE=-L_MODE_B=-1
RECODE L_MODE_B(SYSMIS=-1)

VARIABLE LABELS L_MODE_B ' L_MODE_B Learners mode of attendance'.
VALUE LABELS L_MODE_B
 -1 'Not Applicable/Not Known
 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'.

Date last modified: 10th February 2009