Our course is complete EXCEPT for being able to create a REPORT that will summarize how much CUMULATIVE TIME a student has spent in EACH LESSON.
Currently the STUDENT ACTIVITY LOG only records "start times" when they click on that lesson (even if they don't watch the video immediately). We need to calculate "end times" when they click on the next lesson, time out, or log out.
 The REPORT must list the calculated time spent in the course (the State of Texas requires minimum contact hours).
Subsequent client requests (separate topics?) include:
 auto-generated "Pass/Fail" for each lesson based on whether the student's calculated time is < or is >= to instructor-set minimum time for that lesson.
 Ideally the report could GENERATE AUTOMATICALLY and be EMAILED TO THE INSTRUCTOR when the student clicks "SUBMIT" on a "course completion form" we've placed as the final section of the navigation tree.
I am attaching a PDF of what I think the report might look like (created in Excel), providing the instructor with a complete summary of a student's course participation.
 There is also a State of TX requirement that the student's IDENTITY be periodically verified by correctly entering the same answer to a randomly-pulled PROFILE QUESTION as they had entered during the registration process. The REPORT would need to access that "pass/fail" table as well.
I have two subcontractors collaborating on this solution and awaiting your insights. Thank you.