N
n
Please help a school.
Here is the setup:
One School has a Diploma.
To complete the diploma 3 courses must be taken, 1,2,3.
Several level 1, 2 and 3 courses are running at the same time.
Students may begin at level 1,2 or 3 depending on their level.
Students may need to resit a level depending on their performance.
Resits are possible 2 or 3 times.
Each level is 8 weeks: 5 days a week, 3 lessons a day.
Attendance for each student is taken for each lesson.
What would be the best way to set up this database? For example, which
tables and queries?
Admin needs to be able to see who is present /absent /late each day.
Teachers need to be able to input the attendance for the whole group
each lesson. (student 1, present, student 2 tardy...)
Admin need to be able to check who is teaching which level, which room
the course is in and so on.
Any help greatly appreciated.
Here is the setup:
One School has a Diploma.
To complete the diploma 3 courses must be taken, 1,2,3.
Several level 1, 2 and 3 courses are running at the same time.
Students may begin at level 1,2 or 3 depending on their level.
Students may need to resit a level depending on their performance.
Resits are possible 2 or 3 times.
Each level is 8 weeks: 5 days a week, 3 lessons a day.
Attendance for each student is taken for each lesson.
What would be the best way to set up this database? For example, which
tables and queries?
Admin needs to be able to see who is present /absent /late each day.
Teachers need to be able to input the attendance for the whole group
each lesson. (student 1, present, student 2 tardy...)
Admin need to be able to check who is teaching which level, which room
the course is in and so on.
Any help greatly appreciated.