Activate Student Plan -New!

Relationship to starting school term

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 studnet 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 isfield acontains relationshipinformation toon 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 not idea 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 at least 13 years of school, the student will likely complete 6 to 8 plan.plans.

 

Determining the school term when a student plan is complete

• The associated schools plan's record,record is in the prgrams of study table,table. This record includes the total number of terms required to complete the plan. 
• The student's plan record contains the program start term. 
• AddTo find the last term of the student plan, add the total number of terms to the sequence of the school terms to determine the term the student will complete the plan.

student plan record: program start term: related sequence + related school plan: total number of terms = sequence of term the school plan will be completed

Updating the Active Student Plan

If student's grade_level is greater than the end of current student plan, then the student needs to have a new plan assignedassigned.  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."