I've created a free checklist template you're welcome to use. This sample checklist is perfect for teachers to use in the classroom to keep track of assignments, projects, quizzes, etc. It's editable, so you can make any changes you'd like. Keep reading for directions on how to edit and create your own from scratch. Make sure to scroll to the bottom to grab the free checklist template.
How to Make and Edit a Digital Checklist
It's super easy to add checkboxes in Google Sheets! Watch the short video below to see how to make your own, or keep scrolling for written directions.
How to Add Checkboxes:
Highlight the cells where you'd like checkboxes to appear. Go to Data, then Data Validation. Under Criteria, change List from a Range to Checkbox.
How to Change the Color of Checkboxes:
Highlight the checkboxes you'd like to change. Click on Text Color (the A with the underline). You can choose from the provided colors or click the plus button for more specific options.
How to Add Point Values to Checkboxes:
Highlight the checkboxes you'd like to change. Go to Data, then Data Validation. Check the "Use custom cell value" box. Enter the number you'd like each box to be worth where it says checked. Enter 0 where it says unchecked.
How to Create Alternating Row Colors:
Select the rows you'd like to change. Go to Format, then Alternating Colors. You can choose from a default color choice or individually choose each color.
7/3/2022 12:17:29 pm
I am a retired teacher, going back into the classroom (after 4 years out) because of a critical needs situation. I so appreciate these resources for efficiency. My teaching environment will be somewhat different (from 7-8 preps of classes 15 kids or less to 3 preps of classes with up to 30 kids). I know I will need any help I can get to stay on top of timely feedback and communcation. Thank you!
Leave a Reply.