Skills for Life (SFL) LEITCH Numeracy Data Definition 2009/2010
A_SFL_LEITCH_NUM, L_SFL_LEITCH_NUM
DATA DEFINITION
1. LEITCH Numeracy Skills for Life at aim or learner level.
PURPOSE
2. To identify whether a Skills for Life aim counts as an achievement under the Leitch Numeracy level 1 target.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (UFI)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Skills for Life LEITCH Numeracy.
| Field Name |
Label |
Dataset |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
| A_SFLTY |
A_SFLTY Skills For Life Type |
Aims Standard File |
| A_NOTION |
A_NOTION Notional NVQ Level |
Analytical LAD |
| A_SFL |
A_SFL Counts towards Skills For Life Target |
Aims Standard File |
| A_OPROV |
A_OPROV Aim other provision |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_SFL_LEITCH_NUM |
A_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Aim |
Aims Standard File |
| L_SFL_LEITCH_NUM |
L_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Learner |
Aims Standard File |
VALUES
5. The table below outlines the categories for A_SFL_LEITCH_NUM and L_SFL_LEITCH_NUM
| Value |
Label |
| -1 |
Not Applicable/Not Known* |
| 0 |
No |
| 1 |
Yes |
*Applies to system missing values and where there are non-active aims. Only applicable at learner level.
DETAILED DEFINITION
6. An aim counts towards the LEITCH Numeracy entry level skills for life target where the aim is a Numeracy SFL type (A_SFLTY = 2), the LAD indicates that the Notional NVQ level is Entry (A_NOTION=E), it counts towards the Skills for Life target (A_SFL=1) and it is not other provision (A_OPROV=0).
7. If the learner has any aims that count towards the LEITCH Numeracy target (A_SFL_LEITCH_NUM) then the learner is considered to be a LEITCH Numeracy Skills for Life Learner (L_SFL_LEITCH_NUM = 1). Only aims active in the current academic year are included in the learner level calculation.
Skills for Life (SFL) LEITCH Numeracy Sample Code
1. The following SPSS code is provided to illustrate the SFL LEITCH Numeracy data definition.
A_SFL_LEITCH_NUM L_SFL_LEITCH_NUM
2. The following table shows the steps required to derive A_SFL_LEITCH_NUM L_SFL_LEITCH_NUM
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
N/A |
Set A_SFL_LEITCH_NUM to 0 |
N/A |
| 2 |
Does A_SFLTY = 2
And A_NOTION = “E” And
A_SFL = 1
And A_OPROV = 0 |
Set A_SFL_LEITCH_NUM to 1
Go to 3 |
Go to 3 |
| 3 |
Does L_ACTIVE = 1 |
Go to 4 |
Set L_SFL_LEITCH_NUM to -1 |
| 4 |
Does the learner have any aims where A_SFL_LEITCH_NUM = 1 |
Set L_SFL_LEITCH_NUM to 1 |
Set L_SFL_LEITCH_NUM to 0 |
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_SFL_LEITCH_NUM contain a value |
None |
Set L_SFL_LEITCH_NUM = -1 |
3. The following SPSS code illustrates how to derive A_SFL_LEITCH_NUM, L_SFL_LEITCH_NUM.
|
GET FILE = …………Aims Data set.
SORT CASES BY A09.
MATCH FILES
/FILE = *
/TABLE = …..Analytical LAD data set
/BY A09.
*/The SFL LEITCH Numeracy Flag is set to 1, where the learner is undertaking a SFL LEITCH Numeracy aim.
COMPUTE A_SFL_LEITCH_NUM= 0.
If (A_SFLTY = 2 AND A_NOTION = ‘E’ AND A_SFL =1 AND A_OPROV = 0) A_SFL_LEITCH_NUM = 1.
VARIABLE LABELS A_SFL_LEITCH_NUM – ‘A_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Aim’.
VALUE LABELS A_SFL_LEITCH_NUM
-1 'Not Applicable/Not Known'
0 'No’
1 'yes’.
SELECT IF A_ACTIVE=1.
AGGREGATE
/OUTFILE = '......L_SFL_LEITCH_NUM.SAV'
/PRESORTED
/BREAK = L01 L03
/L_SFL_LEITCH_NUM = max(A_SFL_LEITCH_NUM).
GET FILE '.........Learner data set'.
SORT CASES L01 L03
MATCH FILE
/FILE= *
/TABLE='.... L_SFL_LEITCH_NUM.SAV'
/BY L01 L03.
RECODE L_SFL_LEITCH_NUM(SYSMIS=-1) |
4. The following SQL code illustrates how to derive A_SFL_LEITCH_NUM:
|
select
L01, L03, A05
, case when A_SFLTY = 2 and A_NOTION = 'E' and a.A_SFL = 1 and A_OPROV = 0 then 1
else 0 end as A_SFL_LEITCH_NUM
from
ILR0910_E_AIMS a
join
LAD_0910 b
on a.A09 = b.A09 |
5. The following SQL code illustrates how to derive L_SFL_LEITCH_NUM:
|
select
B.L01, B.L03
, case when L_SFL_LEITCH_NUM_qry is NULL then -1 else L_SFL_LEITCH_NUM_qry end as L_SFL_LEITCH_NUM
from
(
select
L01, L03, count(A05) as aims
, max(A_SFL_LEITCH_NUM) as L_SFL_LEITCH_NUM_qry
from
MISVS001.LSC_MI_db_pub.dbo.ILR0910_L01_AIMS
where A_ACTIVE=1
group by
L01, L03, A_ACTIVE
)T
right outer join
ILR0910_L01_LEARNER B
on T.L01=B.L01 and T.L03=B.L03
order by
B.L01, B.L03 |
Date last modified: 02nd December 2009
