Custom Reports - Grade Percentage

Custom Reports - Grade Percentage

by Ballard Ingram -
Number of replies: 3

Howdy!

So, I am back with a question regarding custom reports. I asked a question similar to this in another thread, but I feel like it would get too confusing to parse that out and rehash it again.

Question
Custom Report > Source > Course Participants > Grade
Why can't I see this as a percentage of the total grade?

My Assumed Short Answer
Because it wasn't designed that way. It just displays the points.

My... Rebuttal
But why? The grader report can show the grade in twelve (12) different ways, but this can't? Moodle has the capability to show the grade as a percentage, a letter, real, and then different combinations of such, but for this it wasn't foreseen that the same capability for the grader report would be wanted or handy for the custom report?

I read on some stack overflow that if you change the column aggregation to "Average" that it will display as a percentage. It doesn't. So what we resorted to was creating an excel template. We copy and paste the .csv data into our template and through some simple calculations, we get the percentage.

Is there anything I am missing about being able to display a percentage? I believe being able to see this as a percentage would be absolutely amazing and totally eliminate the need for a lot of extra plugins. It feels like with some code movement, it would be very much possible. Early Christmas present for the next release? Please.

Visual Images

The grader report I mentioned.

image.png

Below you will see that the custom report builder can display percentages as seen by the "Course Progress" column, but it can't do percentagese for the grade?

image%20%281%29.png

Average of ratings: Useful (1)
In reply to Ballard Ingram

Re: Custom Reports - Grade Percentage

by Ballard Ingram -
I FIGURED THIS OUT!

So here is how I did it.

You will have to contend with a few things first.
You will NOT see a percent symbol. If you and you're clients are okay with that, then this should work.
 
Step 1
Go to the link below and the section titled "Available aggregation types menu."
Grade aggregation - MoodleDocs

Step 2
Add anything with "mean" in it.

Step 3
Go to the gradebook and set up parent child categories to display the "aggregation" as a mean. You can do simple weighted, or weighted.
 
I did "Weighted Mean of Grades." I changed it and it showed it as the "percentage," just without the percentage symbol. Which I am 100% okay with. Here is the before and after.
 
Grader Report
image.png
 
Custom Report
image%20%281%29.png
 
The only thing I have to contend with is that we have quizzes that we grade, but they are optional. If someone doesn't do them their "average" is lower than what it should be. If someone does do them their average is higher. I think I have to just have it ungraded since it is optional, but still. This is significantly better than not having anything at all. This feels like a step in the right direction. More to come on this.
 
Average of ratings: Useful (1)
In reply to Ballard Ingram

Re: Custom Reports - Grade Percentage

by Ballard Ingram -
For Quizzes we have that are optional, I went to the gradebook, put the graded item weight at 1.00, but the category all of the graded items are in as 0.00. This serves two (2) purposes:

1. It shows the Instructor what the average grade is for all of the quizzes within that category.
2. It does not count the overall grade because it is weighted at 0.00.

PARENT A: 25.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00

PARENT B: 25.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00

PARENT C: 25.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00

PARENT D: 25.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00

PARENT E OPTIONAL TEST GROUP: 0.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00
Graded Item: 1.00