ALWAYS use separate columns. I've been bit in the a$$ just about every
time
I tried the comma-delim list approach.
Another plus is it's really easy to return an Excel file directly to
those
doing the tabulating - which they seem to like - without bugging me for the
"latest results" 3 times a day.
-----Original Message-----
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 01, 2006 9:14 PM
To: CF-Talk
Subject: Best Approach for Survey Question
I am trying to determine the best way to structure a series of survey
questions, keeping in mind that I need to make it easy to use for the
respondent, easy to code, and easy to tabulate the data later on.
I can structure the following typical question as a single set of
checkboxes:
Q5: Please select schools that provide interns (check all that apply): [ ]
Sciences [ ] Management/Business [ ] Law [ ] Communications [ ] Other
Using a single datafield for the question, I then would need to parse a
comma-delimited list to separated the answers.
- or - I can use a series of radio buttons:
Q5:Please select schools that provide interns (check all that apply):
A. Sciences [ ]
B. Management/Business [ ]
C. Law [ ]
D. Communications [ ]
E. Other [ ]
If I use a separate data field (5 in this case) for each sub-part of the
question, then it is easy to tabulate results for each part.
Recommendations appreciated.
Richard Colman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228132
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
