| Basic Procedure | |||||||
1. |
Navigate to the Gradebook from the Teach tab | ||||||
2. |
Click on the title of the calculated column and choose option to Edit Column Formula | ||||||
3. |
Enter formula then save it | ||||||
| Examples | |||||||
| Example 1: Using the function buttons | |||||||
| Example 2: Using the keypad to enter a weighted formula | |||||||
| Detailed Instructions | |||||||
| Step 1: Navigate to the Gradebook from the Teach tab | |||||||
Click on Teach tab Click on Gradebook |
![]() |
||||||
| |
|||||||
| Step 2: Click on the title of the calculated column and choose option to "Edit Column Formula" | |||||||
Click on column title Click on "Edit Column Formula" The Edit Formula screen will appear |
![]() |
||||||
| Step 3: Enter formula and Save it | |||||||
Create the formula using the function buttons on the left, the number keypad at the right, and the list of formual compatible Gradebook columns in the middle of the screen. Writing it out first on paper is helpful. The Undo button allows you to erase successive pieces of the formula going backwards from the end. Please note: The only columns that will appear as options for the formula will be Numeric columns, Quiz columns, numeric Assignment columns, and other Calcuated columns.
|
![]() |
||||||
| (return to top) | |||||||
| Example 1: Using the function buttons | |||||||
Click on the button for the function you wish to use. The function name will appear in the formula box |
![]() |
||||||
Click on one of the columns that you wish to use in the function The column name will appear inside the function bracket |
![]() |
||||||
Click on Enter Another Value then click on another column name A comma will appear after the column name that was last entered into the formula
|
![]() |
||||||
| Continue this process until columns have been added to function | ![]() |
||||||
Click End Function. The closing bracket will be added |
![]() |
||||||
| Click on Save button at bottom of screen | |||||||
| (return to top) | |||||||
| |
|||||||
| Example 2: A weighted formula using the keypad | |||||||
| Use number keypad to enter percentage for first item in formula | |
||||||
Click on * in keypad for multiplication Click on column name Click on + sign in keypad |
|
||||||
Type in next percentage, click *, click column name, click + Continue process until all parts of the formula have been added and percentges add up to 100% |
![]() |
||||||
| Click Save button at bottom of screen | |
||||||
| (return to top) | |||||||