Calculate a topic total (including the best X from Y grades)

Calculating a topic total including the best X out of Y items is used when the Statement of Assessment Methods (SAM) follows this format:

Weekly quizzes (best 10 out of 12 quizzes counted) 10%
Assignment 1 20%
Assignment 2 30%
Exam 40%


  1. In the Administration block, click on Grades

  2. In the gradebook, click on Setup Tab, click on Gradebook setup

    Gradebook setup

  3. Put the weekly quizzes/assignment tasks into a category. To do this, click the Add category button at the bottom of the page
    add category
  4. Give the category a name, for example 'Weekly quizzes'

  5. If the assessment items are all marked out of different amounts (e.g. one quiz marked out of 10, another marked out of 15), set the Aggregation to Simple weighted mean of grades. This will ensure each assessment item is given equal weight
    set category name and aggregation method
  6. Click save changes

  7. Click the check boxes next to each weekly assessment task, then use the Move selected items to menu to move to the category you just created
    move selected items to category
  8. Your gradebook should now look like the following, with the weekly assessment items together in one folder (Weekly quizzes) and the standalone items separate
    items in category

  9. In the tab menu, switch to Full view
    full view tab
  10. In the Keep the highest column, set the value for the 'Weekly quizzes' category to the number of items you wish to keep. For example, if you want to include the highest 10 scores, change this to 10.
    set the keep the highest value
  11. From the topmost Aggregation menu, select Weighted mean of grades
    set aggregation to weight mean of grades
  12. In the Weight box next to each grade item or category, enter a number that represents how much this item is worth. For example, if an item is worth 5% of the topic total, enter 5. Remember to include a weight for the category (e.g. if you want the 'Weekly quizzes' items together to be worth 10%, enter 10 for the category).
    set weights
  13. At the bottom of the table, change the Topic total Max grade to 100
    set topic total to 100
  14. Click save changes

» How do I...?