Hi,
I am still looking for the possibility to
"see all grades of a complete moodle site in 1 overview."
Is this in version 2 now possible
If yes, how
I hear, that all grades are in SQL tables, so with a query it shoukd be possible, but I have only 1 teacher and he will see an overview of all grades of a complete moodle site.
He (and also me) cannot work with SQl query's
Can someone help me with this?
I would like to know if this is possible in Moodle 2.4.
I too, am looking for a way to see all students and their grades, not just in a particular course, but in all the courses they have taken.
This question was part of a previous post the other day, but haven't seen any replies as yet.
We are testing 2.5, up from 1.9.
Thank so much
Diane, please vote for my tracker here:
https://tracker.moodle.org/browse/MDL-40152
If this is implemented, we can build a total progress report in a gradebook.
To bad nobody is voting for it.
Well, SQL may not be what you want but that's what you may need to use. The following queries retrieve a list of all completed courses for all students, including their username, last and first names, department, course name, grade and date completed.
I have two ways of getting at the data. (1) Use MS Access and run a MS Access query, or (2) Use MySQL Workbench (or other SQL tool) and run the native query.
(1) MS Access Route - Download & install the ODBC driver to connect to your moodle database and use MS Access to obtain this information. This is the Access Query:
SELECT u.username , u.lastname, u.firstname, u.department, c.shortname AS CourseName, ROUND(gg.finalgrade,2) AS Grade, format(DATEADD("s",cc.timecompleted, '1970-01-01'),'dd-mmm-yyyy') AS CompletionDate FROM mdl_grade_items AS gi, mdl_course AS c, mdl_grade_grades AS gg, mdl_user AS u, mdl_course_completions AS cc
WHERE gi.itemtype = 'course' AND c.id = gi.courseid AND gg.itemid = gi.id AND gg.userid = u.id and cc.userid = u.id and cc.course = gi.courseid and cc.timecompleted is NOT NULL
ORDER BY u.lastname, u.firstname, c.shortname
(2) Download and install MySQL Workbench. This is the native SQL query:
SELECT u.username , u.lastname,u.firstname, u.department, c.shortname CourseName,ROUND(gg.finalgrade,2) AS Grade, DATE_FORMAT(FROM_UNIXTIME(cc.timecompleted), "%d-%b-%Y") CompletionDateTime
FROM mdl_grade_items AS gi, mdl_course AS c, mdl_grade_grades AS gg, mdl_user AS u, mdl_course_completions AS cc WHERE gi.itemtype='course' And c.id=gi.courseid And gg.itemid=gi.id And gg.userid=u.id And cc.userid=u.id And cc.course=gi.courseid And cc.timecompleted Is Not Null ORDER BY u.lastname, u.firstname, c.shortname