What is a grade input file and how to use it? (wrong screen shot of excel file)

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 on student number. It is strongly recommended to use this file to save results, and to upload them in Osiris. 

The 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 to enter grades.

The columns A, B, C and D should be kept as well. They are read by Osiris when you upload the file. Column C must contain the test date, and column D contains the result.
Note that Osiris handles final course results only, that is, it does not store sub-results e.g. for a practical and a written test. These sub-results must be stored at the chair group.
Beside the allowed numerical grades (1, 2, 3, 4, 5, 6, 6.5, 7, 7.5, 8, 8.5, 9, 9.5 or 10), column D can also contain result codes such as Incompl and NoGrade. See for more information on result codes How to use result grade codes

Do not leave empty cells under Grade, for Osiris will not accept the file if any cell under Grade is empty. Enter NoGrade if a student didn't receive a mark for the course.

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.