+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    reecec's Avatar
    Join Date
    Jul 2009
    Location
    Norfolk
    Posts
    13
    Thank Post
    4
    Thanked 3 Times in 3 Posts
    Rep Power
    11

    EXCEL - Recording survey details in excel - Easiest way

    Hi,
    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
    Thanks

  2. #2

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    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)

  3. Thanks to srochford from:

    reecec (28th April 2010)

  4. #3
    reecec's Avatar
    Join Date
    Jul 2009
    Location
    Norfolk
    Posts
    13
    Thank Post
    4
    Thanked 3 Times in 3 Posts
    Rep Power
    11
    Quote Originally Posted by srochford View Post
    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! 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.

    Thanks Again

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 22nd December 2009, 05:05 PM
  2. Help with Excel Chart
    By TechSupp in forum General Chat
    Replies: 3
    Last Post: 9th November 2009, 12:19 PM
  3. [MS Office - 2003] Excel - Read Only
    By rad in forum Office Software
    Replies: 3
    Last Post: 5th October 2009, 08:55 PM
  4. Excel
    By Edu-IT in forum How do you do....it?
    Replies: 13
    Last Post: 7th March 2008, 08:57 AM
  5. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •