forms

July 16, 2016

How to Use Microsoft Forms in Office 365 Education

How to Use the New Microsoft Forms

Have you seen the new Microsoft Forms? One of the most popular articles on my blog in the last 12 months was related to its predecessor – Excel Surveys. Not only did that post get a lot of views, but it also got a lot of comments from people with questions about the features of Excel Surveys, or more importantly for some, the features it did not have. You can still use Excel Surveys, but Microsoft are in the process of transitioning to something better – Microsoft Forms. This version includes automatic grading and built-in student feedback. Here’s what you need to know.

Getting Started

You can find the homepage for Microsoft Forms by going to forms.office.com, or you may see Forms listed in the Office 365 App Launcher. Both links go to the same place. Technically, Forms is still in Preview but you can sign in with your Office 365 Education account today and start creating surveys and quizzes. The new Microsoft Forms work on desktop and mobile browsers.

Once you are logged in, click the New button to create your first form. Replace Untitled Form with a title of your choice, and add a description underneath if you want to provide any directions or information for students or parents who are filling out your Form.

Building a Form

Tapping the Add Question button gives you access to the question types that are available to you in this new version of Microsoft Forms. The options include:

  1. Choice: for creating multiple choice questions! Tap or click the slider to allow people to select multiple answers. You can also tap or click the ellipses button to shuffle answers.
  2. Quiz: a multiple choice question that you allows you to select a correct answer for automatic grading. Tapping the comment icon on each answer choice lets you add student feedback for each selection. Multiple answers and shuffled answers are also available to you when working on Quiz questions.
  3. Text: to collect short (or long) text answers use the Text question type. Tap or click the ellipses button to include number restrictions like greater than, less than, equal to, and more.
  4. Rating: for adding a star or number rating. Could be useful as part of an exit ticket or for voting on class favorites. Ratings can be out of 5 or 10, and tapping the ellipses button will allow you to add a label at either end of this Likert scale.
  5. Date: a question type that only allows for an answer in date format.

Microsoft Forms Question Builder Continue Reading

August 10, 2014

How to Collect Data with an Excel Survey & Office 365 Education

How to Use Excel Surveys

Google Apps for Education schools have Google Forms for surveying staff and quizzing students, but you needn’t feel left out if you are using Microsoft’s Office 365. An Excel Survey does very much the same thing, and it’s easy to set up. You can even do it with a free, individual OneDrive account if your school does not use Office 365. Here’s what you need to know.

Note: An updated version of Excel Surveys – Microsoft Forms – is now available for schools who subscribe to Office 365 Education. See my blog post How to Use Microsoft Forms for more information.

Excel surveys are created online. So, you first need to log in to your OneDrive for Business account and click “new”. Select “Excel survey”, then give your document a name and click “OK”.

create excel survey

On the next screen you can enter a title for your survey and a short description or introduction for those that are filling out your survey. You can then click on the box that says to “Enter your first question here”. This opens a pop up box that gives you more options to do just that. So, enter your question, a question subtitle/help text (optional), and choose the type of question you want to ask. There are currently seven types of questions:

Continue Reading