Skills for Life (SFL) LEITCH Literacy Achievers Data Definition 2009/2010

A_SFL_LEITCH_LIT_ACH, L_SFL_LEITCH_LIT_ACH

DATA DEFINITION

1. LEITCH Literacy Skills for Life achievement at aim or learner level.

PURPOSE

2. To identify whether a Skills for Life aim counts as an achievement under 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 Achievers

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_SFLTYP	A_SFLTYP Skills For Life Type	Analytical LAD
A_OPROV	A_OPROV Aim other provision	Aims Standard File
A35	A35 Learning Outcome	Aims Standard File
A36	A36 Learning Outcome Grade	Aims Standard File

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

Field Name	Label	Dataset
A_SFL_LEITCH_LIT_ACH	A_SFL_LEITCH_LIT_ACH Leitch Skills For Life Literacy Achiever	Aims Standard File
L_SFL_LEITCH_LIT_ACH	L_SFL_LEITCH_LIT_ACH Leitch Skills For Life Literacy Achiever	Aims Standard File

VALUES

5. The table below outlines the categories for A_SFL_LEITCH_LIT_ACH and L_SFL_LEITCH_LIT_ACH

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

Aim level
6. An aim counts towards the LEITCH Literacy level 1 skills for life achievement target where:

7. 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), it is not other provision (A_OPROV=0) and the aim has been Achieved (A35=1).

8. The LAD indicates that the aim is an English Language GCSE (A_SFLTYP=11) that has been Achieved (A35=1) at level 1 (grades D to G).

9. The LAD indicates that the aim is a Key skills (A_SFLTYP=13) that has been Partially Achieved (A35=2) at level 1 (A_NOTION=1).

Learner level
10. If the learner has any aims that count towards the LEITCH Literacy Achievement target (A_SFL_LEITCH_LIT_ACH) then the learner is considered to be a LEITCH Literacy Skills for Life Achievement Learner (L_SFL_LEITCH_LIT_ACH = 1). Only those aims that are Active in the current academic year (A_ACTIVE=1) are included in the learner level calculation.

Skills for Life (SFL) LEITCH Literacy Achievers Sample Code

1. The following SPSS code is provided to illustrate the SFL LEITCH Literacy Achievers data definition.

A_SFL_LEITCH_LIT_ACH L_SFL_LEITCH_LIT_ACH

2. The following table shows the steps required to derive A_SFL_LEITCH_LIT_ACH L_SFL_LEITCH_LIT_ACH

Step	Condition	Action/Action if true	Action if false
1	N/A	Set A_SFL_LEITCH_LIT_ACH 0	N/A
2	Does A_SFLTY = 1, or 3 And A_NOTION = 1 And A_SFL = 1 And A_OPROV = 0 And A35 = 1	Set A_SFL_LEITCH_LIT_ACH to 1 go to 3	Go to 3
3	Does A35 = 1 AND A_SFLTYP = 11 And A36 = ‘D*’, ‘E’, ‘F’, or ‘G’	Set A_SFL_LEITCH_LIT_ACH to 1 go to 4	Go to 4
4	Does A_SFLTYP = 13 ANDA35 = 2 AND A_NOTION = 1	Set A_SFL_LEITCH_LIT_ACH to 1. Go to 5.	Go to 5
5	Does L_ACTIVE = 1	Go to 6	Set L_SFL_LEITCH_LIT_ACH to -1
6	Does the learner have any aims where A_SFL_LEITCH_LIT_ACH = 1	Set L_SFL_LEITCH_LIT_ACH to 1	Set L_SFL_LEITCH_LIT_ACH to 0

Step	Condition	Action/Action if true	Action if false
1	Does L_SFL_LEITCH_LIT_ACH contain a value	None	Set L_SFL_LEITCH_LIT_ACH = -1

3. The following SPSS code illustrates how to derive A_SFL_LEITCH_LIT_ACH, L_SFL_LEITCH_LIT_ACH.

GET FILE = …………Aims Data set.
SORT CASES BY A09.
MATCH FILES 
   /FILE = *
   /TABLE = …..Analytical LAD data set 
   /BY A09. 
