College club and fest work as resume evidence: rewrites that work

Find the data in what you already did

List every club or fest role, then ask of each: what spreadsheets, forms or records did I touch?

If the records still exist and you have permission to use them, they make a genuine small project. Remove names, phone numbers and emails before analysing anything; these are other students' personal details.

Before and after rewrites

The pattern: verb + what you built or analysed + the data + what changed. Use numbers only if you can back them up from the records.

Before: "Core member, Technical Fest Committee."

After: "Built the registration tracker for a 3-day technical fest (Google Forms to Sheets, about 1,100 entries); a daily pivot by event showed two workshops overbooked by day one, and we added a second slot for each."

Before: "Sponsorship team member."

After: "Maintained the sponsorship pipeline sheet for 60 companies contacted; tracked status and follow-up dates, and summarised confirmation rate by sector for the team lead each week."

Before: "Treasurer, Photography Club."

After: "Kept the club's income and expense records for one academic year; prepared an event-wise budget-versus-actual summary that the faculty coordinator used to approve next year's allocation."

Before: "Handled Instagram for the cultural society."

After: "Exported six months of Instagram insights and compared reach by post format; shifted the posting plan toward the formats with higher reach for the final month before the fest."

The numbers in these examples are illustrative. Write your own, and keep the source sheet so you can answer "How did you count that?"

Turn one role into a small project

Pick the richest dataset from the table, then rebuild the analysis properly so you can show it. Here is a minimal version using made-up registration data; it runs as written in Python.

import sqlite3

con = sqlite3.connect(":memory:")
con.executescript("""
CREATE TABLE registrations (reg_id INTEGER, event TEXT, reg_day TEXT, attended INTEGER);
INSERT INTO registrations VALUES
 (1,'Robotics','Day1',1),(2,'Robotics','Day1',1),(3,'Robotics','Day1',0),
 (4,'Quiz','Day1',1),(5,'Quiz','Day2',1),(6,'Quiz','Day2',0),(7,'Quiz','Day2',0),
 (8,'Hackathon','Day1',1),(9,'Hackathon','Day1',1),(10,'Hackathon','Day2',1),
 (11,'Coding','Day2',1),(12,'Coding','Day2',0),(13,'Coding','Day1',1);
""")

rows = con.execute("""
SELECT event,
       COUNT(*) AS registered,
       SUM(attended) AS attended,
       ROUND(100.0 * SUM(attended) / COUNT(*), 1) AS show_rate_pct
FROM registrations
GROUP BY event
ORDER BY show_rate_pct;
""").fetchall()

for r in rows:
    print(r)

On this synthetic data the quiz has the lowest show rate (2 of 4, 50%) while the hackathon had everyone turn up. With your real, anonymised sheet, the write-up would explain what the committee could do about low show rates next year, such as reminders or a waitlist. That turns a club role into a project with a question, a query and a recommendation.

Where to place it on the resume

• If you have no internships, put a "Leadership and activities" section directly after projects, with two or three rewritten lines.
• If one club role produced a proper analysis, list the analysis under Projects and keep a one-line role under Activities.
• Drop roles where you can't describe any action with data or decisions. A long list of titles dilutes the strong lines.

For a full layout, see the annotated fresher resume example.

Prepare for the interview follow-up

Interviewers like these lines because they can ask practical questions. Have short answers ready:

1. 1Where did the data come from, and how did you clean it?
2. 2What decision changed because of your summary?
3. 3What would you track differently next year?
4. 4What went wrong?

Question 4 is often the best one to answer well. "Half our feedback forms had the event name typed differently, so I had to standardise them before counting" is exactly the kind of detail analysts deal with daily.

Cleaning messy form data and turning it into a clear summary is the core of the Data Analyst programme; you can also test how your current resume reads against analyst job descriptions with the free skill check.