Extracting Grade Report Data

Mary DeWan

• October 09, 2023 18:59

Weekly I am extracting grade reports into Microsoft Excel spreadsheets. When I want to export Grade Reports for any class, the list of grade items to be included has all of the Scorm packages in the class as well as the quizzes. We only count the quizzes. In order to only get the quiz data, I have to de-select everything and then re-select the quizzes. Is there any way to have this come up with only the quizzes selected? 

In this example below, I only want the Assessments selected.

0

• 

  Jason Rodgers

  • October 16, 2023 13:45

  You could maybe do something with this

  SELECT 
  MGI.itemname,
  MGI.itemtype,
  MGI.itemmodule,
  MC.fullname,
  MCC.name as Category, 
  MGG.* 
  FROM mdl_grade_grades MGG
  JOIN mdl_grade_items MGI ON MGG.itemid=MGI.id
  
  JOIN mdl_course MC ON MGI.courseid=MC.id
  JOIN mdl_course_categories MCC ON MCC.id=MC.category
  
  WHERE MC.id=9958

  Of course change the MC.id to reflect the course you are wanting and if you wanted to narrow down to quizzes you could add :  AND MGI.itemmodule='quiz'  to the where condition

  0

Please sign in to leave a comment.