In the previous instruction was described how to create a file with candidates for a test. In the current instruction is described how to upload a file in which the grades are added.
Uploading a file with grades is only possible when the file is in the MS Excel '.xlsx' format. Also the layout of the file should be exactly the same as shown in this instruction. If it is not, the upload of the file will lead to errors. To create a file in this format and layout, see the prevous instructions. Please note that you do not change the values in the fields in the heading of the layout (Red rectangular), for that may cause errors when the file is uploaded. Also note that cells in the column to which the grades are added ("Grade"), does not contain formulas, but only has values in the cells. When this column contains formulas, uploading will cause errors.
TIP: use the grade calculater to create a file for uploading grades in Osiris.
Excelfile (grade calculator) http://weblogs.socsci.ru.nl/ictio/files/2018/12/OSIRISinvoerDocent.xlsx
Manual (in Dutch): http://weblogs.socsci.ru.nl/ictio/files/2018/12/OSIRISinvoerDocent.pdf
Adding grades to the excel file
The file you can add the grades to, looks like the above. The column "Test date" you can fill in the date of the test (see instruction on how to enter grades for the requirements the dates have to meet). In the column "Grade" you can add the grade for each candidate.
It is not required to fill in a grade for each student, you can also leave the grades for students blank.
If you use an Excel function to aggregate different sections of the test you might end up with a grade consisting of decimals. OSIRIS will accept only a limited number of decimals, depending on the grading scale of the test that is set in the course. Use the Excel function "=ROUND" to round the outcome of the aggregation to the maximum number of decimals allowed for the test.
Saving the file
After you have entered the grades in the file, you can save it on your computer. OSIRIS will create a name for the file which contains some characteristics of the course and test. In the example above : "Grades_LET-CIWM437_Advisory_report19-01-2018_1422.xlsx".
Please be carefull with files containing data of students. Try to minimize the number of files you keep in your computer, and allways save files to your personal share of the network. Do not save files to USB sticks in order to decrease the chance of a data security issue. Keep in mind that the safest place for students data is OSIRIS!
Select the file
- Select the file you just saved by clicking the button "bestand kiezen".
- Select the file you just saved on your computer
- Click the button "Open"
- Optional you can add the testdate (this is not obligatory, the date in the excelsheet will be uploaded)
- Now click the "READ FILE"button
After the file read proces a "Transaction report" will be shown. with the result of the read file action. You will see:
- the number of rows in the file that was uploaded that has caused errors of warnings.
- the number of rows that were processed succesfully
- the total number of rows
- the name of the students which the upload caused errors of warnings for
- the description of the error or warning for each row
- a button to export a excelfile with all the errors and warnings. This may come in handy when you have a large number of errors and warnings, so you can analyse them in excel.
- Close button to close the transaction report.