What is a grade input file and how to use it?
To enter multiple test results in batch you can use a grade input file. This is an Excel file generated in Osiris Basis or in Osiris Lecturer. See the manuals How to make a grade input file and How to enter results with a grade input file and How to use result grade codes
The grade input file contains all students enrolled in the selected exam, sorted by student number. It is strongly recommended to use this file to save results, and to upload them in Osiris.
Instructions for working with this file:
- Rows 1 to 8 should be kept as they are. They make up for a valid and identifiable grade input file when you upload the file into Osiris.
- Similarly, Osiris uses the layout of column A, B, C and D to register the grades.
- Column C must contain the test date (dd-mm-yyyy),
- Column D contains the final result (1, 2, 3, 4, 5, 6, 6.5, 7, 7.5, 8, 8.5, 9, 9.5 or 10, INCOMPL or NOGRADE)
- See for more information on result codes How to use result grade codes
- Sub- or partial grades are not stored in Osiris, and should be stored at the chair group, and/or in Brightspace)
- Do not leave empty cells under Grade as Osiris will not accept the file with empty cells there. Enter NOGRADE if a student did not receive a result
Below row 7, the columns from E onward (‘Subject’, Topic (English), ‘Deviating category’, and ‘Validity’) can be renamed and used as you wish. For example, sub-grades can be entered here, to be combined in a final course result. Thus you can use the file to calculate the final grade. Keep in mind the correct rounding of the grades in column D ‘Grade’. In case of incorrect rounding, Osiris will give an error message when reading the results.
NB. Only column D ‘Grade’ will be loaded as final result. Osiris does not read the extra columns and will not save the sub-grades. The file will not be saved in Osiris, only loaded, and therefore it needs to be saved in your own records.
NB. By default, students in the grade input file are sorted on surname. If you chose to sort them differently, make sure you only start sorting from row 8 up and take care to keep consistency. Also, pay extra attention when students have the same surname.
Here is an example of a grade input file for a fictitious course that has a practical (counting for 25%) and a written test (counting for 75%). To gain a pass grade for the course, both separate parts must have a pass grade. If only one of the two has a pass, the result is Incompl, else the composite course grade is computed. Finally the course grade is rounded to one of the allowed numerical grades. In this Excel file, All computations and checks are done with built-in Excel functions.
Maarten de Gee
An example of an excel file with subgrades and correct rounding would be useful.