Audit Trail for Gradebook

[Shaun donovan]

Hi All.

I am looking for a way to pull an audit trail of grades changes in the
Gradebook tool. I have noticed that one can pull an audit trail of
individual items using the "LOG" icon in the Gradebook lists, but only
if those items are internal "Gradebook" items, not external items like
"Tests & Quizes" or "Assignments".

The documentation that  I could find states that one must look at those
tools' logs to garner that information, but neither of these tools
provide logging at that level. Does anybody know of a method to get a
report of all of the "Gradeing" activity that has taken place on a site?

Kind Regards.

Shaun

[Steve Swinsburg]

Hi Shaun,

Sorry for the delay in responding. Have you had a look at the gradebook events table in the database? This holds all grading events - could be richer but let me know if that is what you need. If it's more of a forensic need, then the Tomcat logs might provide more insight depending on the log level you have.

regards,

Steve

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.
To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

[Shaun donovan]

Hi Steve, and thank you for the response.

I am looking for a forensic type audit, which is available to a degree through the "Log" icon in the Gradebook tool, but only on internal Gradebook items.

I looked at the gradebook events table, but it only contains grading events on gradebook items, not on changes made to assignments, which is specifically what I needed.

I ended up using the SAKAI_EVENTS table, and from that, I managed to get a list of "who" changed marks on "what" assignment for "which" user including the date and time of that change. What I don't have is how the grade was changed (from what mark to what mark). This was done on a site level, so I ended up with a report with about 36000 lines (large site with many assignments) in a CSV format.

Kind Regards.

Shaun.

[Steve Swinsburg]

Hi Shaun,

That's probably a missing piece in the gradebook events then, having the grade log audit trail for externally managed assessments.

Would you mind opening a JIRA and I'll see if I can get that added?

Regards

Steve