Opensis Integration

This document hopes to outline the goals of integrating OpenSIS with Moodle.

Major Milestones

1. MySQL integration
2. Transition to adodb
   1. Evaluate OpenSIS table structures
      1. https://docs.moodle.org/en/Development:XMLDB_defining_an_XML_structure#Conventions
   2. Transition to moodle/lib/dmllib.php calls
3. Evaluate OpenSIS language strings (get terminology matching with Moodle)
4. Evaluate OpenSIS permissions scheme and migrate toward Moodle user, role, capability, context schema
5. Assessment OpenSIS security
   1. ensure md5 passwords

Desired functionality from integration

1. Users - Single signon for teachers, students, administrators between both systems. The goal is to use Moodle's libraries and authentication types. We will need to create OpenSIS capabilities and perhaps some roles.
2. Courses - Courses created in OpenSIS should automatically create a course in Moodle. By default, this should use the following Course category hierarchy (Marking period, subject (department), course).
3. Enrollments - Teachers and students assigned to a course/period should be automatically enrolled in the Moodle course.
4. Grades - In Moodle grade items are stored in the gradebook. There are various ways of calculating the grades in Moodle. We need to figure out how best to handle this. Perhaps it would just be best initially to have OpenSIS look up the final grade and not worry about assignments or possibly to create some Moodle grade reports and simply use the Moodle gradebook. The downside to this is that the goal as I understand it is to keep the two systems separated enough that each could be a standalone.