Sorting students by district and adding a nine weeks break in gradebook

Sorting students by district and adding a nine weeks break in gradebook

by Michele Carlisle -
Number of replies: 1
Our Moodle version is 1.9, and I am not sure of any additional versions that have been loaded. First, let me apologize if this is redundant... I am only using the gradebook feature for one portion of the districts I manage. All other districts use a gradebook called progress book. My questions are this: 1) Is there a way to sort a class grade book by anything other than student name - ideally, by City ( i have 7 different school district students enrolled in one foreign language class). It would help greatly in reporting, if there were a way to sort the gradebook by City (that is where I place the district name upon enrolling a child) instead of by first/last name. Question number 2) is there a way to place nine weeks breaks in the grade book? and, along with that, is there an easy way to mark/make the gradebook do a semester average, a nine week average, and a course average at the end of a year?
Thank you in advance for any and all help!
In reply to Michele Carlisle

Re: Sorting students by district and adding a nine weeks break in gradebook

by Barry Oosthuizen -
Hi Michele,

I can think of two manual workarounds to sort students by district in the gradebook:
  1. If you don't need the idnumber field for anything else: copy the district or city name in there. Then set your gradebook to display idnumbers. To make this process easy you could use an sql update query
  2. Create a group for each city/district and add the relevant students to each group. Again this can be done quickly by using an sql update query.
Grouping grades by semester and have averages and totals etc can be accomplished by using grade categories, grade calculation methods (aggregation types) and/or using formulas.

For more info, see:

http://docs.moodle.org/en/Category_aggregation
http://docs.moodle.org/en/Grade_categories
http://docs.moodle.org/en/Edit_grade_calculation

Cheers,

Barry