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
  • 2369 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 !

 

résultat(s)
00:00:00
Microsoft Forms include funzionalità avanzate in tempo reale
00:00:02
analisi che forniscono un riepilogo delle risposte
00:00:05
informazioni e risultati individuali
00:00:07
per sondaggi e altri tipi di moduli.
00:00:10
È possibile esportare i risultati in Microsoft
00:00:13
Excel per un'analisi più approfondita,
00:00:15
oltre a cancellare o stampare
00:00:17
un riepilogo delle risposte.
00:00:19
Per visualizzare le informazioni di riepilogo delle risposte
00:00:21
per il modulo, seleziona la scheda Risposte.
00:00:24
Nella parte superiore, vedrai un riepilogo
00:00:26
dati informativi sui tuoi moduli,
00:00:28
come il numero di risposte,
00:00:30
tempo medio impiegato dai rispondenti.
00:00:33
Per completare il modulo e
00:00:35
stato attuale del modulo.
00:00:37
Se gli utenti attivi possono ancora rispondere,
00:00:39
seleziona Visualizza risultati per visualizzarli singolarmente
00:00:42
dettagli per ogni rispondente.
00:00:44
Qui puoi trovare l'ID del rispondente,
00:00:47
nome, ora di esecuzione.
00:00:49
E una ripartizione delle risposte.
00:00:52
Usa le frecce sinistra e destra
00:00:54
per passare da un risultato all'altro
00:00:56
dettagli di altre risposte.
00:00:57
Puoi anche usare l'elenco a discesa per saltare
00:01:00
ai risultati di un rispondente specifico.
00:01:03
Puoi anche cercare una persona
00:01:06
risposta inserendo il numero,
00:01:08
ad esempio, 6,
00:01:09
nel campo del rispondente che è
00:01:11
associato a quella risposta.
00:01:12
Ciò è particolarmente utile quando
00:01:14
le risposte vengono raccolte in forma anonima.
00:01:17
Seleziona altre opzioni per eliminare tutte le risposte,
00:01:20
stampa un riepilogo delle risposte o crea
00:01:23
un link di riepilogo da condividere con altri.
00:01:27
Puoi visualizzare facilmente tutte le risposte
00:01:30
dati per il tuo modulo in Microsoft Excel.
00:01:32
Basta selezionare Apri in Excel per
00:01:35
scatta un'istantanea della tua situazione attuale
00:01:37
dati di risposta in una cartella di lavoro.
00:01:40
È possibile visualizzare ulteriormente i dettagli
00:01:42
per ogni domanda.
00:01:43
Accanto a ogni domanda vedrai
00:01:46
il numero di risposte e un grafico
00:01:49
che mostra una suddivisione delle risposte.
00:01:52
Per concentrarti su una singola domanda,
00:01:54
basta selezionare il link più dettagliato
00:01:56
sotto Domande individuali da visualizzare
00:01:58
il nome e il nome di ciascun rispondente
00:02:00
risposta per quella particolare domanda.
00:02:02
Se il tuo modulo o quiz contiene
00:02:04
un campo per il caricamento del file,
00:02:06
vedrai il numero di risposte
00:02:09
e il riepilogo dell'invio
00:02:11
quando fai clic su Ulteriori dettagli.
00:02:13
Puoi visualizzare tutte le risposte
00:02:16
per questa domanda specifica.
00:02:17
Fai clic su Link per aprire qualsiasi documento
00:02:19
oppure visualizza tutti i documenti di ricevuta in
00:02:21
il OneDrive creato automaticamente
00:02:23
cartella per il tuo modulo.
00:02:25
I documenti vengono rinominati,
00:02:26
incluso il nome del rispondente
00:02:28
come mostrato in questa colonna.
00:02:30
Nota che se elimini il
00:02:32
risposte al questionario,
00:02:33
i documenti non vengono cancellati
00:02:35
dalla cartella OneDrive.
00:02:37
Ora sai come controllare
00:02:39
e condividi i risultati del modulo.

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

 

