Teaching Tip: Active Learning via a Sample Database: The Case of Microsoft's Adventure Works

M. Mitri

2015-08-01

Abstract:1. INTRODUCTION This article presents Microsoft's Adventure Works (AW) business case and database as a pedagogical tool for providing many active learning opportunities to students in advanced database, business intelligence, and application development classes. The paper begins with a literature review of active learning (especially using cases) in IS pedagogy. It then argues that a case which includes an actual physical database (assuming the database is well designed and has a reasonably large volume of data) enhances the student experience with the case. After this, the Adventure Works case is described, followed by a description of the transaction database and the data warehouse of AW. Next comes a set of advanced active learning exercises that make use of AW's case and databases. These exercises include: 1. reverse engineering to a conceptual model from analysis of the database, 2. implementing security techniques in application development, 3. combining advanced SQL queries with XML queries, 4. balanced scorecard dashboard construction, 5. data integration, 6. online analytical processing (OLAP), 7. data mining, and 8. e-commerce application development. Finally, the paper discusses lessons learned using Adventure Works in two different advanced IS courses, and presents results from a student opinion survey of AW as a learning experience. 2. CAN DATABASES ENHANCE THE ACTIVE LEARNING CASE EXPERIENCE? The term "active learning" is very broad and has been defined in many ways. These definitions characteristically focus on student engagement and typically involve problem solving, discussion, and/or writing. The active learning we focus on in this paper is often called problem-based learning (Savery and Duffy, 1995). In terms of Bloom's hierarchy of skills (Bloom et al., 1956), problem-based learning tends to focus on applying, analyzing, evaluating, and creating over recall and understanding. This paper argues that use of Microsoft's Adventure Works case and database facilitates active learning experiences and fosters these higher-level skills, thereby bringing value to a technical IS curriculum. 2.1 Active Learning for Information Systems Pedagogy The importance and efficacy of active learning is well documented in the information systems pedagogy literature. Teaching techniques and projects in IS education include problem-based active learning experiences in e-Commerce (Abrahams and Singh, 2010; Gricar, Pucihar, and Lenart 2005), computer programming (Zhang et al., 2013), system implementation capstone projects (Mitri, 2008), role play exercises (Kerr, Troth, and Pickering, 2003; Mitri and Cole, 2007), and information security projects (He et al., 2014). In addition to traditional face-to-face classroom settings, active learning methods have also been used and tested in online environments (Koohang and Paliszkiewicz, 2013; Paetzold and Melby, 2008). Various software technologies facilitate the richness of the active learning experience. For example, He et al. (2014) use workflow technologies, and Williams and Chinn (2009) use Web 2.0.. This paper argues that Microsoft's SQL Server database engine combined with their Adventure Works sample database provides another fruitful technology for active learning, and presents several examples. Bonwell and Eisen (1991) cite a variety of active learning approaches, including cooperative learning, debates, drama, role playing, simulation, and peer teaching. They also cite methods of incorporating more student participation in lecture-format classes, including "feedback lectures" and "guided lectures." By contrast, Savery and Duffy (1995) focus on problem-based learning. Case studies (Christensen, 1981) and guided design (Wales and Stager, 1978) are two of the most popular instructional strategies for increasing problem solving skills in students. …

Computer Science,Business,Education