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, MEd and MBA, is a teacher and consultant in the Richland School District in Eastern Washington. He is also a Google for Education Certified Trainer, Edmodo Certified Trainer and Hapara Champion Trainer and Consultant.

Sign up for our bimonthly newsletter to stay up-to-date on training events, online courses, and new blog posts!

Share this post: