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 Grade Scheme and deselect Point grade
  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

A pop-up window will open when the exporting is complete

  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 corresponds to the students WUR accounts
  2. The Calculated Final Grade Scheme Symbol corresponds to the grades
Table downloaded from BS

Preparing your Brightspace file

1. Omreken:"Translate" the OrgDefinedId into OSIRIS student number

Osiris does not recognize the OrgDefinedId (WUR account), you need to "translate" it into the corresponding Osiris student number. In order to do so, get the latest version of the Omreken file

It is important to use the latest version of the file to make sure that you get the complete classlist

Copy the data from the OrgDefinedId column in the Brightspace excel file and paste it under the column WUR-account in the Omreken file

Paste

Now, under the column OSIRIS-studentnummer, you will find the student number associated with the WUR account

Make sure to remove the Dummy student from the student list

  1. Select all the data in column OSIRIS-studentnummer
  2. Copy the data

Continue in the Brightspace excel file,

  1. Position the cursor on the first cell under OrgDefinedId
  2. Paste value, through the menu

Consider doing these steps in a empty column, to check if the copy past has been done correctly

Paste student number into the Brightspace file
2. Brightspace excel: order the OrgDefinedId

Once you have replaced the WUR account with the corresponding student numbers, the Brightspace file has to be ordered as Osiris and Brightspace sort the student differently

Make sure items from the two lists have the same order

  1. In the Brightspace file, select the column OrgDefinedId and Calculated Final Grade Scheme Symbol
  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 OrgDefinedId 
  2. For the value Sort On, choose Cell Values 
  3. For the value Order, choose A to Z
  4. Click on OK
Sort

The Brightspace excel now contains student numbers and grades, it is now possible to fill in the Osiris excel

Preparing your Osiris file

Information on how to get the import file can be retrieved here.

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: order the 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

Open the Brightspace excel you have previously worked on, select and copy the column Calculated Final Grade Scheme Symbol, containing the grade

Now go back to the Osiris excel,

  1. Position the cursor on the first cell under the column Resultaat
  2. Right-click on the first cell, a menu will appear
  3. Click on Paste the value you previously copied
  4. Save the file

 

Paste the results

Your Osiris excel is now ready to be uploaded! You can find more instructions here.

.

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

Tips to check if the procedure went well

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

Want to know more about Grades in Brightspace?

Please visit:Â