WebCT Information for Instructors

Instructions for exporting Quiz/Survey results to Microsoft Excel or other spreadsheet software

1) On the Home page, click on the icon for your Quizzes/Surveys.

2) Click the Detail link for the Quiz in question.

3) Under Options: Manage Columns on the right, click Update table.

4) You will see a table showing the students who took the quiz, what their score was, and what their answers were.

5) Under Options: Manage Columns, click Export quiz detail to disk. 

6) Save the file to your hard drive. It will have a name along the lines of scwk330_quiz_Jan_24[1].txt.wct

7) Rename the file, removing the "[1]" and the ".wct" : For example, scwk330_quiz_Jan_24.txt

8) Now, you can open Microsoft Excel (or any other spreadsheet program) and open this file with Excel. Save the file as a *.xls file so that it is a proper spreadsheet. You can now manipulate the data with Excel as you would any spreadsheet.

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

WebCT Contact Information
Suzanne Sprouse, E-Learning & Project Coordinator
Distance Learning and AV Services | 803.323.2551 | sprouses@winthrop.edu
Last updated: 02/05/07