Reports: Export Component Grades

report_componentgrades
Maintained by Picture of Paul NichollsPaul Nicholls, Picture of Marcus GreenMarcus Green
Exports the component grades from a Rubric or Marking Guide for a given assignment into an Excel spreadsheet.
410 sites
114 downloads
21 fans
Moodle 2.9, 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8

Exports the component grades from a Rubric, Marking Guide  and BTEC grading for a given assignment into an Excel spreadsheet.

Once installed, navigate to an assignment which uses a Rubric,  Marking Guide or BTEC grading 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", "Export Rubric Grades" or 'Export BTEC Grading"  as appropriate; click it to download an Excel spreadsheet containing that assignment's component grades for all students in the course. Note the download is a spreadsheet not a CSV file.

Contact Titus Learning for custom development and consultancy.

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2

Contributors

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 David Mudrák
    Thu, Jul 3, 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, Jul 9, 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, Jul 9, 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!
  • Picture of Uriy Dyachek
    Wed, Apr 18, 2018, 4:30 AM
    Hi! All my games projects Y9, Y8, iO Games, Frive is already realized with the help of this Export Component Grades. 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?
  • Picture of Michael Zwahlen
    Tue, Jun 19, 2018, 6:09 PM
    Great and very important plugin for the essential Rubric-Feedback.
    Its works on our installation. But in my export I cant find the "overall Points" nor the "Overall Feedback as comment". Can you add this two colums, please?
  • Picture of Roland Sherwood
    Wed, Dec 26, 2018, 2:49 PM
    Hi Many thanks for this excellent (and much needed) plugin - and just to confirm we recently encountered an issue where export of grades in Assignment activities where a student has multiple attempts leads to data being entered into the spreadsheet in a way that is confusing for teachers. Please see here for full details: https://github.com/pauln/moodle-report_componentgrades/issues/7
  • Picture of Álvaro Martín Sancho
    Tue, Jun 25, 2019, 6:43 PM
    Hi Paul:

    Does it work with Moodle 3.6?

    Thank you!
  • Picture of Marcus Green
    Tue, Jun 25, 2019, 6:53 PM
    Yes (and 3.7)
  • Picture of B Games
    Tue, Mar 10, 2020, 12:22 PM
    Good!
  • Picture of Acqua Alta
    Mon, Apr 13, 2020, 5:56 AM
    Hi,
    Is there a reason that even you (Marcus) assure us that the plugin works with Moodle 3.7, it's not officially updated in the versions tab of the plugin?
    Is there a process that need to be finished so such a support could be declared officially? I'm not familiar with the plugin approval process.
  • Picture of Marcus Green
    Mon, Apr 13, 2020, 3:05 PM
    If definitely works with 3.7 and I am fairly confident it works with 3.8. I have updated the plugin to reflect this.
  • Picture of Gerard Nicholson
    Thu, Jun 4, 2020, 5:27 PM
    IT admin won't install the plugin because the documentation is not updated to include Moodle version 3.8. Is this possible? Thanks, Gerard
  • Picture of Marcus Green
    Thu, Jun 4, 2020, 5:44 PM
    Hi Gerard, good on your IT Admin people. I will attempt to get it checked out for 3.8 (and alpha 3.9 while I am at it) in the near future
  • Picture of Scott Krajewski
    Tue, Jun 9, 2020, 4:37 AM
    Is this working in 3.8 for folks? We have 3.8.3 and it's not showing up in the assignment menu.
  • Picture of Marcus Green
    Tue, Jun 9, 2020, 5:57 AM
    I have just installed it in a fresh instance of Moodle 3.8.3 and it is appearing where I expect it. That is from the course click on an assignment that uses Rubric or Marking guide, click on the Cog on the right and there is an option that says Export Rubric Grades.
1 2
Please login to post comments