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
  • 2048 views

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 :

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
O Microsoft Forms inclui informações ricas em tempo real
00:00:02
análises que fornecem um resumo da resposta
00:00:05
Informação e resultados individuais
00:00:07
para inquéritos por questionário e outros tipos de formulários.
00:00:10
Você pode exportar os resultados para a Microsoft
00:00:13
Excel para uma análise mais aprofundada,
00:00:15
bem como excluir ou imprimir
00:00:17
um resumo das respostas.
00:00:19
Para exibir informações de resumo da resposta
00:00:21
para o formulário, selecione a guia Respostas.
00:00:24
Na parte superior, você verá o resumo
00:00:26
dados de informação sobre os seus formulários,
00:00:28
tais como o número de respostas,
00:00:30
tempo médio necessário para os inquiridos.
00:00:33
Para preencher o seu formulário e o
00:00:35
status atual do formulário.
00:00:37
Se os usuários ativos ainda puderem responder,
00:00:39
selecione Ver Resultados para ver individualmente
00:00:42
detalhes para cada entrevistado.
00:00:44
Aqui pode encontrar o ID dos entrevistados,
00:00:47
nome, tempo de execução.
00:00:49
E um detalhamento das respostas.
00:00:52
Use as setas para a esquerda e para a direita
00:00:54
para alternar o resultado
00:00:56
detalhes de outras respostas.
00:00:57
Você também pode usar a lista suspensa para pular
00:01:00
aos resultados de um entrevistado específico.
00:01:03
Também pode procurar um indivíduo
00:01:06
resposta introduzindo o número,
00:01:08
por exemplo, 6,
00:01:09
no campo respondente, que é
00:01:11
associada a essa resposta.
00:01:12
Isto é especialmente útil quando
00:01:14
As respostas são recolhidas anonimamente.
00:01:17
Selecione mais opções para excluir todas as respostas,
00:01:20
imprimir um resumo das respostas ou criar
00:01:23
um link de resumo para compartilhar com outras pessoas.
00:01:27
Você pode facilmente ver todas as respostas
00:01:30
dados para o seu formulário no Microsoft Excel.
00:01:32
Basta selecionar Abrir no Excel para
00:01:35
capturar um instantâneo do seu atual
00:01:37
dados de resposta em uma pasta de trabalho.
00:01:40
Pode ver mais detalhes
00:01:42
para cada pergunta.
00:01:43
Ao lado de cada pergunta, você verá
00:01:46
o número de respostas e um gráfico
00:01:49
Isso mostra um detalhamento das respostas.
00:01:52
Para se concentrar em uma única pergunta,
00:01:54
basta selecionar o link mais detalhado
00:01:56
em Perguntas individuais para ver
00:01:58
o nome de cada inquirido e os seus
00:02:00
resposta a essa pergunta em particular.
00:02:02
Se o seu formulário ou questionário contiver
00:02:04
um campo de upload de arquivo,
00:02:06
verá o número de respostas
00:02:09
e o resumo da apresentação
00:02:11
quando clica em Mais Detalhes.
00:02:13
Pode ver todas as respostas
00:02:16
para esta pergunta específica.
00:02:17
Clique em Link para abrir qualquer documento
00:02:19
ou veja todos os documentos de recebimento em
00:02:21
o OneDrive criado automaticamente
00:02:23
para o seu formulário.
00:02:25
Os documentos são renomeados,
00:02:26
incluindo o nome do requerido
00:02:28
como mostra esta coluna.
00:02:30
Tenha em atenção que, se eliminar a seringa
00:02:32
respostas ao questionário,
00:02:33
os documentos não são apagados
00:02:35
da pasta OneDrive.
00:02:37
Agora você já sabe como verificar
00:02:39
e partilhe os resultados do seu formulário.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

2749 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

Reminder

Show

/

Join Live Training Session