creating a survey and gathering the data

[Maddie1020]

Hi

I have been given a task to gather questionnaire data for a school, with 12
questions and 5 possible answers. I am likely to get hundreds of responses.

I have tried to set up a survey without much success and am wondering the
easiest way to do this. Is there a template I can download to help me?

Many thanks

Maddie

 

[Dave Peterson]

Maybe you can use this technique from Debra Dalgleish's site:
http://contextures.com/xlForm01.html

I'd add a name field to each of the rows. Then you could copy the Name,
question number, and response from each person's worksheet and create a giant
workshet with all the results for all the people.

Then you can do your sorts, filters, pivottables, charts, ...

 

[John]

Hi Maddie
Try this site
http://officeupdate.microsoft.com/templategallery/default.asp
You can do a search on that site.
HTH
John

 

[fake_be]

Hi Maddie,

I would suggest you make an excelsheet (with a lot of protections) and
let the users save it on a certain location (or send the excel via
mail to you). Once you have the hundreds of different excelfiles in a
same directory you can 'retrieve' all the information on the sheet
with a simple tool (excell add-in xla) named RDBMerge of Ron De Bruin
(www.rondebruin.nl/merge.htm). The tool is pretty much self-
explanory.

All the data will be retrieved in 1 sheet where you can start you
analyse from.

Another idea is to use googledocs more info via
http://www.rimmkaufman.com/rkgblog/2008/02/11/google-docs-survey-tool/

Good luck and let us know how it works
Tom