résultat(s)
00:00:00
Microsoft Forms включает в себя расширенное реальное время
00:00:02
аналитика, содержащая сводку ответов
00:00:05
информация и отдельные результаты
00:00:07
для опросов и других типов форм.
00:00:10
Результаты можно экспортировать в Microsoft
00:00:13
Excel для более глубокого анализа,
00:00:15
а также удалить или распечатать
00:00:17
краткое изложение ответов.
00:00:19
Для просмотра сводной информации об ответах
00:00:21
в форме выберите вкладку Ответы.
00:00:24
В верхней части вы увидите сводку
00:00:26
информационные данные о ваших формах,
00:00:28
например, количество ответов,
00:00:30
среднее время, затраченное респондентами.
00:00:33
Чтобы заполнить форму и
00:00:35
текущий статус формы.
00:00:37
Если активные пользователи все еще могут отвечать,
00:00:39
выберите «Просмотреть результаты», чтобы увидеть отдельных
00:00:42
сведения о каждом респонденте.
00:00:44
Здесь вы можете найти идентификатор респондента,
00:00:47
имя, время выполнения.
00:00:49
И разбивка ответов.
00:00:52
Используйте стрелки влево и вправо
00:00:54
для переключения между результатами
00:00:56
сведения о других ответах.
00:00:57
Вы также можете использовать выпадающий список для перехода
00:01:00
к результатам конкретного респондента.
00:01:03
Вы также можете найти человека
00:01:06
ответ, введя номер,
00:01:08
например, 6,
00:01:09
в поле для респондента это
00:01:11
связано с этим ответом.
00:01:12
Это особенно полезно, когда
00:01:14
ответы собираются анонимно.
00:01:17
Выберите другие варианты, чтобы удалить все ответы,
00:01:20
распечатайте краткое изложение ответов или создайте
00:01:23
сводную ссылку, которой можно поделиться с другими.
00:01:27
Вы можете легко просмотреть все ответы
00:01:30
данные для вашей формы в Microsoft Excel.
00:01:32
Просто выберите «Открыть в Excel», чтобы
00:01:35
сделайте снимок текущего
00:01:37
данные ответов в рабочей книге.
00:01:40
Подробную информацию можно посмотреть дополнительно
00:01:42
на каждый вопрос.
00:01:43
Рядом с каждым вопросом вы увидите
00:01:46
количество ответов и диаграмма
00:01:49
которая показывает разбивку ответов.
00:01:52
Чтобы сосредоточиться на одном вопросе,
00:01:54
просто выберите более подробную ссылку
00:01:56
в разделе «Индивидуальные вопросы» смотрите
00:01:58
имя каждого респондента и их
00:02:00
ответ на этот конкретный вопрос.
00:02:02
Если ваша форма или тест содержат
00:02:04
поле для загрузки файла,
00:02:06
вы увидите количество ответов
00:02:09
и краткое описание заявки
00:02:11
когда вы нажмете «Подробнее».
00:02:13
Вы можете просмотреть все ответы
00:02:16
на этот конкретный вопрос.
00:02:17
Нажмите «Ссылка», чтобы открыть любой документ
00:02:19
или просмотрите все чековые документы в
00:02:21
автоматически созданный OneDrive
00:02:23
папка для вашей формы.
00:02:25
Документы переименованы,
00:02:26
включая имя респондента
00:02:28
как показано в этой колонке.
00:02:30
Обратите внимание, что если вы удалите
00:02:32
ответы на анкету,
00:02:33
документы не удаляются
00:02:35
из папки OneDrive.
00:02:37
Теперь вы знаете, как проверить
00:02:39
и поделитесь результатами своей формы.

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

 

