Grades | How to export or import grades in Brightspace

In the Brightspace Gradebook, you can export or import all the grades of the students at once via a .csv file. This functionality is especially useful when working with other WUR systems like Osiris and ANS (Digital Examination).

This article shows how to:

1. How to Export Grades from the Gradebook

This article explains how to obtain a .csv file with the Grades from the Gradebook.
If your final goal is to add these Grades into Osiris, please follow this other article:

Grades | How to export grades from Brightspace into Osiris

To export the grades from Brightspace follow the next steps:

  1. Click on Grades in the green navigation bar
navigate to Grades in the navbar
  1. Click on the Enter Grades tab
  2. Click on Export
in the tab Enter grades, click Swtih to Spreadsheet view

This will redirect you to the Export Grades page.

Under the Export Options section,

  1. Select the fields you would like to include in your file

We recommend the following:

Export options: Select OrgDefined Id, Points grade and Optional the email

Under Key Field select use the Org Defined ID, which is the student's number ID

Under Grade Values select:

  • Points grade to get the points as-is; using decimals (i.e.: 7.8).
  • (Optional) Grade Scheme will allow you to enter the output of a grading scheme that is used for the Grade Item directly (i.e.: Pass, Incomplete, etc.). Do not select this if you do not have text grades. 

Under User Details select:

  • (Optional) First Name and/or Last Name to include your students' name in the export file.
  • (Optional) Email to include your students' e-mail addresses in the export file.
  • (Optional) Group Membership can be useful when entering grades that are linked to a section or group-based assignments. Delete the column from your file once you have entered all the grades.
  1. Scroll down to the section Choose Grades to Export
  2. Select the grade items you would like to import grades to by clicking the select boxes on the left side
    Grade items will have a type description on the right side of the table.
  3. Click on Export to CSV
select grade items

Select only the grade items. 

Do not select Categories, Subtotals, FormulaFinal Calculated Grade, or Final Adjusted Grade

These items cannot be imported and will prevent you from uploading your file in case you want to import it back in Brightspace.

The pop-up window Export Grades will appear. When the loading bar shows as 'Complete':

  1. Click on Download
export grades completion page, click download

This action will download the .csv file to your computer.

2. How to Import Grades into the Gradebook

Not every document is valid for uploading the grades into Brightspace. Extra or missing information can prevent you from being able to upload the grades. Please follow the instructions below carefully.

Importing Grades into Brightspace can be a bit tricky, since the import .csv file needs to have very specific settings in order to work without errors. The best way is to Export a template file directly from the course's Gradebook,  fill in the grades, and then Import that file back into Brightspace.

To do so:

  1. Export a .csv file following the steps on the previous section.
  2. Open the .csv file you just downloaded

The document will look something similar to this:

If your final document shows all information packed in the first column, select the first column entirely, and click on Data > Text to Columns. On the pop-up window, in Step 1 choose the option "Delimited". Then, in Step 2 select "Comma" and click on "Finish".

If the problem persists, check the Problem 1 in the Troubleshooting section at the end of this article.

  1. Add the grades to the Excel file under the column with the corresponding assignment name
  2. Important: Make sure your last column is named End-of-Line Indicator and includes the # symbol in all the cells of the column from the first to the last user

Do not modify any of the column names, student user codes or student emails.

Any modification will lead to errors during the import process, as the system of Brightspace will not be able to recognize the name and make the correlation.

  1. Save the file on your computer

For more information on how to save a workbook to a .csv format visit this Microsoft page.

Now you have a .csv file ready to be imported into your Brightspace Gradebook.

To do so:

  1. In the Grades page, navigate to the tab Enter Grades
  2. Click on Import
in the tab Enter grades, click Swtih to Spreadsheet view

In the page Import Grades - Step1: Select File to Import:

  1. Click on Choose File and select the .csv file you just created
  2. Click on Continue
