We have earlier covered the Useful SQL queries in the past and now few more queries are added to the Ad-hoc contributed reports page by Elizabeth Dalton to provide learning analytics at the iMoot 2015.
The newly added reports includes:
- Weekly Instructor Online Participation
- Weekly Student Online Participation
- Faculty/Student Interactions
- Course Design Reports
- Quiz Usage in Courses by Date
You can access all the contributed reports contributed by the community all over the years here. Please share any more SQL queries which you want to share with the Moodle community in comments.