Activate Student Plan -New!
The student plan table shows the status of the various plans the student has been assigned over time, it is like a log file for the student plans.
- Multiple student plan records may be associated to a student record
- Only one plan may be active at any point in time. Program_status = active.
- There may be other student plan records associated with the student, but their status may not be active.
- The program start term field contains information on the school term, not the student term. This is an important value and so the name is stored in the student plan term reocrd field called program start term.
Only one student plan record may be active at a time
Develop a combination of UI and programming to ensure that only one student plan is active at ay point in time - (I have no dea how to do this)
Relationship to starting school term
When the user assigns the student a plan, they must enter the start date of the plan. Sometimes students will start a plan in the middle of the term, it is important to know if they had less time to complete courses due to a mid-term start date.
Based on the start_date of the student plan, PEMS identifies the starting school term and creates the relationship between school term and the student's plans.
Student Plans are used to create enrollments, but eventually each student will complete their plan and need to be assigned another plan. In the course of 13 years of school, the student will likely complete 6 to 8 plans.
Determining the school term when a student plan is complete
- The associated schools plan's record is in the prgrams of study table. This record includes the total number of terms required to complete the plan.
- The student's plan record contains the program start term.
- To find the last term of the student plan, add the total number of terms to the sequence
student plan record: program start term: related sequence + related school plan: total number of terms = sequence of term the school plan will be completed
Completing the Active Student Plan
We can find the school term when a student plan should completed (see above). When this school term has passed, then we can mark the student plan record complete. The student plan record is marked complete based only on the calendar, so a student's marks for classes the student took under the plan are not relevent.
So when the current date is passed any student's plan's final term current date, then the student plan record will be marked complete.
When current term sequence = student plans' final term sequence, AND the current date is >/= end date of the student plans' final term, then change the status of the student plan to 'completed.
Activating the next student plan
If there is another student plan record with status = future, then we can automatically activate the next plan record, after we set the satus of the student plan record above to completed. We will need to find the next student plan records by finding the student plan. Each student plan is associated to a school term, which has a sequence. The next student plan will have a program start term reater than the current term's sequence.
If student's grade_level is greater than the end of current student plan, then the student needs to have a new plan assigned. Since mutiple student plans may be entered, the user may set up future plans for the full duration of the school year, where student plan status = "future."