3 Things You Didn’t Know Microsoft Forms Could Do

Post in Teq News by JessicaWenke on 10th November 2017

For those of you with an Education subscription to Microsoft 365, you may be familiar with Microsoft Forms and how easy it makes collecting surveys from your students. But like many of the products in 365, Forms is capable of much more. Here are 3 of our favorite ways to use Microsoft 365 to enhance our teaching.

Branching Logic

If a student is struggling to grasp two-digit division, the teacher will provide more instruction on that topic, whereas when a student who has mastered two digits will move on to three. In this case, the teacher is acting as the mechanism that changes what next step is needed for each student in response to their performance on certain tasks.

This type of logic can be used in a form. Using the same example, in a form, the first question could be a two digit division problem. If a student gets it right, then they advance to a more difficult problem set. If a student gets it wrong, then the rest of their form will provide them with more of the same problems for practice.

Microsoft Forms is capable of using this type of logic, which is called branching logic. To start using this in your forms, follow the following steps:

  1. In a completed form, click the ellipses button in the upper right-hand corner
  2. Select Branching
  3. On the page that appears there will be drop down menus that appear next to each answer under every question (each drop-down menu contains a list of all of the questions that follow)
  4. For each answer, select the question you want that answer to branch to

Export Results to Excel

Microsoft Forms works seamlessly with Microsoft Excel. When you choose the Responses tab in Forms, located under the status of the form, you will see an option to open results in Excel. When you click this a .csv file of all of your form results will be downloaded. Each response will be listed in its own row which makes data analysis easier. From here you can use powerful tools like pivot tables in Excel to analyze your data.

Create Quizzes

To create a quiz in Forms, simply select New Quiz from the Forms home page. Once selected, every choice, text, and ranking question created has an option to add a point value and select a correct answer. This makes do nows and quiz creation quick and easy!  

For more

For more great posts like this, visit our blog at http://www.teq.com/learning-community/teq-talk/, and for quick tips and tricks, visit our Teq Tips page at http://www.teq.com/learning-community/teq-tips/.

Leave a Reply