Overview

DAEBAK is Brown University and Rhode Island School of Design's Kpop dance team!

With over 30 different performers and up to 40 performances per year, DAEBAK is a surprisingly challenging complex operation behind the scenes. To keep up with the workload, we had an Executive Board (EB) of up to 14 members.

Over my several years as a member, I have worn many different hats and been under a couple different official titles - perfomer, communications chair, secretary, and vice director.

Logsitics and Management

Most recently, as first a Secretary and then a Vice Director, I was responsible for the logistics of the DAEBAK operation!

Most simply, I scheduled and officially booked every room and space from Brown University campus used by DAEBAK and made countless Google Forms and Google Spreadsheets.

To book rooms and spaces, I first needed to ensure that all my requests complied with Brown's Student Activities Office's regulations and prerequisites, as outlined through their handbook. With rules and restrictions changing yearly, it was important that I stayed up to date with the documentation throughout the years, making sure to reference specific sections to make sure DAEBAK was using the right tools in the right circumstances.

The remainder of my responsibilities revolved around forms and data.

Spreadsheets and Forms

In DAEBAK, EB used Google Forms and Google Sheets as a free service which allows us to collect and aggregate important responses in real time.

Historically, data aggregation across all of these forms was an intensive, manual process. However, as I watched the club grow in member count, audience size, and budget, I developed a personal initiative to automate this process in order to simultaneously reduce the manual workload and reduce the chance for mistakes.

Thus, between Fall 2023 and Spring 2025, I ultimately developed a system of Google Sheets for our Performer Casting List, Performer Practice Availability Aggregation, and Audience Member Ticket Aggregation. These spreadsheets would take in responses from their relevant Google Forms in real time and organize the information in those responses into important and relevant visualizations / representations.

In order to organize and aggregate these form responses, I often used extensive code and functions in Google Sheets. I became very familiar with tools like mapping, filtering, querying, RegEx matching, and conditional formatting as I manipulated arrays and tables full of text, numbers, and dates.

With so much code that supported DAEBAK EB throughout essential tasks, I also developed internal documentation to pass down for future generations of EB members.

asdf