If you are a Bates student, faculty or staff member, you may use this method to create an online questionnaire without learning any HTML. (Even if you know HTML, this method will probably be easier and faster.) Using this procedure, you can create a website which allows others to respond to your questions. The answers to these questions will be stored in a text data file which can then be imported into Excel or SPSS for analysis.
I have created an Excel spreadsheet which automates the steps for creating a customized questionnaire. You choose what text should be associated with a given question and choose from a variety of question formats (multiple choice, short answer, essay, Likert scales, etc.) Once you have defined all of the questions of your questionnaire, as well as a few other options, the spreadsheet will generate a series of webpages that you can post online. The following instructions will walk you through the process step-by-step.
NOTE: This spreadsheet has been tested only on Windows. Many people have used the Mac version of Excel successfully for the entire procedure. However, if you have spreadsheet troubles not addressed by this webpage and you are using a Mac, please try a Windows PC. (The most likely step for Mac-related problems is Step 9 when clicking on the Generate button.) The final questionnaire will work with any operating system.
If you like, you may download the entire text of this website in a PDF file for easy printing.
LATEST SPREADSHEET VERSION: 2.21. (Check the Basic Settings tab for version number.)
| On to Step 1 |