A Custom Forum Participation Report

Moodle Moot US 2015, Minnesota, August 4-6, 2015


Managing forums effectively and efficiently is a problem for many instructors. Who has posted? Were they on-time? How many posts have they made? Per forum? Per week? The information is all there but in many different locations. Our instructors were clamoring for a tool that pulls all this information together into one simple report.

In this presentation, I will demonstrate how to use the “Configurable Reports” block plugin to create a Forum Participation Report for teachers to use in their courses. The report lists each student in the course, whether or not they made an initial post, the date and time of the initial post, number of replies to peers, total number of posts, and grades (if any). The student’s name links to a page with all of that student’s posts in this specific discussion forum, and if you want to grade a post, you can do so on that same page.

I will show how to set up the SQL Query for your initial report, and how to duplicate it to create reports for the other forums in your course. Prior experience with HTML, Php and SQL is helpful but not required. I will do a very basic introduction to SQL language to facilitate comprehension of the query for this Forum Report. The query itself will eventually be contributed to the community Ad Hoc Reports for everyone to access freely.

The Configurable Reports plugin has many other capabilities that do not require any coding at all, and I will briefly show how to use those features as well.

Conference Program Link | Youtube Video of Presentation