As of July 31st 2009 WebCT was no longer be available at Brock University. Learn more about Isaak, Brock University's Sakai-Based LMS here. This wiki is available for others using WebCT Vista & CE versions 6 through 8 but is not maintained by Brock University.

From WebCT Wiki

Providing students with marks is an excellent way to keep students engaged, motivated and on-track. At Brock there seems to be three competing methods of posting marks:

This is Brock University specific content

1. Genesis also known as BrockDB
2. WebCT
3. The note taped outside your door- although this method now contradicts current FIPPA legislation.

If your students are checking WebCT frequently for course notes, discussions, and other supplements to the lecture, then it makes sense to add marks also.

[edit] Getting Marks into WebCT: Using WebCT Web Interface

Adding marks to your course can be done through the "Grade Book" found under the "Teach" tab.

By default you will have two columns, Midterm and Final. You can add other columns by using the "Create Column" button.

Be sure the column is Released and set to a "Grade" column.You can check these settings in the "GradeBook Options" button.

If you need to use the auto-calculate function, the columns to be added up, need to be "Numeric". Otherwise, you can use alphanumeric if you want to letters & numbers (78B or 82P1).

You also need to go to Manage Course=>Tools=>and select the checkbox next to MyGrades for students to see their grades.

[edit] Getting Marks into WebCT: Using MS Excel

• • Following information is for reference only****

Be certain to upload your marks back to WebCT frequently in order to minimize any chance for information loss.

[edit] Stage 1: WebCT (downloading)

• • NOTE: upload function is currently not working***

• Log into WebCT and your course and go to Teach tab
• Select "Grade book"
• Click on "Export to Spreadsheet"
• You can leave all the default choices selected, as long as you remember whether you chose "comma" or "tab" delimited.
• Click "Export"
• Note: if you are running Internet Explorer, it may prevent you from downloading this file. Click on the yellow bar to allow downloads. This will push you back out to the myWebCT page. Go back into your course and start back at the Teach tab.

[edit] Stage 2: Excel

• • NOTE: upload function is currently not working***
• Open Excel
• Within Excel, open the new file you just created
• The default when the file is opened is “Delimited”, and you want that, so click Next.
• The default on the next screen is Tab (which I’m assuming you used, see Point 6 above), which is what you want, so click Next.
• At the next screen, you normally just click Finish.
• At this point, you can enter grades etc. Note again, you cannot add students or new columns at this point (you must do that in WebCT before you start through the Manage Columns section).
• When finished entering grades, save file. It is okay that you will lose some information (as it warns you) – just proceed with the saving. Close Excel.

[edit] Stage 3: WebCT (uploading)

• • NOTE: upload function is currently not working***
• Log back into WebCT and your course and go to Teach tab, Grade Book
• Click on "Import Spreadsheet"
• Click on Choose File
• Select the file from the My Computer icon
• for Separator, select Tab or Comma (again, if that is what you used)
• Click on Upload
• Confirm the changes are as you want
• Note, a warning that Last Name, First Name columns are not imported, keep that as it is- do not re-import.

Congratulations, you have now updated your file!