LSC
Subscribe Print page

Full Level 2 3 Completers, Achievers and Firstness Data Definition

Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

1 Full level 2 and 3 firstness, achievement and completeness

These variables are relevant from 2007/08 onwards.

The following new DVs are required for calculating full level 2 3 firstness, achievement and completeness.

Purpose

2 These variables define whether the learner is counted as a full level 2 or 3 completer and/or achiever and whether they are a first full level 2 or 3 learner and/or achiever.

Relevant Collections

  • ILR (FE)
  • ILR (UfI)
  • ILR (WBL)
  • ILR (ESFSR)
  • ILR (ACL)

Source Data

3 The following variables are used as source data for the calculation of these variables.

Field Name

Label

Dataset

A_L2WID*

Level 2 width for full level 2 and GCSE aims

A_L3WID*

Level 3 width for full level 3 and As/A2 aims

A_L2CAT

Full level 2 Category

Analytical lad

A_L3CAT

Full level 3 Category

Analytical lad

A_L2PCT

Full level 2 percentage

Analytical lad

A_L3PCT

Full level 3 percentage

Analytical lad

A36

Learning outcome grade

ILR learning aim dataset

GRADE2*

Learning outcome grade (leading space removed)

A35

Learning Outcome

ILR learning aim dataset

A34

Completion Status

ILR learning aim dataset

ACH_QUAL*

Achievement flag

A_L2WID_ACH*

Level 2 Achievement width flag

A_L3WID_ACH*

Level 3 Achievement width flag

A_ATYPE*

DV- TYPE OF AIM

ILR learning aim dataset

A_L2WID_COMP*

Level 2 completetion width flag

A_L3WID_COMP*

Level 3 completetion width flag

L_L2PCT*

Learner full level 2 percentage

L_L3PCT*

Learner full level 3 percentage

L_L2PCT_ACH*

Learner full level 2 percentage achievement

L_L3PCT_ACH*

Learner full level 3 percentage achievement

L_L2PCT_COMP*

Learner full level 2 percentage completion

L_L3PCT_COMP*

Learner full level 3 percentage completion

L35

Prior Attainment Level

ILR Learner dataset


A_L2CAT in Analytical Lad = Level2_entitlement_cat_code in LAD

A_L3CAT in Analytical Lad = Level3_entitlement_cat_code in LAD

A_L2PCT in Analytical Lad = Level2_percentage in LAD

A_L3PCT in Analytical Lad = Level3_Percentage in LAD

* temporary variables used in the calculation.

Derived Variables and Datasets

4 The definition produces the following derived variable(s)

Field Name

Label

Dataset

L_FULLLEVEL2_ACHIEVE

DV- Learner full level 2 achievement

ILR Learner dataset

L_FULLLEVEL3_ACHIEVE

DV- Learner full level 3 achievement

ILR Learner dataset

L_FULLLEVEL2_COMPLETE

DV- Learner full level 2 completion

ILR Learner dataset

L_FULLLEVEL3_COMPLETE

DV- Learner full level 3 completion

ILR Learner dataset

L_FIRST_FULLLEVEL2

DV – Learner first full level 2

ILR Learner dataset

L_FIRST_FULLLEVEL3

DV –Learner first full level 3

ILR Learner dataset

L_FIRST_FULLLEVEL2_ACHIEVE

DV – Learner first full level 2 achievement

ILR Learner dataset

L_FIRST_FULLLEVEL3_ACHIEVE

DV – Learner first full level 3 achievement

ILR Learner dataset




All are numeric set to 1 if the condition is true and 0 if the condition is false. For example if the learner is full level 2 achiever L_FULLLEVEL2_ACHIEVE =1 if not will equal 0.

 

Sample Code

8 The following sample code is available:

Creator

Analysis and MI Team

Date issued

28 September 2006

Date created

11 November 2005

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\DataDefinitions\nat-fulllevel23datadefinition-report-28sep2006.doc

LSC office

Learning and Skills Council
Cheylesmore House Quinton Road Coventry CV1 2WT
T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk/

Last Modified: 28 Sep 06