Analyzing Survey Open-Ended Responses for Beginners | Sort 30-60 answers with an affinity diagram

Marketing & Sales

Analyzing Survey Open-Ended Responses for Beginners | Sort 30-60 answers with an affinity diagram

Beginner | 4 whiteboard pages · Task board: 5 columns (4 parent tasks, 12 subtasks)

Beginner: No technical terms. Just answer the whiteboard's questions, following the examples, and it takes shape.

Sort 30-60 survey comments with an affinity diagram: report, fix now, or ask again.

Read more Show less

Copy each answer onto its own sticky note in the respondent's own words, without deciding categories first, and turn what you fix into tasks with an owner and a deadline. Move similar voices together and give each group a one-sentence heading and a count. Compare headings on effort to fix, clarity, and reader interest, then vote with 3 dots per person. Unlike a tally ranked by count, this keeps a must-not-miss voice in its own frame, even if there is only one.

For two to four staff of an event, class, or shop. About 40 answers take roughly 30 minutes to copy and 60 minutes to group and sort. Check the results in the next survey and keep using this board.

The whiteboard has four A4 pages that run in order: goal and copying, grouping, sorting, then fixing and reporting. The task board has 5 columns, 4 parent tasks (one per page), and 12 subtasks.

0 Likes 0 Copies Author: WeProcess
affinity diagram survey analysis open-ended responses customer feedback class review
Sign up free and use this template

Once you have a free account, you can copy this template from the marketplace

Whiteboard preview

Read the whiteboard text as plain text

Survey Comments Summary Board

How to use (4 pages): ① Set the goal and how to copy on page 1 (boards①–⑤) → ② Copy one voice per note, group similar ones, add headings on page 2 (boards⑥–⑧) → ③ Sort where each voice goes by 3 criteria and votes on page 3 (boards⑨–⑬) → ④ Decide fixes and next questions, then report on page 4 (boards⑭–⑯)

1/4 Set goal and how to copy

① Last result and goal (start here)

What to write Number or date
Last result e.g. Fixed last time: printed and handed out the materials. e.g. Leave blank if this is your first time e.g. Voices saying "I want handouts" went from 5 to 0
This goal e.g. Decide what to fix next session and report to the community center e.g. Finish by Dec 6
Answers and reader e.g. The reader is the community center staff e.g. 3 sessions from Sep to Nov, 33 attendees, 42 open comments

② Steps to copy one voice per note

  1. List the answers Export the form or spreadsheet answers into a list, one row per person e.g. Put 3 sessions from Sep to Nov in one table (33 people)
  2. One voice, one note Copy one voice onto one sticky note, in the respondent's own words e.g. "The teacher spoke too fast and I could not follow the screen"
  3. Split two topics If one answer holds two topics, split it into two notes e.g. "The text is small. Also the room is cold" becomes two notes
  4. No boxes first Do not decide categories first. Put voices that feel alike close together e.g. Put "too fast" next to "I was left behind"

③ Questions to copy (blue: decided)

  • e.g. Copy two questions, Q5 "Good things" and Q6 "Problems and next wishes"
  • e.g. Skip the 5-point satisfaction rating; report only its average in ⑮
  • e.g. If one person wrote the same thing in two questions, merge it into one note
  • How to fill in: write the question numbers to copy and the ones to skip

④ Choose sticky note colors

  • e.g. Problems and complaints are red
  • e.g. Good voices are green
  • e.g. Next wishes and ideas are gold
  • How to fill in: colors are a cue while copying. Do not decide groups by color

⑤ Voices not to copy (blue: decided)

  • e.g. Answers that only say "nothing" or "thanks" (4)
  • e.g. If an answer has a name or phone number, erase that part and copy the rest
  • e.g. Do not copy off-topic remarks, only count them (0 this time)
  • How to fill in: write why you skip them and how many

2/4 Group similar voices

⑥ Voices (red=problem, green=good, gold=wish)

  • Problem voice e.g. The teacher spoke too fast and I could not follow the screen
  • Problem voice e.g. The handout text is too small to read even with glasses
  • Good voice e.g. I could ask about anything I did not understand, as many times as I wanted
  • Next wish e.g. Next I want to learn how to send photos on WhatsApp

⑦ Group headings, counts, sample voices

Heading (1 sentence) Count Sample voice
Group 1 e.g. Handout and screen text is too small to see e.g. 9 voices e.g. "I can't read it even with glasses"
Group 2 e.g. The pace is too fast to keep up e.g. 11 voices e.g. "I couldn't follow the screen"
Group 3 e.g. Easy to ask questions on the spot e.g. 8 voices e.g. "I could ask as many times as I wanted"
Group 4 e.g. There are things I want to learn next e.g. 6 voices e.g. "I want to send photos on WhatsApp"
Group 5 e.g. The room is cold e.g. 3 voices e.g. "My hands were numb"

