Wonder Wall for Google Sheets

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.

Install the add-on from the Chrome Web 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]

form-setupNext, 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!

open

 

 

 

 

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.

Send some suggestions to @rheajt or @get_sharpe, and feel free to check out any of our other projects!

 

 

 

Coding with #COL16

I participated in a Hangout on Air with Daniel Sharpe, and the result was pretty great! We sat down and coded a decent start to an app that displays form responses in the style of Pinterest or Padlet. My internet crashed 4 times during the recording, but despite my terrible connection we would up with a decent product

Probably not for the absolute beginner, but I think there is something in there to be learned for an aspiring coder. (Experienced coders will probably ridicule my lack of style)

Do people want to see more of this? What can we introduce as we go along? Tweet at us @rheajt and @get_sharpe

 

CopyPastaForm for Google Forms

Google Forms is a great tool, unfortunately it takes a bit of time to create one. I have had the thought that it would be much easier to have one single text box that I can type in (or copy and paste into) that will generate the entire form. This led me to create…

CopyPastaForm for Google Forms