Your Moodle version

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

Maintained by Picture of Richard Havinga Richard Havinga
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).


This plugin is part of set Gold, Silver, and Bronze (GSB) Medals.
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.




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 Simon Allison
    Mon, Apr 15, 2013, 1:57 AM
    I think the issue is the assignment table doesnt exist, as its now change to mdl_assign not mdl_assignment
  • Picture of Richard Havinga
    Wed, Apr 17, 2013, 10:42 PM
    Interesting! Can you contact me via Moodle Messaging as I cannot see the same issue when installing on a standard Moodle 2.4.3 build.
  • Picture of Bill Steele
    Thu, May 9, 2013, 4:01 PM
    We thing GSB is a great idea and will encourage our lecturers to move away from a repository model to a more interactive model for their modules. We do though have a couple of issues:

    1) You have in the documentation a wish list of items that you would like to include which contains Turnitin. This is essential for us. If we knew what was involved we may be able t o get a student to try to add this functionality

    2. We would like to be able to detect other plugins such as Campus Pack wikis and blogs. As above we may be able to get a student to help

    3. We would like a totally manual Platinum level which lecturers could aspire to which would be allocated based on pedagogical grounds

    Great plugin and terrific idea
  • Picture of Bill Steele
    Wed, Jul 10, 2013, 3:47 PM
    Hi Richard

    Do you have any feedback from institutions who are using the GSB plugin e.g. why did they decided to use it and what impact has it had


  • Picture of Richard Havinga
    Mon, Jul 15, 2013, 8:30 PM
    Thanks Bill. I have responded to you via the Moodle Messaging system

  • Picture of ICB BNE
    Wed, Jul 17, 2013, 9:03 AM
    It stuck on the screen which does not allow me to do anything. How can I get rid of this warning. I no longer need this plug in.

    Dependencies check failed for report_gsb
    GSB Medals /report/gsb Add-on 2013071500 Moodle 2011120100 block_gsb (2013071500) To be installed
    You must solve all the plugin requirements before proceeding to install this Moodle version!
  • Picture of Richard Havinga
    Wed, Jul 17, 2013, 3:57 PM

    This is because in order to install the GSB set you need both the block and the report. The dependency is there to state this. If you want to get rid of the message just remove the gsb report folder you just added in.
  • 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.
1 2 3
Please login to post comments