 |
|
|
 |
New Member
|
|
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?
|
|
 |
Computer Expert and Renaissance Man
|
|
Apr 4, 2013, 10:34 AM
|
|
Do you have Microsoft Access?
|
|
 |
New Member
|
|
Apr 5, 2013, 03:15 AM
|
|
Yes, but I'm really not firmiliar, with it.
|
|
 |
Computer Expert and Renaissance Man
|
|
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?
|
|
 |
New Member
|
|
Apr 5, 2013, 03:25 AM
|
|
 Originally Posted by 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?
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
|
|
 |
Computer Expert and Renaissance Man
|
|
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?
|
|
 |
New Member
|
|
Apr 5, 2013, 04:42 AM
|
|
 Originally Posted by 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?
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.
|
|
 |
New Member
|
|
Apr 5, 2013, 05:07 AM
|
|
Scott,
Sorry I do have Access, but hardly use it.
|
|
 |
Computer Expert and Renaissance Man
|
|
Apr 5, 2013, 05:09 AM
|
|
 Originally Posted by TommyTrip
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.
|
|
 |
New Member
|
|
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
|
|
 |
Uber Member
|
|
Apr 5, 2013, 06:55 AM
|
|
|
|
 |
Computer Expert and Renaissance Man
|
|
Apr 5, 2013, 06:55 AM
|
|
 Originally Posted by TommyTrip
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.
|
|
 |
New Member
|
|
Apr 9, 2013, 06:56 AM
|
|
 Originally Posted by ScottGem
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?
|
|
 |
Computer Expert and Renaissance Man
|
|
Apr 9, 2013, 12:14 PM
|
|
 Originally Posted by TommyTrip
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.
|
|
 |
Computer Expert and Renaissance Man
|
|
Apr 11, 2013, 03:26 AM
|
|
 Originally Posted by TommyTrip
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.
|
|
 |
Ultra Member
|
|
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.
|
|
Question Tools |
Search this Question |
|
|
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
|