Using Google Forms and Sheets

If you've ever used Estimation 180, you'll notice there's a Google Form on each day where anyone in the world can input their estimate. Although it's not what I envisioned when initially designing the site, it has served a purpose. And it's free. So until I have a million dollars or someone is willing to donate a bunch of money to Estimation 180 so there can be a classroom type interface like teacher.desmos.com or Pear Deck, the Google forms will have to do for now.

My suggestion: create your own form so that you can capture rich data from your students. I believe it's so important that we capture, sort, assess, and discuss student thinking. I put together three short screencasts on:

1. Suggestions for using your own Google Form with students.
2. How to make the Google Form in video 1.
3. How to sort and use the data in the Google Sheet. 

Part 1: The finished form

• Form fields and parameters
• Daily pic in the form

Part 2: Creating and setting up the form

• Text fields and advanced settings
• Insert the image URL into the form
• Creating sentence starters
• Using a shortened URL

Part 3: Sorting the data in a Google Sheet

• Using Add-ons, specifically rowCall to separate class periods into their own sheets
• Conditional Formatting
• Finding the average (and more) of a column

Please let me know if you have any questions or suggestions to make the work flow more efficient.

If you're headed to CUE 2015 in Palm Springs, come check out one of my two sessions where I'll use Google Forms and Sheets to capture, sort, assess, and discuss the rich thinking and data you can receive from students.

Forms,
216