résultat(s)
00:00:00
Microsoft Forms incluye tiempo real enriquecido
00:00:02
análisis que proporcionan un resumen de las respuestas
00:00:05
información y resultados individuales
00:00:07
para encuestas y otros tipos de formularios.
00:00:10
Puede exportar los resultados a Microsoft
00:00:13
Excel para un análisis más profundo,
00:00:15
así como eliminar o imprimir
00:00:17
un resumen de las respuestas.
00:00:19
Para ver la información resumida de las respuestas
00:00:21
para tu formulario, selecciona la pestaña Respuestas.
00:00:24
En la parte superior, verás un resumen
00:00:26
datos de información sobre tus formularios,
00:00:28
como el número de respuestas,
00:00:30
tiempo promedio que tardaron los encuestados.
00:00:33
Para completar su formulario y el
00:00:35
estado actual del formulario.
00:00:37
Si los usuarios activos aún pueden responder,
00:00:39
selecciona Ver resultados para ver los resultados individuales
00:00:42
detalles de cada encuestado.
00:00:44
Aquí puede encontrar la identificación del encuestado,
00:00:47
nombre, hora de ejecución.
00:00:49
Y un desglose de las respuestas.
00:00:52
Usa las flechas izquierda y derecha
00:00:54
para cambiar el resultado
00:00:56
detalles de otras respuestas.
00:00:57
También puedes usar la lista desplegable para saltar
00:01:00
a los resultados de un encuestado específico.
00:01:03
También puedes buscar a una persona
00:01:06
responde introduciendo el número,
00:01:08
por ejemplo, 6,
00:01:09
en el campo del encuestado es
00:01:11
asociado a esa respuesta.
00:01:12
Esto es especialmente útil cuando
00:01:14
las respuestas se recopilan de forma anónima.
00:01:17
Seleccione más opciones para eliminar todas las respuestas,
00:01:20
imprimir un resumen de las respuestas o crear
00:01:23
un enlace resumido para compartir con otros usuarios.
00:01:27
Puedes ver fácilmente todas las respuestas
00:01:30
datos para su formulario en Microsoft Excel.
00:01:32
Simplemente seleccione Abrir en Excel para
00:01:35
capture una instantánea de su estado actual
00:01:37
datos de respuesta en un libro de trabajo.
00:01:40
Puede ver más detalles
00:01:42
para cada pregunta.
00:01:43
Al lado de cada pregunta, verás
00:01:46
el número de respuestas y un gráfico
00:01:49
que muestra un desglose de las respuestas.
00:01:52
Para centrarse en una sola pregunta,
00:01:54
simplemente seleccione el enlace más detallado
00:01:56
en Preguntas individuales para ver
00:01:58
el nombre de cada encuestado y su
00:02:00
respuesta a esa pregunta en particular.
00:02:02
Si su formulario o cuestionario contiene
00:02:04
un campo para subir un archivo,
00:02:06
verás el número de respuestas
00:02:09
y el resumen de la presentación
00:02:11
al hacer clic en Más detalles.
00:02:13
Puedes ver todas las respuestas
00:02:16
para esta pregunta específica.
00:02:17
Haga clic en el enlace para abrir cualquier documento
00:02:19
o vea todos los documentos de recibo en
00:02:21
el OneDrive creado automáticamente
00:02:23
carpeta para tu formulario.
00:02:25
Se cambia el nombre de los documentos,
00:02:26
incluido el nombre del demandado
00:02:28
como se muestra en esta columna.
00:02:30
Tenga en cuenta que si elimina el
00:02:32
respuestas al cuestionario,
00:02:33
los documentos no se eliminan
00:02:35
de la carpeta OneDrive.
00:02:37
Ahora ya sabe cómo comprobarlo
00:02:39
y comparta los resultados de su formulario.

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

3215 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

An Error Has Occurred

Impossible de sauvegarder votre progression. Veuillez recharger la page, vous connecter, et essayer de nouveau. Si le problème persiste, merci de contacter un administrateur.

Close

Reminder

Show

/

Join Live Training Session