Werkinstructies Osiris

How do I upload an Excel file with test results?

Bijgewerkt op

Purpose: Save time with the input of numerous (> 10 students) results from the same test and opportunity;

For whom: The lecturer processing test results;

  1. Click on 'Menu' at the top of your screen and then click on 'Grade'. You'll see multiple tabs where the tab 'TESTS' is automatically selected.
  2. Use the selection filters below to get a list of the course(s) where grades can be added.
    Use more selection filters for a more specific list.
  3. Select a test by clicking on it.
  1. Under 'Actions" choose "Create file"

An excel file will be downloaded where you can fill in the results and exam date. Once you're done, save the file.

Please note:
1. When uploading a file, the values in column D (under 'Grade') are being uploaded. The column 'Grade' must meet the requirements for import compliance (e.g. between 1 and 10, max. 1 decimal, etc.). Do not use formulas in  the columns 'Grade'.

2. If you want to use formulas (for example to calculate them on another sheet) be sure that after the formula is calculated the values end up in column D . You can do this by copying all cells in 'Grade' and afterwards paste them as value in the same place.

In order to upload the file, search for the test (with help of the selection filter as outlined above) in the Grade menu and click on it. Under ' Actions' choose 'Read file' to upload the test results. 

Fill in the testdate (if you have not yet done so in your file) and click on add file. Once you've selected your file, click op 'Open' and then 'Read file'.

You will receive a notification informing you that your file has been uploaded. You may also receive the notification that the file contains errors. 

Via the option "Download excel -file" you can save the file onto your computer.

If the file contained errors you will be able to see these and correct the information either in the file or in Osiris directly.

After uploading a file, you can follow the normal procedure when saving or signing results (by clicking on the green button 'Sign' in the top right hand corner).

Vorige Artikel How can I fill in and sign off results?
Volgende Artikel How do I fill in a digital grade rubric (form)?