Summarize Themes in Survey Data with an AI Chatbot

In ChatGPT or your favorite AI chatbot, cut and paste the following prompt to summarize and find themes in a set of survey data.To get started, replace the words in the brackets with the correct information for your context before copy/pasting. 

NOTE: make sure to remove all personally identifiable information from the data you will be uploading into the chatbot.

Summarize Themes in Survey Data Prompt

You are an expert mixed-methods researcher that uses surveys to gain insight into how to best serve educational staff and communities.  I have attached a dataset from a recent organizational survey that includes both quantitative and qualitative responses.  The audience for the survey was [INSERT PARTICIPANTS], and they were providing feedback and input on [DESCRIBE TOPIC OF YOUR SURVEY]. Your task is to summarize the data and identify trends, themes, and outliers. Please include the following in your analysis: 1. Quantitative data analysis: calculate basic the mean for each quantitative question 2. Qualitative data analysis: provide a summary of the top 3 themes in each question with qualitative data 3.Identify outliers and explain them in the context of the other data  6. Identify 2-3 actionable recommendations based on your summary.

Example Prompt

You are an expert mixed-methods researcher supporting a K-12 district leader that uses surveys to gain insight into how to best serve your staff and community. I have attached a dataset from a recent organizational survey that includes both quantitative and qualitative responses. The audience for the survey was teachers who attended professional development over the summer, and they were providing feedback and input on the quality and usefulness of the training for a new instructional model. Your task is to summarize the data and identify trends, themes, and outliers. Please include the following in your analysis: 1. Quantitative data analysis: calculate basic the mean for each quantitative question 2. Qualitative data analysis: provide a summary of the top 3 themes in each question with qualitative data 3.Identify outliers and explain them in the context of the other data 6. Identify 2-3 actionable recommendations based on your summary.

Additional Prompting Strategies

  • Tweak the task to fit the specific analysis you need such as removing quantitative/ qualitative if you have only one type of data

  • Ask for the key findings to be formatted as a chart

  • Ask the chatbot if there are other key insights or correlations in the data

  • Ask the chatbot for feedback on the survey to improve your collection of data in the future

Want to partner with AI for Education at your school or district? LEARN HOW


Previous
Previous

Analyze Survey Data with an AI Chatbot

Next
Next

Modify the Usability of an Existing Text with an AI Chatbot