2014 ISECON Proceedings
Baltimore, Maryland

Paper Titles | Authors | Tracks | Best Papers | Abstracts | Panels | Teaching Cases
Workshops Lead By Academic Professionals | Workshops Lead by Industry Professionals
Conference Highlights / Program

Teaching Case Presentations

Anthony Serapiglia
St. Vincent College

Cameron Lawrence
University of Montana

(ordered by presentation time)

USMCo Payroll System

Katrina Cohill
Miami University

Danielle Dudley
Miami University

Jason Gregg
Miami University

Elizabeth Millette
Miami University

Adam Zinnecker
Miami University

Douglas Havelka
Miami University

Thursday - 11/6/2014 in Lock Haven 2 at 2:30 p.m.

The General Manager, Steve Gunderson, is currently charged with leading the decision on whether to outsource the payroll function of the USMCo (UltraSonic Machining Co) organization or to purchase a system and hire a full-time, experienced payroll staff member to manage the details of payroll for the company. There are differing opinions of stakeholders in the business units, and a staff member could lose their job. The objective USMCo is trying to meet is to have a payroll system that works correctly, minimize risk of entering wrong information, reduce the costs of running the payroll processes, and provide more time to the current HR staff for their more impending duties. Financial services and HR have differing views on the solution based on their desired outcome and needs. Steve has the goal of streamlining processes and making sense of the business objectives.

Coastal Pacific Doctor Associates: Implementation of a Purchased System

Dana Schwieger
Southeast Missouri State

Michael McDonald
Western Kentucky University

Saturday - 11/8/2014 in Lock Haven 2 at 9:00 a.m.

Coastal Pacific Doctor Associates (CPDA) is a multi-physician medical practice located along the west coast. CPDA decided to replace their inadequate and outdated medical office system during a time of tremendous restructuring in the medical software industry. In their impatience, CPDA chose an electronic medical record (EMR) and practice management (PM) system that would better accommodate the needs of a hospital rather than a medical clinic. The system that they chose to purchase was under development and had not been fully tested before it was hurriedly installed as CPDA’s main system during a cutover implementation. EMR/PM software representatives failed to live up to their original promises as deadlines passed and the employees were trained in the last days before the go live date. Training took place on a portable network brought in by the sales representatives using manufacturer’s test data. After the problems started to escalate, the manufacturer’s help line stopped providing assistance and CPDA was left to solve its own problems. The organization in this case faces a number of project management and technology implementation issues. These issues can be addressed in multiple courses including: enterprise architecture, project management, systems analysis and design as well as systems implementation.

Slushie World: An In-Class Access Database Tutorial

Donald Wynn
University of Dayton

Renee Pratt
Washington and Lee University

Saturday - 11/8/2014 in Camden at 3:45 p.m.

The Slushie World case study is designed to teach the basics of Microsoft Access and database management over a series of three 75-minute class sessions. Students are asked to build a basic database to track sales and inventory for a small business. Skills to be learned include table creation, data entry and importing, form and report design, switchboards, and numerous single and multiple table query designs. The resulting application is sufficient for students to identify a number of basic functions available to the small business, including order entry, sales reports, customer information, and more. The case is designed to be used in a course where the students have little or no prior relational database experience, such as an Introduction to MIS course.

Information Security in a World of Global Connectivity: A Case Study

Cameron Lawrence
University of Montana

Garrett Olson
University of Montana

Bambi Douma
University of Montana

Saturday - 11/8/2014 in Lock Haven 2 at 3:45 p.m.

The widespread use of digital technologies such as smartphones, tablets, and notebook computers expose firms engaged in international business to risks that far exceed what most corporate technology users understand. This case study examines some of the technology-specific vulnerabilities managers face when engaged in international travel and introduces tools and technologies including HTTPS, two-factor authentication, VPNs and the use and management of complex passwords. The case concludes with a set of discussion questions and hands-on exercises that can be completed in or out of class. This case is intended for the Intro to MIS class and complements the model curriculum objectives in IS 2010.1 and IS 2010.7.

The Cocoa Shop: A Database Management Case Project

Renee Pratt
Washington and Lee University

Cindi Smatt
University of North Georgia

Saturday - 11/8/2014 in Camden at 4:15 p.m.

This is an example of a real-world applicable case study, which includes background information on a small local business (i.e., TCS), description of functional business requirements, and sample data. Students are asked to design and develop a database to improve the management of the company’s customers, products, and purchases by emphasizing effective business rules and professional database development. In addition, this case will explore the benefits of working with MS Access, data population, creation and development of forms, queries, reports and a switchboard to complete the requirements express by TCS. This case can be used in a course where the students have little or no prior relational database experience, as well as a more intermediate/advance level of experience. Teaching notes containing suggested guidelines, deliverables, and the resulting database containing data, forms, queries, reports, and switchboard are provided upon request. These teaching notes contain suggested target courses in which to use the case, specific learning objectives, associated information systems and database theory, suggested implementation guidelines and rubrics, a possible entity-relationship model, the resulting physical database structures, and the solution to the forms, queries, reports, and switchboard.