How to export student lists from Canvas or Quercus

This article will detail how to export student lists, specifically with the details needed for CÉIM to add students to their hub.

The following sections provide step-by-step instructions on how to export a student list from either Canvas or Quercus for the purposes of sending on to CÉIM. You do not need to do both, but choose to export either from Canvas or Quercus.

Expand or collapse content Exporting student list from Canvas (preferred)

In each relevant Canvas course, navigate to Grades in the course navigation.

Click on the Export button and choose Export Entire Gradebook. An excel file will download to your device.

Open the spreadsheet. There are several IDs listed for students. The relevant ID is listed in column D.

Keep only the columns labelled:

  • Student
  • SIS Login ID
  • Section
  • Student Email
  • Course Instance

Please additionally delete rows 2 and 3.

 

Expand or collapse content Exporting a class list from Quercus

It is preferable to export the list from the Canvas gradebook, as the file from Canvas contains all information required (SIS login ID, email, names). Student lists exported from Quercus do not include emails.

After you log in, you can search by Student, Courses or Modules.

See an example of a search in the image below.

Select eye icon to view full list. Or, click the link at bottom left to Download as CSV.

View will open up the full course list, and if you select ‘Students’ tab you can search student status by registered, pre-registered, all etc.

From here you can print class list or Download as CSV. CSV file does not include emails.