https://www.themikeburke.com/wp-content/uploads/2020/01/080-Using-A-Spreadsheet-for-Classroom-Attendance-The-Basics-TMB-Blog-Post-Featured-Image-Compressed.jpg 712 1000 Mike https://www.themikeburke.com/wp-content/uploads/2021/07/The-Mike-Burke-Square-Header.png Mike2020-02-29 09:53:392020-04-22 12:15:36Using A Spreadsheet for Classroom Attendance- Advanced Skills
Using A Spreadsheet for Classroom Attendance- Advanced Skills
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.
In this post, I show you how you can extend conditional formatting to highlight other cells and how you can use the count if function to keep track of the number of attendance variations each of your students has over the year. Watch the video below and find a link to the Google Sheets support post about the COUNTIF function at the bottom of this post.
Google Sheets COUNTIF Support Article
The Google Sheet I Created In The YouTube Video Above
Leave a ReplyWant to join the discussion?
Feel free to contribute!