Groups Table

Relevant Topics

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

{{@90#bkmrk-the-teacher-of-recor}}

{{@188#bkmrk-where-teachers-are-t}}

{{@185#bkmrk-a-cohort-is-a-group-}}

{{@90#bkmrk-sections-are-a-set-o}}

{{@185#bkmrk-sections-are-used-to}}

Groups Overview

Critical to allowing third parties access to the Moodle is the capability to limit the students each third party is allowed to see. Moodle Groups allow teachers (proctors) to see only their assigned students.  In Moodle a group needs to be created for each course. Then the students and the teacher are assigned to that group.  When a teacher views student progress, they will only see work from student in the same group as them in that particular course.

Using the Moodle interface, this is a tedious and error-prone process. The Group table in the SIS is used to assign the student to a group, then when that student is enrolled in the Moodle course, the student is also added to the correct group.

In a virtual school, an unlimited number of students may take any online course at anytime. However, the teacher of record is still responsible for grade student work and assign final grades.  Too many students in a course can overwhelm any online teacher, especially as some organizations have a requirement for the student to have virtual, synchronous lessons or for the teacher to hold office hours. 

Data Relationships

Each curriculum record can have multiple groups, one group linked to each curriculum record  fro every location (homeroom). A location will have multiple student grade levels, any combination of K through 12 students, so the sections are not restricted to specific grade level.

The groups are related to the homeroom.  A group can have only one homeroom.

Students are related to multiple groups and only one homeroom.  Note there is no direct relationship between students, proctors, and Teachers, the relationship is created only through the group record.

As a location (Homeroom) is allowed multiple proctors, multiple proctors can be related to the corresponding group.  There is a many to many relationship between proctors and sections, because proctors review multiple courses.

The proctor does not fulfill the regulatory requirements of the teacher of record. There can be only one teacher of record for any class as student takes, so there is only one teacher of record for a group.  The teacher of record may be related to multiple groups (for other classes the teacher teaches).  The teacher of record is not related to the curriculum record, the teacher is only related to the group record.  In relating the teacher to the group record, SIS can better manage the reporting on which specific students took the course under what teacher.

Fields

Group Name - Concatenate the Homeroom and Moodle Course ID.

Capacity - the maximum number of students allowed in the group default to 40.

Action Items JAN 2024

Many to Many relationship to Proctor

Select one teacher of record

Select one Homeroom

Many to Many relationship to students

Teacher of Record Authorization Status - options are "clear, unauthorized, expiration risk, temporary authorization"

Note: The Sections table in the teacher will be deprecated as its function is replaced by this group table.

Also Note: Groups table in the schools module, it should be moved to the homeroom module.