KATE'S MATH LESSONS
  • Home
  • LESSONS
    • Pre-Algebra
    • Algebra 1
    • Geometry
    • Algebra 2
  • About
  • Contact
  • Blog
  • Shop
  • Courses
  • Home
  • LESSONS
    • Pre-Algebra
    • Algebra 1
    • Geometry
    • Algebra 2
  • About
  • Contact
  • Blog
  • Shop
  • Courses
Picture

Welcome to Kate's Math Lessons!

My mission is to make life easier for secondary math teachers.

How to Make a Checklist in Google Sheets

11/30/2021

1 Comment

 
Did you know you can add checkboxes to a spreadsheet?  You can also assign point values to checkboxes and automatically keep track of students' progress!  Paper and pencil checklists are always great, but it can also be nice to have a digital version to help you keep track of things.
How to Make a Digital Checklist in Google Sheets
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.

Picture
1 Comment
Raelynn
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!

Reply



Leave a Reply.

Want to try one of my digital math activities for free?  Click the link to grab the teacher version or student version.

Home

About

Privacy Policy

Lessons

Contact

Copyright © 2015 - 2021 Kate's Math Lessons