Ask Experts Questions for FREE Help !
Ask
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #1

    Apr 4, 2013, 09:32 AM
    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?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Apr 4, 2013, 10:34 AM
    Do you have Microsoft Access?
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #3

    Apr 5, 2013, 03:15 AM
    Yes, but I'm really not firmiliar, with it.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Apr 5, 2013, 03:17 AM
    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?
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #5

    Apr 5, 2013, 03:25 AM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #6

    Apr 5, 2013, 03:32 AM
    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?
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #7

    Apr 5, 2013, 04:42 AM
    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.
    Attached Files
  1. File Type: xls Survey1.xls (23.5 KB, 127 views)
  2. TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #8

    Apr 5, 2013, 05:07 AM
    Scott,

    Sorry I do have Access, but hardly use it.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #9

    Apr 5, 2013, 05:09 AM
    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.
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #10

    Apr 5, 2013, 06:14 AM
    Scott,

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

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

    Tom
    NeedKarma's Avatar
    NeedKarma Posts: 10,635, Reputation: 1706
    Uber Member
     
    #11

    Apr 5, 2013, 06:55 AM
    You could look into online services such as SurveyMonkey: Free online survey software & questionnaire tool
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #12

    Apr 5, 2013, 06:55 AM
    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.
    TommyTrip's Avatar
    TommyTrip Posts: 22, Reputation: 1
    New Member
     
    #13

    Apr 9, 2013, 06:56 AM
    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?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #14

    Apr 9, 2013, 12:14 PM
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #15

    Apr 11, 2013, 03:26 AM
    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.
    InfoJunkie4Life's Avatar
    InfoJunkie4Life Posts: 1,409, Reputation: 81
    Ultra Member
     
    #16

    Apr 12, 2013, 10:58 AM
    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.
    Attached Files
  3. File Type: xls Test.xls (32.5 KB, 124 views)
  4. File Type: xls Survey1.xls (29.0 KB, 135 views)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to compile an anthology [ 4 Answers ]

I have a growing number of poems I have written. And I feel I can present to the world a pretty good compilation. Can someone help me as to how to go about the process of putting one together?

Excel 2003 - Compile Error - Invalid Outside Procedure [ 2 Answers ]

Please Help! This is my first attempt at setting up a Macro in Excel 2003 and all I want to do is print out 8 worksheet pages with a macro. The first message I get says: "Unable to Record" Then I click on "OK" and it records the key strokes anyway! However, when I try to run it, I end up...

Compile error with excel 2007 [ 2 Answers ]

I have written a very basic Macros code to retrieve a photo off my server. I want it to run this macro when a person has selected a certain item off a drop down list. The problem I am having is that when I try and run the macro manually or when the workbook opens I get a an error message that...


View more questions Search