CSC 210 Concordia University. St. Paul Local Music Studio Project Excel

Project Description:

A local music studio, Fiddlers, has a large number of clients who take lessons on a regular basis. Additionally, some students are members of Fiddlers’ competition band, which travels throughout the country and competes with some of the best musicians in the world. The owners need to be able to calculate the revenue generated through lessons and specific students. Additionally, they need to be able to calculate how much each member of the competition band will have to pay toward the next trip. The owners also need to be able to keep track of the cost of competition band uniforms, permission slips, and attendees. Furthermore, the teachers want to be able to track how many students they have and also to give a free lesson to students for every five paid lessons, with a maximum of two free lessons. You have been asked to help construct a workbook that the owners can use to help manage their data.