|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
|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.|
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.
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.
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 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.