Class attendance tracker

The attendance sheet schools and courses use: color-coded P and A, automatic counts, attendance percentage and an at-risk alert.

Area: Education. Level: Easy.

Functions used: COUNTIF, IF, AVERAGE.