Advanced Options

Downloading Grades to a Spreadsheet

The following are steps on how to download the Moodle gradebook as an Excel spreadsheet:

  1. From the Grades table, select Download in Excel format. #1
  2. The File Download screen will appear. Click on Save and
    choose the folder you want the file saved to. #2

Note: Letter Grades cannot be included in the spreadsheet.

Setting up Grade Exceptions

To exclude specific assignments from the grade calculations, follow these steps:

  1. Click on Grades in the Administration block.
  2. Click on the Grade Exceptions tab from the top menu.
  3. From the middle column, select the grade item that you want to make an exception for. #1
  4. In the left column a list of all the students’ names that are included in the grading for that item will appear. Select the name(s) of the student(s) that you want to make an exception for. #2

Note: You can select multiple names using the Shift key on your keyboard.

  1. Click on Exclude from Grading at the bottom. The student(s) will be moved from the left into the right column and will be excluded from the grade calculations for that item. #2

Note: To include students that have been excluded, choose the appropriate assignment, click the student in the right column and click on Include in Grading at the bottom. The student will then be moved from the right column to the left column. #3

 

 

 

 

Important note: The final average includes all the assignments, exams, and/or other activities that are in your Moodle course, whether or not the students have completed them. For example, if an exam has been created, but has not been given to students, the value of zero (0) will be factored into the overall average calculation. To display the latest up-to-date semester average, the activities or exams need to be excluded from the grading calculations.

Awarding Extra Credit Points for an Activity

Extra Credit points can be awarded on top of already existing acitivty grade. Uses for this might include giving specific students scores above what the highest possible grade is on an activity without affecting other students’ grades.

Important Note: The gradebook must already be configured (see pg. 1 of this tutorial) and have existing categories for the assignments to which extra credit will be applied.

  1. Log in to your course and click Turn editing on.
  2. Select Offline Activity from the Add an activity drop-down menu. #1
  3. Enter a name and a description. The activity’s name should indicate “extra credit.”
  4. The Grade drop-down menu should reflect the highest number of extra credit points possible.
  5. Click Save and return to course.
  6. Click on Grades in the Administration block.
  7. Select the Set Categories tab from the top menu. #2
  8. From the Category drop-down, place the extra credit offline activity in the same category as the original assignment. #3
  9. Select the Extra Credit check box next to the bonus item. #3
  10. Click Save Changes. Grade the extra credit assignment as you normally would any other to award extra credit points to students.

Awarding Bonus Points for a Category

Bonus points will add a specified number of points equally to all students’ point total for a category without affecting the overall number of possible points. To provide specific students with points use extra credit instead.

Important Note: The gradebook must already be configured (see pg. 1 of this tutorial) and have existing categories to which bonus points will be applied.

  1. Log in to your course.
  2. Click on Grades in the Administration block.
  3. Select the Set Weights tab from the top menu. #1
  4. In the Bonus Points box enter the total number of overall points to award participants. #2
  5. Click Save Changes.
  6. This will add the number of points specified to each student’s overall total for that category.