Don't know how to make this architecture

[Cactuskipik]

Hi everyone.

I'm helping a teacher to manage student's lessons.

• Let me tell the need:
• There are lessons that students have to assimilate.
• Each student is in a group.
• Each group has courses.
• During this course, teachers note progress for in lesson for students (students are following different lessons in the same course).
• A teacher should be able de note easily the student's progress.
• It should be possible to check the global progress of each lessons for students.

I don't know how to do it, I tried different architecture with no success.

Please, could you help me?

[Katherine561]

Database Structure: Create tables for Students, Groups, Courses, and Lessons. Establish relationships between them. Progress Tracking: Create a Progress table to store individual student progress for each lesson. User Interface: Develop a user-friendly interface for teachers to input and update student progress. Global Progress: Implement a feature for teachers to view global progress for each lesson. Considerations: Ensure authentication, validation checks, and visual representation of progress data.

[Cactuskipik]

I agree with that but how to deduce gloabl progress from individual progress ?