Create a Calculated (formula) Column A calculated column is used when you want Blackboard to automatically calculate a value based on other numeric columns. These are the basic directions but note that additional complex formulas may be added. Step 1. Click the Teach tab and click the Grade Book button in the menu bar. Step 2. Click the Create column and select Calculated Column.
Step 3. Fill in the column settings, which vary by column type and then Click Save. The new column will be placed to the right of the very last column in the Grade Book.
Step 4. Click the Column's title to display the action menu and select Edit Column Formula. The following screen will appear.
Step 5. Click Sum or other function (MIN, MAX, AVG). The Sum formula will automatically add a group of columns (values) and provide the total value. In addition to the Sum formula, the following built-in functions are available from the Edit formula window. Min - determines the minimum value from a group of values. Step 6. Select a Column to add to the formula
Step 7. Click Enter Another Value button and select a Column to add to the Sum formula. Repeat Step 2 and Step 3 to add additional columns to the formula. Step 8. Click the End Function button to complete the formula. Step 9. Click Save.
|
