Not sure which Moodle Forum to post this in, but so far I have got no reply in the General Development forum so I will try here.
I need to develop some analytics on discussion forum activity. Specifically, I would like to query the Moodle (3.1 or 3.2) database to get the following data for activity in a specified discussion forum of a specified course. (The data will later be analyzed against in-person interviews with the users, to study effectiveness of the Forum activities.)
1. For every pair
of users in the course, say "user-A" and "user-B", how many times did user-A
reply to a post by user-B (no matter if it was to a new base note or to a
reply of user-B), and vice versa. (Researching network connectedness and "symmetry" between users
in Forums. The Forum Graph plugin depicts this but doesn't return downloadable data as far as I know. What SQL would do so?)
2. For every pair
of users in the course, user-A and user-B, what was the average "rating" user-A and user-B
gave each other's posts (no matter if it was to a new base note or to a
reply of user-A). (Researching connectedness and "symmetry" between users
in Forums, correlated with perceived Quality of Forum activity. Don't know of anything that returns this data.)
3. How many times did each user post (whether a new topic or a reply) to anyone else in the course. (Level of activity. Available in core Moodle Reporting but I would like to know what SQL to use to get results for specific users, course, forum.)
4. What was the average rating overall that each user received for postings (for new topic and replies) by all other users in the course, in the aggregate. (Quality of activity as measured by all peers. Don't know of anything that returns this data.)
Can anyone point me to the right queries that would do the above, or which I could use as a starting point for development?