Forms - Check and share your form results Tutorial

In this video, you will learn how to check and share your form results using Microsoft Forms.
The video covers the process of accessing response summary information, exporting results to Microsoft Excel, and managing individual responses.
This will help you analyze your form data more effectively and share it with others.

2:42
2634 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive overview of how to utilize Microsoft Forms for analyzing survey responses, including accessing summary information, exporting data to Excel, and managing individual responses.

Chapitres :

Introduction to Microsoft Forms Analytics
Microsoft Forms offers robust real-time analytics that allow users to gather and analyze response data from surveys and various forms. This functionality is essential for understanding participant feedback and improving future surveys.
Accessing Response Summary Information
To view the summary information for your form, navigate to the Responses tab. Here, you will find key metrics such as: - Total number of responses - Average completion time - Current status of the form (active or closed) This data provides a quick overview of how your form is performing.
Viewing Individual Responses
For a detailed look at individual responses, select 'View Results.' This section displays: - Respondent ID - Respondent name - Execution time - Breakdown of responses You can navigate through different responses using the left and right arrows or jump to a specific respondent using the dropdown list. Additionally, you can search for a specific response by entering the respondent number.
Managing Responses
In the Responses tab, you have several options to manage your data: - Delete all responses - Print a summary of responses - Create a summary link to share with others These options help streamline the management of your survey data.
Exporting Data to Microsoft Excel
To conduct a more in-depth analysis, you can export your response data to Microsoft Excel. Simply select 'Open in Excel' to capture a snapshot of your current response data in a workbook. In Excel, you can view: - Number of responses for each question - Charts that illustrate response breakdowns For a focused analysis on a single question, click the more detailed link under Individual questions to see each respondent's answers.
Handling File Uploads
If your form includes a file upload field, you can view the number of submissions and a summary by clicking on 'More Details.' This section allows you to access all responses related to that specific question. Additionally, you can click the link to open any uploaded documents or view all receipt documents in the automatically created OneDrive folder for your form. The documents are renamed to include the respondent's name, ensuring easy identification.
Conclusion
In summary, Microsoft Forms provides a comprehensive suite of tools for analyzing and managing survey responses. By utilizing the analytics features, exporting data to Excel, and effectively managing individual responses, users can gain valuable insights and enhance their data collection processes.

FAQ :

What is Microsoft Forms used for?

Microsoft Forms is used to create surveys, quizzes, and polls, allowing users to collect and analyze responses in real-time.

How can I view the summary of responses in Microsoft Forms?

To view the summary of responses, select the 'Responses' tab in your form. This will display metrics such as the number of responses and average completion time.

Can I export my form responses to Excel?

Yes, you can export your form responses to Microsoft Excel by selecting 'Open in Excel' to capture a snapshot of your current response data.

How do I delete responses in Microsoft Forms?

To delete responses, select 'More options' in the Responses tab and choose the option to delete all responses.

What should I do if I want to view individual responses?

Select 'View Results' in the Responses tab to see individual details for each respondent, including their ID, name, and execution time.

How can I share my form results with others?

You can create a summary link to share with others by selecting 'More options' and then choosing the option to create a summary link.

Quelques cas d'usages :

Conducting Employee Satisfaction Surveys

HR departments can use Microsoft Forms to create employee satisfaction surveys, collect responses, and analyze the data to improve workplace conditions. By exporting the results to Excel, HR can identify trends and areas for improvement.

Collecting Feedback for Events

Event organizers can use Microsoft Forms to gather feedback from attendees after an event. The real-time analytics feature allows them to quickly assess the success of the event and make necessary adjustments for future events.

Educational Quizzes and Assessments

Teachers can create quizzes using Microsoft Forms to assess student understanding. The ability to view individual responses helps educators provide targeted feedback and support to students based on their performance.

Market Research Surveys

Marketing teams can utilize Microsoft Forms to conduct market research surveys. By analyzing the collected data, they can gain insights into customer preferences and behaviors, which can inform product development and marketing strategies.

