Professional Development



Web Development

Selectively Sharing Google Forms Data

by Randy Fairfield, 10/3/17

Google Forms beautifully displays the results of a form that has been responded to! How do you selectively share the results with your intended audience?

One of the best uses of Forms is to pull up the summary of the responses and display them to the whole class once a formative assessment is completed. This can help the teacher make in-the-moment instructional decisions about where to take a lesson. Here’s where you click to pull that data up:

Another great use of Forms is to pull up the individual view and bring students back to discuss their results.

Getting the Google Form data on a Google Sheets spreadsheet can be incredibly useful as well! The image below shows how to make that happen. What’s nice about this spreadsheet is that you can take it and selectively share the data with your colleagues.

Finally, another nice view is the “view analytics” page, which can be be seen by performing the following URL switch:



What’s is fantastic about this view is that you can then copy the chart that shows the results from each individual question and paste the chart into a Google Doc or a Google Slides presentation, which you can then selectively share with your students and/or colleagues.

Randy Fairfield is a Technology/Instructional Coach in the Richland School District in Eastern Washington. He is also a Google for Education Certified Trainer, Edmodo Certified Trainer and Hapara Certified Champion Trainer.