Subject and Subject Requirements Tables
Relevant Definitions
Subjects are families of classes. For example, Algebra I, Geometry, and Algebra II are all in the subject of Math. Schools can define any subjects they need, and identify any class as belonging to that subject area. Subjects are mainly used to assist the administration in checking the student is meeting requirements when creating a plan .
Subject requirements are the number of units in total required in a subject area by a regulatory organization. For example, the NCAA may require 4 years of English and 3 years of math. The University of California may require 4 years of English and 4 years of math. The NCAA subject requirement for math is 3 years, the University of California subject requirement for math is 4 years. For University of California, the subject requirement is 4 years, the subject is math. Note: sometimes requirements are described in 'years' of study, sometimes in credits, and sometimes in units.
Subjects Table
The subjects table has only the name field. The administrator can enter unlimited subjects. However, a class record may only be linked to one subject record. Curriculum records are not linked to subject records. A curriculum may be used to fulfill different subject depending on the plan. For example, Environmental Science may be frequently used to meet Biological Science or Physical Science but not both. There would be two class records. One called Environmental Science that is linked to the subject of biology and another that is linked to the subject of physical science. However there is just one Moodle course, so there is just one curriculum record. The curriculum therefore does not specify a subject, and is not related to subject records.
Subject Requirements Table