Moodle

Removing the need for gradebook exports to be tied to a single course

Details

  • Type: New Feature New Feature
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 2.0
  • Fix Version/s: None
  • Component/s: Gradebook
  • Labels:
    None
  • Affected Branches:
    MOODLE_20_STABLE

Description

This is a patch (gradebookexport_multicourse.patch) which refactors the gradebook export code.

Currently the export code is tied to a single course and it makes it impossible to have grades from activities in different courses in the same spreadsheet. This patch turns this single course into an array of courses.

The second patch (globalgrades_admin_report.patch) is a an example of what could be done with this extra flexibility in the export backend.

It consists of a new admin report which allows admins to export activity grades for more than one course at a time. This was developed for corporate clients who need this functionality since the same instructors teach a lot of different courses and found it very painful to go through a series of courses to do grade exports.

Activity

Hide
Pedro Almeida added a comment -

I'm thinking to try this solution on my site.
But i've moodle 1.9.3 and I can't see any file on globalgrades (my version haven't this folder).
I can's see any moodle 1.9.4... how can I implement this? I must create the folder?

Thanks for your help...

PA

Show
Pedro Almeida added a comment - I'm thinking to try this solution on my site. But i've moodle 1.9.3 and I can't see any file on globalgrades (my version haven't this folder). I can's see any moodle 1.9.4... how can I implement this? I must create the folder? Thanks for your help... PA
Hide
colin wheelhouse added a comment -

I would like to know how to test this patch on a 1.9.? site. Am I correct in understanding that this will allow an admin/teacher to in effect export the overview reports of students on mass thus showing their grades across all courses on one spreadsheet? If details of how to implement the patch could be provided this would be a fantastic addition to the gradebook.

Colin

Show
colin wheelhouse added a comment - I would like to know how to test this patch on a 1.9.? site. Am I correct in understanding that this will allow an admin/teacher to in effect export the overview reports of students on mass thus showing their grades across all courses on one spreadsheet? If details of how to implement the patch could be provided this would be a fantastic addition to the gradebook. Colin
Hide
Francois Marier added a comment -

Hi Colin,

You're right, this new admin report allows an admin to export student grades for all students across all courses on a single spreadsheet.

To apply the two patches, see this page:

http://docs.moodle.org/en/Development:How_to_apply_a_patch

Cheers,
Francois

Show
Francois Marier added a comment - Hi Colin, You're right, this new admin report allows an admin to export student grades for all students across all courses on a single spreadsheet. To apply the two patches, see this page: http://docs.moodle.org/en/Development:How_to_apply_a_patch Cheers, Francois
Hide
Gordon Anderson added a comment -

HI

I have added buttons to allow selection and deselection of all the courses in the initial screen at http://SERVER/admin/report/globalgrades/index.php titled which begins with 'Select the courses to include in the report:'.

The attached patch file is the original patch file as written by Francois, with the following added:

@@ -90,6 +90,14 @@

print_course_list(NULL, NULL, NULL, -1);

+
+ $strselectall = get_string("selectall");
+ $strdeselectall = get_string("deselectall");
+ echo "<p>";
+ echo "<input type=\"button\" onclick=\"checkall()\" value=\"$strselectall\" />\n";
+ echo "<input type=\"button\" onclick=\"uncheckall()\" value=\"$strdeselectall\" />\n";
+ echo "</p>";
+
$exports = get_list_of_plugins('grade/export', 'CVS');
$exportnames = array();
if (!empty($exports)) {

Thanks

Gordon

Show
Gordon Anderson added a comment - HI I have added buttons to allow selection and deselection of all the courses in the initial screen at http://SERVER/admin/report/globalgrades/index.php titled which begins with 'Select the courses to include in the report:'. The attached patch file is the original patch file as written by Francois, with the following added: @@ -90,6 +90,14 @@ print_course_list(NULL, NULL, NULL, -1); + + $strselectall = get_string("selectall"); + $strdeselectall = get_string("deselectall"); + echo "<p>"; + echo "<input type=\"button\" onclick=\"checkall()\" value=\"$strselectall\" />\n"; + echo "<input type=\"button\" onclick=\"uncheckall()\" value=\"$strdeselectall\" />\n"; + echo "</p>"; + $exports = get_list_of_plugins('grade/export', 'CVS'); $exportnames = array(); if (!empty($exports)) { Thanks Gordon
Hide
Dan Poltawski added a comment -

Re-Targeting this for a review with moodle 2.0 in mind (Although 2.0 is changing around us ) cos its not had a real review yet. Please poke us if we don't do a code review/decision soonish

Show
Dan Poltawski added a comment - Re-Targeting this for a review with moodle 2.0 in mind (Although 2.0 is changing around us ) cos its not had a real review yet. Please poke us if we don't do a code review/decision soonish
Hide
Gary Prosser added a comment -

This patch seems to be the only 'improvement' that would allow a teacher to collate grades for multiple students across multiple courses. That's why I'm voting for it.

One important detail - its not uncommon to have pastoral tutors, ie teachers with a cohort of students across several courses and the teacher does not necessarily teach in all those courses.

Show
Gary Prosser added a comment - This patch seems to be the only 'improvement' that would allow a teacher to collate grades for multiple students across multiple courses. That's why I'm voting for it. One important detail - its not uncommon to have pastoral tutors, ie teachers with a cohort of students across several courses and the teacher does not necessarily teach in all those courses.
Hide
colin wheelhouse added a comment -

Hello Moodle Community. It's been a while since I posted a help request but the time has come again! I used with great success a patch called GlobalGrades which allowed me to from the admin panel, select courses and display all users grades for these courses in one spreadsheet. The key to this is it was in one spreadsheet, each student on one row, all the selcted course grades in columns. This is particularly useful for quickly assesing any progress/attainment over a number of courses. For some reason my site 1.9.7 does not like this, it allows you to select the courses but doesn't display the selected output file (.xls, .csv etc) instead when debugging is turned on this message appears: Fatal error: Call to undefined function get_course_ids_string() in /home/bungaymi/public_html/1.9.7/admin/report/globalgrades/index.php on line 56 I have attached the files necessary to install this and would appreciate any help from those of you who know php as I know zilch! The globalgrades folder goes inside the admin>report folder and then to run the custom report go to admin>reports>globalgrades on the frontpage. I await your help. Cheers Wheelie.

Show
colin wheelhouse added a comment - Hello Moodle Community. It's been a while since I posted a help request but the time has come again! I used with great success a patch called GlobalGrades which allowed me to from the admin panel, select courses and display all users grades for these courses in one spreadsheet. The key to this is it was in one spreadsheet, each student on one row, all the selcted course grades in columns. This is particularly useful for quickly assesing any progress/attainment over a number of courses. For some reason my site 1.9.7 does not like this, it allows you to select the courses but doesn't display the selected output file (.xls, .csv etc) instead when debugging is turned on this message appears: Fatal error: Call to undefined function get_course_ids_string() in /home/bungaymi/public_html/1.9.7/admin/report/globalgrades/index.php on line 56 I have attached the files necessary to install this and would appreciate any help from those of you who know php as I know zilch! The globalgrades folder goes inside the admin>report folder and then to run the custom report go to admin>reports>globalgrades on the frontpage. I await your help. Cheers Wheelie.
Hide
Dan Leighton added a comment -

Added UI Mockup: <global course grade overview>

Show
Dan Leighton added a comment - Added UI Mockup: <global course grade overview>

Dates

  • Created:
    Updated: