From Hdwiki
Manage Columns
| Online Learning Module |
Contents |
Adding a Column
When you create a new quiz or assignment, WebCT creates columns for them within the Manage Students section automatically. This page will tell you how to create columns manually that will appear within the Manage Students section.
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Within the Actions menu on the right side of the page, under Organize, click on the Add column button.
- Type in a name in the Label field.
- Change the Type from Alphanumeric to Numeric and click the Add button.
- The new column will appear at the end of your existing columns.
Editing Columns
After you create columns, you have the ability to edit it in various ways. You can rename the columns, release them, hide them, format them, and move them to a different position within the table. You also have the ability to delete the column entirely.
Rename a Column
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Check the box above the column that you want to rename.
- Under the Actions menu, within the Change column label: field, type in a new name.
- Click on the Go button.
Release Columns
You have the ability set up all of your columns prior to the start of the course. However, you may not want your student to see all of the various assignments, quizzes, et al., until the appropriate time comes. Therefore, WebCT gives you the ability to release columns to students’ grade book at your convenience.
To release a column to your students:
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Check the box above the column that you want to release.
- Under the Actions menu, click on the Release columns: drop-down box and choose Yes.
- Click on the Go button.
Note: You have the ability to release multiple columns at once.
Hide Columns
After you have released columns to your student, you can hide those columns at any time. To hide or unhide a column from your students:
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Check the box above the column that you want to hide.
- Under the Actions menu, click on the Hide columns: drop-down box and choose Yes.
- Click on the Go button.
Note: You have the ability to hide multiple columns at once.
Moving Columns
By default, when you create a new column, it appears to the right of all other columns. WebCT gives you the ability to move that column to any other position within the table. To move a column from one position to another:
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Check the box above the column that you want to move.
- Under the Actions menu, click on either the Move item left: or Move item right: drop-down box. Choose the appropriate number of spots you would like to move the item.
- Click on the Go button.
Note: You can only move one column at a time.
Delete Columns
To delete a column:
- From the main page, click on Manage Course located within the Designer Links in the Course Menu.
- Under Manage Students, click on Manage Columns.
- Check the box above the column that you want to delete.
- Under the Actions menu, under Organize, click on the Delete columns button.
- Click the OK button.
Note: Once you delete a column, you can no longer recover it or any records that were contained within that column.
Creating a Total Column
By default, a total column that will add all of your columns together is not available. Instead, you will need to manually create and update such a column.
- On the Manage Columns page, within the Actions menu on the right side of the page, under Organize, click on the Add column button.
- Type in a name in the Label field like “Total” or the like.
- Change the Type from Alphanumeric to Calculated and click the Add button.
- The new column will appear at the end of your existing columns.
Calculating Your Columns
By default, the total column that you create is blank since it does not assume which columns you want to add. You will need to populate the columns manually.
- Check the box above your “Total” column.
- Within the Actions menu on the right side of the page, under Organize, click on the Setup column button.
- If the column type is correctly set to Calculated, then you will see a window similar to the one below.
Using the Calculator
This is a computerized version of a hand-held calculator; therefore, you need to treat it as such. This means that you are not able to type, highlight, or change items directly within the Formula field. You will need to use the buttons just like a hand-held calculator, as well as use the Column: field. To add columns together:
- Under the Column drop-down box, choose the first column that you would like to total.
- Note: You can only add columns that contain a numerical value. If any columns are set up as Alphanumeric or the like, those columns will not show within the Column drop-down box and you will not be able to add them to your “Total” column.
- Click on the Insert button.
- Since you are adding columns together, click on the “+” button.
- Repeat steps 1-3 to add more columns.
- When finished, click on the Update column.
- Note: As you add more columns to your course, update your “Total” column manually.
Editing the Total Column
To add more items to the total column, follow the instructions above. To remove items from the total column, follow these instructions:
- Click on the Manage Students link.
- Navigate to your "Total" column. Click on the Formula link.
- To remove items, click on the CE button to remove items one at a time.
- Add more items if need be. When finished, click on the Update button.
