Moodle in English

Posts made in Moodle in English

Moodle in English -> Quiz Awarding Grades to the best X answers from Y Questions -> Re: Awarding Grades to the best X answers from Y Questions

by Eoin Campbell -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers
I just came across a possible solution to this problem. You can download the quiz responses from the Quiz administration > Results > Responses page as a CSV or Excel file, then use the formula SUMPRODUCT(LARGE(question grades array, {1, 2, 3, ... X})) to get the sum of the best X answers. The YouTube video Sum the Top 5 Values - Excel Formula explains how to use it. Then create an Assignment activity with no file upload requirement as a place to return the computed 'best of' grades to students, Download a grading worksheet from this assignment, and use the Excel function VLOOKUP (or better yet XLOOKUP) to map the computed grades from the from the Quiz results into the assignment grading worksheet, and import them back into Moodle.
Average of ratings: -

Moodle in English -> Blocks Add Course Summary Block to all course pages -> Re: Add Course Summary Block to all course pages

by Eoin Campbell -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers
You could install and use the Upload Block Settings plugin to add the course_summary block to every course. You would need to first get a list of the "course shortname" field for all courses on your site. You could use the Configurable Reports block plugin to write an SQL script to do this, e.g. 
SELECT 
    CONCAT('add,', '') AS '#operation',
    c.shortname AS 'shortname',
    CONCAT('course_summary', '') AS "block",
    CONCAT('side-pre', '') AS "region",
    CONCAT('0', '') AS "weight"
FROM
    {course} AS c

Once you save the list as a CSV file, go to Site administration > Courses > Upload block settings to upload the file and add the block to every course.

Average of ratings: Useful (1)