Teachers should be able to manage lessons

[josepostiga]

Scenario

As a Teacher
I want to be able to manage class lessons
So that I can keep track of absent students, disciplinary notes, and topics discussed

Description

During the development of their classes, teachers have to keep track both of how the class is going, but also of a set of a student's KPIs (assiduity, discipline) in order to be able to do their jobs: to teach. All that information can be compiled over time and worked on after if it's all kept inside the system. To help gather that information, a teacher will be able to create a lesson.

A lesson is related to a class schedule and is an aggregation of three main information: whose students were present (assiduity), disciplinary notes for a student (discipline), and which topics were covered in this lesson.

Database and schema information

Create a new lesson table, which should hold a class_schedule foreign key, a summary of topics discussed, and the usual timestamps.

Create a new lesson_registry table, which should hold a lesson foreign key, a type of registry (ABSENT, DISCIPLINARY_NOTE, TOPIC), and a value, to hold contextual information to the type of record created.

Additional requirements

No additional requirements.