Attendance tracking & at-risk flags
This lesson is part of the course
In this lesson
You count present, absent and late days with COUNTIF, work out each student's attendance %, and flag students at risk with IF, OR and AND.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- A weighted gradebook with SUMPRODUCT Locked
- Dropping the lowest score Locked
- Letter grades with an approximate-match lookup Locked
- Class statistics: mean, median, spread & pass rate Locked
- Curving scores: bonus, scaling & z-scores Locked
- Attendance tracking & at-risk flags Locked
- Progress over terms: growth & rankings Locked
- Item analysis: difficulty & discrimination Locked