Automatic Method: Create a Weighted Calculated Column
Review Drop Lowest Score - Case Study background.
To order to automatically drop the lowest score for each quiz with a weighted column, Julie will
set up a new "calculated" column for the quizzes. The column will
drop the lowest score and provide a final Quiz Score for the Quiz category.
Then Julie will use the results of the Quiz Score column in the Total scores
column.
- Go to the Grade Center main page.
- Click Create Calculated Column button.
- Select the Weighted Column option from the menu
- In Section 1 of the Create Weighted Column screen, enter a name such as "Quiz
Scores" for the Column Name.
- For Description (optional), enter "Drop the lowest Quiz score."
- Select Percentage for Primary Display.
- In Section 3, select the columns and/or categories to include in this weighted grade and then set the weight percentages. For this example, the instructor will choose the category Quiz, since all of the quizzes in this course use this category. (Step 1 below)
Note: It doesn't matter what the category is named, but
all scores must be in the
same category in order to drop a score. For more
information about categories, see
Creating
Categories.
- To work with this category, click the small arrow at the top and to the right
of the list (Step 2 above).
- The category Quiz will appear on the right side of the screen
with options.
- In the percentage box, enter the total percentage
for this category in the course. For this example, the quizzes
account for all of the points in this course, so 100% will be entered.
- For Weight Columns, select Equally (since the point value
for each quiz is the same).
- For Drop Grades, enter a "1" in the blank for Drop __ lowest
grades.
Important! Unlike
this example, most courses will have more than one category of points. Once
a calculated column has been set up for one category, one or more calculated
columns will be needed to total 100% of the course points in the Total column.
For instance, if tests are worth 20% of the course and a calculated column
is used, then at least one other calculated column
worth 80% of the course will need to be used.
- Below the gray box, you will see options for Running Total. For Calculate as Running Total, select No.
- In Section 4, you will choose some display options. For Include this Column in Grade Center Calculations, select Yes
- For Show this Column to Students you may select either Yes or No. It
depends
whether students should see this column.
- For Show Statistics (average and median) for this column to Students in My Grades, select No.
- Click Submit.
NOTE: Depending upon the number you entered in the percentage box, you may
get a dialogue box stating, The sum of the weights is not 100%. Continue? If it is what you intended, click OK.
The Quiz Scores column now shows a percentage total of the quizzes with the
lowest score dropped (28 out of 30 points is 93.33%).
The final step is to modify the Total column to include the
calculated quiz score total.
- Go to the Grade Center main page.
- Find the Total column and click the menu.
- Select Edit Column Information.
- In Section 1, choose what the student should see for Primary Display. The option Percentage has been selected.
- Choose what you would like to see for Secondary Display. (This is optional. Keep in mind that the
student does not see the secondary display.) Letter has been
selected.
- In Section 3, select the columns to be included in the Total column. To do this, click the button next to Selected Columns and Categories.
- In the section, Columns to Select, click on Quiz Scores.
- Click
the arrow to the right to add this column.
- The column Quiz Scores appears in the right panel.
NOTE: Unless
the course only uses quiz scores, you will need to select other columns or
categories to obtain a true total course score.
- For Calculate as Running Total, select Yes*
- In Section 4 select display options:
- Include this Column in Grade Center Calculations, select Yes.
- Show this Column to Students, select Yes.
- Show Statistics (average and median) for this column to Students in My Grades, select Yes or No.
- Click Submit.
The information from the Quiz Scores column has been added to the Total column.
The calculations are correct.
Once you have set up calculated columns, check your Grade
Center settings throughout the term to see if the scores are calculating as expected.
Return to Drop Lowest Score - Case Study
Return to Tips and Tricks