How to use e-mail as a questionnaire

First, determine the purpose of the investigation, determine what you want to know, and make a questionnaire to refine the purpose of the investigation as much as possible to prevent it from turning into a question. Second, identify the respondents, collect their emails and email addresses, organize them with EXCEL forms, and import them into foxmail or outlook address book for later use. Third, design the questionnaire according to the detailed purpose of the survey, and try to design it as a multiple-choice question, but the alternative plan should not mislead the respondents as much as possible. Try to use the questionnaire in word format. To express a question in three columns, only three columns are needed: numbers, questions and answers. The main purpose of using tables to express questions is to make the questions and answers clear at a glance, and it is also convenient to copy the answers to EXCEL tables when sorting out questionnaires. Fourthly, the trial questionnaire is based on 5% of the collected emails, and the designed questions are re-improved according to the answers of the recycled questionnaire, including the unclear questions and improvement options. 5. Official distribution of questionnaires Use the mass distribution function of foxmail or outlook to distribute questionnaires. Sixth, when collecting questionnaires, record the information (number and email address) of each questionnaire and name the file name of the questionnaire with the number. Seven, send the questionnaire for the second time because the questionnaire may be overwhelmed by too many emails from the respondents or because the vacation is not processed, so it needs to be sent for the second time. Three weeks after sending the questionnaire for the first time, the email with information recorded in the questionnaire will be deleted from the mailing list of the respondents, and the questionnaire will be sent again as the mailing list for the second time, and the subject of the email should be marked "XXXX questionnaire (second sending)". Eight, recycle the questionnaire again, recycle the questionnaire again and record the recycling information. If the recovery is still unsatisfactory, you can send a questionnaire for the third time. Nine, sort out the questionnaire. Use excel to organize questionnaire answers into worksheets. X. Statistical Analysis For multiple-choice questions, you can directly import excel tables into the sql server database, write a few sql statements to get statistical data, and then draw a pie chart or histogram. For open questions, we should sum up one by one, sum up several answers to the questions, and then explain what the questions are.