Uploading groups from a spreadsheet

If you would like to use pre-allocated groups in Cadmus for marking (instead of randomly assigning students), you can do so by uploading a spreadsheet of students allocated to groups into Cadmus. 

This article covers how to:

  1. Prepare a Groups spreadsheet to upload
  2. Upload your spreadsheet into Cadmus

NOTE: If your groups have already been created in Blackboard, you can follow these steps to import Blackboard groups into Cadmus.

Prepare a Groups spreadsheet to upload

You will first need to put your list of groups and allocated students into the correct format. At the end of this process, you will have two .csv files to upload into Cadmus. One with Group Names, and the other with Group Allocations.

 

To prepare a Groups spreadsheet to upload

  1. Download our Groups Upload Template (.xlsx file).
  2. Open the file in Excel or similar. You will see that the file has two tabs (Group Names and Group Allocations).
  3. In the Group Names tab, under Title, list the names of each of the Groups as you'd like them to appear in Cadmus.
  4. Ensure each group has a unique Group Code — to keep things simple, we recommend making these the same as Title.

    groups-spreadsheet-upload-1@2x

  5. In the Group Allocations tab, list students' First Name and Last Name, along with their relevant Group Code name. You will need to write student names as they appear in your LMS.

    groups-spreadsheet-upload-2@2x

  6. Once you have allocated all your students, save each tab as a .csv file.

 

Upload your spreadsheet into Cadmus

Once you have prepared the two spreadsheets (Group Names and Group Allocations), you're ready to upload them into Cadmus.

 

To upload your spreadsheets to Cadmus

  1. In the My Class page, click Setup grading groups.
    setup-grading-groups@2x
  2. Click Import groups from LMS.
  3. Click Import a .csv or .zip file, then select the two .csv files you prepared.
  4. Select which groups you’d like to import.
  5. Click Import groups.