⑧ Unplaced voices and must-keep voices

  • Voices that fit nowhere e.g. 4 voices such as "The parking lot is small" and "The teacher's voice is easy to hear"
  • A voice you must not miss, even if only one e.g. "I got a scam message and I am scared. I want to know how to spot one" (1 voice)
  • Count check e.g. 37 in ⑦ plus 5 in ⑧ makes 42. It matches the 42 in ①, minus the 4 in ⑤, plus the 4 you split in two

3/4 Sort where voices go

⑨ Compare ⑦ headings (3 dots per person)

Effort to fix Meaning clear? Reader wants it?
Text too small e.g. Small. Just enlarge the handout text e.g. Clear e.g. Wants to know
Pace too fast e.g. Medium e.g. Unclear (explanation or operation?) e.g. Wants to know
Easy to ask e.g. Nothing to fix e.g. Clear e.g. Wants to know
Things to learn e.g. Large. Plan a new session e.g. Unclear (which app?) e.g. A little interested
Room is cold e.g. Small. Ask for the heating e.g. Clear e.g. Barely interested

⑩ Voices to report (gold)

  • e.g. Easy to ask questions on the spot (8 voices)
  • e.g. Text too small (9 voices) and what we fix from January
  • e.g. Scam message worries (1 voice) and what we will talk about in January
  • How to fill in: write headings the reader wants to know, with counts

⑪ Voices to fix now (red)

  • e.g. Handout and screen text is too small (9 voices)
  • e.g. The room is cold (3 voices)
  • e.g. Scam message worries (1 voice, from ⑧)
  • How to fill in: write headings you can fix before the next session

⑫ Voices to ask again (green)

  • e.g. Pace is too fast (11 voices, unclear if the explanation or the operation is fast)
  • e.g. Things to learn next (6 voices, unclear which app)
  • e.g. The parking lot is small (1 voice, unclear if others are bothered)
  • How to fill in: write unclear headings and what you do not know

⑬ Chosen and skipped headings, with reasons

  • Chosen headings and reasons e.g. Text too small (4 dots) and room is cold (2 dots) get fixed now. They are cheap to fix and clear in meaning
  • Skipped headings and reasons e.g. Things to learn next (1 dot) is not fixed this time, because we do not know which app
  • Where skipped voices go e.g. Write it in ⑫ and turn it into a question in the January survey

4/4 Fix and report

⑭ Write fixes from ⑪ and questions from ⑫

  • Fixes in ⑪ and questions in ⑫
    • Enlarge handout text e.g. Print handouts at 18 pt and enlarge the screen when showing it
    • Ask what was fast e.g. Let them pick one of "explanation", "operation", or "both"
    • Ask for heating e.g. Ask the community center to turn the heating on 30 minutes before we start
    • Ask which app to learn e.g. Let them pick up to two from WhatsApp, photos, and maps
    • Scam message talk e.g. Spend the first 5 minutes of the January session on how to spot them

⑮ Decide the report from the ⑩ voices

  • Reader and how to hand it over e.g. Hand one A4 sheet to the community center staff on Dec 10
  • Order and length e.g. Good voices, then fixes and how, then what we will ask next, with up to 2 lines per heading
  • Voices not to write e.g. Leave out voices that identify a person. Write counts exactly as in ⑦ and ⑧

⑯ Owner, deadline, and signal to continue

Owner Deadline How to check Signal and fallback
Enlarge text e.g. Instructor e.g. The day before the January session e.g. Count text-size voices in the January survey e.g. Keep it if 0 voices, change it if 1-2, stop and go back to (board⑨) if 3 or more
Ask for heating e.g. Staff A e.g. Dec 20 e.g. Write down the room temperature that day e.g. Keep it if 0 cold voices, change it if 1-2, stop and go back to (board⑪) if 3 or more
Scam talk e.g. Instructor e.g. The January session e.g. Count the questions after the talk e.g. If 0 questions, stop and go back to (board⑧)
Add questions e.g. Staff B e.g. 3 days before the January session e.g. Count how many people answered the new question e.g. If fewer than half answered, change the question and go back to (board⑫)

Task board contents

Not started 16 items

Set goal, copy rules

On page 1, write last time's result and this time's goal, and decide which questions to copy and how. Once the copying is settled, you can make sticky notes on page 2 without hesitating. Press Ctrl+F (⌘F on a Mac) and type "3/4" to jump to page 3.

Log result and goal

In the table of board①, write what you fixed last time and how many voices followed, this time's goal and deadline, and the number of answers and who will see the results. Done when all 3 rows are filled.

Read the copy steps

Read the 4 steps in board② and check that one voice goes on one note and that you do not decide categories first. Mark this task done once you have read them.

Decide what to copy

