Support from FASE's Education Technology Office

How do I get student email addresses from Quercus?

Updated on

Although it is recommended to use the Quercus Inbox/Conversations tool to communicate with your students, there are times when you would choose to email your students instead of using the Inbox tool.

There are two methods to download students' email addresses in a CSV format. Both options also include student names and UTORids. The option you select will depend on what additional information you require:

 

  1. A Course Analytics Report: Select this option if you have sections in your course and would like to include information about section membership in your file download.
  2. The UT Advanced Group Tool: Select this option if, in addition to UTORid information and email, you also need Student Number information in your file download.
Expand or collapse content Download emails via Course Analytics Report

1. On the Home Page, select "Course Analytics"

2. Select "Reports"

3. Select "Run Report" for "Class Roster"

4. Select "Run Report"

Filtering the roster report: The +Filter option allows you to export your roster based on sections. If no filters are selected, then "Run Report" will export a CSV for the entire class.

5. Open and view the course roster download file

The roster will download as a CSV file. Locate the CSV file on your computer to open and view the report.

Data in the roster report includes:

  • Student Name (Family and Given Names in one column)
  • Student ID (Canvas User ID - this is not the UofT Student Number)
  • Student SIS User ID (UTORid)
  • Email (student email address)
  • Section Name (all courses include at least one Section, e.g., LEC01)
Expand or collapse content Download emails via UT Advanced Group Tool
Expand or collapse content 1. Enable UT Advanced Group Tool in Course Navigation
  1. In your Course Navigation Menu, click Settings.
  2. From the tabs at the top, click Navigation.
  3. UT Advanced Group Tool is currently in the hidden navigation items. Click on the 3 dots to and choose Enable. Place it where you would like it to to appear in the course menu.
  4. Click Save at the bottom.
  5. Once you have saved your selection, you should see it in your Course Navigation.

2. Export Group Roster

  1. Select the UT Advanced Group Tool option from your course menu.
  2. Once in the tool, select the Export Group Roster option.
  1. Use the button "Click here to download the entire course roster" to generate a copy of the entire course roster. The roster includes students only - those with non-student roles are NOT included in the export file. You can ignore the message "No Group Set is created under this course" if you are simply downloading the entire class roster.

Your roster will not download automatically – it will appear in your Quercus Inbox. After selecting the download button, you may see the following message:

"The report is being generated and will be delivered to your Quercus Inbox when ready. It may take a few minutes."

The time required to generate the report can vary and may take longer for a larger class. Try refreshing your Quercus page to check if it is ready.

4. Retrieve course roster from Quercus Inbox

  1. Select Inbox from the Quercus global navigation menu.
  2. Open the message from UTAGT Admin User.
  3. Download the attached Course Roster Report.

5. Open and view the course roster download

The roster will download as a CSV file. Locate the CSV file on your computer to open and view the report.

Data in the course roster includes:

  • Student (Family and Given Names in one column)
  • ID (Canvas User ID - this is not the UofT Student Number)
  • U of T Student Number
  • UTORid
  • Email
  • First Name
  • Last Name 
Previous Article How do I facilitate final exam viewing in Quercus?
Next Article How can I export my Quercus course?
Still have questions? Contact the FASE EdTech Office