Scenario:
Students have earned some extra Enrichment time! Using a shared Google Sheet, teachers are going to sign up their students, but all the data needs to be uniform in order to make lists, badges, etc., and most of all, easy to sort.
Ta-DA! Using Data Validation, create dropdown menus in the sheet, limiting the data that can be entered!
Click here to see how to Create a new spreadsheet in 24 seconds
Data Validation allows you to create dropdown menus, etc. for each cell in each column so all the information is uniform.
Highlight the column, or the row you wish to have the dropdown menus showing. Then, right click and select Data Validation from the menu:
There are many choices on how you want to create your menus. These are some of the most frequent options I use:
- List of Items to enter the days of the week or teacher names
- Number so that the grade level appears as 3, 4, 5, etc. by selecting “between”
- Use Checkbox to enter a checkbox
This is how to enter the days of the week:
Explore all the options and see which ones work best for the task at hand. Once you have finished, don’t forget to Share the Google Sheet!