Student Plan Table
Note: student plan and student program are used to mean the exact same table
The student plan table keeps track of what plans have been assigned to the student over time. Student Plan records specify the program of study and keep track of the start date, end date, and status of the plan.
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.
The student programs table also stores the start and end dates of the plan. For example, if the student was assigned the plan half-way through the term, the exact date the student was assigned the plan is recorded.
Data Relationships
Fields
Program Status
Active Plans - There can only be one active student plan at any given time.
Suspended Plans - Students may change plans before they are completed, in this case the plan is suspended and a new student plan record created/activated.
Completed Plans - when a student completes all the classed under that plan, the plan is marked completed.
Future - Student plan records may be made for future grade spans. If the student has a future plan already created, then the student will be auto-enrolled in the next set of classes without any need for user involvement.
Units Required - The student plan is associated to the plan record, the plan record requires a total number of units to complete the plan.
Units Completed - The units from the related completed enrollment records are summed to determine how many units have been completed under this plan.
Adherence - As the student is completing the enrollment records on schedule, then the student is in compliance with the plan. If the student is not completing the enrollment records, then the plan adherence is "below plan." If the student is completing the plan, and adding extra classes, or is completing the plan early, the Adherence is above "plan."
Plan GPA - the running GPA of all the enrollments linked to the student plan, updated as the students earn grades.
Program start date - the date the plan was started, calculated from the date of the first enrollment record was activated.
Program end date - the date the program was completed, calculated from the last enrollment record or when the status was changed by the administrator.
Program start term - a link to the school term in which the student began the plan.
Action Items JAN 2024
1-MVP | TRANSCRIPT| In the Student Plan record, deprecate Units Attempted
6-NV | ASSESSMENT | Calculate Units completed under the student plan when enrollments are complete, update units completed in the student plan record.
6-NV |ASSESSMENT |Calculate adherence by comparing the units completed in the enrollments to the student plan's template records to find if the student is staying on the plan.
6-NV | ASSESSMENT | Calculate the plan GPA from the completed student term data. NOTE, this GPA does not appear of the student transcript and is for decision making on which plan to assign in the future. There is no need to track 'other' GPAs in the student plan record in the MVP.
6-NV | ASSESSMENT | Calculate the student plan start and end dates from the status of the enrollment records.
No Comments