Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a survey and gathering the data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a survey and gathering the data
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, ... Maddie1020 wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a survey and gathering the data
Hi Maddie
Try this site http://officeupdate.microsoft.com/te...ry/default.asp You can do a search on that site. HTH John "Maddie1020" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a survey and gathering the data
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/2...s-survey-tool/ Good luck and let us know how it works Tom On 5 jun, 13:18, Maddie1020 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gathering data from worksheet | Excel Discussion (Misc queries) | |||
Creating a survey/quiz | Excel Discussion (Misc queries) | |||
Gathering Comments from Survey Data | Excel Worksheet Functions | |||
Gathering Survey data | Excel Discussion (Misc queries) | |||
gathering data | Excel Discussion (Misc queries) |