Versions Compared

Old Version 10

changes.mady.by.user Stuart McCulley

Saved on

compared with

New Version Current

changes.mady.by.user Gareth Seymour

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.

NoteThe 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
maxLevel6
include
outlinefalse
indent
excludeContents|Related
typelist
class
printablefalse
Panel
bgColor#F4F5F7

Page Tree
rootGrades
startDepth1

Importing Grades

D2L and CPI strongly recommends recommend 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

Warning

Warnings

Below are various warnings that could lead to errors or other issues when making use of the import/export tools in Grades.

  • Column order matters, as does header text and formatting. The order should be: OrgDefinedID, Username, grade items, End-of-Line Indicator.

    • Importing grades does require that the Username and OrgDefineId columns be present, even if they are blank.

  • When importing grades into an already existing grade item, the column with the grades in them must be titled “<Grade item name> Points Grade”. This lets Brightspace know that there are grades being added.

  • Our experience is that certain characters cannot be part of column names. Illegal characters include : % & # * ? < > | \ " '

  • It’s easy to introduce phantom characters into the headers, such as start-of-sentence-width-spaces. Brightspace’s import template even includes these, they need to be removed before importing or errors will occur.

Preparing your file for upload

The file to be uploaded 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 Removed

  • 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.

  • 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.

    • Save file as a CSV
    Note

    While Brightspace offers an example document to use as a structure for import, CPI instead recommends exporting from Grades to retrieve all of the student information (names, org defined ID, etc.) instead of having to enter it manually.

    There are two different options for importing grades. The first option, which is strongly recommended by CPI, begins by creating the grade items in Grades before beginning the import process. The second option involves creating the grade items using the Brightspace import template provided, but comes with more potential for errors.

    Option 1 - Creating Grade Items in Advance

    Expand
    titleClick here to see the steps for importing grades, while creating grade items in advance

    1. Complete the Setup Wizard in the Grades area (learn more from Settings and Setup Wizard).

    2. Create the grade items that will be displayed to the students (learn more from Manage Grades).

    3. From the Enter Grades tab in the Grades area, select the Export button.

    4. Under Key Field, select Both. This will export both username and Org Defined ID (which are required sections for the import process). Keep all other options the default setting.

    5. Under the Choose Grades to Export area, select all grade items that apply to the ensuing import.
      Please note: Some grade items will have a ? icon next to them (i.e. subtotals for categories, grade items with a Calculated grade type). This means that they cannot be imported. Deselect them from the export to avoid issues.

    6. Select Export to CSV at the bottom. Brightspace will create the file, then click Download once the file is ready. The file will look something like the example below when opened in Microsoft Excel:

      Default view of exported gradebook with grade itemsImage Added

    7. Enter grades in the grade item columns for the students. Keep other columns such as the End-of-Line Indicator intact, they will be needed for the import.

      1. The “#” before the OrgDefinedIDs and Usernames can be removed or can stay, they will not affect the import.

    8. Save the file as a CSV after adding the grades.

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

      2. MacOS (Numbers)

    got

      1. go to: Export To > CSV

  • 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 Removed
    A screenshot of the Import Grades screen with no errors or warnings found.Image Added
    Note

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

    You

    1. There will

    see

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

    2. Click Import. You will see an

    “Imported Successfully”

    1. 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. the gradebook.

    Option 2 - Creating Grade Items from the CSV file

    Expand
    titleClick here to see the steps for importing grades, while grade items are created from the CSV file

    1. Complete the Setup Wizard in the Grades area (learn more from Settings and Setup Wizard). This is mainly to make sure the gradebook has a grading scheme of Points-based or weighted. Learn more about the difference between the main grade schemes from https://cpibrock.atlassian.net/wiki/spaces/BLEDOCU/pages/971669516/Settings+and+Setup+Wizard#Grading-System

    2. From the Enter Grades tab in the Grades area, select the Export button.

    3. Under Key Field, select Both. This will export both username and Org Defined ID (which are required sections for the import process). Keep all other options the default setting.

    4. Under the Choose Grades to Export area, select all grade items that apply to the ensuing import.
      Please note: Some grade items will have a ? icon next to them (i.e. subtotals for categories, Final Grade Calculation). This means that they cannot be imported. Deselect them from the export to avoid issues.

    5. Select Export to CSV at the bottom. Brightspace will create the file, then click Download once the file is ready. The file will look something like the example below when opened in Microsoft Excel:

      Default view of exported gradebook with no grade itemsImage Added

    6. Create grade items by adding columns between the Usernameand the End-of-Line Indicator columns. Title the grade items in row 1, making sure that they follow the convention <Grade item name> Points Grade

      1. The “#” before the OrgDefinedIDs and Usernames can be removed or can stay, they will not affect the import.

    7. Enter grades in the grade item columns for the students. Keep other columns such as the End-of-Line Indicator intact, they will be needed for the import.

    8. Save the file as a CSV after adding the grades.

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

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

    Uploading the file

    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 Removed
    A screenshot of the Import Grades screen with no errors or warnings found.Image Added
    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”

    1. Imported Successfully message and your imported grades will appear under the Enter Grades tab of your

    Gradebook

    1. 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.

    1. Choose Export to CSV or Export to Excel.

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

    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

    Scantron processing

    1. Instructors can acquire scantron forms from Brock Printing and Digital Services (MacKenzie Chown G210, ext. 3207).

    2. The scantron forms must be filled out in pencil.

    3. To have the forms processed, they must be brought to the ITS Help Desk. A Scantron Test Processing Request form must either be completed in advance and submitted with them, or one can be filled out at no charge at the Help Desk upon arrival.

    4. The forms are scanned and processed by Scantron Processing Services. If an instructor used multiple versions of the same exam, each version has its own results sheet generated. The resulting sheets are uploaded in the form of a standard excel file containing student names, IDs, and grades, to the instructor’s BrockDB portal. Any optional reports requested in the Scantron Test Processing Request form are emailed to the email provided on the form as either a PDF, CSV, or both as indicated.

    5. Results and reports are retrieved from BrockDB by the instructor and added into Brightspace.

    Import Scantron results to Brightspace

    1. In Brock DB:

      1. Find the Scantron results and download the .csv labeled rosterreport. This contains only student ID numbers and total scores.

    1. In Brightspace:

      1. Go to Grades and click Export.

      2. Use only the default Key Field option Org Defined ID to match what the Scantron provided.

        1. If you have created a Grade Item for the Scantron assessment, scroll down and select that:

          Image Added

        2. If you have not created a Grade Item for the Scantron assessment, you can export with none selected. You will be prompted to create a new Grade item when importing back to Brightspace.

      3. Choose Export to CSV and be sure to actually Download once it’s prepared.

    2. In Excel:

      1. The import back to Brightspace does not require every student--it’s acceptable if some are missing. Be careful that you don’t move the Scantron scores to the file with the complete list of students, as those may not align.

      2. In the rosterreport sheet, remove all columns except Student_Id and Grade.

      3. Copy the column headers from the exported sheet and paste them into the rosterreport sheet. Rearrange as necessary: OrgDefinedId | scantron grade item name | End-of-Line Indicator.

        1. The Grade Item column name (which includes information exported from Brightspace) will replace the Total column. The complete cell data will look something like this:

          Image Added

        2. OrgDefinedId will replace Student_Id. The End-of-Line Indicator is for Brightspace.

      4. Save the file.

     In Brightspace:

    1. Go to Grades and click Import. Attach the now updated rosterreport CSV. This will run through a few verification steps. You will get a final confirmation showing how the grades are filling into the relevant column.

      1. If you did not have a Grade Item set up in advance (Step 2.b.ii), select the option to Create new grade item when an unrecognized item is referenced. This will let you specify the name, max points, and weight.