Excerpts from the Handbook

Sections
1 |  2 |  3 |  4 |  5 |  6 |  7 |  8

Manage Students with an Offline Gradebook Using Excel™

4. Enter grades in Excel (add new columns etc.):
1. Refer to item 1.2 for important reminders about creating columns.
2. In Excel formulae can be used as follows
• To curve grades.
• To give an aggregate of scores accumulated over a range of time. For example four essays worth 25 points each (for a total of 100 points) are required in the course. As each essay is graded the Aggregate column would show how many points have been accumulated towards the 100 goal.
• A simple formula can be used to keep an average of all the grade columns so that the student can see immediately what their current grade is for the course.
• You can have extremely complicated formulae including weighted grades.
5. Save as an Excel workbook (.xls extension):
1. In Excel the changes should be saved as a Microsoft Excel Workbook (.xls) file. This is the working gradebook for the semester.





6. Save a second time as a Tab-delimited text (.txt) file:
1. The file should be saved again as a text (.txt) file (Tab-delimited). This is the file that will be imported into WebCT. At this point a Microsoft Excel Warning box will pop up.
2. The Warning box is asking if the workbook should be saved in the Text (Tab-delimited) format. Click on the Yes button. Note at the top of the worksheet that the title is followed by .txt, which confirms that this is a text file.





7. Import Student Data into WebCT (this uploads and imports the data from the revised Tab-delimited (.txt) file above:
1. In WebCT on the Control Panel, choose Manage Course.

Sections
1 |  2 |  3 |  4 |  5 |  6 |  7 |  8