Simple Tracker Sheets

Are you tired of fixing typos when others are sloppy with what they enter? When you have a limited number of choices, it's easy in Google Sheets to set up a Dropdown list. This means you determine which are the available options. If they don't select one of them, they soon find out! In this beginner-friendly video, you'll learn how to create a color-coded dropdown menu in Google Sheets to manage student homeroom assignments with ease. Learn step-by-step how to use Data Validation to limit entri

Here's a simple way to create a checklist for your class. If you have several tasks, or exercises, you can easily add up the number of checkboxes that are checked for each student. This involves a very simple formula in Google Sheets.

If you have to use spreadsheets, but don't like doing it, here are some basics that will help you. In this introductory video, you'll see how to: Create a new Google sheet, rename the file, color-code tabs, and duplicate tabs for efficiency. 00:00 Google Sheets tips for teachers 00:20 Create new sheet from browser 00:30 Name your Google Sheet file 01:00 Rename your tabs 02:08 Color-code Google Sheets tabs 02:45 List tabs (sheets) 03:03 Reorder Google Sheets tabs 03:25 Copy a Google Sheet tab 0