What is a grade input file and how to use it? (OSIRIS-Basis)
If the final grades are in Brightspace, you can also export an Osiris grade input file (with the final grades) from Brightspace, under Grades -> Export for Osiris. See Grades | How to export grades from Brightspace into Osiris
To enter multiple test results in batch, you can use a grade input file, that is an Excel file generated in OSIRIS-Basis or OSIRIS-Lecturer. See also the manuals
- How to make a grade input file
- How to enter results with a grade input file
- How to use result grade codes
The grade input file contains all students enrolled in the selected test, sorted on students' last name. It is strongly recommended to use this file to save results, and to upload them into OSIRIS.
How to use it?
Instructions to make sure Osiris will process the file correctly:
- The rows 1 to 8, and column headings A to H, 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.
- Fill in the test date in column C, in format dd-mm-yyyy, or dd/mm/yyyy
- Fill in the final result in column D, so only 1, 2, 3, 4, 5, 6, 6.5, 7, 7.5, 8, 8.5, 9, 9.5, 10, or INCOMPL or NOGRADE
- Make sure you fill in a result for each student (if no grade is available, consider NOGRADE or INCOMPL, see How to use result grade codes)
- Leave columns E - H (under row 8) empty
NB. Osiris will fail to process the file and give errors during the grade upload, if any of these conditions are not met!
About the Grade
Partial grades / results
OSIRIS only records the result of the course as a whole, so partial results of, for example, a written examination and a practical exam are not included. These partial results must be kept by the course coordinator (e.g. in Brightspace) or at the secretariat of the chair group.
User tip: from column I the columns can be renamed and used as you wish. Any partial results can be entered here. In this way, you can use the partial grades to calculate a final grade. Take into account the correct rounding of figures in column D 'Grade'. In the event of incorrect rounding, OSIRIS will give an error message when reading the file. Do not use formulas in the grade column!
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 by students' last name. If you choose 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.
Work is still in progress on this file. If you have extra info in the columns starting from E and you get the following error message then you need to empty the cells in these columns. Error message: "you have no permission to change the subject".
About the Test date
Column C contains the Test date. As long as MS Excel identifies a date as date, Osiris can work with it. However, you could also leave the test date empty. When you are going to upload (read file) the grade input file, you then enter the date for all students at the same time (see below) and choose the date from the calendar. Which date is allowed can be found in the manual What 'Test date' do I use at grade entry?
If students have not enrolled for the test, and you wish to enter a result, fill in their student numbers and names in the Excel file. In that case, these students will automatically be enrolled for the test with the corresponding grade.