It is not uncommon that you need to ask family members or friends when organizing a party, that you want to create a quiz for your students, or that the ” we want to conduct a survey of visitors to our website or Blog. With Office 365, such surveys or quizzes can be carried out very simply, with a few clicks, and then be published online instantly. The results are then directly integrated into an Excel table that you can filter and analyze and on which you can perform all kinds of statistics.
A / Access the online questionnaires
To access the online questionnaire creation wizard as quickly as possible, log in to your SkyDrive drive using the Microsoft ID in your Office 365 account. Expand the menu Create and select ” Excel survey “
Enter the name of your future questionnaire, or more exactly the name of the Excel file that will host the results. Click on Create. The wizard for creating the questionnaire will then start in Excel Web App.
B / Define the title of the questionnaire
The very first step of this wizard is to enter a survey title by clicking on the line ” Please enter a title for your survey “, As well as a description presenting the objective of the questionnaire by clicking on the line” Please enter a description for your survey here “
C / Create a question
Then click on ” Please enter your first question ” An input bubble appears on the screen which will allow you to enter the label and define the type of expected response.
Start by entering the question by filling in the field Question, then enter additional information using the ” Question subtitle “
Then use the menu ” Response type To specify whether the user should enter free text (Text or paragraph text option), enter a number or amount (Number option), enter time information (Date or Time option), answer with Yes or No (option Yes / No) or choose from a list of predetermined answers (Choice option). Most often, we will select the option ” Choice “
Then edit the field Choice, by entering a possible answer per line (use the combination SHIFT + ENTER to go to the line). Do not forget to specify if this question is mandatory (check the box Necessary) or optional (leave the box unchecked). It is also possible to specify a default response. Click on Finish to validate the question.
D / Add identity fields
The survey can include an almost unlimited number of questions. To make your study easier to use, do not forget to add questions allowing the user to enter his Last name and First name as well as his email address for example. You can also ask him to specify his age.
E / Publish the survey
All that remains is to publish the survey. Click on Share the survey. This operation triggers the saving of your questions, the preparation of the XLS answer file and the appearance of a link creation window.
Click on Create. A share link is then generated. This link is complex and long, think of creating on the button Shorten to make it easier to share an abridged version. Right-click and select To copy. Then click on Finish.
F / What users will see on the screen
It only remains to distribute your survey using the link generated and copied in the previous step. You are free to choose the means of propagation. You can, for example, email this link to contacts, post it on your Facebook wall or Twitter feed, or place this link on your Blog or personal site. When a user clicks the published link, the questionnaire will automatically appear in their web browser.
G / Results saved in the form of an Excel table
The survey results are automatically grouped together in an Excel file. Obviously it is possible to open this document directly from a web browser via SkyDrive and Excel Web App. This allows in particular to edit the survey and to correct or complete the questions using the menu Investigation.
But it is even more interesting to take advantage of all the richness of your Office 365 subscription by loading the results file in Excel 2013. You can then use the numerous filtering and statistics functions to analyze the answers effectively or generate talking charts.