Gradebook

 
 
Picture of Lauran de Bever
Re: See all grades of a complete moodle site and what needs to be done!!!
 

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?

Wazza
Re: See all grades of a complete moodle site and what needs to be done!!!
 

I would like to know if this is possible in Moodle 2.4.

Picture of Diane Fink
Re: See all grades of a complete moodle site and what needs to be done!!!
 

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

Wazza
Re: See all grades of a complete moodle site and what needs to be done!!!
 

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.

Wazza
Re: See all grades of a complete moodle site and what needs to be done!!!
 

To bad nobody is voting for it.

Picture of Constance Horne
Re: See all grades of a complete moodle site and what needs to be done!!!
 

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