Example: Weighted Quarter Final Grade
You can create a weighted column that calculates a grade for one quarter of the year in which the Test category, the Assignment category, and the participation grade column are each given a certain percentage of the quarter's final grade for your course.
(Tests = 40%) + (Assignments = 40%) + (Participation = 20%) = (Quarter Final Grade)
Example: Weighted Final Grade for the Year
You can create any number of weighted columns, including weighted columns that include other weighted columns. You can create a weighted column that uses the quarters’ weighted columns and the final test grade columns to calculate the final grade for your course.
(Quarter 1 = 15%) + (Quarter 2 = 20%) + (Quarter 3 = 15%) + (Quarter 4 = 20%) + (2 Semester Tests = 30%) = (Year Final Grade*)
Note: Columns with text as the grade display are not included in a weighted column’s calculation. For example, if you set a column to display text, such as Satisfactory/Unsatisfactory, you cannot use it in grade calculations.
*In a new course, the default total column is the default external grade column, but you can set any column as the external grade. The external grade is the grade reported to your institution.
When you create a weighted column, you can include:
- All Grade Columns: Include all individual grade columns in the Grade Center.
- Selected Columns and Categories: Include specific grade columns and categories (and the associated columns).
- Selected Columns from a Grading Period: If grading periods exist and you have chosen a category, include only the grade columns that have been associated with a specific grading period.
Example: Simple Weighted Column for First Quarter
You create a weighted column based on two columns and two categories:
- Assignments Category = 25%
- Chapter Quizzes Category = 25%
- Midterm Test = 20%
- Final Test = 30%
Note: Only the first 14-15 characters typed in either name box appear in the column heading in the Grade Center grid. Point to the column heading to see its full name on the Grade Information Bar.
3. Make a selection in the Primary Displaydrop-down list. Optionally, make a selection in the Secondary Display drop-down list.
4. If grading periods exist, you can associate the weighted column with a grading period by making a selection in the Grading Period drop-down list. If no grading periods exist, the drop-down list does not appear. You can use grading periods to filter Grade Center data and create calculated columns.
5. In the Select Columns section, select what to include in the weighted column's calculation and assign percentages for each column or category.
- Select the columns in the Columns to Select box and click the right-pointing arrow to move the selections to the Selected Columns box. When you select a column, you can view information about the column in the Column Information area below the Columns to Selectbox.
Note: A column that is set to No for Include this Column in Grade Center Calculations does not appear in the selection list.
Tip: For Windows, to select multiple items in a list, press the Shift key and click the first and last items. To select items out of sequence, press the Ctrl key and click each item needed. For Macs, press the Command key instead of the Ctrl key.
- Select the categories in the Categories to Select box and click the right-pointing arrow to move the selections to the Selected Columns box. When you select a category, you can view which columns are included in the category in the Category Information area below the Categories to Select box. The following table lists the options that appear after you move a cate
|Grading Period drop-down list||If you selected a category for the calculation, you can limit the columns used by selecting a particular grading period.|
|Weight Columns||Select how to weigh columns within the category.
|Drop Grades||Removes a number of either the highest or lowest grades for each category from the calculation. If you do not type numbers in the boxes, no grades are dropped.|
|Use only the Lowest -OR- Highest Value to Calculate||Removes all grades from the calculation except for the best or worst score.|
Note: To delete a selection in the Selected Columns box, click the red X.
7. Calculate as Running Total: Click Yes to calculate as a running total. Running totals exempt cells that do not contain data. Click No to include all selected columns in the calculation, using a value of 0 if no grade exists. This can make grades appear artificially low.
8. Select the Options:
- Include this Column in Grade Center Calculations: Click Yes to make the column available for potential inclusion when creating calculated columns.
- Show this Column to Students: Click Yes to display the column to students/participants on their My Grades pages.
This article was updated: 05/8/2017