Start Period Data Definition 2009/2010
A_STARTP
DATA DEFINITION
1. Indicates the period a learner started the aim.
PURPOSE
2. To enable monitoring of the number of aims that learners started per period over the academic year.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Period a Learner Started the Aim.
| Field Name |
Label |
Dataset |
| A27 |
A27 Learning Start Date |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_STARTP |
A_STARTP - Period Started in |
ER Aims Standard File |
VALUES
5. The table below outlines the categories for A_STARTP
| Value |
Label |
| -99 |
Before 1 August 2009 |
| 1 |
Period 1 |
| 2 |
Period 2 |
| 3 |
Period 3 |
| 4 |
Period 4 |
| 5 |
Period 5 |
| 6 |
Period 6 |
| 7 |
Period 7 |
| 8 |
Period 8 |
| 9 |
Period 9 |
| 10 |
Period 10 |
| 11 |
Period 11 |
| 12 |
Period 12 |
| 99 |
After 1 August 2010 |
| -1 |
Not Applicable/Not Known |
DETAILED DEFINITION
6. If the Learning Start Date (A27) of the aim occurs during the period, then that period is determined to be the period that the aim started in.
Start Period Sample Code
1. The following SPSS code is provided to illustrate the Start Period data definition.
A_STARTP
2. The following table shows the steps required to derive A_STARTP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A27< 1 Aug Current Academic year |
Set A_STARTP to -99 |
Go to 2 |
| 2 |
Is A27> 31 Jul Current Academic year + 1 |
Set A_STARTP to 99 |
Go to 3 |
| 3 |
Is the month of A27 = Aug |
Set A_STARTP to 1 |
Go to 4 |
| 4 |
Is the month of A27 = Sep |
Set A_STARTP to 2 |
Go to 5 |
| 5 |
Is the month of A27 = Oct |
Set A_STARTP to 3 |
Go to 6 |
| 6 |
Is the month of A27 = Nov |
Set A_STARTP to 4 |
Go to 7 |
| 7 |
Is the month of A27 = Dec |
Set A_STARTP to 5 |
Go to 8 |
| 8 |
Is the month of A27 = Jan |
Set A_STARTP to 6 |
Go to 9 |
| 9 |
Is the month of A27 = Feb |
Set A_STARTP to 7 |
Go to 10 |
| 10 |
Is the month of A27 = Mar |
Set A_STARTP to 8 |
Go to 11 |
| 11 |
Is the month of A27 = Apr |
Set A_STARTP to 9 |
Go to 12 |
| 12 |
Is the month of A27 = May |
Set A_STARTP to 10 |
Go to 13 |
| 13 |
Is the month of A27 = Jun |
Set A_STARTP to 11 |
Go to 14 |
| 14 |
Is the month of A27 = Jul |
Set A_STARTP to 12 |
|
| Step |
Condition |
Action if true |
Action if false |
| 1 |
Does A_STARTP contain a value |
None |
Set A_STARTP = -1 |
3. The following SPSS code illustrates how to derive A_STARTP.
|
GET FILE=’……….Aims dataset’.
IF A27 < DATE.DMY(1,8, current academic year) A_STARTP=-99.
DO IF XDATE.YEAR(A27)=current academic year.
IF XDATE.MON(A27)=8 A_STARTP=1.
IF XDATE.MON(A27)=9 A_STARTP=2.
IF XDATE.MON(A27)=10 A_STARTP=3.
IF XDATE.MON(A27)=11 A_STARTP=4.
IF XDATE.MON(A27)=12 A_STARTP=5.
ELSE IF XDATE.YEAR(A27)=current academic year+1.
IF XDATE.MON(A27)=1 A_STARTP=6.
IF XDATE.MON(A27)=2 A_STARTP=7.
IF XDATE.MON(A27)=3 A_STARTP=8.
IF XDATE.MON(A27)=4 A_STARTP=9.
IF XDATE.MON(A27)=5 A_STARTP=10.
IF XDATE.MON(A27)=6 A_STARTP=11.
IF XDATE.MON(A27)=7 A_STARTP=12.
END IF.
IF A27 > DATE.DMY(31,7, current academic year+1) A_STARTP=99.
RECODE A_STARTP (SYSMIS=-1).
VARIABLE LABELS A_STARTP "A_STARTP Period Started in".
VALUE LABELS A_STARTP -99 "Before 1 August current academic year”
1 "Period 1"
2 "Period 2"
3 "Period 3"
4 "Period 4"
5 "Period 5"
6 "Period 6"
7 "Period 7"
8 "Period 8"
9 "Period 9"
10 "Period 10"
11 "Period 11"
12 "Period 12"
99 “After 31 July current academic year “
-1 ‘Not Applicable/Not Known’. |
4. The following SQL code illustrates how to derive A_STARTP:
|
select
L01, L03, A05
, case when A27<'1 august 2009' then -99
when A27>'31 july 2010' then 99
when datepart(month,A27)=8 then 1
when datepart(month,A27)=9 then 2
when datepart(month,A27)=10 then 3
when datepart(month,A27)=11 then 4
when datepart(month,A27)=12 then 5
when datepart(month,A27)=1 then 6
when datepart(month,A27)=2 then 7
when datepart(month,A27)=3 then 8
when datepart(month,A27)=4 then 9
when datepart(month,A27)=5 then 10
when datepart(month,A27)=6 then 11
when datepart(month,A27)=7 then 12
else -1 end as A_STARTP
from
ILR0910_E_AIMS |
Date last modified: 02nd December 2009
