According to research analyst Ian Brace, a questionnaire is a “medium of communication,” between researcher and subjects. A questionnaire allows you to gather data to find patterns and trends. However, the data collected will only be as good as the questionnaire allows it to be. The acronym “GIGO,” meaning garbage in, garbage out, was coined to reflect this.
- Skill level:
- Moderately Easy
Things you need
- Word processing application
Follow Microsoft’s advice and plan your questionnaire, or survey, on paper first. The data collected from a well-designed survey is much easier to interrogate and is therefore more reliable. Think of clear and distinct questions and answers to avoid confusion in your results.
Use a word processing application to create your question sheet. Add the name of the survey and other details, if you wish, such as your name, today’s date and instructions. Enter your survey questions together with all the possible answers. Number the answers to make it easier to enter your results numerically later.
Print your sheets and hand them out to people included in the survey. Explain any questions, if necessary, on request. Give people as much time as they need to complete your questionnaire, unless the questionnaire is designed to test the response times of your subjects.
Run Excel when you have collected all the completed question sheets. In the first row, type field names. These are identifying labels relating to each question, such as: “Colour,” “Type,” and “Number.” In the columns below each field name, enter the numbers that relate to the answers given on your question sheets.
Select all the cells when you have inputted all the data. Click “Insert” then “Table.” Click “My table has headers.” Click OK. Excel will make a table of the data. Filter or sort the table by clicking the header row arrows.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for