Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Computers for Beginners (https://www.askmehelpdesk.com/forumdisplay.php?f=79)
-   -   How do I compile a survey? (https://www.askmehelpdesk.com/showthread.php?t=742601)

  • Apr 4, 2013, 09:32 AM
    TommyTrip
    How do I compile a survey?
    I want to do a small survey to parents of a basketball league. I thought I would send it out as and email using excel. The way I formatted it was as follows:

    Rate the following from needs improvement to excellent; on a scale from 1 to 4.
    Please use drop down box in each category below with 1 being needs improvement and 4 being
    Excellent. ( If it does not apply leave blank)
    With questions lYour child's grade level?
    Ease at Sign Ups
    Cost
    Uniforms
    League age structure
    Basketball Instruction
    Coaches knowledge
    Duration of game
    Duration of practice
    Playing time
    Child's improvement
    Schedule
    Communication
    Supervision
    Game officials
    Scorekeepers
    Web-site

    I have nio idea if I can consolidate the info when they email it back to me. Is there an easy way to do this?
  • Apr 4, 2013, 10:34 AM
    ScottGem
    Do you have Microsoft Access?
  • Apr 5, 2013, 03:15 AM
    TommyTrip
    Yes, but I'm really not firmiliar, with it.
  • Apr 5, 2013, 03:17 AM
    ScottGem
    Well this would be best done in Access. A survey is a specific type of database. Are the questions set up in a column with the question in column A and the answers in column B?
  • Apr 5, 2013, 03:25 AM
    TommyTrip
    Quote:

    Originally Posted by ScottGem View Post
    Well this would be best done in Access. A survey is a specific type of database. Are the questions set up in a column with the question in column A and the answers in column B?

    Yes, about 15 basic questions in column A and a drop down 1-4 in column B. I was checking in excel for consolidation & pivot tables. Maybe I'll pick up a Access for dummies. It looks like that is the way to go, I just didn't feel like tackling it.

    Thanks Tom
  • Apr 5, 2013, 03:32 AM
    ScottGem
    I can help there. If all the work sheets are the same, this won't be too difficult. How many surveys did you send out. Is there anything in the sheet that identifies the parent the survey was sent to?
  • Apr 5, 2013, 04:42 AM
    TommyTrip
    1 Attachment(s)
    Quote:

    Originally Posted by ScottGem View Post
    I can help there. If all the work sheets are the same, this won't be too difficult. How many surveys did you send out. Is there anything in the sheet that identifies the parent the survey was sent to?

    Scott,

    I haven't sent any out. I wanted to get everything in place 1st. I will attach what I have maybe this will help.
  • Apr 5, 2013, 05:07 AM
    TommyTrip
    Scott,

    Sorry I do have Access, but hardly use it.
  • Apr 5, 2013, 05:09 AM
    ScottGem
    Quote:

    Originally Posted by TommyTrip View Post
    Scott,

    I haven't sent any out. I wanted to get everything in place 1st. I will attach what I have maybe this will help.


    OK, One more question, will the survey be anonymous or will the parents identify their response.

    If you can give me over the weekend I can work something up for you.
  • Apr 5, 2013, 06:14 AM
    TommyTrip
    Scott,

    I was thinking of putting Players Name (Optional): & Parents Name (Optional):

    Wow, that would be great, thank you for your help.

    Tom
  • Apr 5, 2013, 06:55 AM
    NeedKarma
    You could look into online services such as SurveyMonkey: Free online survey software & questionnaire tool
  • Apr 5, 2013, 06:55 AM
    ScottGem
    Quote:

    Originally Posted by TommyTrip View Post
    Scott,

    I was thinking of putting Players Name (Optional): & Parents Name (Optional):

    Wow, that would be great, thank you for your help.

    Tom

    Ok, so the surveys could be anonymous. I can deal with that.
  • Apr 9, 2013, 06:56 AM
    TommyTrip
    Quote:

    Originally Posted by ScottGem View Post
    Ok, so the surveys could be anonymous. I can deal with that.

    Scott,

    Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?
  • Apr 9, 2013, 12:14 PM
    ScottGem
    Quote:

    Originally Posted by TommyTrip View Post
    Scott,

    Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?

    I'm sorry, I got distracted. I'll do something before the end of the week.
  • Apr 11, 2013, 03:26 AM
    ScottGem
    Quote:

    Originally Posted by TommyTrip View Post
    Scott,

    Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?

    Yes, in terms of collecting the data, Survey Monkey is certainly a good idea. If you want to go that route, you would have to see how survey Monky provide the data to you to see where you go from there.
  • Apr 12, 2013, 10:58 AM
    InfoJunkie4Life
    2 Attachment(s)
    I have a potential alternative answer.

    Attached are two files. The text.xls contains a macro that opens a new workbook and imports any *.xls file from c:\CSV as separate sheets. It also contains a template for consolidating via average the cells from other sheets if you were to copy it into the new workbook.

    The trick is the average will not work unless the survey matches the template, so included is a template survey based off the file you had originally provided. The other important thing to remember is the macro only merges xls files within the c:\CSV\ directory, none others.

    The steps to use these would be as following...
    Distribute "Survey1.xls" and gather results.
    Give each a new name (If you have a lot try something like the bulk rename utility)
    Put them all in the c:\csv directory
    open test.xls and run the Loop macro.
    In the new workbook that appears, go to sheet 1
    Copy into it the data from test.xls
    Change the =Average(SheetA:SheetB!C14) to the corresponding:
    Average is the function, SheetA is the Left most sheet, SheetB is the right most sheet you want included. C14 is the cell in all the selected sheets that will be averaged.

    This would avoid using access and realistically probably could more easily be accomplished in Access as ScottGem has suggested. But this is how I would do it.

  • All times are GMT -7. The time now is 01:25 AM.