Enrollments Table
Enrollments According to the Selected Plan
The software allows the school to plan out what classes each student will take on an individual basis using the Program of Study Module. For example, all 9th graders will not take all the same classes, each and every student has an individual plan of what classes to take. The plans are created by the school administrator by creating templates associated to each student program (plan).
Enrollment Records are created from Template Records
Templates 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 student program(plan). When the student is assigned a program (plan) the templates are used to create the enrollment records. One enrollment record is made for each template record linked to the selected program(plan).
Enrollment Records are made for future classes
A enrollment record is made for every class the student takes while attending the school. Enrollment records are also created for future classes the student will take, based on the selected plan. One enrollment record is made for each class the student is taking, and will take in each student term until the end of the selected plan. Because Plans can not cross over grade_ pans, 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 templates. 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.
For the current term, the students are auto-enrolled in Moodle.
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.
Enrollment records are only made for the program(plan) record entered into the current term filed in the student record.
The conditions before creating all these enrollment records are that the a student program record is made active, and has a current term
A program(plan) spans multiple grade years, but may only be linked to one grade_span. If a program(plan) is assigned to a new student, it is likely that the student will start the program(plan) half-way through. Each template record has a specified grade level and term label, so the student will start the plan at the corresponding grade level and term label. Enrollment records will only be created for current and future terms.
If a student is progressing through their program(plan) and the school decides to change their plan, then the student has to start the new plan at the corresponding grade level and term, just like the new student. Enrollment records will only be created for current and future terms.
All Enrollment records must be linked to their corresponding “student term”. The “student term” record knows the student’s grade level and can look up the term label based on the linked academic term record.
Template database: Templates
Templates 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 student program(plan). When the student is assigned a program (plan) the templates are used to create the enrollment records. One enrollment record is made for each template record linked to the selected program(plan).
New Records database: Enrollments
A enrollment record is made for every class the student takes while attending the school. Enrollment records are also created for future classes the student will take, based on the selected plan. One enrollment record is made for each class the student has/is/will take in each student term.
Purpose
The software allows the school to plan out what classes each student will take on an individual basis. All 9th graders, for example, do not take all the same classes, each and every student has an individual plan of what classes to take. The plans are created by the school administrator by creating templates associated to each student program (plan).
When a student is assigned a plan, the enrollment records are created from the templates, for all future classes. By creating all future enrollments, the student can be auto-enrolled (Moodle) without further user action. The user selects the student’s plan, the enrollment records are created, and for the current term, the students are auto-enrolled in Moodle. This makes managing customized programs extremely easy.
Also, we can easily see what classes the student has left to take to complete the program by looking at all incomplete enrollments. This allows for a quick view of student progress towards graduation, which is very difficult to get out of most traditional Student Information Systems.
Plans can not cross over grade_spans, so there will always be enough student terms records to be associated with the enrollment records.
Business Rules
When the student is assigned a program(plan), enrollment records are created for each template record linked to the program(plan).
Changing a student’s program(plan) is a significant change. Everytime the program(plan) is changed, enrollment records that are incomplete are deleted and new ones created. The enrollment records also will trigger auto-enrollment in Moodle. The UI should help avoid changing the current program on accident.
The “Student Program” table keeps the history of what program(plan) the student was completing over the years of study. Every time the current program field in the student record is changed, a record is created in the “student program” table. The “student program” record stores the program(plan) name as well as the planned start and end dates of the program. The student program table acts like a log file of changes made to the ”current program” field in the student record.
Based on the start date of the “student program” record, the term can be linked to the record.
Enrollment records are only made for the program(plan) record entered into the current term filed in the student record.
The conditions before creating all these enrollment records are that the a student program record is made active, and has a current term
A program(plan) spans multiple grade years, but may only be linked to one grade_span. If a program(plan) is assigned to a new student, it is likely that the student will start the program(plan) half-way through. Each template record has a specified grade level and term label, so the student will start the plan at the corresponding grade level and term label. Enrollment records will only be created for current and future terms.
If a student is progressing through their program(plan) and the school decides to change their plan, then the student has to start the new plan at the corresponding grade level and term, just like the new student. Enrollment records will only be created for current and future terms.
All Enrollment records must be linked to their corresponding “student term”. The “student term” record knows the student’s grade level and can look up the term label based on the linked academic term record.