Database Service-learning Projects: Addressing Community Needs While Measuring and Meeting Computer Science Learning Outcomes

Abstract

This innovative practice full paper describes the iterative use of service learning to develop, review, and improve computing-based artifacts for small rural organizations, over an extended period. It is well-known that computing students benefit from service-learning experiences as do the community partners. It is also well-known that computing artifacts rarely function well long-term without versioning and updates. Service-learning projects are often one-time engagements, completed by single teams of students over the course of a semester or year long course. This limits the benefit for the community partners, such as small rural organizations, that do not have the expertise or resources to review and update a project on their own.Over the course of several years, teams of undergraduate students in a computing capstone social media development course created tailored social media plans for numerous small rural organizations. The projects were required to meet the client's specific needs, with identified audiences, measurable goals, and a minimum of three recommended social media strategies and tactics to reach the identified goals. This paper builds on previously reported initial results for 60 projects conducted over several years. Nine clients were selected to participate in the iterative follow-up process, where new student teams conducted client interviews, reviewed the initial plans, and analyzed metrics from the social media strategies and tactics already in place to provide updated, improved artifacts. Using ABET computing learning objectives as a basis, clients reviewed the student teams and the artifacts created. Students also reflected on their experiences. This research provides a longitudinal study of the impact of the interventions in increasing implementation and sustained use rates of computing artifacts developed through service learning, along with lessons learned. Both students and clients reported high satisfaction levels, and clients were particularly satisfied with the iterative improvement process. This research demonstrates an innovative practice for creating and maintaining computing artifacts through iterative service learning, while addressing the resource constraints of small rural organizations.