[Moodle] MySql - reading dates and times

[Roland Gesthuizen]

Here is a quick and dirty way to check on your Moodle usage. Go to the admin
view where you list all the participants. Click on the table heading to login
time. This should resort your list of users from the most recent login time.
To estimate the proportion of regular users, scroll back in time one month
and count the number of users (users per page x number of pages x 100 /
population). This definition is what we use for the mailing lists. The rest
are probably significant but incidental users.

Here are some stats for my college
     Frequent users over the last week = 44% students and 46% staff
     Regular users over the last month = 65% students and 72% staff

Scroll further back and you cover nearly all the students in the school.
Gets rubbery as you start bumping into last years cohort of students that
have left. Significantly, the two thirds population of our students probably
use moodle by a much smaller population of staff (perhaps 20%) that teach
more than one class. I suspect that the other staff just use some of the new
staff area features. In all, I am quite happy with this level of usage.

Regards Roland



On 03/05/06, Phil Brown <brown.phillip.p1 at edumail.vic.gov.au> wrote:
>
>  I'm sure someone can solve this.
>
>
>
> When I do an export from the mdl_user table of the MySql database in
> Moodle all the date/time fields are integers. I want to put this information
> in an Access database so I can better report on the usage of Moodle. Does
> anyone know how to convert these numbers so that Access (or Excel) can read
> them as dates and times?
>
>
>
> Phil Brown
>
> ICT Manager
>
> Wellington Secondary College
>
>
>
> *Important - *This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before opening
> or using attachments check them for viruses and defects. Regardless of any
> loss, damage or consequence, whether caused by the negligence of the sender
> or not, resulting directly or indirectly from the use of any attached files
> our liability is limited to resupplying any affected attachments. Any
> representations or opinions expressed are those of the individual sender,
> and not necessarily those of the Department of Education &
> Training._______________________________________________
>  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> Moodle Mailing List kindly supported by
>  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority and
>  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers
> Association Inc
>



--
Roland Gesthuizen - ICT Coordinator - Westall Secondary College
http://www.westallsc.vic.edu.au

"Never doubt that a small group of thoughtful, committed citizens can change
the world; indeed it is the only thing that ever has." --Margaret Mead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/moodle/attachments/20060503/16e2b3e9/attachment.html