cells highlighted in red are denoted as absences

Cells highlighted in yellow are lowest/missed quizzes replaced by quiz 9, students without yellow cells had lower quiz 9 grades and no missing quizzes to replace