Surveys and Graphs

Page history last edited by readinginthemiddle 4 mos ago

 

In the process of teaching how to use spreadsheets I have often had students do a few surveys. Typically these are somewhat trivial surveys indicating food preferences, favorite teams, or frequently used products.  Students collect data, crunch numbers, and write about their results.   At times they have created surveys on major issues. In the past I used MSExcel and more recently the spread sheet tool in Google Docs. In the past doing large class based surveys required the collection of data, compilation, and extensive repetitive entering of data into worksheets.  There were always many opportunities for errors, especially when students enter data.

 

This year Google added a new feature to Google Docs called Google Forms. This has been one of the most fantastic tools I have EVER used....and the best part, results can be incorporated into your Wiki.

 


 

To create a Google Doc Spreadsheet you will need a Google account.  Go ahead. Its free, and so is virtually every online tool Google Offers.

 

Here is a simple Google Docs spreadsheet that will become a Favorite Web Sites Survey.  The survey choices are simply entered at the top of each column.  More choices were possible but I kept this one very basic.

 

 

 

After you have created the spreadsheet you then create a form to go with it.  The form will be used by the participants of the survey to automatically add their survey data to the spreadsheet you just created.  The form creation tool allows you to create a wide variety of surveys. For example purposes I created, once again, a very simple form.  You can see the form below, but first............

 

