Recently I made a YouTube video and blog post about how I keep track of student attendance in my classroom using spreadsheets. Those resources showed you how to use conditional formatting to highlight students’ statuses and how to use data validation to create drop-down menus in your spreadsheets.