Versions Compared

Old Version 8

changes.mady.by.user Noah James

Saved on

compared with

New Version 9

changes.mady.by.user Stuart McCulley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can enter grades in another application (Excel) and import them into Brightspace using a CSV, TSV or TXT file. New items can be created by adding columns to the import template. Any grades you import for discussion grade items and assignment grade items are also synchronized back to Discussions and Assignments as published feedback. Grades can also be exported to other applications as a CSV or XLSX.

Note

The import file MUST follow a strict format provided by D2L. See the sample file provided here:

View file
nameGrades_Sample_Import_File.csv

Contents

Table of Contents
minLevel1
maxLevel

...

6
include
outlinefalse
indent
excludeContents|Related
typelist
class
printablefalse
Panel
bgColor#F4F5F7

Page Tree
rootGrades
startDepth1

Importing Grades

D2L strongly recommends instructors to enter and manage grades within the Grades tool for the best experience. Only grades that have changed should be imported into the Gradebook. Grade items that have not been changed in the CSV files should have these columns deleted prior to upload. While new items can be added via the CSV upload it is strongly recommended to only create new grade items within the Grades tool. This page covers how to prepare your file for upload and upload your grades.

Preparing your file for upload

Brightspace provides a grades upload template on the import page and is also provided here [

View file
nameGrades_Sample_Import_File.csv
]. The upload file must be a CSV, TXT, or TSV file type. It is recommended to use CSV files.

A screenshot of a sample grade import CSV file. Image Modified

  • If you enter a grade value that is greater than the value for the grade item, the grade is capped at the value unless you selected the Can Exceed option when setting up the grade item.

  • Do not import other options, such as a user’s first name, email, or weighted grade.

  • To improve performance when importing grades for large classes, only import grade items that have changed and import by group or section when possible.

  1. Enter grades or grade changes. Ensure all users have an org ID or username linked to their row - if not their information will not be imported.

  2. Save file as a CSV.

    1. Windows (Microsoft Excel) go to: Save As > File type: CSV

    2. MacOS (Numbers) got to: Export To > CSV

  3. Remember where you have saved this file and the name!

Uploading your file

  1. Click Import.

  2. Click Choose file.

  3. Select the .csv file you want to import, then click Open.

  4. Click Continue. You will see a Processing… message while your file is loading.

  5. You will see a page displaying any errors and warnings that were found. Click Continue.

A screenshot of the Import Grades screen with no errors or warnings found.Image Modified
Note

The Errors and Warnings page will appear even if there are ZERO errors.

  1. You will see a preview of the new grades for each student. Review here for accuracy before continuing.

  2. Click Import. You will see an “Imported Successfully” message and your imported grades will appear under the Enter Grades tab of your gradebook.

Importing Grades and Creating New Grade Items from the Import

  1. Click Import.

  2. Click Choose file.

    1. Select the Item Creation box labelled “Create new grade item when an unrecognized item is referenced”.

A screenshot of the Item Creation checkbox which states create new grade item when an unrecognized item is referenced.Image Modified

  1. Select the .csv file you want to import, then click Open.

  2. Click Continue. You will see a Processing… message while your file is loading.

  3. If new grade items are recognized they will be listed in Step 2: Create New Grade Items.

    1. Review the new items and select the grade type (Numeric or Pass/Fail)

  4. After clicking Continue, Step 3: New Grade Item Properties is where you will set properties for the grade item: category, max points, can exceed, bonus.

  5. Click Continue. Next you will see a page displaying any errors and warnings that were found.

A screenshot of the Import Grades screen with no errors or warnings found.Image Modified
Note

The Errors and Warnings page will appear even if there are ZERO errors.

  1. You will see a preview of the new grades for each student. Review here for accuracy before continuing.

  2. Click Import. You will see an “Imported Successfully” message and your imported grades will appear under the Enter Grades tab of your Gradebook.

Exporting Grades

Grades can be exported to CSV or XLSX file formats. These file types are compatible with Microsoft Excel and MacOS Numbers. D2L strongly encourages creating grade items and entering grades directly in Brightspace for the most compatible and reliable experience. Grades can be exported for all users in a course, or by groups. Follow the instructions outlined below:

  1. Go to Grades tool homepage.

  2. Select Export.

  3. Specify the desired export details and formatting, including what users to export grades for - this can be All usersor byGroups.

    1. The Key Fieldis the left most column and how users will be sorted by.

    2. The Sort bytab specifies how user information is organized in columns from left to right.

Note

Do not select the Grade Schemeoption if you want to use the export file for an import later as it is not compatible with the import format.

  1. Select the grade items to be exported at the bottom of the page (note: all items are selected by default).

A screenshot of the export options at the bottom of the page, the buttons are export to CSV, export to excel, or cancel.Image Modified

  1. Choose Export to CSV or Export to Excel.

A screenshot of the export grades page showing the progress of the export being prepared.Image Modified

  1. Once the file is prepared click Download.

  2. The file can now be opened with programs that support the CSV file type or Excel.

For further assistance please contact edtech@brocku.ca.

FAQ

Q

A

Can I import grades after making changes to a grades export file?

Yes - if saved and uploaded as a CSV

Can I import excel (XLSX) files?

No - unless saved as a CSV

Can I add new students with an import?

No

...

Panel
panelIconId1f517
panelIcon:link:
panelIconText🔗
bgColor#E3FCEF

Related Articles

...