How to Spread Holiday Cheer with Spreadsheets

Posted by on December 7, 2012

information technology degreeLet’s face it. Unless you are earning your information technology degree and are required to take Microsoft Office Applications 1, you probably haven’t had the opportunity to take the class. This is the class in which IT students learn about Microsoft Word, Excel, and PowerPoint, and how to integrate the programs and utilize them in the workplace. This quarter, Minnesota School of Business-Blaine instructor, Sarah Bowe, decided to do something different.

On Dec. 3, Bowe and her students met at Blaine Town Hall to help out with the annual Winter Holiday Celebration from 6:00-8:00pm. The students were assigned to help run the events and activities, which included holiday bingo, postcards to Santa, crafts, refreshments, and temporary tattoos.

While at their stations, the students also recorded data.

The information the students recorded included:

  • how many people played bingo during the different bingo sessions
  • children getting a temporary tattoo separated by gender
  • ages of children in the craft room
  • average of how long each family stayed
  • which craft was the most popular
  • how many adults and children came through the cookie line
  • what time refreshments ran out
  • and how many people took more than one cookie.

By the end of the night, 701 members of the community had participated in this event.

information technology degreeOnce the event was cleaned up, Bowe and her students went back to campus to begin their discussion of the event, and also to begin analyzing the data they had collected. The students charted everything in Microsoft Excel, and prepared it to be delivered to the City of Blaine, so that they can use this information to make this fun-filled family holiday event even better next year.

Sarah Bowe states, “My students were able to help Blaine Parks and Recreation provide a fun family night for the people in their community.  They alleviated some of the stress of the Parks and Recreation employees, as there was more work than they could do themselves.  Students also were able to see the real-world applications of Excel by providing important data to Blaine Parks and Recreation so they can improve the experience for next year.”

Thank you for your Interest in Minnesota School of Business.