Option 1 – Spreadsheet in long list format
NB - The most successful file type is CSV Comma delimited
Alis/CEM IBE exam results accepted – A/A2 Level, A1/AS Level, IB Higher, IB Standard, Pre-U Short Course, Pre-U Full Course
One of the following combinations of Examination Result Fields is compulsory:
Qualification + Subject + Result – Suitable for all accepted qualifications
Board + Option Code + Result – Not suitable for IB or Cambridge International A Levels
Qualification + Subject + Board + Option Code + Result * - Not suitable for IB or Cambridge International A Levels
(*You may include all 5 examination result fields in your spreadsheet but you should choose to select the ignore option for qualification type and subject name during the mapping of your column headers. This will force you to map to board and option code only, which is a simpler and more accurate way to map qualifications as some subject names can be ambiguous. Option codes and Exam Board are only required if you use the Syllabus Level Analysis in the Value Added Reports)
An example of a correctly formatted long list file with all 5 examination result fields included is given below.
If you are including subject names in your spreadsheet, make sure these are clear, in particular:
- A2/AS distinguish between:
Textiles: Art & Design (Textiles) and DT Product Design(Textiles)
Graphics: Art & Design (Graphics) and DT Product Design (Graphics)
English: English Literature, English Language or English Language and Literature
- INTERNATIONAL BACCALAUREATE
All IB Languages MUST be classified as A, B or ab initio, the level (Higher or Standard) included and
English A is further split between Language, Literature and Language and Literature
e.g. IBS;English Language and Literature A, IBS;English Language A, IBH;English Literature A,
IBH;French, IBS;Spanish ab initio, IBH;German A etc.
- BOARD AND OPTION CODE
No board or option code should be entered for IB qualifications or Cambridge International A Levels
Pre-us must be specified as Full Course or Short Course i.e. PREUFC or PREUSC. Board may be selected as CIE or Other
If you need to upload a mixture of qualifications with and without board and option codes, please prepare 2 spreadsheets; one for the qualifications with codes and one for those without codes and upload them separately. If all or none of your qualifications have codes that the system can accept, they can all be included on the same spreadsheet.
Option 2 – SIMS Broadsheet
This can be obtained from SIMS using the following menu options:
Focus > Examinations > Reports, which will get to the Exam Results module part of SIMS.
Then choose the following menu option to generate the report:
Reports > Results > Export Results, choosing the one row per pupil option and saving the file as a Comma Separate Variable (.csv) file type. This should result in a file that looks like this (when displayed in Excel):
If following these instructions does not generate the report you require, please contact SIMS customer support for assistance. Please note we are unable to offer guidance on how to obtain this report from any other Management Information System (MIS). Also, board and option code details are included in this format and cannot be removed so it is not suitable for IB qualifications or International A Levels. Please use the Long List Format for these qualifications.