Provision Mix Matrix Summary Data Definition 2009/2010
A_FE_PROVMIX_MATRIX_SUMM
DEFINITION
1. Higher Level Provision Mix Matrix Category. Replaces the Provision Mix as from 2007/08.
PURPOSE
2. The aim of this variable is to support the Planning Cycle, the LSC has established a Corporate Language of mix of provision.
3. Assigns the value for the High level Provision Mix Category (A_FE_PROVMIX_SUMM) to each aim that is in the aims standard files.
CURRENT COLLECTIONS
- ILR (LR)
- ILR (ASL)
- ILR (UfI)
- ILR (ER)
- ILR (ESF SR)
SOURCE DATA
4. The following variables are used as source data for the calculation of High Level Provision Mix category.
| Field Name |
Label |
Dataset |
A_FE_PROVMIX
_MATRIX |
A_FE_PROVMIX_MATRIX Provision Mix Matrix |
ILR Learning Aims Dataset |
DERIVED VARIABLES AND DATASETS
5. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
A_FE_PROVMIX_
MATRIX_SUMM |
A_FE_PROVMIX_MATRIX_SUMM FE Provision Mix Matrix Summary |
Aims Standard File |
VALUES
6. The table below outlines the categories for A_FE_PROVMIX_MATRIX_SUMM
A_FE_PROVMIX_
MATRIX_SUMM Value |
Label |
| 1 |
Category 1 - Foundation Learning Tier (level 1 and entry - excluding level 1 and entry Skills for Life) |
| 2 |
Category 2 - Skills for Life outside of section 96/97 |
| 3.1 |
Category 3a - Skills for Life within section 96/97 |
| 3.2 |
Category 3b - aims that directly contribute to full level 2 target |
| 3.3 |
Category 3c - aims that directly contribute to full level 3 target |
| 4.2 |
Category 4a - level 2 aims that do not contribute to full level 2 target |
| 4.3 |
Category 4b - level 3 aims that do not contribute to full level 3 target |
| 5 |
Category 5 - level 4 aims |
| 6 |
Category 6 - level not classified |
PROVISION MIX MATRIX SUMMARY SAMPLE CODE
1. The following SPSS code is provided to illustrate the High level Provision Mix Matrix Summary data definition.
A_FE_PROVMIX_MATRIX_SUMM
2. The following table shows the steps required to derive A_FE_PROVMIX_MATRIX_SUMM
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set
A_FE_PROVMIX_
MATRIX_SUMM
to 0 |
Go to 2 |
| 2 |
DOES A_FE_PROVMIX_MATRIX = (1,2,11 or 12) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 1 |
Go to 3 |
| 3 |
DOES A_FE_PROVMIX_MATRIX = (112,122 or 132) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 2 |
Go to 4 |
| 4 |
DOES A_FE_PROVMIX_MATRIX = (111, 110, 121, 120, 130 or 131) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 3.1 |
Go to 5 |
| 5 |
DOES A_FE_PROVMIX_MATRIX = (25 or 26) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 3.2 |
Go to 6 |
| 6 |
DOES A_FE_PROVMIX_MATRIX = (35,36 or 39) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 3.3 |
Go to 7 |
| 7 |
DOES A_FE_PROVMIX_MATRIX = (21 or 22) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 4.2 |
Go to 8 |
| 8 |
DOES A_FE_PROVMIX_MATRIX = (31or 32) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 4.3 |
Go to 9 |
| 9 |
DOES A_FE_PROVMIX_MATRIX = (41 or 42) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 5 |
Go to 10 |
| 10 |
DOES A_FE_PROVMIX_MATRIX = (70 or 999) |
Set A_FE_PROVMIX
_MATRIX_SUMM to 6 |
Set A_FE_PROVMIX_
MATRIX_SUMM to 0. |
3. The following SPSS code illustrates how to derive A_FE_PROVMIX_MATRIX_SUMM.
|
**********************************************************************.
**Define high level version of provision mix matrix used in autumn performance review**.
**********************************************************************.
COMPUTE A_FE_PROVMIX_MATRIX_SUMM=0.
DO IF ANY(A_FE_PROVMIX_MATRIX,1,2,11,12).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=1.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,112,122,132).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=2.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,111,110,121,120,131,130).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=3.1.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,25,26).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=3.2.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,35,36,39).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=3.3.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,21,22).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=4.2.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,31,32).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=4.3.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,41,42).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=5.
ELSE IF ANY(A_FE_PROVMIX_MATRIX,70,998,999).
+COMPUTE A_FE_PROVMIX_MATRIX_SUMM=6.
END IF.
VARIABLE LABELS A_FE_PROVMIX_MATRIX_SUMM 'FE Provision
Mix Matrix Summary'.
VALUE LABELS A_FE_PROVMIX_MATRIX_SUMM
1 'Foundation Learning Tier'
2 'Skills For Life - Non Accredited'
3.1 'Skills For Life - Target'
3.2 'Level 2 - Directly contributes to full level 2 threshold'
3.3 'Level 3 - Directly contributes to full level 3 threshold'
4.2 'Level 2 - Does not directly contribute to full level 2 threshold'
4.3 'Level 3 - Does not directly contribute to full level 3 threshold'
5 'Level 4'
6 'Level not classified'.
|
4. The following SQL code illustrates how to derive A_FE_PROVMIX_MATRIX_SUMM:
|
select
L01, L03, A05
, case when A_FE_PROVMIX_MATRIX in (1,2,11,12) then 1
when A_FE_PROVMIX_MATRIX in (112,122,132) then 2
when A_FE_PROVMIX_MATRIX in (111,110,121,120,130,131) then 3.1
when A_FE_PROVMIX_MATRIX in (25,26) then 3.2
when A_FE_PROVMIX_MATRIX in (35,36,39) then 3.3
when A_FE_PROVMIX_MATRIX in (21,22) then 4.2
when A_FE_PROVMIX_MATRIX in (31,32) then 4.3
when A_FE_PROVMIX_MATRIX in (41,42) then 5
when A_FE_PROVMIX_MATRIX in (70,999) then 6
else 0 end as A_FE_PROVMIX_MATRIX_SUMM
from
ILR0910_E_AIMS a
join
LAD_0910 b
on a.A09 = b.A09 |
Date last modfied: 07th December 2009