In boards③–⑤, write the question numbers to copy, how to color the notes, and the voices you will not copy with their count. Done when each of the 3 frames has a line.

Group similar voices

On page 2, group the voices you copied one by one by similarity, and give each group a heading and a count. These groups are the material you sort on page 3.

Copy voices to notes

Using the questions and colors from boards③–⑤, copy one voice per sticky note from the list of answers and place it in the frame of board⑥. Done when the number of notes matches the answers in the list, minus the voices you skip, plus the ones you split in two.

Add group headings

In board⑥, move similar voices close together and, in the table of board⑦, write a one-sentence heading, a count, and a sample voice for each group. Done when all 5 rows are filled.

Keep unplaced voices

Move voices that fit no group, and voices you must not miss even if only one, to board⑧ and write how many you kept. Done when the counts in ⑦ and ⑧ add up to the total.

Sort where voices go

On page 3, compare the headings from page 2 on 3 criteria, choose by votes, and sort them into voices to report, voices to fix now, and voices to ask again. The reasons you chose and skipped are kept, so you can review them later.

Compare and vote

In the table of board⑨, write the effort to fix, how clear the meaning is, and whether the reader wants to know for each heading in ⑦, and put each person's 3 dots on the heading rows. Done when everyone has placed 3 dots.

Split into 3 piles

Looking at the dots and the table, copy the headings with counts into boards⑩ (report), ⑪ (fix now), and ⑫ (ask again). Done when every heading in ⑦ and ⑧ is somewhere.

Write the reasons

In board⑬, write one line each for the chosen headings and reasons, the skipped headings and reasons, and where the skipped voices go. Done when all 3 lines are filled.

Fix and report

On page 4, decide how to fix the voices to fix now and the questions for next time, then write the report content with owners and deadlines. One round ends when you read the signals in the next survey and decide whether to continue.

Set fixes and owners

In the branches of board⑭, add the fixes from ⑪ and the questions from ⑫, and in the table of board⑯, write owner, deadline, and how to check. Done when owners and deadlines for all 4 rows are filled.

Plan the report

In board⑮, write who gets the report and how, the order and length, and the voices you leave out. Done when you make the report with that content and hand it over.

Decide by the signal

After the next survey, look at the "Signal and fallback" column of board⑯, decide to keep, change, or stop for each row, and write the result beside the column. If a row says stop, go back to the board frame it names and choose again.

Copying 0 items

Grouping and sorting 0 items

Fixing 0 items

Reported 0 items

← Back to templates

Preview mode Analyzing Survey Open-Ended Responses for Beginners | Sort 30-60 answers with an affinity diagram

Whiteboard preview

