You can either:
Enter your prepared data directly into the appropriate template spreadsheet provided with the tool, OR,
Have your data in the right format in another file or extract (such as csv or spreadsheet), so that you can easily copy / paste it into the appropriate template spreadsheet. The data required is detailed below:
- Student Number
- Overall Mark
- Position in Cohort
- Position in Classification
Student Number - the student number only (e.g. 12345678)
Classification - the classification or year outcome for the examination (details on format below - see templates)
Overall Mark - a number between 0 and 100 representing the student’s overall performance in the examination (up to two decimal places, e.g. 77.22)
Position in Cohort - a number indicating a student’s ranking relative to all the students considered by the examination board (integer, e.g. 2)
Position in Classification - a number indicating a student’s ranking relative to all the students awarded the same classification or year outcome by the examination board (integer, e.g. 2)
Please note that if your source ranking (position) data is expressed as, for example, "6 of 19", you will need to use standard Excel functionality to create a column with the position shown independently from the number in cohort (e.g. as "6"). Please contact the Student Systems Support Centre or your IT team if you need help using this Excel function.
If you have a departmental system for examinations, you can talk to your IT team about how you will produce the data in the format required.
Note: If you do not calculate and hold all of the data items in the table above, the minimum data is student number, classification, and at least one of the other columns.
How do I know which template spreadsheet is right for me?
There are currently three spreadsheet templates, supporting different allowable outcomes for the examination. More may be added over time.
Template Allowable values Meaning
PassFail D, P, F Distinction, Pass, Fail
HPPassFail HP, P, Fail Honors Pass, Pass, Fail
Honours 1, 21, 22, 3 First, Second Class Division One, Second Class Division Two, Third
If you cannot see an appropriate template for your classification scheme, please contact the Student Systems Support Centre or the project team.
Entering Summary Totals
Summary totals also need to be entered into eVision during the upload process. At the time of upload, you will need to know, and have at hand:
- Total in Cohort (the total number of students considered by the examination board)
- Number of results in each Classification/Year Outcome