Attaching Roster Database to Moodle

Attaching Roster Database to Moodle

by Mike Condardo -
Number of replies: 4

Hello -- I am using Moodle 2.8 and am fairly new to the Moodle world. Our students are allowed to self enroll in courses. We have both federal and state funders so reporting and documenting is crucial. My question is: How do I link or attach an ever-changing student roster to our reporting of completed courses so that it shows not only who HAS completed the course, but also who HAS NOT completed the course or even enrolled.


Also, I'm looking for recommendations for a more detailed and flexible reporting instance. Some real-world examples of how it is currently being done would be really helpful. Thank you!

Average of ratings: -
In reply to Mike Condardo

Re: Attaching Roster Database to Moodle

by Joseph Thibault -
Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

Mike, not knowing how many students/courses you have, is it feasible to pull the completion report directly from the completion block once criteria have been defined for the course?

https://docs.moodle.org/30/en/Course_completion_status_block

As an Administrator this will give you a view of the entire class roster, their progress, and whether students are completed or not in that course. 

Accessing that via SQL might give you a fast way of generating the reports across all courses. 


Average of ratings: -
In reply to Joseph Thibault

Re: Attaching Roster Database to Moodle

by Mike Condardo -

Hi Joseph,

We have approximately 1,000 students spread out over 65 courses using metacourses and groups. As for SQL, we're trying not to have to bring someone in to write SQL code for us to get reports. But we'd like our reporting to dig down to a granular level as needed and was hoping that there was a plugin that would allow us to pull that course completion information, specifically date completed, student's name, sort by group, etc.

Average of ratings: -
In reply to Joseph Thibault

Re: Attaching Roster Database to Moodle

by Mike Condardo -

Hi Joseph,

We have approximately 1,000 students spread out over 65 courses using metacourses and groups. As for SQL, we're trying not to have to bring someone in to write SQL code for us to get reports. But we'd like our reporting to dig down to a granular level as needed and was hoping that there was a plugin that would allow us to pull that course completion information, specifically date completed, student's name, sort by group, etc.


And we would like to somehow attach our entire roster of students to the course reporting to see not only who HAS taken their courses, but also who has NOT taken their courses ... and students (adults) are Self-Enrolling.

Average of ratings: -
In reply to Mike Condardo

Re: Attaching Roster Database to Moodle

by AL Rachels -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

Hi Mike,

There are a couple of different items that you can install that might enable you to get the information you want. In the Moodle downloads, under reports, there is the Ad-hoc database queries. Also, under blocks, there is the Configurable Reports. If you go read their documentation, both of them have a number of queries/reports contributed by other users. Maybe one of them will give you what you want. If not, maybe you can rewrite/adapt one to do so.

Average of ratings: -