Upload Results File

Use the Upload Results File option in the External Exams Manager module to upload results files issues by exam boards. Exam boards will produce a results file for each BaseData file that has been imported; results files automatically match with candidate details.

Exam board results files can be issued in one of two formats; via an EDI carrier or a .xlsx file from Cambridge International Examinations (CIE). Some additional preparation is required on the .xlsx file before it can be imported in iSAMS.

To upload a results file:

1. Receive the results file from the exam board either:
   • Via your EDI carrier and move to Step 2.
     or
   • From the CIE as a .xlsx file. Prepare the file ready for import:

   1. 1. Copy the results from the .xlsx file into the CIE Import file. Click Edit Document below and use the example shown as a template for the CIE Import file:

         Syllabus	Option code	Centre number	Candidate number	Candidate name	Raw mark	Adjusted mark	Grade	Raw mark	Adjusted mark	Grade	Raw mark	Adjusted mark	Grade	Raw mark	Adjusted mark	Grade	Component 11	Component 21	Component 31	Component 41	Syllabus total	Syllabus grade
         5678	DG	AB001	9876	Bloggs: Fred	18	18	E	24	24	D	14	15	U	17	17	E	18	24	15	17	74	E
         5678	SI	AB001	5432	James: Naomi Sarah	14	14	U	38	38	A							14	38			52	c
         5678	SR	AB001	1234	Tester: Test	37	37	A	32	31	C							37	31			68	a

         Do not change the format of the CIE Import file.

      2. Ensure that the tabs containing the results display as 'Month_Year_SyllabusCode'. For example, 'June_2016_1234'.
      3. Ensure that the following headers appear in row 1 of the results tabs (these are not case sensitive but must be in the order shown here):
         • Syllabus.
         • Option Code.
         • Centre Number.
         • Candidate Number.
         • Syllabus Total (also shown as Syllabus Mark Total).
         • Syllabus Grade.

      4. Save the CIE Import file and continue with Step 2.

2. Open the External Exams Manager module and select the Results tab.
3. Select Upload Results File from the right hand menu to display this screen:
   

4. Use the drop down list in the top right to select the exam cycle that you want to work with.

5. In the Results File section, click Browse and select the results file that you want to import.
6. In the Upload Settings section:
   • Select the Pupil Linking Method that you want to apply to the imported data. It is recommended that you select 'UCI and Candidate Number' to ensure that data is matched to candidate files accurately.
   • Select the Action on Problem method that you want to apply while the file is uploading. It is recommended that you select Stop & Rollback; any results that can't be matched are shown as you upload the file. 
7. Click Preview to check candidate names and results before committing to the import.
8. Once you have checked the data, click Upload.
9. Repeat the process for each results file.
10. The imported results are displayed in Results File History.
11. You are now ready to:
    • Go through any unassigned results.
    • Publish results to the rest of iSAMS and the Parent and Pupil Portals.