INYEAR_COURSE_PROP
DATA DEFINITION
1. Proportion of the total days on the learning aim that are within the current academic year
SOURCE DATA
2. The following variables are used as source data for the calculation of INYEAR_COURSE_PROP.
| Field Name |
Label |
Dataset |
| Current_year_start |
Start date of the current year (eg 1 August 2006 for 2006/07) |
|
| Current_year_end |
End date of the current year (eg 31 July 2007 for 2006/07) |
|
| Total_course_length |
Total length of the learning aim in days |
|
| Prior_course_length |
Number of days on learning aim prior to the start of the current year |
|
| Post_course_length |
Planned number of days on the learning aim after the end of the current year |
|
| Inyear_course_length |
Number of days on the learning aim the occur within the current academic year |
|
DERIVED VARIABLES AND DATASETS
3. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| INYEAR_COURSE_PROP |
Proportion of the total days on the learning aim that are within the current academic year |
|
| prev_INYEAR_COURSE_PROP |
Proportion of the total days on the learning aim that are within the pasr 3 academic years. |
|
INYEAR_COURSE_PROP Sample Code
1. The following SPSS code is provided to illustrate the INYEAR_COURSE_PROP data definition.
INYEAR_COURSE_PROP
2. The following table shows the steps required to derive INYEAR_COURSE_PROP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
n/a |
Set CURRENT_YEAR_START to the 1 August of the current academic year (eg 1/08/06) for 2006/7 then go to 2 |
n/a |
| 2 |
n/a |
Set CURRENT_YEAR_END to the 31 July of the current academic year (eg 31/07/07) for 2006/7 then go to 3 |
n/a |
| 3 |
n/a |
Set TOTAL_COURSE_LENGTH to the number of days between the Learning Planned End Date (A28) and the Learning start date (A27) + 1 day then go to 4 |
n/a |
| 4 |
Is the Learning aim start date before the start of the current year (CURRENT_YEAR
_START > A27) |
Set PRIOR_COURSE_LENGTH to the greater of zero or the number of days between CURRENT_YEAR_START and A27 then go to 5 |
Set PRIOR_COURSE_
LENGTH To 0Go to 5 |
| 5 |
Is the Learning planned end date after the end of the current year. (CURRENT_YEAR_END < A28) |
Set POST_COURSE_LENGTH to the greater of zero or the number of days between A28 and CURRENT_YEAR_END A28 then go to 6 |
Set POST_COURSE_
LENGTH To 0 GO to 6 |
| 6 |
n/a |
Set INYEAR_COURSE_LENGTH to the greater of zero or (TOTAL_COURSE_LENGTH – PRIOR_COURSE_LENGTH – POST_COURSE_LENGTH) go to 7 |
n/a |
| 7 |
n/a |
Set INYEAR_COURSE_PROP to INYEAR_COURSE_LENGTH / TOTAL_COURSE_LENGTH go to 8 |
n/a |
| 8 |
DOES Learning outcome = achieved and is the learning actual end date in the current year (A35 = 1 A31 < =CURRENT_YEAR_END AND A31 > =CURRENT_YEAR
_START) |
Set INYEAR_COURSE_PROP to (INYEAR_COURSE_LENGTH + POST_COURSE_LENGTH) / TOTAL_COURSE_LENGTH go to 9 |
Go to 9 |
| 9 |
n/a |
End |
n/a |
3. The following SPSS code illustrates how to derive INYEAR_COURSE_PROP.
|
Compute current_year_start = date.dmy(1, 8, CURRENT ACADEMIC YEAR).
Compute current_year_end = date.dmy(31, 7, CURRENT ACADEMIC YEAR+1).
FORMAT current_year_start current_year_end (DATE11).
COMPUTE total_course_length = DATEDIFF(a28,a27,"days")+1 .
IF (current_year_start>a27) prior_course_length = MAX(0,DATEDIFF(current_year_start,a27,"days")).
IF (current_year_end<a28) post_course_length = MAX(0,DATEDIFF(a28,current_year_end,"days")).
RECODE prior_course_length post_course_length (SYSMIS = 0) (else = copy).
COMPUTE inyear_course_length = MAX(0,total_course_length - prior_course_length - post_course_length).
COMPUTE inyear_course_prop = inyear_course_length / total_course_length.
IF (a35 = 1 and a31 <= current_year_end and a31 >= current_year_start) inyear_course_prop = (inyear_course_length + post_course_length) / total_course_length.
*just as inyear_course_prop is derived, three more variables namely inyear_course_prop1, inyear_course_prop2 and inyear_course_prop3 are derived using dates of the previous three academic years respectively.
*prev_inyear_course_prop is then derived using the above 3 variables.
COMPUTE prev_inyear_course_prop = inyear_course_prop1 + inyear_course_prop2 + inyear_course_prop3. |
Date last modfied: 09th March 2010
