In this article, you will find a step-by-step plan on how to import grades to Brightspace.
If you are looking for information on how to export grades, please go to this article.
See here for a video on Import Grades.
Import Grades can be used to transfer Grades from other systems into Brightspace, or you can use the export and import function to update student grades on your local computer and get them back into Brightspace.
This article consist of
Import Grades
The most easy way to import Grades, is by exporting the Gradebook first and then use this document to import again. Please follow the steps below in order to import Grades correctly.
Step 1: Export grades
- Click on Grades in the navbar of your course.
- Click on Enter Grades.
- Click on Export.
Step 2: The settings of the export-file
- Select whether you want to export all student data or just from 1 group or section.
- Choose how to sort your data
- Only tick the box Points Grade under Grade Value
- DO NOT CHECK any other User Details
- Select under Choose Grades to Export which grade items you would like to export.
- Finally, click on Export to CSV
We discourage everyone to use the option Export to Excel. Preparing the file for import is a lot more complicated when you have to work with an Excel-file compared to a CSV-file.
Step 3: Open and edit with Excel
- Open the downloaded csv-file in Excel.
- Select the first column and navigate to the header Data in Excel. Click on the option Text to Columns.
- In step 1 of this Wizard, choose for the file-type Delimited.
- Check under Delimiters only Comma, make sure that Tab is unchecked.
- When the settings are correct, click Finish.
Now that you have made a clear table of your students and the Grade Items, you can start to fill in the grades.
Note: to import Adjusted Final Grade, you must fill in the grade points received in the column labelled Adjusted Final Grade Numerator and the maximum number of points in the column labelled Adjusted Final Grade Denominator.
Step 4: Preparing the file for import
Correctly saving the file:
- Save the file as Text (Tab Delimited).txt
- Excel then gives a warning relating to the extension. Indicate that you want to retain the format.
- Close the file.
- When you try to close the file, Excel gives a warning stating that the file needs to be saved again. Click on Don't Save.
Step 5: Importing to Brightspace
- Click on Grades in the navbar of your course.
- Click on Enter Grades.
- Click on Import.
Importing Step 1: uploading the txt file
- Click on Choose File to upload the Text (Tab Delimited).txt
- Click on Continue.
Importing Step 2: possible errors
- If everything went well, you should see the above-displayed screen.
- Click on Continue
Importing Step 3: Preview
- In the last screen you can see a preview of the import.
- Adjusted grades will always be displayed the following way: old grade -> new grade
- Click on Import to complete the Import.
You are done!