An excel file with grade results (such as from Brightspace or another medium) 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.
For information on how to make a file in OSIRIS-format, consult this instruction.
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 own excel sheet if you obtained that from a different source like Brightspace or ANS.
- Column B does not need to be filled.
- Column C can remain empty if you add the test date upon importing 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 a maximum of 2, mostly 1). 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. Now 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.
Select the ‘Read file’ action.
Now select the ‘Read file’ action from the action menu to choose the file you just saved.
Select the file
- Click on the ‘Select file’ button.
- Now select the file that was just saved.
- Click on the ‘Open’ button.
- If necessary, enter a test date (this is not mandatory; the date in the Excel sheet will be used as the test date if you have not entered anything here).
- Then click on the ‘Read file’ button.
View the processing report in case of anomalies
After importing, a ‘processing report’ may be generated containing the results of the import operation. It may show the following:
- the number of rows in the file that generated a warning or error and were therefore not imported
- the number of rows that were successfully imported
- the total number of rows
- the names of the students for whom the import generated warnings or errors
- the errors in the import action
- a button that allows you to download the errors displayed in Excel. This can be useful when importing a large group of results. After the import action, you can then take your time to view in Excel what went wrong for which student.
Sign
Now click on the ‘Sign’ button to sign the results either manually or electronically. Please check to this work instruction on how to do this.
Problems have been reported with importing results when the Google Analytics opt-out browser add-on is installed (https://support.google.com/analytics/answer/181881?hl=nl). If this is the case, this add-on must be temporarily disabled before importing. There is no other solution to this potential problem at this time.
In 9 out of 10 cases, the order of the student numbers in the lecturer's own Excel file (e.g. obtained from ANS, Brightspace or via the Evaluation Service) is different from that in the exported Osiris file. However, this does not matter in this step-by-step plan.
It also does not matter if this own Excel list has fewer participants/test candidates than the exported Osiris file (as it sometimes happens that students register for the test but ultimately do not take it). Once you import this list with fewer candidates, only they will receive a mark in Osiris. For non-participants, nothing will be entered (= no mark).
Students who did take the exam but did not register (and are therefore not on the candidate list) will not be added with a grade in this way. An error message will appear during the import: [student number] – [Name] Student is not registered for the exam. That student must then be added to the test manually – by the faculty Osiris administrator – (and then indeed register the mark or inform the lecturer that he can still enter the mark).