User Logs & Time Activity

User Logs & Time Activity

Alfred Whitehurst發表於
Number of replies: 12

I'm a new moodle user, have been playing around with it for a few weeks - so it is entirely possible I have either missed the answer to this question during my searches, or that Moodle does not do what I am asking - The question is this...

Is there a way to get a weekly or montly report of how long each user (whether student or instructor) has spent logged into the moodle server?  Or is that data saved in MySQL somewhere (time in, time out) where I can Query it out on a daily, weekly, or monthly basis?  Not concerned with any fancy graphical display - just something like :

Username                         Total                      Report Date Range

Jim@somewhere.com       6 hours 24mins         01/01/04-01/31/04

Bill@somewhereelse.com  3 hours 0 mins

Any help would be greatly appreciated!

評比平均分數: -
In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Przemyslaw Stencel發表於
Have you seen the activity report in the user's profile? There are a few different views, depending on what information you're looking for (outline, complete, today's logs and all logs)

For example, here's the "All logs" report of your activity in this course:
http://moodle.org/course/user.php?id=5&user=28086&mode=alllogs
P.S. Only you, Martin and Eloy (they are teachers in this course) will be able to view this page.
評比平均分數:Useful (1)
In reply to Przemyslaw Stencel

Re: User Logs & Time Activity

Alfred Whitehurst發表於

Thank you Przemyslaw, your example shows the Activity report may be just what I am looking for, except for one thing.  In the Activity report graph, the left side Y data, going from 0 to 200 - is that a count of page hits?  Does anyone know if that left side can display Mins or Hours logged in, instead? Or am I misreading the graph?

Thanks again for any feedback, and grats to the designer(s) as well as all the contrubuiting users for a great product thats getting even better with time! (As open source is meant to be).

In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Przemyslaw Stencel發表於

Actually, I think it is better the way it is now (showing page hits rather than time logged in). Showing time logged in would be misleading in many cases. Take my own report of my today's activity in this course (see attached image).

Disregarding the 12am hits (which really belong to my yesterday's activity smile), I've only had about 40 hits throughout the whole day. However, I just kept my browser open all day long, so I only logged in once, around 10am. So, if the logs were to show logged-in time, it would make me look like an extremely eager student wink.

附件 loggraph.png
In reply to Alfred Whitehurst

Re: User Logs & Time Activity

W Page發表於
Hi Przemyslaw & Alfred!
 
Thought you might be interested in this based on this thread.  Check out Christian Milani's posts in the following thread about a program called "GISMO".
 
WP1
In reply to W Page

Re: User Logs & Time Activity

Alfred Whitehurst發表於

Thank you again for your replies - indeed, I myself prefer the page hit format as a reliable indicator of user/course interactivity (or is it user/site interactivity?).  In any case, let me further clarify the circumstance under which my orginal question about time logging was asked.

Here in California, this campus is considering a Moodle deployment, rather than the oddball mix of Blackboard, WebCT, and face-to-class Netmeeting sessions - the choice of which is often defaulted to the 'easiest', depending on the computer savy and time of the relevant faculty member.  It was recently asked of me by the administration (actually, a senior committee member relayed the question to me from the Dean's Office / President ), that  they assured me the State would pay the college by the hour they are active in the online class - all that was required was a report built from logs showing each registered student and how many hours they were logged into the class/course.  I was told this only applied to Non AA/AS, BA/BS courses (I'll refer to them as non-degree certificate courses).  So , for example, the student Bill spent 32 hours in course CF101, and student Anne spent 20 hours in the same course - then the fees paid to the college district from the state would be greater for student Bill then for student Anne.  No one (including apparently the state dept in charge of recieving the bills for this service) seems concerned that just staying logged in while surfing on the beach would produce much greater total hours of attendance - what matters to them is how long, in hours per 18 week course, each student is logged in.  They either pay by the hour, or a flat rate per student per course- and the current administration seems to feel that pay-by-hour would produce greater income (ie, more IT resources for the campus? <yeah right,insert silly grin here>).

  So this is why I am trying to come up with a way to log or export from the database, user time logged in.

  Am willing to enterain any and all suggestions - such as, what (if any) database fields would be appropiate to query?

  Thanks all for your input!

In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Simon Bryan發表於
If you are just looking for time logged into the server rather than an individual course you might be able to get that information from the web server logs. I have done something similar to this in the past (dim past) I think we used Webalizer or something similar to anlayse the web logs. Basically it has to extraxt any hits on the logon / logoff pages and sort them by username and time.
In reply to Simon Bryan

Re: User Logs & Time Activity

Przemyslaw Stencel發表於

I'm not too technical and I don't know how server logs work, so apologies if I'm asking a dumb question, but what if a user never logs off (just closes the browser)?

In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Bernard Boucher發表於
Hi Alfred,
I use a small hack from that post to estimate online time of students.

The log output looks like:

log1.png

3 added colums:

Tot: indicate total estimated online time
Cegep: in school estimated online time
Ext: External estimated online time

As indicated in the original post, the estimation function will never be perfect but may be refined to be more fair and less "cheatable".

I hope it may help,

Bernard

In reply to Bernard Boucher

Re: User Logs & Time Activity

Alfred Whitehurst發表於

Bernard, that seems very much like what I am looking for - I referenced the post you stated, but am unsure what lines/coding I need to change where - are you able to post the entire 'hack', or coded lines, if I and/or others are able to use them?  If not, I understand - a few more hints may be all that I need :

Thanks again!

In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Bernard Boucher發表於
Hi Alfred,
the preceding screenshot was not created with the exact code of the original post. Even that small hack evolvesmile.

But the screenshot with the original post was and it display only one additionnal columnwink.

The function print_log from course/lib.php is modified to give that result.

The lastest version modified ( moodle 1.4 v 1.296.2.1 2004/08/29 03:54:51 ) is attached here.

Please don't try it on a production server first.

I hope it will be helpfull.

Bye,

Bernard

In reply to Alfred Whitehurst

Re: User Logs & Time Activity

Sandra King發表於
Hello, I have been tasked with creating or finding something like this that works in Moodle 1.6 and also in Moodle 1.8. Does any one have a way to make one of the current report also show an elapsed time during which a student has been in a course?

I already have a hack in place which counts down the amount of time a student is has been in a lesson. (Our students have a required minimum time as opposed to the built in max. time setting.) I have now been told that there is a requirement that we show on one screen approximately how much actual time each student has spent in this course.