Community college students invented, built, and implemented a user-friendly computer and mobile phone tool that enables musicians to compose and analyze music in the classroom and outside the classroom quickly. The key enabler was the collaboration among first- and second-year students who study engineering and music. While in the classroom, a music student contrived a clever idea for a new tool. The student reached out to the community college’s engineering department for help with the necessary creative program logic and formulas in Microsoft Excel. The first edition of the tool is used by students with positive reviews. It saves hours of time in learning and applying music theory concepts. This student-led project opened excellent research opportunities for community college students, motivated retention, and prompted innovative teaching and studying. It also inspired more students to participate in academic research and aspire to higher levels of education, including master’s and doctorates in engineering.
Tonal music comprises the musical keys, scales, and chords that are used most in much of the Americas and Europe today and since the 1600’s. Tonal music is complex and highly mathematical.
Understanding music theory takes many students three to four semesters to learn. Music analysis and composition are time consuming. The coordination between music theory students and engineering students enabled the project to progress. This creative combination of music theory expertise and engineering creativity with mathematics resulted in a time-saving tool. This user-friendly laptop tool offers substantial time savings and reduces the amount of information that must be looked up in textbooks or committed to memory.
Music theory course material taught at the community college provided the data and numerical relationships for the new mathematical spreadsheet tool. Musical notes were organized into tonal keys, scales, and chords, then input into mathematical databases. Students programmed handy look-up tables. Next, students developed a user-friendly input function to access the spreadsheet's programmed music theory. There are many attractive features that save music students a lot of time. Here are a few examples:
(1) Tonal Composition Guide: the user types in one piece of information--the musical key--in which to compose, and the tool provides all the chords, notes, and typical sequence of chords for "tonal" music.
(2) Diatonic Post-Tonal Music Guide: User types in one data point—name of the collection. Tool provides the proper ordering of notes in ionian, dorian, phrygian, lydian, mixolydian, aeolian, & locrian modes.
(3) Octatonic and Hexatonic Guide: User simply reads notes off the provided charts.
(4) Twelve Note Serialism: the user can use the provided template to create a 12x12 matrix that is super handy for composers to pick the proper ordering of notes.
Engineering skills in algebraic formulas and data lookup features in spreadsheets combined well with music theory knowledge to create this elegant tool. Online research generated several music theory applications. However, none of them were free nor as focused for music theory academic studies nor for music composition.
Link to the User-Friendly Music Theory Application tool: https://docs.google.com/spreadsheets/d/1EQ05ppdQUp9bpME3OvFgRv7tuBa4JB0R/edit#gid=281206229
Are you a researcher? Would you like to cite this paper? Visit the ASEE document repository at peer.asee.org for more tools and easy citations.