Summarizing elapsed Student time in each lesson

Summarizing elapsed Student time in each lesson

by Jonathan Anderson -
Number of replies: 8

http://courses.electriciantesting.com

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.

[1] 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:

[2] 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.

[3] 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.

[4] 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.

Average of ratings: Useful (1)
In reply to Jonathan Anderson

Re: Summarizing elapsed Student time in each lesson

by Juan Leyva -
Picture of Core developers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

Hi Jonhatan,

1) Configurable reports has a stats column that supports the spent time

For the rest of features see:

http://docs.moodle.org/22/en/Configurable_reports#How_to_request_a_new_feature

Regards

Average of ratings: -
In reply to Juan Leyva

Re: Summarizing elapsed Student time in each lesson

by Fabrizio Ciommei -

Hi all,

regarding this issue, I have 2 questions:

1) is this functionality strictly related to the Moodle native reporting functionality or is it exposed by some other further modules/plugin (e.g. Attendance Module)?

2) is this functionality never deprecated in the Moodle releases next 2.0.8?

I need to know that soon because we have to decide to apply that on our company training project.

Thanks in advance for the collaboration.

Best regards,

Fabrizio

Average of ratings: -
In reply to Juan Leyva

Re: Summarizing elapsed Student time in each lesson

by Massimo Zallocco -

I have exactly the same problem. I'm trying to solve it using configurable report add-on (sql query) but have problems in understanding which table to use and how to compose the query.

Any hint on how to solve the problem?

What do you mean with "Configurable reports has a stats column"? how can I use it in queries?

Thank you in advance

Massimo

Average of ratings: Useful (1)
In reply to Massimo Zallocco

Re: Summarizing elapsed Student time in each lesson

by Massimo Zallocco -

I defined a different strategy to obtain the result of summarizing elapsed time in a lesson. 

1. Each lesson but the first one contains a dependency from previous lesson based on elapsed time in minutes. 

2. Defined a summary query on the table 'prefix_lesson_timer'.

As far as understood (unfort did not found documentation) the 'prefix_lesson_timer' is used to track the time spent in lessons in order to check the time constraint (1) and it may contain multiple records for lesson/user. My query (I'm using configurable report to run sql queries) looks like: 

select 
     c.id as courseid,
     t.lessonid, 
     t.userid,
     u.username as UserName,
     c.shortname as CourseName,
     l.name as LessonName, 
     sum(((t.lessontime-t.starttime)/60)) as SpentTime 
from 
     prefix_course c, 
     prefix_lesson l, 
     prefix_user u, 
     prefix_lesson_timer t
where
     t.lessonid = l.id and
     t.userid = u.id and
     l.course = c.id 
group by userid, courseid, lessonid

 Ciao

Massimo

Average of ratings: -
In reply to Juan Leyva

Re: Summarizing elapsed Student time in each lesson

by François Jimenez -

Hi, I just want to know how the the time spent is calculated because I have different scorm activities, and if I SUM the total of time spent in each module, I never get the same time.

The time spent on course is always less than the SUM.

Can someone explain me that please ?
I use the custom report blog to get this value.

Thanks in advance

Cheers,

F.

Average of ratings: -
In reply to Juan Leyva

Re: Summarizing elapsed Student time in each lesson

by François Jimenez -

Hi again,

I've tried your custom report block and it's wonderfull !

My question : is there a way to get the SQL QUERY to get the time spent on a specified course please ? I will develop an online tool which can help me to to get in one click a personalized reporting in CSV.

Thanks in advance for your help

Cheers,

F.

Average of ratings: -
In reply to François Jimenez

Re: Summarizing elapsed Student time in each lesson

by François Jimenez -

Any idea ?

Someone can help me with that please ?

Thanks in advance

Cheers,

F.

Average of ratings: -