Office Software Thread, EXCEL - Recording survey details in excel - Easiest way in Technical; Hi,
I have got the job of creating a spreadsheet to record about 1,600 survey results. I am trying to ...
28th April 2010, 08:29 PM #1
EXCEL - Recording survey details in excel - Easiest way
I have got the job of creating a spreadsheet to record about 1,600 survey results. I am trying to think of the easiest way to record them. The survey has open and closed questions. So i was thinking if its possible to create a macro that would add one to the total each time it is clicked like a tally but have no clue for the open questions.
Any help appreciated
28th April 2010, 08:44 PM #2
I think I'd use Access rather than Excel (actually, I'd rather use a web based form and SQL server. It's a bit harder to set up but it's much easier to have multiple people entering data - you can even collect directly rather than doing paper forms and rekeying)
You don't need to worry about adding up the totals as you go - even if you use Excel you just have a set of COUNT or COUNTIF statements (eg if Q1 can have answers 1,2 or 3 then somehwhere you'd have a COUNTIF for each of the possible values and it will just increment each time you enter 1,2 or 3)
Access needs a little bit more work - you probably want to make a form to collect the data - but you've got much better reporting facilities. I assume what you're doing is asking questions like "what do you think of the canteen?" and you'll get back free-text answers. There's very little you can do with these apart from list responses (and this is where you really need to get your survey design right - if you have too many questions like this you get nothing out of the survey because it's just too much effort to correlate all the responses)
Thanks to srochford from:
28th April 2010, 09:16 PM #3
Thanks! That is how I would have done it but the data has been collected manually on paper. So all the data has got to be entered into it. And I think I might give access a go.
Originally Posted by srochford
By DaveP in forum Downloads
Last Post: 22nd December 2009, 06:05 PM
By TechSupp in forum General Chat
Last Post: 9th November 2009, 01:19 PM
By rad in forum Office Software
Last Post: 5th October 2009, 09:55 PM
By Edu-IT in forum How do you do....it?
Last Post: 7th March 2008, 09:57 AM
By wesleyw in forum Windows
Last Post: 22nd June 2007, 04:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)