Grading rules between Moodle and Genius

This Moodle site is integrated with Genius.  Genius is a student system - front end and handles enrollments, accounts, and GRADES and communications.  The moodle handles the actual courses and maintaining the grades.

Genius is master of enrollment and authentication.  Both external authentication and enrollment plugins are configured in the Moodle.  Moodle contains all the course content and is the master grade maker - Genius pulls its grade data from moodle.

This is the SQL pulling grade-able items from Moodle.

SELECT users.username, courses.shortname as almsid, count(*) AS CurAss,                         

    (   

                 SELECT  finalgrade from mdl_grade_grades g

                  JOIN mdl_grade_items i ON g.itemid = i.id

      WHERE

       i.itemtype='course' and g.userid = grades.userid

                           AND i.courseid = items.courseid limit 1

    ) 

  as CurGrade   

FROM mdl_grade_grades grades

    JOIN mdl_grade_items items ON grades.itemid = items.id

    JOIN mdl_user users on users.id = grades.userid 

    JOIN mdl_course courses ON items.courseid = courses.id    

WHERE items.itemtype='mod'

GROUP BY users.username, courses.shortname

When we update graded activities in moodle, Genius reacts to it.

These are the rules regarding this important integration.

1. My customer looks at the grades in Genius
2. The grade data in Genius should match moodle - since it is pulling from Moodle
3. If we hide graded content in the moodle - this removes it from Genius
4. If we hide graded content in the moodle and want the total points avail to be correct in the moodle, we must also move the graded item, now hidden, out of the gradebook category Percentage of course completed, and into a different category.
1. Create a not used category, for example, and move the hidden items into it.
5. After making grade changes in moodle - invoke the grade update from Genius (pulls from moodle).  Admin - Download grades from LMS (Moodle)

Each of these assertions was tested and confirmed today, again.

The end.