For the latest COVID-19 information, please go to our  coronavirus page. 

nau logo


IN > OIEI > ID&S > Step-by-Step Tutorials

Drop Lowest Grade

If you have a set of grades (in this example, 6 quizzes) and you would like to drop the lowest grade and display the resulting total, you can do so using Categories:

  1. Navigate to Grade Center > Full Grade Center.
  2. Create a category (in this example we'll call it "Quizzes") by navigating to Manage Categories and clicking Create Category.
  3. To add each quiz column to the Quizzes category you created: go to Manage Column Organization, then check the boxes for the columns called Quiz 1 through Quiz 6.
  4. Under the Change Category to... menu, select the category you're using (Quizzes in this example), then click Submit.

  5. categories

    Watch this video to review how to create a category and add grade center columns to that category (steps 2-4 above).

  6. Under the Create Calculated Column menu, select Total Column and call it Quiz Totals.
  7. Set the Primary Display to Score.
  8. In Select Columnschoose Selected Columns and Categories, then under Categories to Select, select Quizzes (or the appropriate category) and click the arrow to move it to Selected Categories.
  9. Under Selected Categories, you'll see options to Drop __ Highest GradesDrop __ Lowest Grades, etc. Set it to Drop 1 Lowest Grades (or however many you would like to drop).

  10. select columns

  11. If you're editing an existing Total column, make sure to also include any columns that aren't covered by the category you've just worked with (in this case Quizzes).
  12. Click Submit. The new column will now show the total of all of the columns that you categorized, minus however many of the lowest (or highest) grades you chose to drop. Feel free to create different categories, name them differently, etc.