Tuesday, August 30, 2016

Google Forms: Data Validation

Google Forms have many uses in the educational setting. One feature of Google forms that can be especially helpful is the data validation feature on items and/or questions. Today, our district was working on a form to allow students to vote for homecoming maids. In this instance, students could only vote for 3 students of those listed as options in the question. Data validation works perfectly for this!


  • Type in your question/item
  • Click on the 3 dots on the bottom right corner of your question/item
  • Click on data validation
    • Click to select the first option (Select at least, Select at most, Select exactly)
    • Input the number for the number of options you want to allow 
    • Type in the information you would like to appear in the event the user does not follow the rules for options you created in the previous steps.
  • Add more questions/items and data validation if needed for those items as well.

How cool is that? This is actually a super, simple solution to a situation that happens more often than you might think. We have also used the data validation feature to password protect forms, but this way expands the flexibility of Google forms. What other uses do you see for data validation?

Sunday, August 21, 2016

Google Sheets Add On: Row Call



I have shared about the Row Call add on for sheets several times. Sometimes people don’t see a good use for it right off the bat. This year, I found a perfect use for it as we were submitting technology agreements. I needed to sort which teachers had completed the document in each building. Row Call performed perfectly. It took the submitted entries and divided each entry out into separate sheets based on which building they indicated that they worked in which was located in Column D.

Row Call is a super spreadsheet sorter. Do you have data in a spreadsheet that you need instantly sorted to different sheets? Check it out and put it to work for you!