Downloading VLE statistics

Downloading VLE statistics

by Pat Cresswell -
Number of replies: 3

On the college MOODLE VLE where I teach I can find no way to download course statistics, student access and so on.

I am sure that is available on the 'vanilla Moodle', I do have a test Moodle of my own, but for some technical reason I cannot access it at the moment - I have not updated it for 6 months due to examination fever at work maybe SQL has recently been updated on my website.

Can anybody help with this? I would like to evaluate my VLE for last year before re-writing for next semester.

Pat

Average of ratings: -
In reply to Pat Cresswell

Re: Downloading VLE statistics

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Pat - I typically look at the Activity Reports - it gives me an idea of how many times a resource or activity was used. Is this what you are looking for? Peace - Anthony
Attachment activity.jpg
Average of ratings: -
In reply to Anthony Borrow

Re: Downloading VLE statistics

by Pat Cresswell -

Yes, I can see the logs and they are what I want. I wanted to download them to EXCEL and do some stats with the figures. I thought I could do that.
The logs are OK but can cover many screens.

I would like to know the most popular resource and the least, also who visited what resource. Then I want to discover how this relates to final grades.
I am being nosey, but only to improve.

Perhaps I will try copy and paste  into a spreadsheet.

Average of ratings: -
In reply to Pat Cresswell

Re: Downloading VLE statistics

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Pat - I remember being requested for stats about which resources were used by which teachers, in which courses, etc. I ended up using phpmyadmin which has an option of exporting to Excel. Essentially, I worked directly with the database rather than through Moodle. Would you have access to phpmyadmin? If not, as a teacher, the activity report is the best place. You can copy and paste it into Excel - I would recommend doing the Paste Special - Text so that each one gets put in its own cell. Peace - Anthony
Average of ratings: -