Grades | How to export grades from Brightspace into Osiris

Once grades are placed in the grade book, they need to be added to Osiris, the student's information system of WUR. To export grades from Brightspace to Osiris, you need to create a table that matches Osiris criteria. You will be working on different excel files: one downloaded from Brightspace (Brightspace excel), the Omreken file and one downloaded from Osiris (Osiris excel)

In this article you will learn:

 

Downloading the Brightspace excel file

Navigate to your course, in the green navigation bar,

  1. Click on Grades
  2. Click on Export
Navigate to Export grade

This will open the Export homepage,

  1. Under Key Field select  Org Defined ID 
  2. Under Grade, Values select only Grade Scheme
  3. Under User Details deselect all the boxes

Deselect the boxes is not mandatory, however these information are not relevant for OSIRIS

Options before downlod

Scroll the page down and from the table Choose Grades to Export,

  1. Select the box for the Final (Calculated) Grade (or the grade item you wish to import to Osiris)
  2. Click on Export To Excel 
Chose grade table

On the pop-up window Export Grades

  1. Click on Download 
Export grades pop up window

The downloaded Brightspace excel file contains a table that should look like this,

  1. The OrgDefinedId - the students' ID number
  2. The Calculated Final Grade Scheme Symbol - the grades
Table downloaded from BS

Preparing your Osiris file

  1. Go to OSIRIS-Lecturer and log in.
  2. Click on Grade.

A screen appears with all exams for which you can enter grades.

  1. Select your course.
  2. Click in the menu ACTIONS ,and then
  3. Click on Create file
  4. Save the grade input file in a secure environment

For more information visit the article:  How to make a grade input file

Overview of the Osiris excel

From OSIRIS, you can download an excel file containing the following information,

OSIRIS file
  1. Student number (Studentnummer)
  2. Name of the student (Naam), sorted in alphabetical order
  3. Date of the exam (Toetsdatum)
  4. Result (Resultaat)

In order to upload grades in OSIRIS, the table must be filled in with the results

1. Osiris excel: Sort by Student number

The file downloaded from Osiris is alphabetically sorted by last name. In order to keep the correspondence between the students and the grade, it is important to sort the Osiris excel by student number

To do so:

  1. Select the column Student number and Name (and any other column that might contains data, from the row 8 onwards)
  2. Right-click on the selected columns, a menu will appear
  3. Click on Sort, a second menu will appear
  4. Click on Custom Sort...
Custom sort

A pop-up window will appear,

  1. For the value Sort by, choose Student number 
  2. For the value Sort On, choose Cell Values 
  3. For the value Order, choose A to Z
  4. Click on OK
Sort

2. Osiris excel: Add grades

  1. Open the Brightspace excel you have previously worked on,

Under the column Calculated Final Grade Scheme Symbol, that contains the grade

  1. Select and Copy the all values

Now go back to the Osiris excel, and under the column Resultaat

  1. Click on Paste the value you previously copied, and
  2. Save the file

 

OSIRIS file

Your Osiris excel is now ready to be uploaded!

For more information and step by instructions visit the article : How to import results with a grade input file

Tips to check if the procedure was successful

1. Check if the Brightspace excel and the Osiris excel have the same number of rows

2. Use an Equal test

An equal test is a formula to check the correspondence between two cells

To use the equal test:

  1. Copy-paste the Brightspace excel table (OrgDefinedId and Calculated Final Grade Scheme Symbol) into the Osiris excel

The first data copied from Brightspace has to be placed in the same row of the first data of the Osiris excel (row 9)                        

In the first empty column next to the data,

  1. Enter the equal function. Type the following: "= cell containing Student number = cell containing the value copied from Brightspace", in this case  "=A9=F9"
Equal function
  1. Drag and drop the function to the all table

 

Equal function to all the table

When the column is filled with "TRUE" value, the ordering of the student number in the Osiris and in the Brigthspace excel is the same

Now, you can repeat the same procedure to check the correspondence of grades

To do so, in the first empty column next to the data:

  1. Enter the equal function. Type the following: "= cell containing grade = cell containing the grade value copied from Brightspace", in this case "=D9+G9"
  2. Drag and drop the function to the all table
Equal function for grades

When the column is filled with "TRUE" value, the ordering of the grades in the Osiris and in the Brigthspace excel is the same

.

You now know how to export grades from Brightspace to Osiris!

Want to know more about Grades in Brightspace?

Please visit: