Uploading grades to the LMS

If the grades from your Cadmus assessment haven't pulled through to the LMS Grade Centre, you may need to upload the grades manually.

Follow these steps to upload grades for:

Blackboard

To upload grades to Blackboard, you will need to:

  1. Create a new column in Grade Centre
  2. Download the Grade Centre spreadsheet
  3. Download grades from your Cadmus assessment
  4. Transfer the Cadmus grades into the Grade Centre spreadsheet
  5. Upload the updated spreadsheet to Blackboard 

 

To create a new Grade Centre column

  1. Navigate to the Full Grade Centre page.
  2. Click Create Column.

    create-column-blackboard@2x

  3. Give the column a Name.
  4. Enter a numeric value for Points Possible (the highest mark that the assessment task can have).
  5. Click Submit.

 

To download the Grade Centre spreadsheet

  1. From the Full Grade Centre page, select Work Offline > Download.

    download-grades-blackboard@2x

  2. Choose Selected Column from Select Data to Download, then select the column you've just created.
  3. Click Submit.
  4. Click Download.

 

To download grades from Cadmus

  1. From your Cadmus assessment, navigate to the Marking page.
  2. In the More options ••• menu, click Download grades.

 

To transfer the Cadmus grades into the Grade Centre spreadsheet

  1. Open both files in Excel or similar.
  2. Sort both sheets by Last Name.
  3. Copy the grades from the Cadmus spreadsheet into the Grade Centre spreadsheet.
  4. Save the updated file.

TIP! We would recommend copying the grades across using the VLOOKUP function, matching by Email address.

 

To upload the updated spreadsheet to Blackboard

  1. From the Full Grade Centre page, select Work Offline > Upload.

    upload-grades-blackboard copy@2x

  2. Click Browse My Computer and select your updated file.
  3. Leave the delimiter type at Auto.
  4. Click Submit.
  5. Confirm your updated column, and click Submit.

 

Canvas

To upload grades to Canvas, you will need to:

  1. Download the Gradebook spreadsheet
  2. Download grades from your Cadmus assessment
  3. Transfer the Cadmus grades into the Gradebook spreadsheet
  4. Upload the updated spreadsheet to Canvas

 

To download grades from the Gradebook spreadsheet

  1. Navigate to the Grades page in your Canvas site.
  2. Click Actions > Export.

 

To download grades from Cadmus

  1. From your Cadmus assessment, navigate to the Marking page.
  2. In the More options ••• menu, click Download grades.

 

To transfer grades from Cadmus to the Gradebook spreadsheet

  1. Open both files in Excel or similar.
  2. Sort both sheets by Email Address.
  3. Copy the grades from the Cadmus spreadsheet into the appropriate column of the Gradebook spreadsheet.
  4. Save the updated file as a .csv.

TIP! We would recommend copying the grades across using the VLOOKUP function, matching by Email Address.

 

To upload the updated spreadsheet to Canvas

  1. Navigate to the Grades page in your Canvas site.
  2. Click Actions > Import.
  3. Click Choose file and select your updated Gradebook .csv
  4. Click Upload data.
  5. Review updates and click Save changes.