NOTE: It is necessary that your student records table in WebCT has the same column headings as your excel workbook. The easiest way to do this is to start in WebCT Manage Course Section and follow these steps:

---

1. Select Manage Students Link
   

2. Select Download from the Drop-down menu and Click Go.
   
   1. Change Record Separator to Tab
   2. Click Download
      

3. Click Save to save the gradebook.
   
4. Save window opens
   1. Select appropriate folder to download
   2. Name file appropriately (eg, grades_eng101.txt)
   3. Click Save
5. Minimize your browser window

Step Two:

1. Open Microsoft Excel
2. Select File - Open
   1. Browse to the folder where you just downloaded the gradebook.
   2. Change Files of type to All Files(*.*)
   3. Select the text file you just downloaded
   4. Click Open
      

3. The Text Import Wizard starts.
   1. Make sure radio button before the word Delimited is selected
   2. Click Next
      

   3. Make sure box before Tab is checked
   4. Click Next
      

   5. Make sure radio button before the word General is selected in the box titled Column Data Format
   6. Click Finish
      

4. Save the workbook
   1. Select File > Save as
   2. Change Save as Type from "Text (tab Delimited) .txt" to "Microsoft Excel Workbook (.xls)"
   3. This saves the text file as a work book
5. Enter any additional column headings, data, formulas, etc that you need to track/calculate grades.
   1. Suggestion 1: Do not change the headings or information in the first three columns. This confuses WebCT.
   2. Suggestion 2: Name the columns something that you will be as happy with the last day of classes as the day you create them. If you try to change the heading after you upload the grade book to WebCT, the program will not place the data in the correct spots. (If you do need to change the Column Headings do this in WebCT not Excel).
   3. Save workbook

    

Step Three Uploading Excel workbook to WebCT Course:

1. After adding the necessary information and saving the workbook you need to save it as a text file
   1. Select File > Save as
   2. Change Save as Type from "Microsoft Excel Workbook (.xls)" to "Text (tab Delimited) .txt"
      

   3. This saves the workbook as a text file (you might get a format warning click ok)
2. Maximize your browser window
3. Select Manage Course
4. Select Manage Students
5. Select Add/Import Student Data from pull down list
   

6. Click Go
7. Click Browse
   1. WebCT Browser window opens (this window has two frames in it notice the scroll bar)
      

   2. The Lower Frame will change. Select the Browse... button.
      
8. 1. Select the .txt file that you created
   2. Click the lower Upload button (this will upload the grade book to the WebCT server)
      

9. The File you just uploaded will now be visible in the upper "File Browser" section of the window.
   1. Click the radio button next to the file you just uploaded
   2. Click Add Selected (in upper frame)
      

10. The WebCT Browser window closes and the file is selected in the Filename box
11. Change the Separator from Comma to Tab
12. Click Import
    

13. WebCT will recognize new fields in the spreadsheet and suggest creating a new WebCT column for each new column. Click Continue.
    
14. Click Continue at the Import Confirmation: Field Names Resolved screen.
15. You will get a Final Confirmation screen. If all looks as expected, click Continue.

---

top

return to WebCT Tutorials Page

---