A full-cycle case study in data coordination, event planning, multi-stakeholder communication, and system design — executed solo across an 8-week timeline.
Each spring, the English department at a small regional Catholic liberal arts university runs its annual induction cycle for the Alpha Phi Iota chapter of Sigma Tau Delta, the International English Honor Society. The chapter carries no dedicated budget line and no second coordinator. The work belongs entirely to the departmental administrative assistant — who also supports five additional academic departments simultaneously.
This case study documents how I managed the full project cycle: from pulling raw registrar data and building a tracking system from scratch, through designing all event materials, coordinating with faculty and the national organization, executing the ceremony, and filing the post-event records.
Every phase ran on schedule. Every payment reconciled. Every new member record reached the national organization error-free. This case study explains how I built the system that made that possible.
"This project had no budget line, no dedicated staff, and no existing system. What it had was a deadline, 34 students whose records required careful handling, and a requirement to get everything right."
Eligibility data lived across three separate sources: a registrar enrollment report, a chapter member database last updated the previous spring, and a national organization member portal. No single source of truth existed. Cross-referencing these manually produced errors. I needed to build a system before I could use one.
Student academic records fall under FERPA. Every eligibility check, every email, every event list required careful attention to who could see what and when. Working solo meant I was the only checkpoint between a student's record and any outward-facing document.
Six simultaneous phases — data analysis, student outreach, materials design, event logistics, ceremony execution, and post-event documentation — with no ability to delegate and no buffer for missed steps. Every phase had to close cleanly before the next one could open.
I pulled the spring enrollment report from the registrar and built a five-tab Excel workbook before any outreach began. The workbook organized all 34 English-connected students into four program categories (English major, English education major, double major, English minor), sorted by graduation year and alphabetical order within each group. I applied cognitive load theory to the design: color coding, freeze panes, section headers, and alternating row fills reduce scanning time so the user can spend their attention deciding, not orienting. I then cross-referenced the enrollment data against the chapter's historical membership database to flag existing members, track payment history, and remove graduated students from the active eligibility pool.
5-tab tracking workbook · Eligibility shortlist · Approved member cross-referenceI applied the national organization's eligibility criteria to the full student roster: 3.0+ career GPA, 3.0+ English GPA, sophomore standing or above, and a minimum of three completed Mount English courses. This narrowed the pool from 34 students to 17 eligible candidates. I submitted the shortlist to the faculty chapter advisor for review before any student outreach began — a required step that also served as a second data check. The advisor confirmed or adjusted the list, and I updated the tracker to reflect the final approved pool.
Analyzed 34 students · Identified 17 eligible · Faculty-approved shortlistI drafted the formal induction invitation and submitted it for faculty advisor approval before distribution. Outreach ran across four touchpoints per eligible student: initial invitation, five-day follow-up for non-respondents, RSVP confirmation, and payment confirmation. I tracked every touchpoint in the communications log tab of the workbook, which flagged pending RSVPs and unpaid fees in real time. This approach kept the outreach organized and ensured no eligible student fell through without a second contact.
Communications log · RSVP tracker · Payment confirmation recordsSimultaneously with outreach, I designed and produced all ceremony materials: a formal induction invitation in HTML and print-ready PDF format (institutional navy and gold, dark academia aesthetic), a ceremony program including member names, chapter history, faculty sponsor recognition, and the national organization's induction oath, an honors dinner RSVP and seating coordination packet, and a payment tracking log. I also prepared the enrollment package for submission to the national Sigma Tau Delta organization, which required compiling verified contact information, graduation years, and payment confirmations for each new inductee.
HTML invitation · Print ceremony program · Payment log · Enrollment packageI coordinated venue setup, catering, faculty attendance, and student check-in. Day-of management ran from room setup through the formal induction ceremony and honors dinner. I managed check-in against the RSVP list, collected remaining fees at the door, and coordinated the ceremony proceedings with the faculty chapter advisor. I also documented the ceremony for departmental records and chapter archives.
12 students inducted · 0 check-in discrepancies · Faculty and student coordinationAfter the ceremony, I submitted all new member enrollments to the national Sigma Tau Delta portal, reconciled payment records against the enrollment submission, updated the chapter's master member database to reflect the new inductees and any changes in class standing among existing members, and drafted a post-event summary report for the faculty advisor. I archived all student records per FERPA protocols, documented process improvements for the next cycle, and updated the tracking workbook template so the next coordinator could start from a clean, ready system.
National enrollment submitted · Database updated · Post-event report · Process documentationFive-tab Excel workbook containing eligibility tracker, six-phase planning checklist, Gantt-style project timeline, student communications log, and outcomes summary. Designed as a handoff document for future coordinators.
Microsoft Excel · Century Gothic · Cognitive Load Theory design principlesBranded invitation in institutional navy and gold. Produced in two formats: an HTML email version and a print-ready PDF for physical distribution. Design draws on dark academia aesthetic with Cormorant Garamond typography.
HTML/CSS · Adobe · Cormorant Garamond · Institutional brand standardsPrint-ready ceremony program including the order of proceedings, member roster, chapter history, faculty sponsor recognition, and the national organization's induction oath language.
Microsoft Word · Adobe · Institutional brand standardsCommunications tracking log with four touchpoints per student: invitation sent, follow-up, RSVP receipt, and payment confirmation. Conditional color coding flagged pending items automatically. Generated final headcount for venue.
Microsoft Excel · Conditional formatting · Data validationComplete enrollment submission to the national Sigma Tau Delta organization: verified contact information, graduation years, payment confirmations, and chapter documentation for all new inductees.
STD National Member Portal · Cross-referenced against payment logWritten summary for the faculty chapter advisor covering headcount, induction totals, financial reconciliation, process notes, and recommendations for the next cycle. Archived per institutional document retention policy.
Microsoft Word · FERPA-compliant archiving protocols| Last Name | First | Yr | GPA | Major | Eligible | Member |
|---|---|---|---|---|---|---|
| Ashworth | Morgan | SR | 3.82 | ENGL | Y | |
| Blackwood | Riley | SR | 3.91 | ENGL | Y | ✓ |
| Ellsworth | Jamie | SR | 3.65 | ENGL+HIST | Y | ✓ |
| Thornton | Casey | SR | 2.91 | ENGL | N | |
| Fairmont | Drew | JR | 3.80 | ENGL+COMM | Y | |
| Merriweather | Quinn | JR | 3.74 | ENGL | Y | |
| Ashbridge | Parker | SO | 3.88 | ENGL Ed. | Y |
"The gap between an administrative role and a project management, marketing, or instructional design role is rarely a skills gap. It is almost always a visibility gap. This case study exists to close it."
This project required the same disciplines a formal project manager brings to any engagement: scope definition, phase sequencing, stakeholder mapping, risk identification, and a clean close. The absence of a project management framework did not prevent rigorous project management — it required me to build the framework myself, which is a more transferable demonstration of the skill.
Outreach to 17 eligible students across four touchpoints, formal invitation design in two formats, faculty coordination, and post-event documentation all require exactly the skills a marketing coordinator applies daily: content creation, audience-aware communication, multi-channel distribution, and outcome tracking. The context is academic, but the discipline is marketing.
Cognitive load theory shaped the workbook design. The decision to organize the tracker into five tabs — one job per tab — reflects the same design logic that makes a well-built eLearning module easier to navigate than a dense PDF. The handoff documentation I produced at the end of the cycle is, in effect, a performance support tool: a future coordinator can pick up the workbook and complete the project without ever asking me a question.
Every deliverable in this project required writing: the invitation, the program, the summary report, the outreach emails, the post-event documentation. None of these were produced from templates. Each required original writing calibrated to a specific audience, a specific purpose, and a specific channel. Producing six distinct content outputs — on deadline, with no copyediting support — is content marketing under a different institutional name.