sqlIf you setup SQL access through PHPmyAdmin or through a program like MySQL Workbench you can directly query your site’s database to extract lots more information than you’ll find available through the admin interface, logs or just as a user looking through the statistics.

Post Pages - Post Inline - WIRIS

Thankfully you don’t have to be a master of SQL to start running reports and pulling information. At Moodle.org there are over 100 queries created by the community that can assist you in extracting harder to get to data from your Moodle. This includes info like how many teachers have logged in lately (or which haven’t), online participation across courses, student interactions, quiz usage in courses by date, and many more.

Check out the full list at https://docs.moodle.org/29/en/ad-hoc_contributed_reports

The following is a list of those shared by Elizabeth Dalton of Granite State University during the iMoot which reminded me of this great resource:

Note the comments in the SQL snippets which will help you to customize them to fit your specific needs.

Previous articleLearning Analytics at Open University – presentation by Dr. Bart Rienties
Next articleFree Live Presentation: Moodle End-of-Year Rollovers with @lewiscarr



Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.