attendance for the week / month or semester is a larger view that relies on the granular attendance for each day.
You cant calculate weekly attendance with out first knowing daily attendance.
The strategy of using a linking table to track attendance on a daily basis is the best approach.