Enrollments Table
Dependent Tables
Program of Study
The software allows the school to plan out what classes each student will take on an individual basis using the Program of Study Module. Each and every student has a specially selected plan of what classes to take, and the school may define unlimited number of plans. The plans are created by the school administrator by creating templates associated to each program (plan).
A plan may span multiple grade years, but may only be linked to one grade span, and may not be longer in duration than the grade span.
Templates
Template records are a set of records that specify which class a student should plan to take in which term. Groups of templates are linked to a program (plan). When the student is assigned a plan, the templates are used to create the enrollment records.
Student Plan
A student plan is a record that links the student to a selected program of study. The record tracked the completion of the plan, or series of classed taken according to the plan. There is only one active student plan at any given time. Enrollment records are made for an active student plan.
If a plan is assigned to a new student, it is likely that the student will start the plan half-way through the plan. Enrollment records will only be created for current and future terms, they will not be created for past terms in the plan that the student did not actually complete.
Student Terms
Student term records are created for the entire grade span of the student. There is a student term record for every school term the student attends in that grade span.
Enrollment Records
Enrollment records relate the student to the class, to the specific curricula (Moodle Course), to a specific student term the class will be taken in, and predict the grade level of the students in that term.
As the curriculum is completed, the enrollment record is updated with the grade from Moodle and then marked complete. All completed enrollment records appear on the student's transcript.
One enrollment record is made for each template record linked to the selected program plan and linked to the student and the student term.
Future classes
One enrollment record is made for each class the student is takes at the school. Enrollment records are also created for future enrollments to represent the classes the student will have to take to complete the selected plan. Because Plans can not cross over grade spans, there will always be enough student terms records to be associated with the enrollment records. Enrollment records can not be made unless the student term records have already been created.
Enrollment Record Creation Process
When a student is assigned a plan, the enrollment records are created from information in the associated template records. By creating all future as well as current term enrollments, the student can be auto-enrolled in Moodle courses without further user action. The user selects the student’s plan, and then the enrollment records are created.
This approach allows the user to easily see what classes the student has left to take in order to complete the program by looking at all incomplete enrollments. Student progress towards graduation is very difficult to assess with most traditional Student Information Systems.
For the current term, the students are auto-enrolled in Moodle. Students are not enrolled in Moodle courses for any future terms.
Conditions to Create Enrollment Records
Enrollment records can only be created if there are student term records and a student plan assigned. Student term records are created for all terms until the student exits the grade span. To create the enrollments, a plan has to be selected for the student.