Lesson attendance log

[peterinth]

Hi I'm new to this forum and am asking for some advise for a spreadsheet for school attendance.

• The students have the option to come to a class or not
• There are approx. 20 different subject classes a day
• There are 4 periods a day
• There are approx. 100 students
• There are about 20 different teachers

Problem is a student comes into school goes to a class, skip 2 classes and attend the last. In the event of an emergency there is no way to know who is on site/class
At the end of the term there is no recall of how many lessons or classes attended.

I manage the school database and can extract the classes and class lists, but there is no lesson attendance monitor and this is what I'm after.

I tried to make something in Access, but got lost in the maze.

If anyone can help I would be eternally grateful.

 

[Trevor G]

Welcome to the forum,

With regards,
"I manage the school database and can extract the classes and class lists, but there is no lesson attendance monitor and this is what I'm after."

If you already have an Access Database, wouldn't it be easier to add a Field, Attended Yes/No and have a date field automatically populate based on the Selection from the person (Teacher) who calls the register?

I have recently been involved with a school and have created a number of databases which they use for Government reports, attendance issues etc.

If I can help then let me know.

 

[peterinth]

Thanks Trevor

Yes I have an Access database, but it became messy and I guess I got sidetracked into making fancy drop down lists to select a teacher - student - class - period and dropped the whole project.

I was thinking an Excel system might have been more manageable for me. Perhaps if I couldn't manage an Access system it's unlikely I'll manage an Excel one.

Thanks anyway.