Your Moodle version

Reports: Gold, Silver, and Bronze (GSB) Medals

Maintained by Picture of Richard Havinga Richard Havinga
**PLUGIN NO LONGER MAINTAINED** The GSB set allows automatic medal awards for Moodle courses based upon a defined benchmark criteria of activities and resources. The set consists of a report which allows the criteria to be benchmarked and a block to publicise the award to the teacher(s).
**PLUGIN NO LONGER MAINTAINED** The GSB Report is designed as part of a set called GSB Benchmarking. The report allows administrators to assign medals based upon either manual configuration or an auto-calculated award based upon set criteria within the reports settings. You can choose to include or exclude sub-categories, set the minimum average student hit rates before awarding an auto-calculated medal as well as the number of mandatory or optional resources and activities required to meet that benchmarked medal. Administrators can also choose to exclude courses from medals if they wish to. A spreadsheet of the medals awarded to courses can also be downloaded in the report. Not affiliated to ULCC. New features including support for turnitin, folders, labels and files within folders.


This plugin is part of set Gold, Silver, and Bronze (GSB) Medals.


Screenshot #0
Screenshot #1


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

Comments RSS

Show comments
  • Picture of Monika Schnaider
    Wed, Jul 31, 2013, 5:27 PM
    hey.. I'm just tring to instal your plugin but I have problem. When Im trying to instal REPORT it's show information that I need to instal BLOCK before.. but when Im trying instal BLOCK it's show me message I need to have REPORT before.
  • Picture of Richard Havinga
    Wed, Jul 31, 2013, 5:30 PM
    You need to put both plugins into their folders and then try and install them together. They both have a dependency of each other to exist and install.
  • Picture of Jamie Homewood
    Tue, Nov 19, 2013, 11:34 PM
    Hi, great plugin;)

    A couple of things:

    Can we change the title from GSM to something more meaningful?

    How about a loop to process all courses at once so we can just download the Spreadsheet? By processing each category it makes it almost unusable if you have many courses with sub-category after sub-category.

    My feeling is that the real value of this plugin isn't necessarily the badge element but rather what resources each course has, something Moodle is very lacking in.
  • Picture of Richard Havinga
    Thu, Nov 21, 2013, 12:07 AM
    Hi Jamie,

    Thanks for your kind words. I plan on doing what you have said as part of the next release along some funky new features so keep your eyes peeled. You can rename the block title by changing the language string in the front end of moodle under Site Administration > Language > Language Customisation and search for gsb and change the neccessary language string.

    Thanks again for your feedback.
  • Just Me
    Fri, Feb 7, 2014, 7:08 PM
    Hi RIchard,

    I have installed both the block and report successfully. However, when I run a report I get the following SQL error:

    Error reading from database
    Debug info: ERROR: operator does not exist: bigint = character varying
    LINE 2: ..._course INNER JOIN mdl_block_gsb ON = mdl_bloc...
    HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
    SELECT AS gb,, mdl_course.shortname, mdl_course.fullname, mdl_block_gsb.gsb, mdl_block_gsb.enrolnum, mdl_block_gsb.gsboverride
    FROM mdl_course INNER JOIN mdl_block_gsb ON = mdl_block_gsb.ids
    WHERE (((mdl_course.category)=52))
    [array (
    Error code: dmlreadexception
    Stack trace:
    line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
    line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
    line 753 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
    line 251 of /report/gsb/gsb_by_department.php: call to pgsql_native_moodle_database->get_records_sql()

    I've tried deleting the block/report plugins and re-installed but get the same error when running a report.

    Thanks in advance.
  • Picture of Richard Havinga
    Wed, Feb 19, 2014, 10:27 PM
    The new Version should fix this as I have looked at using less MySQL reliant queries however, I do not have a Postgres or MS SQL setup so please do feed back any issues. Thanks
  • Picture of Richard Havinga
    Fri, Feb 21, 2014, 10:16 PM
    Small bug fix today to take into account another MS SQL change.
  • Picture of Richard Havinga
    Wed, Mar 5, 2014, 2:08 AM
    Small bug fix pointed out earlier which mean't it was only displaying one course per category. Now fixed.
  • Picture of aaran mcguire
    Fri, Jul 18, 2014, 5:49 PM

    Were planning to upgrade to 2.7 soon, has anyone tested this plugin in 2.7? If not I will do so later this month.
  • Picture of Dave Perry
    Tue, Sep 9, 2014, 9:59 PM
    I've tried this on one of our instances, and noticed that it doesn't handle subdirectories. We have some categories that then have subcategories where the courses actually sit - and when you choose the main category (top level) from the list, it doesn't even offer a list of subcategories for that category to report on them. Are there plans to expand this so it either lets you choose each subcategory, or recursively searches the main category and shows each subcategory title in the list showing the report for that category?
  • Picture of Dave Perry
    Fri, Sep 19, 2014, 6:56 PM
    Thanks for the pm for the enable subcategories tickbox.
    Features suggestion - list the reports for subcategories that are in a category on the report page (like how the Manage Courses page does it)
  • Picture of Tim Bryan
    Tue, Sep 30, 2014, 8:09 PM
    Hello all,

    I'm currently using moodle 2.7 and was wondering how to enable the auto calculate feature. I think i read somewhere that this had been disabled on the 2.7 version and was wondering what settings/code would need to be changed to auto calculate my courses.

    Kind regards,
  • Picture of Bill Steele
    Sat, Dec 13, 2014, 1:37 PM
    Richard will you be updating for Moodle 2.7?
  • Picture of Richard Havinga
    Mon, Dec 15, 2014, 10:40 PM
    Hi Bill, I am not a developer in the day job anymore but hope to get it to work in the future with 2.7 and 2.8. I think the code needs be updated to take advantage of the new logging API but as of yet, I haven't found the time to familiarise myself with it.
  • Picture of Paul Carey
    Tue, Oct 13, 2015, 10:46 PM
    AS this thread is not updated, can I assume this is no longer supported?
1 2 3
Please login to post comments