Some instructors find it convenient to download their WebCT gradebook and edit it with Microsoft Excel. The steps to accomplish this are reasonably simple and are listed below. Please note that there are some limitations, which are included.
In WebCT Download/view video (2.29 MB)
(RealPlayer required to view the video clip) - Manage Course, Manage Students
- Select Download from the Options: Records pull-down menu
- Click Go
- Click the Download button (keep default comma separator)
- Click Save
- Choose a location (desktop or folder of your choice) for saving the file (file type is text)
- Change the file name if desired
- Click Close to close the download dialog box
|  |
| |
Excel- Open Excel
- Open the saved text file with Excel (files of type: All Files or Text Files)
- Text import wizard opens
- Select the Delimited radio button
- Click Next
- Select the Comma checkbox
- Click Finish
- Edit the spreadsheet
- Columns that have been created with the WebCT Assignment or Quiz tool cannot be edited.
- Letter Grade and Calculated columns cannot be edited. Even though you can add values to the columns in Excel, they will not transfer to the WebCT Gradebook.
- New columns created in Excel will migrate into WebCT with the alphanumeric column type. If you want to use such columns in a formula that calculates other column values, you must change the column type to Numeric
- Manage Course
- Click on Add or Modify columns under the Organize heading
- Click Go
- Select the checkbox above the column of which you want to change the type
- Under Organize select Convert column type
- Click Go
- From the New column type pull-down menu select Numeric
- Click Convert
- Click Convert on the confirmation screen
- Check the column type on the Modify Columns screen — N for Numeric
- File, Save As…
- Save as type… CSV
- If desired, rename the file (not necessary, though)
- Keep CSV format when asked
| 
 | hover over image to view effect of checking the Comma checkbox |
|
| |
In WebCT- Manage Course, Manage Students
- Select Add/Import Students from the Options: Records pull-down menu
- Click Go
- In the Import From File section click on Browse... - the WebCT File Browser opens
- In the Upload File section click on Browse..., select the CSV file that you saved earlier in Excel.
- Once you have selected the file click on Open - the file location and name are entered into the WebCT Filename: text box.
- Select the WebCT folder into which you would like the file to be transferred and click Upload - the file is copied to the MyFiles directory you selected and its radio button is selected.
- Click Add Selected at the bottom of the page - the file name is entered into the Filename: textbox.
- Ensure that the Separator: selection is Comma, and click Import.
- If you have created a new column, you will be prompted to resolve the column name. If the name is acceptable, leave the default pull-down menu selection at Create New.
- Click Continue; confirm the import and click Continue.
- Complete the Final Confirmation by clicking Continue.
- Check the columns when Manage Students opens.
- Done
|
