Responses in Office Forms

Standard

Yesterday I posted about my first experience of Office Forms and attached a form at the bottom for users to play with to answer my questions.  The form had three questions which were three different types of question types available which include Choice (used multiple choice), Text and Rating and I wanted to share the results so you could see what it looked like.  I spent the day watch the numbers grow and it also changes as more answers came through.  So thank you to the 32 who responded even though many of you may know nothing about the English Premier League and Aston Villa.

1

The first question was multiple choice but I also left in an option for you to fill in your own.  People filled in the normal 4 answers but there were 5 other options added.  These 5 were added but not available to others to see.

The results first started as a pie chart but once we had 6 different types of answers it moved to being the bar chart.

Next to each question you can see a two way arrow in the top right.  When selecting this you get a table of answers.  Of course lots of these are anonymous but if the user is logged in, you can see who said this from their Azure AD display name.

2

The second question was free text but did not have a requirement around it (where you needed to answer the question).  From the 21 people who did answer, on the home page (the first image of this post) you can see the last 3 responses but again when selecting the arrows you can see all answers.

3

The final question was a rating (and thanks to those who rated Aston Villas season as a 2.68 our of 5 as I feel it was a lot worse than that).  By selecting the arrows you can see each users response.

4

I mentioned yesterday that you could download a Excel spreadsheet of all the answers.  I still wish there was an option which asked if you would like to send it to your OneDrive for Business but just being able to get it in Excel is great.

In here we can see each of the users responses, time and who they were (with their User Principal Name as well as their Display Name).  The spreadsheet is already formatted with a table and easy to navigate.  The multiple choice question has each of their answers in the single cell while the others have their answers as well.

The spreadsheet is a lot better to see who answered what across the form.  When selecting the arrows in the browser you can’t easily navigate to see what the user gave across all their answer so this spreadsheet does help with that.  Just to take this data and add it to PowerBI now.

5

First look at Office Forms for Office 365

Standard

It caught me by surprise when Microsoft announced Office Forms in Office 365 Education as Microsoft have announced that only Education customers would get access to a preview.  With InfoPath forms now in extended support and no new solution from Microsoft, something like Office Forms was hoped to take your company forms to the next level.

Microsoft announced Office Forms would come to Office 365 Education customers first, so I jumped onto the my education test tenant and requested access.  Heard nothing back but found the URL from a recent blog post and decide to take a look and there we go, we have Office Forms.

1

So there a few things to note from my first experience with this preview and these are mainly around the Forms you can build.

I’ve logged in with my organisation ID and the solution has its only app launcher style (not the Office 365 one).  At any time if I click on the Office logo/Forms in the top left, it takes me back to the landing page at the top.  Selecting the top three dots in the top right gives me chance to give Feedback, get help, navigate to my Office 365 Account Profile and sign out.

It’s very much has a bit of a Sway look and feel to the site with the rectangle box for each Form.

2

When selecting New it very quickly takes you to a new form which I see this mainly as just a quizzing tool.  So for all you budding InfoPath specialist or SharePoint people expecting this to be the replacement, it not (well at least not at the moment).  It’s not asked me to create anything in SharePoint, asked for a relation with a Office 365 Group nor have I found anything that has changed in my Office 365 tenant so I believe this is a stand alone product.

Creating a Quiz

Having selected a new form, I can then start to create my quiz.  I can easily give it a name and a subtitle and then start to add my quiz questions.

3

We have three types of questions we can ask which include Choice, Text and Rating.

4

Choice really is what we expect with an easily to fill out question and options feature.  By default we have 2 answer options but can easily add more as well as an Other option allowing the user filling out the quiz to give their own answer.

We can also set allow multiple answers and set whether this question has to be answered (Answer Required).  We also have the ability to add a subtitle to the question should we want to give more context.

5

A Text question allows you add a question and for the user to have free text for either a short or long length answer.

6

With the Ratings question you can ask the user to give something either out of 5 or 10.  They can select their answer either as a number or a star.

7

Sharing my Quiz

Once we have finished our quiz we don’t need to worry about saving as it has done this throughout the use of the webapp.  At the top, we can now Preview and Share the form.  We can preview it for both a computer view (your current view) or by selecting Mobile, see what it would look like in this state.

8

You can share it as a URL, sending an email, it will provide you with a QR Tag or get a set of embed code.  You can also state at this point if users have to log in access the question and if they are allowed to answer the whole quiz multiple times.

9

At the bottom of that fly out, you will see ‘More share settings’.  There are some great features here allowing you to apply a deadline and also for questions to be shuffled when loading allowing you to use this as a great classroom quiz.

Responses

The Responses tab gives you a great visual look at how people have answered with graphs, responses and the average score in a rating.

10

There is also a Open in Excel which will download the quiz to your PC – I’m hoping this will be replaced with a Save to OneDrive option soon.

What to see my quiz, take a look at the bottom.