Skills for Life (SFL) LEITCH Literacy Data Definition 2009/2010
A_SFL_LEITCH_LIT, L_SFL_LEITCH_LIT
DATA DEFINITION
1. LEITCH Literacy Skills for Life at aim or learner level.
PURPOSE
2. To identify whether an aim or learner counts as participation towards the Leitch Literacy 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 Literacy.
| 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_LIT |
A_SFL_LEITCH_LIT Leitch Skills for Life Literacy aim |
Aims Standard File |
| L_SFL_LEITCH_LIT |
L_SFL_LEITCH_LIT Leitch Skills For Life Literacy Learner |
Aims Standard File |
VALUES
5. The table below outlines the categories for A_SFL_LEITCH_LIT and L_SFL_LEITCH_LIT.
| 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 Literacy level 1 skills for life target where the aim is a literacy or language SFL type (A_SFLTY = 1 or 3), the LAD indicates that the Notional NVQ level is 1 (A_NOTION=1), 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 Literacy target (A_SFL_LEITCH_LIT) then the learner is considered to be a LEITCH Literacy Skills for Life Learner (L_SFL_LEITCH_LIT = 1). Only aims active in the current academic year are included in the learner level calculation.
Skills for Life (SFL) LEITCH Literacy Sample Code
1. The following SPSS code is provided to illustrate the SFL LEITCH Literacy data definition.
A_SFL_LEITCH_LIT L_SFL_LEITCH_LIT
2. The following table shows the steps required to derive A_SFL_LEITCH_LIT, L_SFL_LEITCH_LIT
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
N/A |
Set A_SFL_LEITCH_LIT 0 |
N/A |
| 2 |
Does A_SFLTY = 1, or 3 And
A_NOTION = 1
And A_SFL = 1 And A_OPROV = 0 |
Set A_SFL_LEITCH_LIT to 1 go to 3 |
Go to 3 |
| 3 |
Does A_ACTIVE = 1 |
Go to 4 |
Set L_SFL_LEITCH_LIT to
-1 |
| 4 |
Does the learner have any aims where A_SFL_LEITCH_LIT = 1 |
Set L_SFL_LEITCH_LIT to 1 |
Set L_SFL_LEITCH_LIT to 0 |
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_SFL_LEITCH_LIT contain a value |
None |
Set L_SFL_LEITCH_LIT = -1 |
3. The following SPSS code illustrates how to derive A_SFL_LEITCH_LIT, L_SFL_LEITCH_LIT.
| GET FILE = …………Aims Data set.
SORT CASES BY A09.
MATCH FILES
/FILE = *
/TABLE = …..Analytical LAD data set
/BY A09.
*/The SFL LEITCH Literacy Flag is set to 1, where the learner is undertaking a SFL LEITCH Literacy aim.
COMPUTE A_SFL_LEITCH_LIT = 0.
If (Any(A_SFLTY,1,3) AND A_NOTION = 1 AND A_SFL =1 AND A_OPROV = 0) A_SFL_LEITCH_LIT = 1.
VARIABLE LABELS A_SFL_LEITCH_LIT – ‘A_SFL_LEITCH_LIT Leitch Skills for Life Literacy Aim’.
VALUE LABELS A_SFL_LEITCH_LIT
-1 'Not Applicable/Not Known'
0 'No’
1 'Yes’.
SELECT IF A_ACTIVE=1.
SORT CASES L01 L03
AGGREGATE
/OUTFILE = '.......L_SFL_LEITCH_LIT.SAV
/PRESORTED
/BREAK = L01 L03
/L_SFL_LEITCH_LIT = max(A_SFL_LEITCH_LIT).
GET FILE '.........Learner data set'.
SORT CASES L01 L03
MATCH FILE
/FILE= *
/TABLE='......L_SLF_LEITCH_LIT.SAV'
/BY L01 L03
RECODE L_SFL_LEITCH_LIT (SYSMIS=-1) |
4. The following SQL code illustrates how to derive A_SFL_LEITCH_LIT:
|
select
L01, L03, A05
, case when A_SFLTY in (1, 3) and A_NOTION = '1' and a.A_SFL = 1 and A_OPROV = 0 then 1
else 0 end as A_SFL_LEITCH_LIT
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_LIT:
|
select
B.L01, B.L03
, case when L_SFL_LEITCH_LIT_qry is NULL then -1 else L_SFL_LEITCH_LIT_qry end as L_SFL_LEITCH_LIT
from
(
select
L01, L03, count(A05) as aims
, max(A_SFL_LEITCH_LIT) as L_SFL_LEITCH_LIT_qry
from
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
