Best practice forum (Archived)

Grade not displaying in custom report

I created a course completion report using the report builder. The source is course completion and I included the 'grade' column. I then completed the course logged in as a learner and ran the report. The grade does not display in my custom report, but it does display in the grader report.

Here is a screen shot of the report results. I'll post a screen shot of the grader report in another post.

I'm assuming this is a bug since the column is in the list of available data but no data is displaying.

Kathy

Permalien | Répondre

And here is the generic Moodle grader report.

Permalien | Niveau supérieur | Répondre

Hi Kathy

There are a few settings in the report builder that could be affecting this

The content tab lets you only display records for a certain position , date, user

Normally a learner would only be allowed to see their own record in the grader or other reports. Have you modified the learner role to allow this or applied another role to the Learner user.

Have you created this on the demo site - I will try and recreate this on the demo site.

Craig

Permalien | Niveau supérieur | Répondre

Thanks for the reply, Craig. I am logged in as an admin running this report and the report is set up so that Admins and Learners can view the report. I understand that Learners would only see their own results, but shouldn't the admin see everything? I see all the users and their status as an admin, so why don't I see a grade?

I haven't tried this on the demo site - will try to do that tomorrow.

Thanks

Kathy

Permalien | Niveau supérieur | Répondre

Hi Kathy

Ok this explains why you can see all records - the admin should see everything in the Grader report and also in the Report Builder (if the admin is given access).

The grade in the completion source is only shown if the learner has been marked as complete in the course - this might be the problem. Can you check the learner user is complete in the course.

Craig

Permalien | Niveau supérieur | Répondre

Hi Kathy

I tried on the demo site and the Grade in the Report Builder from the Completion data source is not appearing for me either.

I completed a quiz in a course and the course was completed. There was a grade for the quiz shown but this doesn't seem to be passed to the grade in the Report Builder as expected.

I'll think some more on what could be causing this.

Permalien | Niveau supérieur | Répondre

I've looked into this and I now understand what's going on - let's see if I can do a good job of explaining ;-)

The grade being displayed in the report builder course completion report is actually the course completion grade criteria grade - not the final grade for the course. What that means is that it will only show the correct value if the course has 'completion by grade' as one of the course completion criteria AND the user has met that criteria.

Therefore the problem is with the report source - we should switch it to get the grade directly from the grades table instead - then everything should work the way you would expect.

I've created a bug, and we'll try and get it fixed in time for the next release - 1.0.23 due out on Tuesday 6th September.

Simon

Permalien | Niveau supérieur | Répondre

Thanks Craig and Simon!

Permalien | Niveau supérieur | Répondre