The best approach would be to download grades from the Participation Report then delete all the unnecessary columns, leaving only student names and email addresses (feel free to also use the Template Roster attached to this article!). The specific steps may vary depending on your LMS. Here are some examples:
Step-by-Step Instructions for Extracting Your Roster from Blackboard
- Go into the course you want to view.
- Choose "Grade Center" under the "Control Panel".
- Click on "Full Grade Center".
- Click on the gray "Work Offline" button at the top, right corner
- Click "Download"
- Choose the "User Information Only" option for "Select Data to Download"
- Click "Submit"
- Open the downloaded file and delete all unnecessary columns leaving student names and email addresses
- Save and name the file "[YourName]_RosterTermYY" (example: Jones_RosterF18.csv)
Step-by-Step Instructions for Extracting Your Roster from Canvas
- Check the sidebar and navigate to the "Grades" tab
- Click on "Export" and choose the "CSV file" link
- Open the file and delete all unnecessary columns leaving student names and email addresses
- Save and name the file "[YourName]_RosterTermYY"
Note: The roster might not include the emails but the student's SIS Login ID, which is the first part of the email address (example: student123 = student123@students.sbts.edu). If you can't find the email, the login IDs are good too!
Step-by-Step Instructions for Extracting Your Roster from D2L
- On the "Enter Grades" page, click "Export"
- On the "Export Grades" page, keep the Last Name, First Name, and Email checkboxes selected under "User Details"
- Check the top checkbox under "Choose Grades to Export" to clear all the grade items
- Click "Export" to CSV
- In the Export Grades pop-up window, click on the hyperlink to download
- Open the file and delete all unnecessary columns leaving student names and email addresses
- Save and name the file "[YourName]_RosterTermYY"