11. Using the Gradebook Contents Contents
Embedded Files
11. Using the Gradebook
11. Using the Gradebook
Each activity in Moodle is individually graded, although by Gradebook activities can be viewed collectively. Moreover, as explained in ”11.2 Managing grades for the tests outside of Moodle”, the Gradebook are also available to grade activities assigned in or out of Moodle (means include activities assigned outside of Moodle) altogether.
11.1 Totaling and managing scores
11.1 Totaling and managing scores
To summarize grades assigned to each part of content, the Gradebook (Grader report) displayed in the "Grade" feature of Moodle is used. At the "Gradebook setups" in the settings tab, you can make settings for the gradebook.
By default, Chiba University Moodle hides the gradebook from students. If you want students able to check their grades (User report) by themselves, change the settings described later (see section 11.2). However, even if the gradebook is set to hide from students, students can check their scores of individual activities (assignments, quizzes, etc.) at each assigned activity content.
Displaying the Gradebook (Grader report)
By clicking "Grade" in the context navigation of the course screen, "Grader report" is displayed.
The users and available activities list to grade is displayed. The grades for each activities are also displayed.
Selecting a totaling method
You can select the method for totaling on the Gradebook.
① Click "Grades" in the context navigation of the course screen to display the grading table.
Click on the box labeled "Grader report" to open the menu of operations for the grader report, then click on "Gradebook setup".
② The grading table setup screen will be displayed.
Click "Edit" on the far right of the course name (Here, "hajimete no Moodle") and select "Edit category" from the drop-down menu that appears.
Upon doing so, the ※column will show the currently selected totaling method.
③ The "Edit category" screen will be displayed.
Click the box next to "Aggregation" to display the calculation methods that can be used for totaling. Select an appropriate method.
Selectable calculation methods include:
Mean of grades
Weighted mean of grades
Simple weighted mean of grades
Mean of grades (with extra credits)
Median of grades
Lowest grade
Highest grade
Mode of grades
Natural ※
※Natural: Sum of score
Do not check the box "Exclude blank scores".
If you check this box, the calculation results will not include activities that the student did not take/respond to (e.g., quizzes not taken).
《"Simple weighted mean of grades" and "Mean of grades”》
With the "Simple weighted mean of grades", the average scores are calculated by the weight of "Highest grade - Lowest grade" of each grading item.
For example, for grading A1 and A2 (Lowest grade: 0, Highest grade: 100) and A3 (Lowest grade: 0, Highest grade: 10), the weight of A1, A2, and A3 is 100, 100, and 10 respectively.
Supposing when the scores of A1, A2, and A3 are set to 80, 90, and 5, respectively, the ratio of the scores for the "Simple weighted mean of grades" is
((80/100)*100＋(90/100)*100＋(5/10)*10)/210≒0.8333
Therefore, if 100.00 is considered a perfect score for the "Course total", the "Course total" will be 83.33.
On the other hand, the ratio of scores in the case of an "Mean of grades" is
((80/100)＋(90/100)＋(5/10))/3≒0.7333
Therefore, the "Course total" is 73.33.
Adjusting settings to allow students to check their Gradebook (Grader report)
① Click "Settings" from the context navigation of the course screen to open the course settings screen.
Under "Appearance", change "Show gradebook to students " to "YES" and click "Save and display".
② "Grades" will also appear in the context navigation on the student's course screen and can be selected.
③ A grading table (user report) will be displayed, listing your scores in the course.
11.2 Managing grades for the tests outside of Moodle
11.2 Managing grades for the tests outside of Moodle
It is possible to manage scores using the grading table for tests given outside of Moodle, such as mid-term exams.
Settings
① Click from the "Grade" in the context navigation to the "Graders report" box, then click "Gradebook setups" from the dropdown menu to display the "Gradebook setups" screen.
② Click "Add grade item" to display the "New grade items" setting screen.
③ In the "New grade items" screen, set the necessary columns such as "Item name" and "Maximum (Minimum) grade" and click "Save changes" to save the settings.
④ The items entered above will be added to the Gradebook.
Inputting grades
Entering scores for the item (here, the mid-term exam) added to the Gradebook.
① Click "Grade" in the context navigation of the course screen to open "Grader report".
② Click "Edit mode" at the top right of the screen to begin editing, and then enter the score in the blank of the newly added grading item. To save the grade, click "Save changes" at the bottom left of the table. If you want to add a comment in addition to the score, click the gear icon on the upper right of the blank to enter it in "Feedback" displayed on the screen.
Enter the grade in the spaces of the added grading item.To save the grades, Click the "Save changes" on the lower left corner of the table. If adding a comment in addition to the grade, click the gear icon on the upper right corner of the blank column then enter it in the "Feedback" displayed on the screen.
③ Click "Edit Mode" in the upper right corner of the screen to finish editing.
Overall grading changes
On the Gradebook, you can change not only the grading items added as described above, but also scores related to activities in Moodle and feedback comments in general. However, if you change scores or feedback comments in the Gradebook, the grade or feedback comment added in the original activities are overwritten and you are not able to enter it from the activity content afterwards (Gradebook changes are prioritized).
11.3 Using calculation formulas
11.3 Using calculation formulas
You can also use a calculation formula to calculate the total of each grade item, which is called "Course total".
① Click to select "Grades" in the context navigation, then click on "Gradebook setup" from the box that appears to display the "Gradebook setup" screen.
② Select "Edit calculation" from "Edit" under "Course total".
Note) Values calculated using a calculation formula will not exceed the perfect score of the course total (100.00 on the screen).
③ Give a name (ID numbers) to the item to be used in the formula.
The items that can be used in the calculation are displayed. In the box next to the item, enter a name for the calculation and click "Add ID Numbers" to save the ID number.
④ Enter the calculation formula in the "Calculation" field using the ID number enroled in ③.
The formula starts with "=". ID numbers in the formula are enclosed in “[[...]]”.
Click "Save changes" to save, and the changes will be reflected in the "Course total" of the grader report.
Calculation formula examples
Here is an explains with examples that the Assignment 01 (Kadai01), Assignment 02 (Kadai02), and Quiz 01 (Quiz01) have been completed (the quoted by “()” numbers refer ID numbers, considering the Maximum grade for Assignment 01 and Assignment 02 is 100 points, the Maximum grade for Quiz 01 is 10 points, and the “Max grade” for the Course total is 100).
Ex 1) Simple total calculation:
=[[Kadai01]]+[[Kadai02]]+[[Quiz01]]
Note) The result of the calculation will not exceed the Max grade of the "Course total."
Ex 2) Average grades calculation:
=([[Kadai01]]+[[Kadai02]]+[[Quiz01]]*10)/3
Ex 3) Calculation with the condition of calculating the average grades of Assignment 01 and Assignment 02 is calculated only when Quiz 01 is a Maximum grade, and 0 points when the Quiz 01 is not a Maximum grade:
=max(min([[Quiz01]]-9,1),0)*([[Kadai01]]+[[Kadai02]])/2
Main functions that can be used
Function
format
Sum:
sum(Value 1, Value 2, ...)
Average:
average(Value 1, Value 2, ...)
Maximum value:
max(Value 1, Value 2, ...)
Minimum value:
min(Value 1, Value 2, ...)
Remainder:
mod(Value, Divisor)
Power:
power(Bottom of power, Exponent )
Round off:
round(Value, Digits after decimal point)
Maximum integer less than or equal to a given real number:
floor(Value)
Minimum integer greater than or equal to a given real number:
ceil(Value)
Square root:
sqrt(Value)
Absolute value:
abs(Value)
Power with e as the bottom:
exp(Value)
Pi:
pi()
Here select the totaling method for calculating the "Course total" by sumiming up the grades of each grade item.
Specifically the "Simple weighted mean of grades" is the default setting in Chiba University Moodle and "Exclude empty grades" will have been set unavailable, which means by default settings items that have not been graded such as ungraded assignments or quizzes that students have not yet taken are treated as zero points.
Page updated
Report abuse