WebCT Information for Instructors

Instructions for Exporting Student Grades to Microsoft Excel

1. Click on Control Panel
2. Click Manage Course
3. Go to Manage Students
4. Under Actions, Options: Records, select Download
5. Click Go
6. Next to Record separator, select Comma
7. Click Download
8. A window will pop up titled File Download, click the Save option
9. Select the location where you would like to save the file such as the Desktop, and click Save
10. Open Microsoft Excel
11. On the top menu bar click Data
12. Select Import External Data
13. Click Import Data
14. Locate your newly downloaded file and click Open
15. Make sure the Delimited option is selected and click Next
16. Under delimiters, deselect Tab and select Comma
17. Click Next
18. Click Finish
19. A window will pop up asking you where you want to put your data. Click on the location of the sheet where you want the data inserted, and click OK

You should now see the names and WebCT IDs of the students listed along with their grades.

Click on this link to view a printable version of this page.
 

WebCT Contact Information
WebCT Contact Information
Lars Larsen, Director, Distance Learning and AV Services | 803.323.4551 | larsenl@winthrop.edu
Last updated: 10/02/06