Calcalualtion of class attendance

[Daryl2106]

HI,

I am about to embark on the challenege of calculating % attendance for each student in each class of my DB. Each student attends multiple classes and each class has multiple attendance records. This is all new to me, so I am asking for some direction before I go off in my own direction and make errors or make things harder they they need to be, which is my tendancy.



Thanks and take care,

Daryl

[June7]

Depends how you want to calculate. If student was present for any class in the day does that count as 1 day or do you want percentage of all classes? Then how do you want to handle excused absences such as illness or extracuricular activities?

Google: Access database student attendance

http://office.microsoft.com/en-us/ac...010353349.aspx

I don't know if this accommodates multiple classes or if it is an elementary school model.

[Daryl2106]

Hi JUne,

Thanks for the link. In my DB, faculty enter attendance biweekly for each student in their courses as whole numbers. For example, in the ClassesAttended field they may enter 7 and in the classes offered they may enter 10. At this point there is about ten records for each student. So I need to calculate the PercentAttendance for each student in each class by summing the ClassesAttended and the ClassesOffered and then dividing the first by the second. I need to group the "answers" by StudentID, then by class. I would like to show SumofClassesAttended, SumofClassesOfferes, PercentAttendance.

Thanks and take care,

Daryl

[June7]

So you know how to accomplish those calcs and this issue is resolved?

[Daryl2106]

Not quite. I think I may be able to figure out how to write the expressions when I get there, but right now I am struggle with the best "route" to take. In the end we need to be able to view a complete attendance profile for each student from the main student review form (during our meetings). Also we will need to print a complete attendance profile for each student as needed. Thirdly we need to be able to display the average attendance for each course a student is enrolled in several other forms and reports.

I played with pivot tables and charts a little. I am wondering if using excel pivot tables with access might be an option. Or maybe it is a report that I need that can be opened from a button in the main form.

I think this should be a fairly simple problem to solve and set of results to create. I just don't want to make things more difficult to do than they need be.

Thanks and take care,

Daryl

[Daryl2106]

Hi JUne,

I did my calculations to work so far. Thanks, Daryl