Help needed: student attendance

We are trying to build a board to use for attendance. We need to show if they attended, were late, or absent and whether or not it was excused. We also need to be able to easily see which students have had 4 or more unexcused absences per cycle. I haven’t been able to figure out a way to easily capture this data. Can anyone possibly help with this please?

hi @ler2147 !

You can probably start with a simple setup.

Vertical setup:
Board = class / course
Section = Week
item = Student
Status column + Date column = Present/Abs w Excuse / Abs wo Excuse + date

Then you can do filter or a dashboard. Statuses are cool because you can easily filter things out.

You can do a horizontal setup

Board = course
Item = Student
25 Status columns = each column equals a date/week with a lecture, and it’s statuses reflect the presence/absence

Hope it helps.