Classes Table

Relevant Definitions

{{@90#bkmrk-subjects-are-familie}}

{{@90#bkmrk-a-grade-span-covers-}}

{{@90#bkmrk-in-summary%2C-enrollme}}

{{@90#bkmrk-curriculum-generall-}}

{{@90#bkmrk-this-is-the-list-of-}}

The Class List

The class list is a set of records that represent all the 'transcript' classes a student will take at the school.  The names of the classes are the exact names that appear on the student's transcript.

Data Relationships

Classes are linked to multiple enrollment records.

As many students will take the same class, many student enrollment records are associated to the same class record.  A list of all students who ever took that class may be reported on. 

Classes are linked to multiple template records.

1) there may be multiple curriculum (Moodle Courses) that will have all the same name on the transcript, such as two different Algebra I courses using different curriculum, but essential both just Algebra. 

2) There will be multiple plans that all required the same class. For example the University preparation will require English 9, but so with the basic diploma.

Each class may only have one assigned subject.  Some classes can be dual purpose, this use case is is described in Subject and Subject Requirements Tables.

{{@168#bkmrk-for-example%2C-environ}}

A class record may be associated to only one subject record.

Per above, should a class fulfill multiple subject requirements, separate class records must be created.

Classes are not associated to Curriculum

In the use case above, we see why the classes are not directly associated with the curriculum. Either the template or the enrollment record contains the additional information needed to determine which requirements the combination of class and curriculum fulfill.

A class record may be associate to one grade span.

This feature may be used to filter and down select the relationships when creating the records.  Additional logic may be added to prevent students from being enrolled in classes outside their gran span, but this feature has not yet been determined necessary.

Fields

The class name is the name of the course exactly as it is to appear on transcripts.

The units the school gives for the class in only stored in the class record. There are no units associated with the various curriculum (Moodle Courses).

NCES, State, and Local code - these are various Class coding systems used by various regulatory organizations.  The local code is used for all school business, the NCES and State codes are informational.

NCES rigor is a specific requirement for hte NCES organization in the US. It specifies the difficulty level of the class.

Syllabus - a field is provided so that the administrator can link an official syllabus to the class. 

This Pre-requisite field reserved to add logic to prevent enrollments to be created where courses are out of sync.  This is not needed when plans are enables since the planning processes specifies the order.

Carnegie units - this is an alternate unit system used in the US based on the number of hours of the course.

Exclude GPA - this field is a flag to exempt the class from various GPA calculations. The administrator may choose to exempt the Class from the standard GPA calculation, an alternate GPS calculation, both, or neither.  The use case for this is that the State of Claifornia's student financial aid organization does not consider Physical Education when calculating the student's GPA for the purpose of student loans.

Action Items JAN 2023

Exclude GPA field is used in the transcript GPA calculations, this has not yet been fully implemented.