Moodle plugins directory: Gold, Silver, and Bronze (GSB) Medals | Moodle.org
Gold, Silver, and Bronze (GSB) Medals
Reports ::: report_gsb
Maintained by 
R H
R HPart of set Gold, Silver, and Bronze (GSB) Medals.
**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).
Latest release:
9 sites
3 fans
**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.
Useful links
Screenshots
Contributors
R H (Lead maintainer)
Please login to view contributors details and/or to contact them
Comments 
Comments
Please login to post comments
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.
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.
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_course.id = mdl_bloc...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
SELECT mdl_block_gsb.id AS gb, mdl_course.id, 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_course.id = mdl_block_gsb.ids
WHERE (((mdl_course.category)=52))
ORDER BY mdl_course.id;
[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.
Majid.
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.
Features suggestion - list the reports for subcategories that are in a category on the report page (like how the Manage Courses page does it)
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,
Tim.