3. Programs of Study and Subject Requirements - Ready
The program of study (plan) record must be linked to a grade_span record. There can be only one grade_span per program plan as programs plans can not cross over a grade_span.
However, a plan cover a period less than the grade span, for example there may be a 6th grade Remedial Plan that covers just one year of the 6th-8th grade span. After that plan is complete, the student is re-evaluated and placed in a new plan.
Auto Enter Start and End Grade based on related Grade Span
When entering a new Program of Study, the user must select a grade span. The grade span has a start grade and end grade, covering the entire span. Default the start grade fields and end grade fields in the program of study to the same as the grade span, then let the user override them.
The auto-enter algorithm runs one time only. The trigger is the creation of a new record or a change to the grade span value. Once this auto-enter is run, there is no need to run again. The user may change the values of start and end grade manually. A program of study may be shorter than a grade span, but may not be longer.
If the user enters a grade level manually that exceeds the grade span, such as a grade lower than the linked grade span, then do not allow this value to be saved. Also, if the user enters a grade level higher than the linked grade span, do not allow the user to save the record.
Auto-enter start and end grade
Trigger is new program of study record, or any change to grade span value
start grade = related grade span start grade
Do not allow save if:
start grade is less than the related grade span start grade
end grade is greater than the related grade span end grade
show a message to the user stating that the start or end grades are not within the grade span selected
Auto Enter Total Terms
The grade span has a field called "total terms". This field should be used to set the default for the total terms of the program plan. So the user should first select the grade span field, and then see these values populate.
However, the user may then update the actual grade levels manually. This would happen when the user is creating a program of study that does not go the full length of the span. This may be a program for one term or just one year of the span. In this case the total number of terms that were entered from the related grade span record is not correct.
If the user changes the grade levels and does not use the grade levels from the plan, then the terms will be wrong. In this case, clear the number of terms value from the field. Do not allow the user to save the record unless the total number of terms has been entered. The total number of terms may not be greater that the required and optional terms in the grade span, and can not be less that one.
Trigger is new program of study record, or any change to grade span value
If there is a change to the start grade or end grade, clear the number of terms field
Do not allow save if:
terms value is blank
terms value exceed the number of optional and required terms in the grade span
show a message to the user to enter the total number of terms for this program of study, the number may not exceed the number of terms in the grade span
Subject Requirements
The subject requirement records specify how many units of the subject a student must take under that specific plan. They relate the subjects to the programs in a many to many relationship. There will be multiple subject requirement records for each plan, but each requirement only applies to one plan. Multiple subject requirement records will related to a single subject record.
For example, under the honors program, the requirements for English are 40 units ( four years, two terms). But under the basic diploma, the requirements are only three years - 30 units.
The user creates subject requirements records when making a plan of study, then selects the classes that fulfill that requirement.
Subject Requirement Name
Concatenate: Subject Name “.” Plan Name “.U” Units Required : Example: “English.Standard 23.U20”
Update the record name every time the record is saved when there is a change to the related subject name change, related program plan name change, or the records required units field. associated term, associated student fields, or grade level field.
Potential for Errors
User changes the grade levels in the related grade span record. Now when the record is opened, the start and end grades no longer correspond to the grade span, and the record can not be saved.