Gradebookplus

GradebookPlus

GradebookPlus Version 2 (GBPv2) adds the following functionality to standard gradebook:

• in-place editing of gradebook
• multi-column editing (spreadheet-style) for all numerically-marked activities in a given category
• popular with teachers used to traditional gradebook software
• makes moodle accessible to more teaching styles
• currently only available as a contrib package in CVS contrib/gradebookplus
• works with moodle 1.5 and moodle 1.6 (with bug patch below, not thoroughly tested)

• 18STABLE branch works with Moodle 1.8 and has been merged with 18STABLE branch of CVS by Anthony Borrow.

• Below is an initial discussion of possible plans to migrate GBPv2 1.8 data to Moodle 1.9beta. I would like to keep the docs updated with whatever we find and work collaboratively at developing a plan to migrate the data. Thanks for your collaboration.

Migration from GBPv2 to Moodle 1.9

I'm beginning this thread to discuss how we ought to move toward migrating the GBPv2 data from Moodle 1.8 to 1.9. I have started to play with some SQL queries and figured that sharing my thoughts (I would not call it progress yet) might be helpful as we work toward this. Please keep in mind that these queries are intended to only show the relationship beween the tables so that we can work out a migration plan. They are not intended to be run on a production site. My typical warning of using it in so far as it is helpful and avoiding it in so far as it is not certainly applies. With that said, I see the migration as involving 2 steps. Migrating the grade events (1.8) to grade items (1.9) and grade event grades (1.8) to grade grades. What may complicate things or what I am least clear on at this point is moving from grade category (1.8) to grade categories (1.9). For now, I am ignoring the issue of categories.

To move the grade events to grade items I am thinking of doing something like:

INSERT INTO mdl_grade_items (courseid, categoryid, itemname, itemtype, iteminfo, idnumber, grademax, grademin, timecreated, timemodified) SELECT gi.courseid as courseid, gi.category as categoryid, ge.name as itemname, 'manual' as itemtype, ge.description as iteminfo, concat ('GBP-',ge.id) as idnumber, ge.grade as grademax, 0 as grademin, ge.timemodified as timecreated, ge.timemodified as timemodified FROM mdl_grade_item as gi, mdl_grade_events as ge WHERE gi.courseid=ge.course AND gi.modid=0 AND gi.cminstance=ge.id;

n.b. - We need to make sure that the categoryid is correct - I have not looked to see how the data is getting mapped in the 1.8 to 1.9 upgrade.

I have used the grade event (1.8) id field concatenated with the GBP- string as the id number to easily identify the item as a GBP item and to provide a way to easily link the items (1.9) and assign the grades.

INSERT INTO mdl_grade_grades (itemid, userid, usermodified, finalgrade, timecreated, timemodified) SELECT gi.id as itemid, geg.userid as userid, geg.teacher as usermodified, geg.grade as finalgrade, geg.timemarked as timecreated, geg.timemarked as timemodified) FROM mdl_grade_events_grades as geg, mdl_grade_items as gi WHERE replace(gi.idnumber,'GBP-',)=geg.event;

I have not tested these queries out yet but wanted to get some conversation and ideas out there as I know that some folks are chomping at the bit to get started. I appreciate any feedback, questions, critiques, etc. Peace - Anthony