Sociometry — a team retrospective, from text to a map of relations
Synthetic team retrospective interviews · 7 members · 16 confirmed relation tuples
Research question — Who trusts and relies on whom in this team, and what shape does that structure take?
Raw data sample_sociometry_team_retro.csv · 27 rows
Entirely synthetic — not a real retrospective, and unrelated to real people or organizations. The statements were designed so that star, bridge, clique and isolate all appear together.
| speaker | response |
|---|---|
| Minseo | When the analysis stalls, Junho is the first person I go to. He points out what I missed, so I always run things past him before a meeting. |
| Minseo | Taeyun and I pulled two all-nighters together at the end of a sprint. Since then I trust Taeyun with anything to do with the schedule. |
| Minseo | When a decision is hard I ask Seoyeon. Once Seoyeon lays it out, the whole team tends to accept it. |
| Minseo | In this retrospective I did wonder whether the talking only goes around the three of us. |
| Junho | I never need to check a document Minseo has put together. That is how much I trust Minseo. |
The study, step by step — what was actually produced
① Pulling out the relational statements
Across the 27 turns we looked for sentences carrying “who does what toward whom” and drew out 18 candidate relation tuples. What the AI found is only a first pass — deciding whether it is right belongs to the researcher in the next step.
First-pass candidates (some) — from→to · kind · supporting excerpt Junho→Minseo · relies on · “When the analysis stalls, Junho is the first person I go to” Minseo→Taeyun · trusts · “I trust Taeyun with anything to do with the schedule” Haeun→Seoyeon · relies on · “For anything that needs judgment I lean on Seoyeon” Taeyun→Jihun · distance · “Jihun’s way of working does not fit mine” Jihun→Junho · relies on · “If it still will not come out, I lean on Junho” Yerin→Seoyeon · trusts · “I find myself going to Seoyeon” Haeun→Yerin · works with · “Next quarter I would like to try working together” Seoyeon→Haeun · trusts · “Haeun is the one person I talk things over with beforehand” … and 10 more candidates
② The researcher confirms
Each of the 18 candidates was checked one by one against its supporting sentence: 16 were accepted and 2 were corrected — the machine’s suggestion is a first pass, and the accuracy of the map comes from the researcher’s confirmation. (1) One dropped: Haeun→Yerin “works with” rested on “Next quarter I would like to try working together”, which describes a wish rather than something that happened, so it was kept off the map. (2) One direction fixed: “When the analysis stalls, Junho is the first person I go to” is Minseo speaking, so it became Minseo→Junho rather than Junho→Minseo.
③ Building the matrix
The 16 confirmed tuples became a 7×7 adjacency matrix. A choice counts when trust, reliance or working together is named; the single “distance” tuple was kept on a separate negative-nomination layer — drawn on one sheet, reliance and distance make each other unreadable.
Matrix summary — 7 members · 15 positive choices · 1 negative nomination · 5 mutual pairs (Minseo-Junho · Minseo-Taeyun · Junho-Taeyun · Seoyeon-Haeun · Taeyun-Haeun).
④ Running the sociometry
The map is drawn — 5 pairs chose each other, and 1 member is not reached by any connection. Seoyeon is the star, where five people’s trust and reliance gather; Minseo, Junho and Taeyun form a clique that chose one another; Haeun is the bridge, tied mutually to both groups; Yerin is the isolate, with no choices received. Not being reached is the present shape of the relations, not a judgment about the person.
Key results
Relation tuples (confirmed)
16 confirmed by the researcher. Every supporting excerpt is a continuous string that exists in the source.
| From | To | Kind | Supporting excerpt |
|---|---|---|---|
| Minseo | Junho | relies on | When the analysis stalls, Junho is the first person I go to |
| Minseo | Taeyun | trusts | I trust Taeyun with anything to do with the schedule |
| Minseo | Seoyeon | trusts | When a decision is hard I ask Seoyeon |
| Junho | Minseo | trusts | That is how much I trust Minseo |
| Junho | Taeyun | works with | I do the backend work sitting side by side with Taeyun |
| Junho | Seoyeon | trusts | When I cannot find my footing I follow Seoyeon’s judgment |
| Taeyun | Minseo | works with | Urgent things I clear together with Minseo |
| Taeyun | Junho | trusts | I bring technical worries to Junho and trust him with them |
| Taeyun | Haeun | trusts | When I need to talk to another part of the org I ask Haeun first and trust it |
| Taeyun | Jihun | distance | Jihun’s way of working does not fit mine |
| Haeun | Seoyeon | relies on | For anything that needs judgment I lean on Seoyeon |
| Haeun | Taeyun | trusts | For how things stand on the development side I ask Taeyun |
| Seoyeon | Haeun | trusts | Haeun is the one person I talk things over with beforehand |
| Jihun | Junho | relies on | If it still will not come out, I lean on Junho |
| Jihun | Seoyeon | trusts | The way Seoyeon pulls a meeting together earns trust |
| Yerin | Seoyeon | trusts | I find myself going to Seoyeon |
Sociometric status
Popularity = positive choices received · rejection status = negative nominations received · a choice counts when trust, reliance or working together is named.
| Member | Popularity | Rejection status | Mutual choices | Role |
|---|---|---|---|---|
| Seoyeon | 5 | — | 1 | Star |
| Junho | 3 | — | 2 | Clique |
| Taeyun | 3 | — | 3 | Clique |
| Minseo | 2 | — | 2 | Clique |
| Haeun | 2 | — | 2 | Bridge |
| Jihun | 0 | 1 | 0 | Ordinary |
| Yerin | 0 | — | 0 | Isolate |
The four structures
A structure is the present shape of the relations — not a judgment about any member.
| Structure | Member | Grounds |
|---|---|---|
| Star | Seoyeon | Five people (Minseo, Junho, Haeun, Jihun, Yerin) name trust or reliance — popularity 5, the highest |
| Clique | Minseo · Junho · Taeyun | The three chose one another — 3 mutual pairs closing a triangle |
| Bridge | Haeun | The only member tied mutually to both Seoyeon (Seoyeon-Haeun) and the clique through Taeyun (Taeyun-Haeun) |
| Isolate | Yerin | No choices received — names only Seoyeon, and says of herself that she is still watching |
Representative quotes
Every quote is a sentence that exists in the raw data (excerpt-existence check passed).
“I find myself going to Seoyeon”
Star · Yerin
“When the analysis stalls, Junho is the first person I go to”
Clique · Minseo
“A lot of what I do is going back and forth between two sides and joining them”
Bridge · Haeun
“Rather than going up to anyone first, I am learning how things flow”
Isolate · Yerin
Paper-ready tables
Table 1. Quotations by category
Participant words supporting each category.
| Category | Case | Quotation |
|---|---|---|
| Relies on | Haeun | For anything that needs judgment I lean on Seoyeon |
| Trusts | Taeyun | I bring technical worries to Junho and trust him with them |
| Works with | Junho | I do the backend work sitting side by side with Taeyun |
| Distance | Taeyun | Jihun’s way of working does not fit mine |
Copying opens an editable duplicate in your workbench — this showcase stays as it is.