Curriculum, Lessons & Student Progress

Beyond structural organization, the Sunday School module coordinates weekly lesson planning, class attendance, and student performance metrics.

---

1. Weekly Curriculum (sunday_school_curriculum)

Teachers define a syllabus of lessons for their assigned classes.

Core Lesson Fields

• class_id (uuid): References the class this lesson belongs to.
• week_number (integer): The chronological lesson week (e.g., Week 1, Week 12).
• topic (text): The title of the lesson (e.g., "The Parable of the Sower").
• scripture_reference (text): Key biblical or liturgical texts (e.g., "Matthew 13:1-23").
• materials (text): Teacher aids, download links, handouts, or slides.
• lesson_date (date): Scheduled day of instruction.
• is_completed (boolean): Mark whether the lesson was taught. Defaults to false.

---

2. Lesson Attendance (sunday_school_attendance)

Attendance for weekly lessons is tracked independently of general church services.

• curriculum_id (uuid): References the specific lesson topic being taught.
• class_id (uuid): References the class.
• person_id (uuid): References the student.
• status (text): Attendance status: 'present', 'absent', or 'late'.
• recorded_at (timestamptz): When check-in occurred.

Note: Absence alerts do not automatically generate pastoral visitation cases for Sunday School lesson absences unless configured in the organizational alerting parameters. However, they contribute to the student’s overall engagement score.

---

3. Progress & Grading (sunday_school_progress)

To record comprehension and quiz scores, teachers can log evaluations.

• score (numeric): Numeric grade on assessments (such as quizzes or oral exams).
• grade (text): Letter grade designation (e.g., "A", "B+", "Pass").
• completion_status (text): Status tracking for assignments or term progress: 'not_started', 'in_progress', or 'completed'.
• assessed_by (uuid): References the teacher’s profile ID who conducted the evaluation.