Moodle can be configured with different Gradebook calculation methods depending on the scenario. This guide is specifically for the scenario where the final course grade is calculated based solely on the independent items set by the teacher and their corresponding percentages. Additionally, this setup ensures that other grade items that already exist in the course but are not included in the final grade calculation remain visible and unaffected.
1. Access the Moodle page of the course, and then navigate to the “Gradebook” settings page via the path “Grade –> Setup -> Gradebook setup”. Click the “Add grade item” button at the bottom.
2. Add grade items according to the dimensions you want to track. In this step, you only need to fill in the “Item Name” and then directly click the “Save Changes” button at the bottom of the page.
3. After all the grade items have been added, the interface will look like the screenshot below. At this point, make sure that the weights of all items are initialized to 0. If there are any other existing items, set their weights to 0 as well.
4. Since we only need to use the percentage calculation method to calculate the grades, we first need to ensure that there are no existing calculation formulas in the course.
We start by locating “Course Total” at the bottom of the interface from the previous step and clicking its corresponding “Edit -> Edit calculation” button. If there is a formula in the “Calculation” section of the newly popped-up interface, just delete it. Then click the “Save Changes” button to save this modification.
Please note that not all courses will have existing formulas, so if there is no formula, you can skip this step directly.
5. Next, we need to confirm that the grades will be calculated using a percentage-based formula. First, go to the “Gradebook setup” interface and click the “Edit -> Edit settings” button corresponding to the name of the top-level item.
6. Set the value of “Aggregation” to “Weighted mean of grades,” and then click the “Save changes” button at the bottom of the page to save the modification.
Please note that if there are other formulas in the grade book as shown in step 4, the “Aggregation” option will not be displayed on this page.
7. In the “Gradebook setup” interface, assign the corresponding weight percentages to the new items you set up in the previous steps. Set the weights of all other items that do not participate in the calculation to 0. Scroll to the bottom of the page and click the “Save changes” button to save these settings.
With this, we have completed the setup of the Gradebook. Below is a brief explanation of how teachers can bulk import student grades according to this setup.
1. Go to the “Grades -> Import” page and prepare a csv file (one of the formats of an Excel spreadsheet) that contains student information and the final grades for each item. Then click the “Choose a file” button.
You can click the following online CSV document for reference. Grade Upload.csv
2. The system will automatically read the contents of the csv file. As shown in the figure below, the first part is the matching rule between the students in the course and the student information in the csv file. The second part is the matching rule between the columns in the table and the items in the Gradebook that we previously set up to participate in the calculation.
After selecting the corresponding matching rules, click the “Save Changes” button at the bottom of the page.
3. After completing the above operations, you can go to the “Grades -> View -> Grader report” page to view the grades that were just uploaded in bulk.
You will notice that the scores of other existing items that are not used in the final grade calculation remain unchanged and are not affected.
The “Course Total” score at the end is calculated solely based on the percentage settings of the items we previously configured. Other items that are not within the calculation scope, such as “Attendance,” will have their own separate scores, but these will not influence the final grade calculation.