We have a University regulation whereby grades should be posted to campus based students 20 days after an assignment deadline (25 days for distance learners). The motivation being that students receive timely feedback and grades for their assignments.
I'm looking to produce a report which details for each assignment (Moodle, Turnitin V1 & V2) when grades were released to each student in relation to the assignment due date.
I'm thinking that the gradebook is the ultimate place where grades are finally released to students. This should take into account workflow states (Moodle assignment), hidden until dates and Turnitin post dates.
Could someone please point me in the direction of the functions and database tables/fields which hold the data needed to write this report.
Thanks for any help