Import grades page. Choose the file to import, select the checkbox under item creation section, click continue

The next page, Import Grades - Step 2: Errors and Warnings Found, will show any errors that the import might have. If the box shows the text "No errors or warnings found":

  1. Click on Continue
errors and warnings found page, errors will be shown here. Click continue

Please note that, if you enter a Grade value that is greater than the Max Points of that Grade Item, the grade will be capped at the Max Points value.

(i.e.: The Max Points of the Grade Item is 10 but in the .csv a student has a grade of 11. It will be imported as 10).

If Brightspace finds any errors in the .csv file for the Import, it will list them on this page. You can try fixing them manually if the solution is clear.

If the solution is not clear, check the Troubleshooting section at the end of this article to know what they mean and how to fix them.

In the next page, Import Grades - Step 3: Preview Import, you will see a preview of the grades to be imported. You can occur a final check and then:

  1. Click on Import
import grades preview, an arrow will show if the grades are being modified from previous values to new ones, click import to confirm the import process

If a student was already graded, an arrow will indicate the update of the grade. It will be changed from a previous value to the new one (e.g. 8/10 -> 7.3/10).

After the process completes, the message Imported successfully will be shown on the screen and you will be directed back to the Enter Grades page.

3. Troubleshooting

Problem 1: All the information packed on the first column of the Export file.

 Some computers have the decimal separator shifted between comma (,) and dot (.).
To check this, on the .csv:

  1. Go to File
  2. Click on Options
  3. Click on Advanced
  4. Make sure the "Decimal Separator" is a comma (,) and the "Thousands separator" is a dot (.)

Then do the Data > Text to Columns steps again.

You can find more help about this in this article from Microsoft.

Problem 2: Possible Errors when trying to Import the .csv file into Brightspace

The most common errors you will encounter are the following:

'Unrecognized user'

Meaning: A student is listed in the .csv but not in the course Classlist

Solution:

  • Make sure the list of students is the same in the .csv and in the Course Classlist. If any students are not in the Classlist remove them from the .csv
  • If some of the grades are empty there will also be an error. Make sure all the students have a grade in the .csv
  • Some rows may appear blank but still contain some data. Delete all the rows that are not part of your data set, even if they seem empty.
'The import file selected cannot be read'

Meaning: Typically, this will occur due to a file formatting issue.

Solution:

  • Verify that the columns are named appropriately. Make sure the name of the column includes the grade item type and max points inside the <> characters.
  • Verify that the End-of-Line Indicator column is the last column in the file. There might be extra (invisible) columns after the End-of-Line Indicator. Select all the columns after this one and delete them.
  • Verifying the data in the rows matches the column type. OrgDefinedId should be 'text' and the grade points should be 'number'.

More on .csv file format

Info about .csv files

CSV stands for comma-separated value, which is a type of file where data is organized in columns separated by a comma ( , ) or semi-colon ( ; ) characters.

A .csv file needs to have dots (.) as decimal separators and commas ( , ) or semi-colons ( ; ) as separators.

Files in .csv format can be created and modified with text editors or with Excel. Excel has the functionality to convert .csv files into .xlsx files.

Brightspace Import format

Brightspace needs the following three components to be able to import grades from a .csv file:

  • The Student Number (in Brightspace: OrgDefinedID) including a hashtag( # )
  • The grades listed under the name Grade Item <Grade values info>; for example Exams Points Grade <Numeric MaxPoints: 10> will import the grades listed to the Grade Item Exams in Brightspace
  • The End-of-Line Indicator (#)
OrgDefinedId Exams Points Grade <Numeric MaxPoints:10> End-of-line Indicator
#student.number001 9.0 #
#student.number002 7.9 #
#student.number003 8.0 #

If you have a file where the values are separated by another character different than a comma, use the function Replace all (default is Ctrl+H) to replace all list separators with commas.

 

Now you know how to export and import grades from and into Brightspace!

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.