Display responses from Google Forms in real time!
The idea sprung from a professional development meeting I was having on inquiry based learning (IBL). Several apps were discussed as ways for students to share their questions in real time. I immediately thought that using Google Forms and Sheets would be a great project. My friend Daniel Sharpe who I do a weekly hour of code with thought the same thing. So we devoted two hours to making it a deployed add-on in the add-on store.
Check out the project, and let us know how we can improve it!
After you have installed the add-on, the first step is to create a Google Form with the correct questions. You can create your own or make a copy below.
[su_button url=”https://docs.google.com/forms/d/1ufeASeFlwc-cJhV16FHtzgc4A_mgNQn8kn8iDyBofqg/copy” target=”blank” style=”flat” background=”#f37c2d” color=”#ffffff” size=”8″ wide=”yes” center=”yes” radius=”0″ icon=”icon: users” text_shadow=”0px 0px 0px #000000″]Make a copy on your drive.[/su_button]
Next, create a spreadsheet for responses and open it. Once you have done that, all you need to do is open the add-on menu and run!
The page will update itself every 10 seconds with responses. We tried to make it look like Pinterest or Padlet style sites. However, neither of us is that great at CSS styling. So we used Bubble CSS for the text bubbles, and a codepen.io project for the columns.