|
|
WebCT
Faculty Tip Sheets
Manage Students/Gradebook
Manage Students is a powerful tool for maintaining student information and grades in WebCT.
My Grades, the tool students use to view their grades, is integrated with Manage Students. Use Manage Students to add or delete students, update student records, calculate grades, access the Quiz and Mail features for a particular student, add statistical information to student records, change how student records are displayed, release quiz results and assignment grades to students. This tip sheet covers adding, deleting, and editing columns in Manage Students. Also available are the Modify Column Attributes tip sheet, which covers how to rename, align, convert, hide, and release columns, and the Column Types tip sheet, which covers the eight types of columns and how to edit their settings.
To add a column:
- From the Control Panel, click Manage Course.
- Click Manage Students. The Manage Students screen appears.
- Under Actions, from the Organize drop-down list , select Manage columns and click Go. The Columns screen appears.
- By default, the new column will appear as the last column on the right in the Student table, or you can specify where you want the new column to appear.
- To accept the default placement of the new column, go to the next step.
- To specify where you want the new column to appear, select a column in the Student table before you go to the next step; the new column will appear on its left.
- Under Organize, click Add column. The Add Column screen appears.
- In the Label text box, enter the column name.
- From the Type drop-down list, select the column type and click Add. The Columns screen appears with the column added. For information about the various column types, please see the Column Types tip sheet.
To move a column:
- From the Control Panel, click Manage Course, and then click Manage Students. The Manage Students screen appears.
- Under Actions, from the Organize drop-down list, select Manage columns and click Go. The Columns screen appears.

- Select the check box at the top of the column that you want to move.
- Under Organize, select the direction and distance of the move and click Go. The Columns screen appears with the column moved.
To delete a column:
Warning: You cannot retrieve a column that has been deleted. Before you delete any columns, we recommend that you back up the course and download it to your computer. If you don't like the changes you have made to the course, you can upload and restore the backup. For instructions on backing up and restoring a course, please see the Backup/Restore tip sheet.
Note: You cannot delete the User ID column. You cannot delete a quiz or assignment column unless its corresponding quiz or assignment has been deleted.
- From the Control Panel, click Manage Course, and then click Manage Students. The Manage Students screen appears.
- Under Actions, from the Organize drop-down list, select Manage columns and click Go. The Columns screen appears.

- Select the check box at the top of each column that you want to delete.
- Under Organize, click Delete columns. A confirmation message appears.
- Click OK. The Columns screen appears and the column(s) are deleted.
To edit the values in a column:
This feature allows you to edit the contents of an entire column at once (i.e. enter grades for a test).
- From Manage Students, in the Student table, under the column name, click Edit. The Edit Column Values screen appears.
- In the text boxes, edit the column data.
- Click Update. The Manage Students screen appears with the column updated.
To sort a column:
The Student table can be sorted by a column or a combination of columns. For example, you can sort student records so they appear in alphabetical order according to surname.
- From Manage Students, in the Student table, click the column name that you want to use to sort the records. The screen refreshes and the column that you sorted appears in bold text. This column is now the primary sort key indicated by the small upward pointing arrow beside the column name.
- If a second column is clicked, that column now becomes the primary key, and the other column (the one you sorted in step 1) becomes the secondary sort key. For example, if you want a listing sorted by last name, click the Last Name column. But if you wanted that listing to be sorted by User ID as the secondary key you would first need to click the User ID column, and then click the Last Name column.
|