BYU Country Swing Database

Feb 2025 – Apr 20253 mosCompleted

A management tool for the BYU Country Swing Club that tracks instructors, lesson content, and teaching assignments—reducing the workload on club officers and enabling better decisions about instructor progress and scheduling.

A data management tool built for the BYU Country Swing Dance Club to streamline the coordination of instructors, lessons, and volunteer schedules—reducing administrative overhead and improving teaching consistency.

Developed as part of IS 301 – Introduction to Databases, this project focused on identifying real-world data challenges and implementing efficient information organization. Drawing from my experience as a club officer, I designed a database that could track:

  • Instructor qualifications and lesson assignments (beginner, intermediate, technique, and line dance).
  • Volunteer schedules and event participation (e.g., door duty, teaching frequency, and last taught dates).
  • Lesson histories and progression tracking for both instructors and participants.

The system was implemented using Airtable for rapid prototyping, with integrated forms that allowed officers to input and access data easily without technical experience. This design replaced manual tracking and simplified weekly coordination for the 30–40 volunteers running club events.

Through this project, I gained experience in data modeling, normalization, and CRUD design principles, while applying relational thinking to a real-world context.

This prototype later informed the broader BYU Country Swing Management System. The underlying questions remained the same—who is prepared to teach, what has been taught recently, and where are volunteers being overlooked—but the later system could connect those answers directly to weekly planning and the club's teaching resources.