**Calculate the Expectations Score:**
Use the responses from the column **"[Column with expectations ratings]"** in the attached CSV to calculate the Expectations score using the following formula:
Expectations Score = (sum of all Likert ratings in **[Column with expectations ratings]**) ÷ (number of responses) ÷ 5
Likert Ratings are coded as:
- Exceeded Expectations = 5
- Met Expectations = 4
- Neutral = 3
- Fell Short of Expectations = 2
- Failed Expectations = 1
After calculating the Expectations score, report where it lands on the following scale:
- **Very Good** = above 90%
- **Good** = 70–89%
- **Average** = 50–69%
- **Poor** = 30–49%
- **Very Poor** = 0–29%
Next, analyze the responses in the column **"[Column with qualitative explanations]"** in the CSV to identify common themes and provide clear, actionable suggestions for how the Expectations score could be improved.
📊 Metric Calculations
Total Likert Sum = 358
Number of Responses (N) = 90
Maximum Possible Score = 90 × 5 = 450
Expectations Score
=
358
450
=
0.796
=
79.6
%
Expectations Score=
450
358
=0.796=79.6%
✅ Scale Placement
Expectations Score = 79.6% → Good (70–89%)
💬 Common Themes in Section 2 Explanations
Frequent terms and ideas from participants:
Event details & information (63 mentions of “event,” 33 “details,” 15 “information”) → users expect clear, specific content.
Calendar & scheduling (13 mentions of “calendar,” 11 “set up”) → participants want integration or reminders.
Expectations/clarity (24 “expect,” 13 “see,” 11 “where”) → people look for transparency in what’s provided.
Personal usefulness (“my,” “me,” “would”) → expectations are tied to personal relevance.
🔧 Suggestions to Improve Expectations
Provide Richer Event Details
Ensure event pages include full descriptions, context, and key information upfront.
Highlight “what’s included” to meet expectations of detail.
Integrate with Calendars
Offer quick calendar sync, reminders, or scheduling options to match user expectations of event utility.
Clarify the Flow
Use step-by-step or preview text so participants know exactly what to expect before committing.
Reduce vague wording (“about,” “etc.”) with more concrete explanations.
Personalize Content
Allow filtering or customization of events to match personal interests, reinforcing individual relevance.
✅ The score is already strong (“Good”), but addressing clarity, calendar integration, and detailed information could push it closer to “Very Good.”