Reports: Export Component Grades

Maintained by Picture of Paul Nicholls Paul Nicholls
Exports the component grades from a Rubric or Marking Guide for a given assignment into an Excel spreadsheet.
170 sites
11 fans

Exports the component grades from a Rubric or Marking Guide for a given assignment into an Excel spreadsheet.

Once installed, navigate to an assignment which uses a Rubric or Marking Guide as a user who has permission to grade the assignment.  A new menu item will appear in the Assignment Administration menu: "Export Marking Guide Grades" or "Export Rubric Grades", as appropriate; click it to download an Excel spreadsheet containing that assignment's component grades for all students in the course.


Picture of Paul Nicholls
Paul Nicholls (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Plugins bot
    Wed, 18 Jun 2014, 7:49 PM
    Thanks for sharing this plugin with the Moodle community. Some formal issues were detected and reported by our automated plugin checker tool. Please review all the plugin checker results and fix the issues mentioned, if possible. These changes are typically pretty easy to make but if you have any questions just let us know.

    Please resolve these formal issues so that the plugin code can be fully reviewed and approved by my human colleagues.
  • Picture of David Mudrák
    Thu, 3 Jul 2014, 9:33 PM
    Hi Paul. Thanks for sharing this plugin with the community. There is an issue with the SQL function FROM_UNIXTIME() which is MySQL specific. This makes your plugin fail on other DBs that Moodle supports. I believe this is easily fixable in your code so I'm marking this as needing more work for now. Thanks for your patience with the review and approval process.
  • Picture of Paul Nicholls
    Wed, 9 Jul 2014, 10:49 AM
    Hi David, I've just released a new version which uses the userdate() function in PHP rather than FROM_UNIXTIME() in the SQL query. It also includes a fix for another issue (mismatch between the list of students and the component grade data causing it to stop outputting the grades).
  • Picture of David Mudrák
    Wed, 9 Jul 2014, 8:47 PM
    Hi Paul. While testing the plugin, I realized the new navigation node it's creating via
    report_componentgrades_extend_navigation_module() might be better rooted under Assignment administration > Advanced grading. It
    would make it explicit what it refers to. But to be honest I'm not sure if the Advanced grading node is already available there at
    the moment when your report's callback is executed. It's worth of trying though.

    I was having troubles to use the report with debugging set to DEBUG_DEVELOPER in Moodle 2.7. Instead of the grades in the
    spreadsheet, all I got was the warning about add_to_log() being deprecated. Maybe you can find a way to avoid these debug() messages
    being part of the spreadsheet? And make sure that grades are always present there?

    With regards to string wording, please note that Moodle 'en' language pack does not use Capitalized Letters in titles. So it should
    read 'Export rubric grades' instead of 'Export Rubric Grades' to achieve better consistency in the UI.

    Let me suggest to improve the code yet and protect it with sesskey() to avoid fetching the data via CSRF. Also, I think there is bit
    of inconsistency in what permissions are actually checked. To display the link, you use 'moodle/grade:edit'. But the data generator
    checks against 'mod/assign:grade'. Even though eventual mismatch in not likely to happen given the typical roles setup, both these
    places should use the same capability.

    I am going to approve the plugin now. I believe that many users will find it useful and will provide you with a good feedback for
    further improvements. You are cleared to land, welcome to the Plugins directory!
Please login to post comments