Event Registration Forms

Organizations can create registration forms for events using Microsoft Forms. The collected data can be exported to Excel for tracking attendance and managing event logistics efficiently.

Glossaire :

Microsoft Forms

A web-based application that allows users to create surveys, quizzes, and polls, and collect responses in real-time.

Real-time analytics

The ability to analyze data as it is collected, providing immediate insights into responses and trends.

Response summary

A consolidated view of the data collected from respondents, including metrics such as the number of responses and average completion time.

Export

The process of transferring data from Microsoft Forms to another application, such as Microsoft Excel, for further analysis.

Respondent

An individual who answers questions in a survey or form.

ID

A unique identifier assigned to each respondent for tracking their responses.

OneDrive

A cloud storage service from Microsoft that allows users to store files and access them from any device.

Upload file field

A type of question in a form that allows respondents to submit files as part of their response.

00:00:00

Microsoft Forms includes rich real time

00:00:02

analytics that provide response summary

00:00:05

information and individual results

00:00:07

for surveys and other types of forms.

00:00:10

You can export the results to Microsoft

00:00:13

Excel for more in-depth analysis,

00:00:15

as well as delete or print

00:00:17

a summary of responses.

00:00:19

To view response summary information

00:00:21

for your form, select the Responses tab.

00:00:24

Across the top, you'll see summary

00:00:26

information data about your forms,

00:00:28

such as number of responses,

00:00:30

average time it took for respondents.

00:00:33

To complete your form and the

00:00:35

form's current status.

00:00:37

If active users can still respond,

00:00:39

select View Results to see individual

00:00:42

details for each respondent.

00:00:44

Here you can find the respondents ID,

00:00:47

name, execution time.

00:00:49

And a breakdown of the responses.

00:00:52

Use the left and right arrows

00:00:54

to toggle through the result

00:00:56

details of other responses.

00:00:57

You can also use the dropdown list to jump

00:01:00

to the results of a specific respondent.

00:01:03

You can also search for an individual

00:01:06

response by entering the number,

00:01:08

for instance, 6,

00:01:09

in the respondent field that's

00:01:11

associated with that response.

00:01:12

This is especially helpful when

00:01:14

responses are collected anonymously.

00:01:17

Select more options to delete all responses,

00:01:20

print a summary of responses, or create

00:01:23

a summary link to share with others.

00:01:27

You can easily view all the response

00:01:30

data for your form in Microsoft Excel.

00:01:32

Just select Open in Excel to

00:01:35

capture a snapshot of your current

00:01:37

response data in a workbook.

00:01:40

You can further view details

00:01:42

for each question.

00:01:43

Next to each question you'll see

00:01:46

the number of responses and a chart

00:01:49

that shows a breakdown of responses.

00:01:52

To focus on a single question,

00:01:54

just select the more detailed link

00:01:56

under Individual questions to see

00:01:58

the name of each respondent and their

00:02:00

answer for that particular question.

00:02:02

If your form or quiz contains

00:02:04

an upload file field,

00:02:06

you will see the number of responses

00:02:09

and the submission summary

00:02:11

when you click on More Details.

00:02:13

You can view all responses

00:02:16

for this specific question.

00:02:17

Click Link to open any document

00:02:19

or view all receipt documents in

00:02:21

the automatically created OneDrive

00:02:23

folder for your form.

00:02:25

Documents are renamed,

00:02:26

including the name of the respondent

00:02:28

as shown in this column.

00:02:30

Note that if you delete the

00:02:32

questionnaire responses,

00:02:33

the documents are not deleted

00:02:35

from the OneDrive folder.

00:02:37

Now you know how to check

00:02:39

and share your form results.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

3576 Views

Microsoft Forms Video Training - Using the survey and questionnaire tool

From any web browser, guests have access to the form, even from a mobile device. Built-in and exportable analysis features ensure more in-de...

ALL COURSES