Student education plan database maintenance manual

Selectives. In some cases, the Faculty allows students to choose from a list of two or more courses in order to meet a requirement. The courses which are included in these lists are called "selectives." There may any number of selective lists in a student educational plan.

Selective choices are specified by means of the following course codes:

The course_prefix is SEL

The first two numbers of the course_number indicate which selective list is being referenced

For example: If the choice must be made from the first selective list, the course code is SEL 01x. If the choice must be made from the ninth selective list, the course code is SEL 09x. If the choice must be made from the tenth selective list, the course code is SEL 10x.

The last number of the course_number indicates which choice is being referenced

For example: If the choice must be made from the first selective list, and this is the first time a choice has been required from this list, the course code is SEL 011. If the choice must be made from the ninth selective list, and this is the eighth time a choice has been required from this list, the course code is SEL 098. If the choice must be made from the tenth selective list, and this is the third time a choice has been required from this list the course code is SEL 103.

Selective list descriptions. Any description can be entered into the course title field for selective course codes. By this means, a description of the selective list can be entered into the student education plan.

For example, after entering SEL 103, the operator could enter "Math basic skills course" or "Humanities selective."

Courses which may be taken in either semester. In some cases, the Faculty indicates that students may take a course in either semester of a year. In such cases, the course shoud be entered for each semester in which it might be required, and required_course field in each record should be set to "F."

Student education plan printout and display. The student education plan printouts and displays should work like this:

Print "Student education plan"

Print catalog_year

Print long_majmin_desc

Print degree_type_desc

For each class_code

Print description which corresponds to next class_code [Freshman, Sophomore…]

Print description which corresponds to next sched_priority_code [Fall, Spring or Summer]

For each sched_priority_code

Select all records which correspond to this class code and sched_priority_code and which do not have course_prefix = SEL and which do not have required_course = 0

For each selected course

Print course_prefix + course_number + catalog_course_desc + program_credits

Print "These courses may be taken in either semester of the [class_code description] year"

Select all records which do not have course_prefix = SEL and which have required_course = 0

For each selected course

Print course_prefix + course_number + catalog_course_desc + program_credits

For each selective list for this major

Print "Selective list: [Description entered for the selective list in the student education plan]"

For each course in this selective list

Print course_prefix + course_number + catalog_course_desc + program_credits

Example student education plan:

Student Education Plan

1997-98

Agricultural Technology

Associate of Science

Freshman year

Fall semester

AG      100     Leadership Development    3

AG      101     Animal Science         3

…

Spring semester

AG      125     Farm Management   3

AG      150     Agricultural Computing         3

….

These courses may be taken in either semester of the Freshman year

ENGL 111     Written Communication I      3

SEL    011     Basic skills Math selective   3

…

Sophomore year

…

Junior year

…

…

Selective lists.

Basic skills Math selectives

MATH 110     Math for Liberal Arts 4

MATH 112     College Algebra        3

Distribution Science selectives

…

Program selectives