Exam Results and Monitoring Notes about results files 2003 -

Exam Results and Monitoring

Index for Exam Results and Monitoring
- Notes about results files 2003

Updates

20.08.03	Note about field LVC clarified
23.07.03	Note about field LSC corrrected
08.06.03	Stats removed from Year 13 results in 2003 IB TOK and Diploma added. Field 'exams' added to CSV file for A-level NO printed or Word versions of Year 13 results will be availavle in 2003 GCSE Results will be available in Word, text and CSV formats as usual Scottish ex
29.08.02	Gender Codes Bg, Gb, C, Cs, dropped. M (mixed) added.
13.08.02	Word files will be available for Year13 and GCSE. Confirmation that Scottish results will not be available in this new format - traditional printed results will be available.
08.08.02	Points scheme tariffs added.
08.08.02	Explanation of AAL, AAS, GAL added. GAG corrrected.
07.08.03	The csv file for Year 13 exam now includes more details about the numbers of candidates.

Introduction

For Sample files see files.htm. Choose 2002 files for GCSE, because the 2003 format is the same as that used in 2002. For Year 13 results, choose file ATX04X.csv.

There will be major changes in the way that files will be made available this year. New format files will be available for Year 13 (GCE, VCE and IB) exams and Year 11 (GCSE) exams. Scottish Results will not be coverted to the new format this year.

This paragraph refers to GCSE only : A text file with tab separated columns suitable for dropping into a word processor will enable users to print copies of lists for themselves. Word Files will also be availablefor printing. These lists will contain only limited statistical information and will not be suitable for loading into spreadsheets.

Text are Word files will NOT be available for Year 13 results.

There will be csv files with data suitable for loading into spreadsheets. The GCSE files will be the same as in 2002. The Year 13 files will NOT contain points statistics. Details of IB Theory of Knowledge and the number of candidates awarded the Diploma have been added.

The notes below refer to the structure of the csv files.

FILE NAMING CONVENTION

eg ABGTX03.csv (a csv file). The corresponding text file would be called ABGT03.txt
The name of the file is made up as follows:
The first character is one of: A - Year 13, G - GCSE or S - Scotland
Then follows some combination of B G T, indicating that the file contains results for : B - Boys, G - Girls and/or T - Totals - i.e. Boys and Girls results combined.
The following character (X in example) defines the version. MAKE SURE YOU USE CORRECT VERSION
The two subsequent digits indicate the year.
If 'X' follows the two digits, points statistics are not present.

The first editions of the results files issued in August, are for the total number of candidates for each school. Files with Boys and Girls results shown separately are published no earlier than mid-September.

FIELDS

The csv file contains field names in the first line of data. The first six fields give data about the school. Subsequent fields give data about exam results.
ref: The ISC 4 digit reference number between 0002-1599
name: Usually the name of the school, but sometimes slightly modifed for the purpose of exam results.
town - the postal town of the school
county - the data in this field will normally be a county name but other areas, as customarily used by ISC, eg. Merseyside Area are sometimes used.
assoc - GSA, HMC, ISA or SHMIS
type - type of school B (all Boys), G (all Girls), M (Mixed). Please note that the codes B, G, M refer to the mix of boys and girls for the exams in the list.
exams - Exams taken (Year 13) G (GCE), V (VCE), I (IB)

EXAMS

Each of the exam types recorded in the tables is allocated a three letter code which is used as part of the definitions of fields connected with exam statistics. These codes are listed here:

YEAR 13
ALG - GCE A-level excl. General Studies
ASG - GCE AS-level excl. General Studies
GAS - GCE A and AS level excl. General Studies

GLG - GCE A-level General Studies ONLY
GSG - GCE AS-level General Studies ONLY
GAG - GCE A and AS level General Studies ONLY

AAL - GCE A-level incl. General Studies
AAS - GCE AS-level incl. General Studies
GAL - GCE A and AS level including General Studies

VLG - VCE A-level ONLY
VSG - VCE AS-level ONLY
VAG - VCE A and AS level ONLY

IHG - IB, Higher Level
ISG - IB, Standard Level
IBT - All International Baccalaureate results
ITK - International Baccalaureate Theory of Knowledge
IDI - International Baccalaureate Diploma

YEAR 11 (GCSE)
GCG - Full Courses
GCS - Short Courses
GFS - Combined Full and Short Courses

Scottish
Scottish results will be published in the traditional way until time is found to upgrade to the new method.

Year 13 Candidates

eg lsct03C

Candidates for whom results are given in the tables will have sat some combination of the exams mentioned above. The numbers of candidates with results shown for various groups of exams are given next:
lsc - Candidates who took GCE A and/or GCE AS exams (NB this field was incorrectly named lcs here in earlier versions)
gvc - Candidates who took VCE A and/or GCE AS exams
lvc - Candidates who took any of GCE-A GCE-AS VCE-A VCE-AS exams
ibc - Candidates who took IB exams
Note that the total number of pupils in Year 13 is not shown explicitly. It can be assumed to be the number shown in lvc aded to the number shown in ibc, because it is assuemd that IB candidates do not also take GCE or VCE exams.

EXAM DATA FIELDS

eg algb03C
alg - indicates the exam, see above list.
b g or t - indicates that the figures are for boys, girls or totals.
03 - year (eg 03 stands for 2003.) This two-character field is also used for averages- eg -5 indicates that averages have been calculated from results for the previous 5 years.
A - If the above code is followed by a single letter eg A, The field will contain the number of results obtained at that grade. Grade T is used for the Total number of entries.
(a GCE A-level example would be: algb03C. This is the field which contains results for boys who obtained grade C in GCE A-level in 2003)

Statistics follow the Grades
The following three letter codes describing statistics are appended to the exam description code - eg. in the example algb03
can - the number of candidates eg for the above A level exam the full name of the candidate field would be algb03can
* ppc - the number of points per candidate.
* ppe - the points per entry.
* epc - the entries per candidate.
* NB these statistics are omitted for Year 13 results in 2003.

Please Note there that ppe and epc are replaced by pps and spc when two exam have been combined - e.g. GCE A-level and GCE AS-Level.
pps - points per subject
spc - subjects per candidate

Some additional statistics are included in the GCSE files, as follows.
n5p - the number of candidates gaining 5 or more *A-C subject passes. NB. Short courses count as half subjects.
p5p - the percentage of candidates gainign 5 or more *A-C.
pas - the percentage of subjects with results at *A (Field may be named A*)
pa - the percentage of subjects passed at grade A or better.
pb - the percentage of subjects passed at grade B or better.
pc - the percentage of subjects passed at grade C or better.
pd - the percentage of subjects passed at grade D or better.
pe - the percentage of subjects passed at grade E or better.
pf - the percentage of subjects passed at grade F or better.
pg - the percentage of subjects passed at grade G or better.
pu - the percentage of subjects passed at grade U or better.
Note that the cumulative percentages described above, will for many schools reach 100% at a grade higher than U. In these cases only the first 100% is recorded. Subsequent columns will contain blanks.

The difference between entries and subjects is that in the individual exams (eg GCSE Full courses)
Entries indicate the total number of grades awarded. However, when results for GCSE Full and Short courses are combined ONE GCSE Short Course counts for ONE entry but only HALF a GCSE subject. Similarly, and AS entry counts as half an A-level subject.

Top