Here is a  Link to the Actual Google Doc Spreadsheet.  (Note: This is a link to the spreadsheet, it is not embedded or uploaded to PBWiki.  The spreadsheet is still "living" at Google Docs.

If you open the above spreadsheet, before you take the survey below, you may actually be able to see your data automatically populate the spreadsheet after you submit the form embedded below.  Many people have already completed their survey. You can try it now.

http://spreadsheets.google.com/pub?key=rbGBts4nkRF0JYmLEKymUZA&single=true&gid=0&output=html 

 

Here is the actual embedded LIVE survey form.  Take the survey, Please. (More information on embedding the form appears later) 

When you complete this survey, click the submit button at the bottom. Your results are automatically entered into the spreadsheet created above.

THIS IS A LIVE SURVEY.....PLEASE COMPLETE IT NOW AND DON'T FORGET TO CLICK THE SUBMIT BUTTON AT THE BOTTOM OF THE SURVEY.

 

 

You can see below some survey data that has been entered by way of the above form.  These ARE NOT real time embedded examples, merely screen shots.  If you want to see something amazing you can watch the data being entered into the spreadsheet. 

To see the actual data coming into the spreadsheet you must be viewing the spreadsheets in Google Docs, while you or someone else is completing and submitting data. After you have enough data graphs can be generated from Google Docs and embedded here in PBWorks pages.

 

 

The individual ratings can be averaged and a summary chart can be generated and embedded into a PBworks page.

Unfortunately it will NOT update in real time but, it is relatively easy to generate and embed updated charts and survey results.

Here is a chart representing the data of about eighty, PBworks summer camp participants.

 

 

Let's hear it for PBworks!!

 

A wide variety of surveys can be generated.  You are not limited to surveys based upon numerical data. Short answers, longer answers, multiple choice, checkboxes with multiple answers, and other survey styles are supported.  Here is a screen shot of the Google Form creation tool.

 

 

At my school we have even created a form for teachers to use to enter computer support requests. Our computer support specialist is able to automatically maintain a running log of tech support issues.  All sorts of possiblities exist, and data entry forms can live on PBWorks pages. 

 

One of my most novel uses was in in the process of students evaluating other student projects.  Students used a Google Docs form and a rubric to grade the classmates' programming assignments. Upon completion of their evaluation, they entered the data into a form, which in turn entered the class data for each student's project into a spreadsheet.  Each student received an analysis of their grade generated from their thirty-five classmates.

 

To Embed Your Google Docs Spreadsheet Form. Use the Form Menu.

 

 

Do a Select All on the HTML code that is shown in the Embed dialog box.

 

Insert your cursor at the point in your PBWorks document that you want the embedded form to appear and choose Insert Plugin.

Choose PBworks magic (and it is magic, isn't it?) Then choose HTML/JavaScript.

 

SurveyMonkey Surveys 

SurveyMonkey is a well known, and well regarded website that anyone can use to create simple-complex surveys.  They offer a limited subset of free tools as well and a premium service for those who want advanced survey tools and capabilities.

You will need to create a SurveyMonkey account to access the free survey tools.  A survey can then be created and that survey can be linked to your PBWorks page(s).  Here is an example of the Website survey done with the SurveyMonkey site.

Take the SurveyMonkey version of the survey. Click this link.

Click Here to take survey 

Unfortunately, the basic free account seems to limit you to simply viewing responses and not much more.  You will have to pay ($20/month, $60/quarter or $200/yr) for features that allow you to download data, share responses and results and survey large groups.  For these reasons I prefer Google Docs. Google Docs is completely FREE, and the tools are available to all.


Tools used to create this page.

Screen capture  SnapzPro, but any free screen capture program would work, on Macintosh, try Capture Me, or  SnapNDrag.

Photoshop or other photo or picture editor.

Google Docs. Google Docs requires a free Google account.

SurveyMonkey. SurveyMonkey also requires a free account for limited survey features or a paid account for complete survey capabilities.

Comments (Show all 80)

profile picture

kathleen kouchi said

at 3:24 pm on Jun 30, 2009

This is so cool - Thanks for the new resource - I use Google all the time without knowing about docs - Thanks so very much!

profile picture

Cynthia Coulter said

at 4:29 pm on Jun 30, 2009

Survey Monkey is limited to 100 responses in its free version, then you have to pay for it.
Check out Tiger Survey www.tigersurvey.com/ for a free tools with a lot less limitations in number of responses allowed per survey, and also the number of surveys you can create.

profile picture

Judy Brown said

at 7:26 pm on Jun 30, 2009

AS someone who is new to manyof these tools, I appreciate your clear description and suggestions for using the Google documents.

profile picture

Raymond G. Oltion said

at 7:46 pm on Jun 30, 2009

I suppose surveys would be a good way to get students involved in a class. I tried something similar in my astronomy class when I had them vote for homework problems. I asked them to pick one problem from each of several (maybe eight or ten) groups of problems, which I would then assign for them to complete. That forced them to read all the homework problems and choose the ones they preferred. (I figured even choosing the easiest ones was acceptible, as long as they read them all to make their choice.) The survey tool described in this tutorial would work well if the number of survey "questions" wasn't limited to 10 or less.

profile picture

Cathryn McCormack said

at 11:46 pm on Jun 30, 2009

I do loads of surveys to collect student feedback - I actually have three SurveyMonkey accounts which I share with others in different areas. I usually conduct surveys on behalf of other staff members, so asking students in a class what they thought of the class and the teacher. The part that I find most useful is being able to send individual emails to students to complete the survey - I can introduce myself, what the survey is about, how it is separate from their class, and provide links to sample reports so students can see their response is de-identified before the report goes to their teacher. At the time I set up the survey I can schedule reminder emails for students who haven't completed the survey.
However the Google Docs survey idea looks really useful for peer feedback. I'd like to give it a go.

profile picture

Nancy Roberts said

at 3:30 am on Jul 1, 2009

Thanks for sharing Bruce! Your instructions were very clear and enabled me to create a survey. I love the way the data is recorded and easily transformed into charts. You have just made my life easier!

profile picture

Alvaro Jesus Ricardez said

at 5:01 am on Jul 1, 2009

Thanks Bruce fort this remarkable explanation. It is extremely clear and very well detailed! You didn't leave anything out! Very often informatics gurus think that we, simple mortals, know absolutely all the "simplest" details. And at least for me, those details are forgotten time after time! So, a million thanks from the deepest part of my heart!

profile picture

LZimm said

at 9:56 am on Jul 1, 2009

I'm having trouble embedding the right code for the survey - my spreadsheet shows but not the form that I created. UGHH! on Google Docs - it doesn't even indicate that I have saved the form.....can anyone help?

profile picture

LZimm said

at 10:05 am on Jul 1, 2009

Trial by Fire! I figured it out after carefully reading through Bruce's instructions......minor details....you can't choose embed spreadsheet under google apps, you need to embed HTML code for the "form".

profile picture

Kim Abouabdo said

at 11:56 am on Jul 1, 2009

Hi! I love the surveys! I think it's a great way to involve students in a way they will find fun - not to mention the potential feedback I can get! I added a survey using Google docs and the form shows up in a square box with a scroll bar. I noticed your example had the entire form showing. How do I do that? Thanks!

profile picture

Bruce Gurnick said

at 2:03 pm on Jul 1, 2009

My Google Docs spreadsheet is NOT actually embedded into my wiki. Rather, there is a link to the Google Docs spredsheet. You create the link in Google Docs while viewing the spreadsheet. Just click the Blue Share button (upper right) and choose "Get the Link to Share". Make sure you check the box Allow anyone with the link to view (no sign-in required) and make sure that Allow anyone to edit IS NOT CHECKED. Then copy the code that appears and paste it into your PBworks page as a link. Be sure to have this page open in a new window, a choice you make when creating links on your wiki page. Then you will see a scrolling spreadsheet.

profile picture

Kim Abouabdo said

at 12:31 pm on Jul 1, 2009

Well I checked your embed codes against mine and saw a difference in the size numbers. So I changed mine and got the entire form. But I'm thinking that is not the best way to do this... a lot of guessing until you get the numbers correct.... So please still help!

profile picture

Kelly Cleavinger said

at 4:54 pm on Jul 1, 2009

I too have struggled with the size codes, however it seems an increase of just 25% can make a significant difference. I don't know what the actual rule is however.

profile picture

Kim Abouabdo said

at 5:44 pm on Jul 1, 2009

Bruce, I tried what you said. It allows me to share my spreadsheet. I was asking about getting my survey form to show completely on my wiki page. Is there a different way to do it then by changing the size in the embedded code?

profile picture

Jessica Mann said

at 5:58 pm on Jul 1, 2009

This is sooooooo cool! Thanks so much for sharing it! I work with gifted 3-5th math students, and this will be a great project for them.

profile picture

ed shephard said

at 7:17 pm on Jul 1, 2009

Really nice job with your page. I was able to work my way through and get a Google docs survey on my Week 2 HW page. Thanks.

profile picture

Mr. Swan said

at 2:35 am on Jul 2, 2009

Google Form is great. If I remember correctly, the "summary" page with the results will "live update" as the data is collected. This creates a nice graph that changes with incoming responses. Kind of cool for developing "makeshift" learning response systems.

profile picture

Mrs. Sexton said

at 4:59 am on Jul 2, 2009

Thanks for the great summary. I will definitely be using Google survey. I've used Survey Monkey before; it is limited unless you pay. I love free!

profile picture

Mrs S said

at 7:51 am on Jul 2, 2009

Really liked the Google Doc spreadsheet. Never thought to use this. An easy way to collate data from many people. Thanks.

profile picture

Cynthia Coulter said

at 8:45 am on Jul 2, 2009

Is there instructions to create more than one question on a survey? Not sure how to have multiple questions on google docs spreadsheet.
Thank you!

profile picture

Terry Downs said

at 9:25 am on Jul 2, 2009

Thanks Bruce, your instructions helped a great deal. My question is how do I get the survery to show up in its full form? Right now it is partly visible with a scroll bar to move to the next questions. How do I get the whole survey to show up on the wiki page?

profile picture

nusa said

at 9:25 am on Jul 2, 2009

Since I joined the summer camp, I have been all excited and grateful at the same time as I have learnt so much, much more than in the whole previous year. I'm a little bit scared of surveys, but you've given a wonderful explanation. Thank you very much!

profile picture

Tapan Patel said

at 12:19 pm on Jul 2, 2009

wow. this seems like a pretty neat tool. i've been using a lot of google applications, but never got too into the spreadsheets - they didn't seem to have any application to what I was doing.

This changes that - I can see how these can be used to collect info from students on the course, for students to grade work, and maybe even to create brief quizzes that can be taken at home.

Thanks!

profile picture

burdick@... said

at 12:22 pm on Jul 2, 2009

I wasn't aware of this part of google docs. Thanks.

profile picture

Joan Vinall-Cox said

at 5:24 pm on Jul 2, 2009

Great demonstration. I'm going to use it. Thanks.

profile picture

Ken Steffen said

at 6:43 pm on Jul 2, 2009

This is a great new tool to learn about. I'm wondering if anyone has a method for revealing the updated graph to a user after they complete the survey?

profile picture

Lori Baker-Schena said

at 6:55 pm on Jul 2, 2009

I actually was able to make a graph and embed it! This is such a wonderful way to be exposed to Google Documents. Thanks so much for your terrific tutorial. This is absolutely awesome!

profile picture

Marcia Alessi said

at 9:51 am on Jul 3, 2009

Thanks, Bruce, you're a great teacher!

profile picture

stwine@... said

at 10:00 am on Jul 3, 2009

Great resources and tool to add to my "teacher tool box" Thank you

profile picture

Michael Novick said

at 12:34 pm on Jul 3, 2009

Unfortunately, as far as I know, LAUSD adult division students are out in the cold again. Do you know who I could talk to to get access my students at Abram Friedman Occupational Center?

profile picture

lindamc said

at 2:35 pm on Jul 3, 2009

I found the information on google docs very clear and I loved the idea of setting up a survey which allowed students to evaluate other students' work. I will be adding this to my use of the wiki -- and I think the kids will love it.

profile picture

Brodrick Hawn said

at 6:00 pm on Jul 3, 2009

Thanks for the tutorial, Bruce. I have several ideas I plan to implement. This technique certainly broadens the use of Google tools for the classroom.

profile picture

Claudio Fleury said

at 6:23 pm on Jul 3, 2009

This tutorial is really good! Thanks for sharing it. I hope to be able to use it in some of my EFL classes. You've given us great ideas.

profile picture

sealecollazo@... said

at 9:01 pm on Jul 3, 2009

Here's where my mind is going with this: I want to use surveys--I actually did the model as my week 2 homework--to get students to rate other students' online group projects. Now, at any time, that's going to involve 21 separate projects, each on its own page with its own survey form embedded. My question is, how is that going to work on the Google docs end? Would I be able to keep the 21 surveys separate from one another, say by giving each a page-specific title? Or would the Google spreadsheet put them all together? Thanks! This camp has my mind spinning--haven't had this kind of paradigm shift in my teaching in years!

profile picture

JVA said

at 12:07 am on Jul 4, 2009

Great tutorial! thanks

profile picture

sami said

at 7:11 am on Jul 5, 2009

Thanks for sharing

profile picture

Ms. Dixon said

at 9:48 am on Jul 6, 2009

Do you have to be logged in to see your survey results?

profile picture

Ms. Dixon said

at 9:59 am on Jul 6, 2009

Ummm, nevermind I answered my questions and realized the timestamps aren't in EST. Wow!

profile picture

Deborah said

at 9:53 pm on Jul 7, 2009

Google Docs once again leaves me speechless... the possibilities are endless. Thank you for sharing this wonderful instructional on surveys and spreadsheets.

profile picture

Larry Bowditch said

at 12:02 am on Jul 8, 2009

Thank you for sharing this information. It is very useful and is bringing to mind several surveys I can implement with this tool.

You don't have permission to comment on this page.