I am trying to do some correlation analysis seeing what might predict student performance in one of my courses. I've been able to get a lot of information writing SQL queries. So far, so good.
Then, I tried to figure out which students looked at their grades and which looked at their feedback for each assignment. This is where I hit a wall.
I looked in the mdl_assignment table. Empty.
I looked in the mdl_assign table. Good, all of my assignments are in there.
I looked in the mdl_assign_grades table. Nothing for my first 12 assignments which are the ones I care about.
So, I thought maybe the data got deleted. I looked in the Grader Report (on the web) and saw all the grades. So, the data must be somewhere. Then I looked at the assignment (on the web) and I could see everyone who submitted and nobody had any grades. All assignments appear to be waiting to be graded. However, the Grader Report still shows grades. Confusing (for me).
Then I click on the assignment (again) and see everyone who submitted (again), still no grades are listed. I click on one of the student submissions and I can see the grade where it says "Current grade in gradebook" on the right. Still confusing.
I am worried about making this a compound question but I do have several, potentially related, questions.
2) How can I see if (and when) the student has viewed their grade?
3) Where can I see the assignment feedback in the database?
4) How can I see if (and when) the student has viewed their feedback for each assignment?
5) Why would grades show up in the Grader Report but not when viewing the assignment submissions?
A few other potentially important points:
A) The grades were not entered by hand, they were uploaded in a spreadsheet (each week) along with the feedback
B) There are 12 assignments I care about (plus three I do not). Six have grades and feedback while the other six just have feedback and no grades (by design).
C) Assignments are graded on a scale, specifically BTEC with Fail, Referral, Pass, Merit, and Distinction as the possible grades.
D) Many of my students use the Moodle app on their phone, and I understand there may be a challenging way the Moodle server will log that activity compared with those doing everything via a web browser.
I'm handy with SQL and have used mdl_logstore_standard_log to get most of the data I'm looking for. However, I'm still fairly new to Moodle, especially digging through the database.
Any insights would be great.