Calculated columns display the numeric result of a formula that you create. By default the Blackboard Vista Grade Book has two calculated columns, Midterm and Final. These columns represent the computed Midterm and Final averages and cannot be deleted only hidden.

You can calculate many mathematical equations for the Final and Midterm columns.
NOTE: Start by writing your calculation on paper and then use the various functions on the Edit Formula screen in Blackboard Vista.

A simple average is one where all assignments, tests, projects, etc…are weighted equally. For example, if you only give 2 tests and a final, each exam will account for 33.3% of the student’s grade.

Grading Criteria:

Test 1              33.3%
Test 2              33.3%
Final Exam       33.3%
Total                99.9% or 100%

Mathematical Formula:

(Test 1 + Test 2 + Final Exam) / 3

To create this formula in the Blackboard Vista Grade Book:

1. For the Final column, click the Actionlinks drop-down menu.
2. Select Edit Column Formula. The Edit Formula screen is displayed.
3. Click the left parenthesis button.
4. In the "Select a column to add to your formula" box, choose the first column you want included in the formula.
5. Click the plus sign button (+).
6. In the "Select a column to add to your formula" box, choose the second column you want included in the formula.
7. Click the plus sign button (+).
8. In the "Select a column to add to your formula" box, choose the third column you want included in the formula.
9. Click the right parenthesis button.
10. Click the divide button (/).
11. Use the number keypad to enter the number of items that are included in the formula.
12. Scroll to the bottom of the screen and click Save.