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

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 NameLabelDataset
A_ACTIVEA_ACTIVE Aim Active for the current academic yearAims Standard File
A_SFLTYA_SFLTY Skills For Life TypeAims Standard File
A_NOTIONA_NOTION Notional NVQ Level Analytical LAD
A_SFLA_SFL Counts towards Skills For Life TargetAims Standard File
A_SFLTYPA_SFLTYP Skills For Life TypeAnalytical LAD
A_OPROVA_OPROV Aim other provisionAims Standard File
A35A35 Learning OutcomeAims Standard File
A36A36 Learning Outcome GradeAims Standard File

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

Field NameLabelDataset
A_SFL_LEITCH_LIT_ACHA_SFL_LEITCH_LIT_ACH  Leitch Skills For Life Literacy AchieverAims Standard File
L_SFL_LEITCH_LIT_ACHL_SFL_LEITCH_LIT_ACH Leitch Skills For Life Literacy AchieverAims Standard File

VALUES

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

ValueLabel
-1Not Applicable/Not Known*
0No
1Yes

*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

StepConditionAction/Action if trueAction if false
1N/ASet A_SFL_LEITCH_LIT_ACH 0N/A
2Does 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 3Go to 3
3Does A35 = 1 AND A_SFLTYP = 11
And
A36 = ‘D*’, ‘E’, ‘F’, or ‘G’
Set A_SFL_LEITCH_LIT_ACH to 1 go to 4Go to 4
4Does A_SFLTYP = 13 ANDA35 = 2 AND A_NOTION = 1Set A_SFL_LEITCH_LIT_ACH to 1. Go to 5.Go to 5
5Does L_ACTIVE = 1Go to 6 Set
L_SFL_LEITCH_LIT_ACH to -1
6Does the learner have any aims where A_SFL_LEITCH_LIT_ACH = 1Set L_SFL_LEITCH_LIT_ACH to 1Set L_SFL_LEITCH_LIT_ACH to 0

StepConditionAction/Action if trueAction if false
1Does A_SFL_LEITCH_LIT_ACH contain a valueNoneSet A_SFL_LEITCH_LIT_ACH = -1

StepConditionAction/Action if trueAction if false
1Does L_SFL_LEITCH_LIT_ACH contain a valueNoneSet 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.

RECODE A_SFL_LEITCH_LIT_ACH(SYSMIS=-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).


Date last modified: 12th January 2009