  |
 |
 |
|
|
|
|
|
|
Maintained by ic@ucsc.edu |
|
|
How to import scantron results into WebCTOverviewThis tutorial shows you how to modify the scantron files that you get from Media Services and upload them into your WebCT gradebook. Contents:
Create a column in WebCT for the test results1. Click on the Control Panel button, then choose Manage Course, and Manage Students.
2. Now select "Manage columns" from the drop-down box at the far right, and press Go.
3. From within Manage Columns, click on the "Add column" button.
4. From the Add Column Window, type the label for your column. Remember this label, because you will need to make sure the scantron spreadsheet uses the exact same label. For the type of column, select Numeric. Then click on the Add button.
5. To make sure your students can view their results, you need to release the column to them. To do this, click in the box just above the column you want to release. That selects the column.
6. Now, select the drop-down menu next to "Release columns" on the right side of the screen, and choose yes. You can also enable your students to view the overall class statistics so they know where they stand in relation to their classmates.
7. You're finished working in Manage Columns, so go back to Manage Students. You will want to edit the column from within Manage Students to specify the total possible number of points for this column. Select the "Edit" link in the appropriate column.
8. Select the "Out of" box and type in the total possible points and then click on the "Update" button.
Edit the Scantron Results File9. The scantron results file will be attached to an email. The results file will end with a .csv extension. Save the file -- note where you saved it, then open it in Excel. 10. You need to change the column heading with the scores in it from "Results" to match the column you just created in WebCT.
11. In this case, the column was called "Midterm A." Make sure you use exactly the same spacing and case in the Excel spreadsheet that you used in WebCT.
12. Save the file, and make sure you save it as a "CSV" file. Upload the Scantron Results File into WebCT13. From within Manage Students, select the pull-down menu and choose "Add/Import students" and then click on the "Go" button.
14. Now you need to select the file to be imported. Click on "Browse" to see the files on the WebCT server.
15. You need to click on the "Browse" button again in order to see the files on your local computer.
16. Now you see the files on your local computer. Find the scantron results file that you edited earlier, and select it, then click the "Open" button.
17. Now select the "Upload" button to upload the file to the WebCT server.
18. Now your file has been uploaded to the WebCT server, so you need to add it by clicking on "Add selected".
19. Now you need to click on the "Import" button to initiate the import of the data into the WebCT Manage Students gradebook.
20. WebCT will confirm that it found the same column names in your scantron file that exist in the WebCT Manage Students gradebook. Assuming you did everything correctly, there should be no error messages, and you can press the "Continue" button.
21. WebCT will ask for final conformation. Make sure that it has correctly matched the student names and scores from your scantron file with the names in the WebCT Manage Students gradebook, then select "Continue."
Congratulations! You've uploaded your scantron data into your WebCT Manage Students gradebook. Please use the form below to tell us what you think of this page. USCS Faculty Instructional Technology Center |
