How do I create a weighted column using percentages?
A weighted column is a type of calculated column that computes a grade based on the result of selected columns and categories that are weighted using percentages. For example, a semester grade could be calculated using the following formula:
Semester Grade = Assignments (40%) + Tests (40%) + Quizzes (20%)
- Go to the Grade Center under the Course Management area
- Select Full Grade Center
- Once in the Grade Center, choose the Create Calculated Column action link.
- Select Weighted Column.
- Type in a Column Name in the textbox (e.g., Total Weighted Column).
- The Grade Center name is optional and is only visible in the Grade Center, which is not visible to students under My Grades.
- The Description is also optional and is only visible when the students see the column details in My Grades.
- Select an option from the Primary Display down drop list. For example, selecting Percentage will show the students their final calculated percentage in this column (e.g., 93%).
- To select the columns and categories to include in the equation, click on the name, and choose the arrow next to the Selected Columns area. The top arrow controls the columns, and the middle arrow controls the categories to select. This will transfer the column or category to the Selected Columns list.
- Set the percentage of the total for each column and/or category.
- Select Calculate as Running Total, if needed. A running total only includes items that have grades or attempts. Selecting No includes all items in the calculations, using a value of 0 for an item if there is no grade.
- Select the other Options as appropriate.
- Click Submit.
Note: If a category does not have any assessments defined, then you cannot use the category option.