...
Though Canvas's built-in messaging tool and announcements offer you ways to communicate with your students, it may be helpful to have a list of your students' emails handy. Below, we have outlined the quickest way to generate such a list from within your Canvas course.
Click in to your course site.
Select Grades on the
...
Course Layout Menu.
Select Actions in the upper left of the Gradebook page, and then select Export from the drop-down menu that appears.
...
Locate and open the .csv file on your computer
...
Next, select row 2 and right click to delete this row from the excel file.
(Click image below to enlarge it)
...
To increase readability, we recommend expanding columns A, B, and C, in addition to labeling column C as "Email Addresses". In cell C2, type =B2&"@u.boisestate.edu" and press Enter. This should automatically update the cell with the student's email address.
(Click image below to enlarge it)
...
and open it.
Example: Downloads might be saved to the “Downloads” folder on your computer
Delete all columns except for Student, SIS User ID (student ID), SIS Login ID (username)
...
Add the header “Email Addresses” to Column D.
In row 2 of Column D, type in the formula: =C2&”@u.boisestate.edu”
...
Select the small square in the lower right corner of D2. Pull the formula down. The email addresses will autogenerate.
...
To save the email list you have just created, select File in the upper left of the excel document.
...
Select Save As > This PC and designate a location to store the file on your computer.
You now have a list of your students' email addresses!
...
Relevant Information
Have a suggestion?
...
Related Articles
| Expand | ||||
|---|---|---|---|---|
| ||||
|