Qualifications and Credit Framework Data Definition 2009/2010
DATA DEFINATION
1. Qualifications and Credit Framework flags for aims and learners.
PURPOSE
2. Identifies learners (and aims) who are part of the Qualifications and Credit Framework. These DVs were previously known as A_FFA and L_FFA.
CURRENT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (ASL)
- ILR (ESF SR)
- ILR (UFI)
SOURCE DATA
3. The following variables are used as source data for the calculation of the Framework for Achievement flags
| Field Name |
Label |
Dataset |
| A_QCF_REF |
A_QCF_REF Qualifications and Credit Framework Reference |
Analytical LAD * |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
* The oracle LAD database still uses the framework for achievement field name of FFA_REF. The data is the same.
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_QCF |
A_QCF Qualifications and Credit Framework Aim |
Aims Standard File |
| L_QCF |
L_QCF Qualifications and Credit Framework Learner |
Learner Standard File |
VALUES
5. The table below outlines the values for A_QCF and L_QCF
| 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 DEFINATION
6. Qualification Credit Framework Aims are identified where there is a corresponding value in the Qualification Credit Framework Reference in the Analytical LAD.
7. At learner level only those active in the current academic year (A_ACTIVE=1) with at least one qualification credit framework aim are considered to be Qualification Credit Framework learners.
SAMPLE CODE
8. The following sample code is available:
- Calculation of the Qualification Credit Framework flags (A_QCF, L_QCF)
Qualification Credit Framework Sample Code
9. The following pseudo code and SPSS code is provided to illustrate the Qualification Credit Framework data definition.
A_QCF, L_QCF
10. The following table shows the steps required to derive A_QCF
| Step |
Condition |
Action if true |
Acton if false |
| 1 |
Does A_QCF_REF have an entry |
Set A_QCF to 1 |
Set A_ QCF to 0 |
11. The following table shows the steps required to derive L_ QCF
| Step |
Condition |
Action if true |
Action if false |
| 1 |
Does A_ACTIVE =1 |
Go to 2 |
Set L_ QCF to -1 |
| 2 |
Does any A_ QCF =1 |
Set L_ QCF to 1 |
Set L_ QCF to 0 |
| Step |
Condition |
Action if true |
Action if false |
| 1 |
Does L_QCF contain a value |
None |
Set L_QCF = -1 |
| 2 |
Does L_ACTIVE = 0 |
Set L_QCF = -1 |
None |
12. The following SPSS code illustrates how to derive A_ QCF and L_ QCF.
|
/* Matches the current working file (aims file) with the Analytical Lad dataset by A09 (Qualification Aim Reference).
GET FILE=’………………….AIMS data set.’.
SORT CASES BY A09.
MATCH FILES /FILE=*
/TABLE=’………………….Analytical LAD data set’
/BY A09.
IF (A_QCF_REF <> “”) A_QCF =1.
SELECT IF A_ACTIVE=1.
VALUE LABELS A_ QCF
-1 ‘Not Applicable/Not Known’
0 ‘No’
1 ‘Yes’.
AGGREGATE OUTFILE=……………L_QCF.SAV
/BREAK=L01 L03
/L_QCF=MAX(A_QCF).
GET FILE ‘…………Learner data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_QCF.SAV’
/BY L01 L03.
RECODE L_QCF(SYSMIS=-1). |
13. The following SQL code illustrates how to derive A_QCF:
|
select
L01, L03 , b.a09 as A09
, case when A_QCF_REF is not null then 1 else 0 end as A_QCF
from
LAD_0910 A
left outer join
ILR0910_E_AIMS B
on A.A09 = B.A09 |
14. The following SQL code illustrates how to derive L_QCF:
|
select
B.L01, B.L03
, case when L_QCF_qry is NULL then -1
else L_QCF_qry end as L_QCF
from
(
select
L01, L03, count(A05) as aims
, max(A_QCF) as L_QCF_qry
from
ILR0910_L01_AIMS
where A_ACTIVE=1
group by
L01, L03
)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 Modified: 02nd December 2009
