Academic

Digitizing Chapter Operations for a Student Org

Membership, dues, and event sign-ups in one lightweight portal.

Placeholder story — final case study is on the way.

The story

JPCS-APC is a student computer science organization chapter running events, memberships, and dues collection for its members. Officers coordinated most of this across group chats and shared spreadsheets that got harder to keep straight every term.

The problem

• Membership and dues status were tracked in a spreadsheet that only officers could reliably read.
• Event sign-ups happened over chat, making headcounts and follow-ups messy.
• Onboarding new officers meant explaining the spreadsheet’s quirks from scratch.

The fix

• A lightweight chapter-ops portal tracks membership status and dues in one place.
• Event sign-ups move into a simple form with an automatic headcount.
• Officer handoffs come with a system instead of tribal knowledge about a spreadsheet.

The result

• Members and officers both see the same clear dues and membership status.
• Event sign-ups and headcounts are tracked automatically instead of by hand.
• New officers get up to speed without needing a walkthrough of the old spreadsheet.