From Hdwiki

Gradebook

Grade Book / "My Grades" Overview

In order to review students’ grades and add grades manually, you will need to navigate to the Manage Students portion within the Manage Course section of WebCT. You are able to see all of the students’ scores all at once in this mode.

However, students will only be able to see individual grades in their My Grades section under the Evaluation Tools. As an instructor, you will only be able to see a mock up of what a student’s My Grades section would look like. You are not able to view individual grades in this mode. Below is an image of what a student might see.

Adding a Grade Manually

In your course, you might be grading students on items that WebCT does not grade automatically. In these cases, you will need to create a column (see Manage Columns for instructions) and then manually enter in points possible and the students’ grades.

1. Navigate to the column where you want to add grades and click on the Edit link.
2. Fill in the total points possible in the Out of: field, and then fill in the number grades for each student.
3. When finished, click on the Update button.

   

You do have the ability to download all of your information onto your computer as a delimited-file so you have permanent access. You can then open the delimited-file in Microsoft Excel to do further analysis on the data. The CSP IT Department recommends that you should always keep a backup of your grades, as there is not a way to recover lost or deleted information.

Export a Copy of the Grades to Your Computer

1. Navigate to your Manage Students section of your course. Within the Actions menu, under Options: Records drop-down box, choose Download. Click on the Go button.

   

2. Under Download Student Records, choose either Comma or Tab. This means either a comma or a tab character will separate each item in each record. Click on the Download button.

   

3. You will receive a prompt to save the file. Find an appropriate place to save it. This will save as a text file (.txt).

Opening the File in Excel

1. Open Microsoft Excel on your computer.
2. Go to File, Open.
3. Change the Files of type to All files (*.*). Find your text file and then click on the Open button.
4. The Text import Wizard will appear. In Step 1 of 3, under Original data type, choose Delimited.

   

5. Click on the Next > button.
6. In Step 2 of 3, choose Comma for the delimiter.

   

7. Click on the Finish button.

Note: If you make any modifications to your information while you are in Excel, you will not be able to import it back into WebCT. For more help on Excel, please contact the Concordia University Help Desk, help_desk@csp.edu, 651-641-8866.

Related Links

• Manage Columns

• This page was last modified 16:07, 23 April 2007.
• This page has been accessed 8,109 times.