Visualize Survey Results with Excel

Thursday, March 21, 2019 - 12:00pm to 1:30pm
Organization Name: 
Event Topic: 

You collected data with a survey--now what? Surveys, assessments, questionnaires, and forms are one of the most common ways for organizations to collect data. It's time to get those numbers off of your spreadsheets and into real-world conversations. In this workshop, Ann Emery will describe how to showcase survey results with effective data visualization. We'll begin with a brief overview of data storytelling principles, like removing unnecessary ink from your graph and then drawing attention to your desired takeaway finding with a dark/light contrast and a storytelling title. Then, we'll dive into real-life survey questions. You'll learn how to visualize data from yes/no survey questions, check-all-that-apply questions, rating scales, pre/post questionnaires, and from open-ended comments. The speaker will show you a few ideas for visualizing each type of survey question, and then you'll vote on your favorite. This session is about software-agnostic critical thinking skills, not about how-to software skills, but the speaker will share the Excel file that she used to create all of the visualizations in case you want to adapt her file for your own projects.

Contact / Reservations

Share This