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

A_SFL_LEITCH_NUM_ACH, L_SFL_LEITCH_NUM _ACH

DATA DEFINITION

1. LEITCH Numeracy Achievement 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 Entry level 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 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_OPROV	A_OPROV Aim other provision	Aims Standard File
A35	A35 Learning Outcome	Aims Standard File

DERIVED VARIABLES AND DATASETS

4. The definition produces the following derived variable(s)

Field Name	Label	Dataset
A_SFL_LEITCH_NUM _ACH	A_SFL_LEITCH_NUM_ACH Leitch Skills For Life Numeracy Achiever	Aims Standard File
L_SFL_LEITCH_NUM _ACH	L_SFL_LEITCH_NUM_ACH Leitch Skills For Life Numeracy Achiever	Aims Standard File

VALUES

5. The table below outlines the categories for A_SFL_LEITCH_NUM_ACH and L_SFL_LEITCH_NUM_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 Numeracy Entry level skills for life achievement 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), it is not other provision (A_OPROV=0) and the aim has been Achieved (A35=1).

Learner Level
7. If the learner has any aims that count towards the LEITCH Numeracy Achievement target (A_SFL_LEITCH_NUM_ACH) then the learner is considered to be a LEITCH Numeracy Skills for Life Achievement Learner (L_SFL_LEITCH_NUM_ACH = 1). Only aims that are Active in the current academic year (A_ACTIVE=1) are included in the calculation.

Skills for Life (SFL) LEITCH Numeracy Achievers Sample Code

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

A_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH

2. The following table shows the steps required to derive A_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH

Step	Condition	Action/Action if true	Action if false
1	N/A	Set A_SFL_LEITCH_NUM_ACH to 0	N/A
2	Does A_SFLTY = 2 And A_NOTION = “E” And A_SFL = 1 And A_OPROV = 0 And A35 = 1	Set A_SFL_LEITCH_NUM_ACH to 1. Go to 3	Go to 3
3	Does L_ACTIVE = 1	Go to 4.	Set L_SFL_LEITCH_NUM_ACH to -1
4	Does the learner have any aims where A_SFL_LEITCH_NUM_ACH = 1	Set L_SFL_LEITCH_NUM_ACH to 1	Set L_SFL_LEITCH_NUM_ACH to 0

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

3. The following SPSS code illustrates how to derive A_SFL_LEITCH_NUM_ACH, L_SFL_LEITCH_NUM_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 Numeracy Achievement Flag is set to 1.
COMPUTE A_SFL_LEITCH_NUM_ACH = 0.
If (A_ACTIVE = 1 AND A_SFLTY = 2 AND A_NOTION = ‘E’ AND A_SFL =1 AND A_OPROV = 0 AND A35 = 1) A_SFL_LEITCH_NUM_ACH = 1.

VARIABLE LABELS A_SFL_LEITCH_NUM_ACH – ‘LEITCH SKILLS FOR LIFE NUMERACY ACHIEVER’
VALUE LABELS A_SFL_LEITCH_NUM_ACH
 -1 'Not Applicable/Not Known'
  0 'No’
  1 'Yes’
SELECT IF A_ACTIVE=1.
SORT CASES L01 L03.
AGGREGATE
  /OUTFILE = '........L_SFL_LEITCH_NUM_ACH.SAV' 
  /PRESORTED
  /BREAK = L01 L03
  /L_SFL_LEITCH_NUM_ACH = max(A_SFL_LEITCH_NUM_ACH) 
GET FILE '...........Learner data set'.

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

RECODE L_SFL_LEITCH_NUM_ACH(SYSMIS=-1).

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

select L01, L03, A05 , case when A_SFLTY = 2 and A_NOTION = 'E' and a.A_SFL = 1 and A_OPROV = 0 and A35 = 1 then 1 else 0 end as A_SFL_LEITCH_NUM_ACH from ILR0910_E_AIMS a join LAD_0910 b on a.A09 = b.A09

select

     L01, L03, A05
     , case when A_SFLTY = 2 and A_NOTION = 'E' and a.A_SFL = 1 and A_OPROV = 0 and A35 = 1 then 1
     else 0 end as A_SFL_LEITCH_NUM_ACH

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_ACH:

select B.L01, B.L03 , case when L_SFL_LEITCH_NUM_ACH_qry is NULL then -1 else L_SFL_LEITCH_NUM_ACH_qry end as L_SFL_LEITCH_NUM_ACH from ( select L01, L03, count(A05) as aims , max(A_SFL_LEITCH_NUM_ACH) as L_SFL_LEITCH_NUM_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_NUM_ACH_qry is NULL then -1 else L_SFL_LEITCH_NUM_ACH_qry end as L_SFL_LEITCH_NUM_ACH

from
(
select

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