MIS Cases: Solving Small Business Scenarios Using Application Software

Now in its second edition, this book provides twenty–two hands–on cases for use as a supplement to an Introduction to IS/MIS text. Designed to teach students about the use of database applications, spreadsheet applications, and web design via small business scenarios, the book′s approach to learning MS Office skills differs from every other casebook on the market. Instead of having students follow a formulaic problem–solving strategy, each problem in the book is context–based and forces students to think through the requirements of the particular small–business scenario. Built with a consistent pedagogical design, this applied thinking approach will prepare students to use MS Office in their careers as a tool for making business decisions.

The small business cases range from tracking business revenue within multiple stores to a restaurant remodel cost projection, a chiropractic office inventory andR client database, and many others.

This new second edition includes:

All cases updated to the 2010 version of Microsoft office. Discussion questions at the end of each case which challenge students′ critical thinking skills and encourage a higher level of analytical reasoning. Cases which explicitly correlate with key concepts taught in introductory MIS courses.

This book is revolutionary as it is the only book on the market to provide MS Office cases that foster critical thinking skills. Instead of giving students step–by–step instructions, it forces them to think through a strategy relevant to a particular, context–based problem. I′m looking forward to using this book in my course.
Elizabeth Baker, Wake Forest University

PART 1 DEVELOPING A DATABASE APPLICATION 1

CHAPTER 1 Access Tables and Forms 3

Case 1 Up the Hill Bakery 3

Case 2 Dr. Garrett s Chiropractic Office 10

Case 3 Home Town Realty 16

CHAPTER 2 Access Queries and Reports 24

Case 4 Up the Hill Bakery 24

Case 5 Earth Foods Grocery Store 33

Case 6 Destination Corporate Event

Planning, Inc. 40

CHAPTER 3 Access Advanced Queries and Reports 47

Case 7 Up the Hill Bakery 47

Case 8 Sun and Beach Clothing 55

Case 9 Just Breathe Yoga Center 62

PART 2 DEVELOPING A SPREADSHEET APPLICATION 79

CHAPTER 4 Excel Spreadsheet Basics 81

Case 10 Up the Hill Bakery 81

Case 11 Celebrations for Charity 87

Case 12 Dr. William Gardner s Dental Office 92

CHAPTER 5 Excel Intermediate Design Techniques 98

Case 13 Up the Hill Bakery 98

Case 14 JB Bike Rental 108

Case 15 Torero Tennis Team 114

CHAPTER 6 Excel Advanced Design Techniques 121

Case 16 Up the Hill Bakery 121

Case 17 Maxine s Travel Agency 131

Case 18 Thomas Paul Investment, Inc. 137

PART 3 DEVELOPING A WEBSITE APPLICATION 143

CHAPTER 7 Website Design 145

Case 19 Up the Hill Bakery 145

Case 20 Bella Spa 150

Case 21 Legends 153

Index 157