① Last result and goal (start here) ② Steps to copy one voice per note ③ Questions to copy (blue: decided) ④ Choose sticky note colors ⑤ Voices not to copy (blue: decided) ⑥ Voices (red=problem, green=good, go... ⑦ Group headings, counts, sample voices ⑧ Unplaced voices and must-keep voices ⑨ Compare ⑦ headings (3 dots per person) ⑩ Voices to report (gold) ⑪ Voices to fix now (red) ⑫ Voices to ask again (green) ⑬ Chosen and skipped headings, with r... ⑮ Decide the report from the ⑩ voices ⑯ Owner, deadline, and signal to cont... Survey Comments S... How to use (4 pag... Next wishes, what... Decisions and steps Problem voices, f... Good voices, ask ... 1/4 Set goal and how ... Ctrl+F / ⌘F : 2/4... → 2/4 2/4 Group similar voices ↙ 3/4 What to write Number or date Last result e.g. Fixed last time: printed and handed out the materials. e.g. Leave blank if this is your first time e.g. Voices saying "I want handouts" went from 5 to 0 This goal e.g. Decide what to fix next session and report to the community center e.g. Finish by Dec 6 Answers and reader e.g. The reader is the community center staff e.g. 3 sessions from Sep to Nov, 33 attendees, 42 open comments List the answersExport the form or spreadsheet answers into a list, one row per persone.g. Put 3 sessions from Sep to Nov in one table (33 people) One voice, one noteCopy one voice onto one sticky note, in the respondent's own wordse.g. "The teacher spoke too fast and I could not follow the screen" Split two topicsIf one answer holds two topics, split it into two notese.g. "The text is small. Also the room is cold" becomes two notes No boxes firstDo not decide categories first. Put voices that feel alike close togethere.g. Put "too fast" next to "I was left behind" e.g. Copy two questions, Q5 "Good things" and Q6 "Problems and next wishes" e.g. Skip the 5-point satisfaction rating; report only its average in ⑮ e.g. If one person wrote the same thing in two questions, merge it into one note How to fill in: write the question numbers to copy and the ones to skip e.g. Problems and complaints are red e.g. Good voices are green e.g. Next wishes and ideas are gold How to fill in: colors are a cue while copying. Do not decide groups by color e.g. Answers that only say "nothing" or "thanks" (4) e.g. If an answer has a name or phone number, erase that part and copy the rest e.g. Do not copy off-topic remarks, only count them (0 this time) How to fill in: write why you skip them and how many Problem voicee.g. The teacher spoke too fast and I could not follow the screen Problem voicee.g. The handout text is too small to read even with glasses Good voicee.g. I could ask about anything I did not understand, as many times as I wanted Next wishe.g. Next I want to learn how to send photos on WhatsApp Heading (1 sentence) Count Sample voice Group 1 e.g. Handout and screen text is too small to see e.g. 9 voices e.g. "I can't read it even with glasses" Group 2 e.g. The pace is too fast to keep up e.g. 11 voices e.g. "I couldn't follow the screen" Group 3 e.g. Easy to ask questions on the spot e.g. 8 voices e.g. "I could ask as many times as I wanted" Group 4 e.g. There are things I want to learn next e.g. 6 voices e.g. "I want to send photos on WhatsApp" Group 5 e.g. The room is cold e.g. 3 voices e.g. "My hands were numb" Voices that fit nowheree.g. 4 voices such as "The parking lot is small" and "The teacher's voice is easy to hear" A voice you must not miss, even if only onee.g. "I got a scam message and I am scared. I want to know how to spot one" (1 voice) Count checke.g. 37 in ⑦ plus 5 in ⑧ makes 42. It matches the 42 in ①, minus the 4 in ⑤, plus the 4 you split in two 3/4 Sort where voices go → 4/4 4/4 Fix and report Effort to fix Meaning clear? Reader wants it? Text too small e.g. Small. Just enlarge the handout text e.g. Clear e.g. Wants to know Pace too fast e.g. Medium e.g. Unclear (explanation or operation?) e.g. Wants to know Easy to ask e.g. Nothing to fix e.g. Clear e.g. Wants to know Things to learn e.g. Large. Plan a new session e.g. Unclear (which app?) e.g. A little interested Room is cold e.g. Small. Ask for the heating e.g. Clear e.g. Barely interested e.g. Easy to ask questions on the spot (8 voices) e.g. Text too small (9 voices) and what we fix from January e.g. Scam message worries (1 voice) and what we will talk about in January How to fill in: write headings the reader wants to know, with counts e.g. Handout and screen text is too small (9 voices) e.g. The room is cold (3 voices) e.g. Scam message worries (1 voice, from ⑧) How to fill in: write headings you can fix before the next session e.g. Pace is too fast (11 voices, unclear if the explanation or the operation is fast) e.g. Things to learn next (6 voices, unclear which app) e.g. The parking lot is small (1 voice, unclear if others are bothered) How to fill in: write unclear headings and what you do not know Chosen headings and reasonse.g. Text too small (4 dots) and room is cold (2 dots) get fixed now. They are cheap to fix and clear in meaning Skipped headings and reasonse.g. Things to learn next (1 dot) is not fixed this time, because we do not know which app Where skipped voices goe.g. Write it in ⑫ and turn it into a question in the January survey ⑭ Write fixes fro... Fixes in ⑪ and questions in ⑫ Enlarge handout text e.g. Print handouts at 18 pt and enlarge the screen when sh… Ask for heating e.g. Ask the community center to turn the heating on 30 min… Scam message talk e.g. Spend the first 5 minutes of the January session on how Ask what was fast e.g. Let them pick one of "explanation", "operation", or "b… Ask which app to learn e.g. Let them pick up to two from WhatsApp, photos, and maps Reader and how to hand it overe.g. Hand one A4 sheet to the community center staff on Dec 10 Order and lengthe.g. Good voices, then fixes and how, then what we will ask next, with up to 2 lines per heading Voices not to writee.g. Leave out voices that identify a person. Write counts exactly as in ⑦ and ⑧ Owner Deadline How to check Signal and fallback Enlarge text e.g. Instructor e.g. The day before the January session e.g. Count text-size voices in the January survey e.g. Keep it if 0 voices, change it if 1-2, stop and go back to (board⑨) if 3 or more Ask for heating e.g. Staff A e.g. Dec 20 e.g. Write down the room temperature that day e.g. Keep it if 0 cold voices, change it if 1-2, stop and go back to (board⑪) if 3 or more Scam talk e.g. Instructor e.g. The January session e.g. Count the questions after the talk e.g. If 0 questions, stop and go back to (board⑧) Add questions e.g. Staff B e.g. 3 days before the January session e.g. Count how many people answered the new question e.g. If fewer than half answered, change the question and go back to (board⑫) → 2/4 Group similar voices ↙ 3/4 Sort where voices go → 4/4 Fix and report
100%

Drag to move, scroll to zoom