In Spring 2015, we piloted service-learning projects in Franklin in six existing courses at Colby-Sawyer College, including:
Access Database for Toad Hall
BUS 312 COMPUTING ESSENTIALS FOR BUSINESS
BUS312 Computing Essentials for Business introduces students to intermediate level software tools for business use. The Access database application is one of the tools. As an example of how to use the software, the class drafted a database application for “Toad Hall” in Franklin Falls. Toad Hall showcases many artists' works for public viewing and sale. It is also an entertainment venue, that can be booked for public and private functions. As there are many facets to Toad Hall operations, a database is the perfect application to inventory operations. Vendors, patrons, artworks, sales, donations, schedules and more can be tracked and queried in the Access application.
A student from the class completed the project as an intern at Toad Hall during the summer of 2015 and implemented the Access database.
Wayfinding Maps and Signage for winnipesaukee basin trails
GD 327 Information Design
Graphic design majors in this intermediate course applied their typography and information design skills to the design of wayfinding maps and signage prototypes for Winnipesaukee Basin Trails, a potential unified system within which to map and market the multiple bike trails in and around Franklin. The students worked in five teams of three to develop alternative solutions to present to Todd Workman of PermaCityLife. Workman intends to share the designs with the various groups that manage the bike trails in the area, hoping to garner support for a unified system that will both encourage use of the trails by local residents and promote the region as a recreational destination for tourists.
BUS 415 Consumer Behavior and Marketing Research
The purpose of this exploratory research was to assess the parking resources in the city. Observation research was conducted onsite. Students were consistent in their views that Franklin is a city with great potential and concluded:
- it is the geographic center of New Hampshire, with a wealth of trails and rivers
- there is potential for an ideal building mix, and many historic structures still stand
- there is plenty of critical space, including empty storefront that could house thriving businesses
- Franklin experiences high levels of traffic through downtown, and thus has the ability to attract all age ranges if properly restructured.
Five teams were assigned elements of a comprehensive municipal parking strategy and collectively comprised the spring 2015 Marketing Research and Consumer Behavior class. Based upon the secondary research conducted, the class determined the importance of creating a comprehensive parking plan as a key element in revitalizing the city. The primary research resulted in short-term recommendations focused on parking permits and signage. These Phase 1 recommendations could lessen the parking challenges facing residents, businesses and visitors at minimal cost. Long-range solutions include the creation of solar panel covered parking spaces, parking meters and new parking lots to support a growing city.