*/If the learner has achieved the aim, the SFL LEITCH Literacy Achievement Flag is set to 1. 
COMPUTE A_SFL_LEITCH_LIT_ACH = 0.
If (Any(A_SFLTY,1,3) AND A_NOTION = 1 AND A_SFL = 1 AND A_OPROV = 0 AND A35 = 1) A_SFL_LEITCH_LIT_ACH = 1.
*/Set GCSE English achieved at grades D to G to 1. 
Compute a36 = LTRIM (a36, " ").
COMPUTE grade = SUBSTR (a36, 1, 1).
IF (a35 = 1 AND any(a_sfltyp,"11") AND ANY (grade, "D", "E", "F", "G")) A_SFL_LEITCH_LIT_ACH = 1.
*/If the learner has partially achieved Key skills in comunication at level 1 the aim is treated as achieved. 
IF (A_ACTIVE = 1 AND A35 = 2 and A_SFLTYP = "13" and A_NOTION = 1) A_SFL_LEITCH_LIT_ACH = 1.

VARIABLE LABELS A_SFL_LEITCH_LIT_ACH – ‘A_SFL_LEITCH_LIT_ACH Leitch Skills For Life Literacy Achiever’
VALUE LABELS A_SFL_LEITCH_LIT_ACH
   -1 'Not Applicable/Not Known'
    0 'No’
    1 'Yes’
SELECT IF A_ACTIVE=1.
AGGREGATE
  /OUTFILE = '........L_SFL_LEITCH_LIT_ACH.SAV' 
  /PRESORTED
  /BREAK = L01 L03
  /L_SFL_LEITCH_LIT_ACH = max(A_SFL_LEITCH_LIT_ACH)

GET FILE '......Learner data set'

SORT CASES L01 L03
MATCH FILE
/FILE= *
/TABLE='...L_SFL_LEITCH_LIT_ACH.SAV'
/BY L01 L03.

RECODE L_SFL_LEITCH_LIT_ACH(SYSMIS=-1).

4. The following SQL code illustrates how to derive A_SFL_LEITCH_LIT_ACH:

select L01, L03, A05 , case when A_SFLTY in (1, 3) and A_NOTION = '1' and a.A_SFL = 1 and A_OPROV = 0 and A35 = 1 then 1 when A35 = 1 and b.A_SFLTYP = '11' and A36 in ('D' , 'E' , 'F' , 'G') then 1 when b.A_SFLTYP = '13' and A35 = 2 and A_NOTION = '1' then 1 else 0 end as A_SFL_LEITCH_LIT_ACH from dbo.ILR0910_E_AIMS a join dbo.LAD_0910 b on a.A09 = b.A09

select

     L01, L03, A05
     , case when A_SFLTY in (1, 3) and A_NOTION = '1' and a.A_SFL = 1 and A_OPROV = 0 and A35 = 1 then 1
     when A35 = 1 and b.A_SFLTYP = '11' and A36 in ('D' , 'E' , 'F' , 'G') then 1
     when b.A_SFLTYP = '13' and A35 = 2 and A_NOTION = '1' then 1
     else 0 end as A_SFL_LEITCH_LIT_ACH

from

     dbo.ILR0910_E_AIMS a
     join
     dbo.LAD_0910 b

on a.A09 = b.A09

5. The following SQL code illustrates how to derive L_SFL_LEITCH_LIT_ACH:

select B.L01, B.L03 , case when L_SFL_LEITCH_LIT_ACH_qry is NULL then -1 else L_SFL_LEITCH_LIT_ACH_qry end as L_SFL_LEITCH_LIT_ACH from ( select L01, L03, count(A05) as aims , max(A_SFL_LEITCH_LIT_ACH) as L_SFL_LEITCH_LIT_ACH_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

select

B.L01, B.L03
, case when L_SFL_LEITCH_LIT_ACH_qry is NULL then -1 else L_SFL_LEITCH_LIT_ACH_qry end as L_SFL_LEITCH_LIT_ACH

from
(
select

L01, L03, count(A05) as aims
, max(A_SFL_LEITCH_LIT_ACH) as L_SFL_LEITCH_LIT_ACH_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