Moodle Expert & MySQL

Moodle Expert & MySQL

Closed - This job posting has been filled and work has been completed.

Job Description

We need a Moodle expert can provide us two MySQL Queries:

1. First Query:

All students enrolled in a given course and a period (between a start date and end) :

Fields (for each student):
-----------
Student Name
Amount of logins (for each student)
Total time connected (for each student)
Percent done (for each student)
grade in the course (for each student)


2. Second Query:

All students rolled in a given course and period (start and end) :

Fields (for each student):
-----------
Student Name
First login (for each student)
Last Login (for each student)
Total amount of hours (for each student)
Total amount of different days (for each student)
Total amount of viewed lessons (for each student)
Total amount of passed tests (for each student)
Total amount of required time (for each student)
Total amount of required days (for each student)

Info we provide in both queries:

Idcourse, UserId, StartDate, LastDate

Other open jobs by this client