Google Sheets is a great tool for almost any application. I know that the primary use is as a spreadsheet and the computation that can come with that, but there is much more that this tool is capable of. In this post, I will highlight how to use Data Validation to create drop down menus in your spreadsheet to make your life easier and open up the possibilities of this tool.

Here is a tutorial I quickly put together that will walk you through how to do it and how it looks!

I have used data validation to:
  • Create grouping sheets
  • Organize centers
  • Track Student progress
  • Track Behavior
  • Develop student driven lessons

If you like what you read, please subscribe or share!