Attendance spreadsheet

[Guest]

I am trying to set up an attendance system to record student attendance.
Students are assigned to one of eight courses. The course involves them in
attending 3 modules (from a choice of seven) three times per week (9
attendances in total per week). I need a combined system that allows me to
view attendance by module, by course and by individual student.

 

[Guest]

I would have thought the easiest way would be throught auto filter.

Once you have created your list - click Data, Filter, Aito filter. This
will allow you to select individual courses, or student, or a mixture, and
wioll return all instances in the list which fulfil the filter criteria,

Amanda