An excel file with grade results can easily be imported ('read') in OSIRIS. This instruction states the requirements that this file must meet in order to make reading the file possible.
Importing a file with results is only possible with a file in the xlsx-format, and with the format shown below. When entering results into the Excel sheet, please make sure that the fields that have already been filled out are not changed, otherwise errors will occur during the import into OSIRIS.
The file created looks like the one above. Row 1 through 8 should not be changed, they contain critical data needed by OSIRIS.
- Column A must be filled with a studentnumber without the S prefix. See below for a formula on how to delete the S from your oqwn excel sheet if you obtained that from a different source like Brightspace or Cirrus.
- Column B does not need to be filled.
- Column C can remain empty if you add the test date upon impporting the results in ORISIS, otherwise the test date needs to be filled out (format: DD-MM-YYYY). This date may only lie between the first date of the block in which the test falls and the current date (it is therefore not possible to give a result in the future).
- Column D should mention the results per student, but please note that this should not contain an Excel formula, as this would result in error messages during import. Also, the result to be filled in must be allowed in the Result scale shown.
It is not necessary to provide all students with a result. However, a result must always have a test date, either in the file or when importing.
When you put the results of different parts/questions into an Excel sheet and then calculate a final result for the different parts/questions, for example by calculating the average, you may end up with a result that has several decimals.
OSIRIS will only accept results that meet the maximum number of decimals set in the course (usually 2). The column of results to be imported will therefore have to have a maximum number of decimals. Use the Excel function "=Round(number;number of decimals)" to round the result to the maximum allowed number of decimals.
OSIRIS requires studentnumbers without S, so remove them if they appear in your list. You can do this by adding an extra column in your own file with the following formula: :
=RIGHT(A2; LEN(A2)-1)
Nb. Where in this case, ‘A2’ is the field in which the studentnumber wíth S is mentioned.
The copy the correct numbers in your import file.
Saving the file
After you have entered the results, you must save the file. Preferably do this on a network drive under your own name, so the file can only be read by you. Delete the file after it has been imported, so that no data leak can occur because the file has been 'found' by unauthorised persons.