Your Office

Amy S. Kinser, Esq., Series EditorAmy holds a B.A. degree in Chemistry with a Business minor from Indiana University, and a J.D. from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past 15 years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University. She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.  J. Eric KinserEric Kinser received his B.S. degree in Biology from Indiana University and his M.S. in Counseling and Education from the Indiana School of Education. He has worked in the medical field and in higher education as a technology and decision support specialist. He is currently a senior lecturer in the Operations and Decision Technology Department at the Kelley School of Business at Indiana University. When not teaching he enjoys experimenting with new technologies, traveling, and hiking with his family. Jennifer Nightingale MassartJennifer Nightingale Massart, associate professor at Slippery Rock University, has taught Information Systems Management since 2000. Before entering academia, she spent 15 years in industry with a focus in management and training. Her research expertise is in instructional technology, using technology as a teaching tool, and the impact of instructional technologies on student learning. She has earned numerous teaching and research honors and awards, holds an Ed.D. (instructional technology) and two M.S. degrees (information systems management and education) from Duquesne University, and has a B.A. from the University of Pittsburg. She lives in the suburbs north of Pittsburg with her husband, Chuck, and cat, Allie.

• EXCEL Excel Case 1: Creating Spreadsheet Models to Support Decisions Understanding Spreadsheet Models The Basic Components of Spreadsheet Models The Basic Design Principles of Spreadsheet Models Creating Spreadsheet Models to Support Decisions Business Background Business Requirements Provided File Analysis Questions Deliverables Case Checklist Key Terms Excel Case 2: Evaluating a Plan of Action with a Decision Support System Understanding Decision Support Systems Decision Making in Business Evaluating a Plan of Action with a Decision Support System Business Background Business Requirements Provided Files Analysis Questions Deliverables Case Checklist Key Terms Excel Case 3: Excel Simulation with Sensitivity and Risk Analysis Understanding Simulation with Sensitivity and Risk Analysis Decision Making with Heuristics Controlling for Conditions of Uncertainty Evaluating the Risk of Healthcare Plan Pricing Business Background Business Requirements Provided File Analysis Questions Deliverables Case Checklist Key Terms Excel Case 4: Determining Economic Order Quantity and Optimal Product Mix to Maximize Profits Understanding Economic Order Quantity (EOQ) EOQ Formula Inputs Calculating a Reorder Point with Uncertain Demand Determining Economic Order Quantity and Optimal Product Mix to Maximize Profits Business Background Business Requirements Provided File Analysis Questions Deliverables Case Checklist Key Terms Excel Case 5: Creating and Analyzing a Financial Business Plan Analyzing Loan Options and Business Statistics Constructing a Loan Analysis Calculating NPV and IRR Depreciating Assets Applying Basic Statistical Methods and Using Descriptive Statistical Analysis Applying Probability Distributions and Finding Data Relationships Creating and Analyzing a Financial Business Plan Loan Analysis NPV Analysis Depreciation Expense Statistical Analysis Data Relationships Business Background Business Requirements Provided File Analysis Questions Deliverables Case Checklist Key Terms Excel Case 6: Identify Business Trends and Visualize Data with Dashboards Determining a Competitive Strategy Porter’s Five Forces Porter’s Four Competitive Strategies Identify Business Trends and Visualize Data with Dashboards Business Background Business Requirements Provided File Analysis Questions Deliverables Case Checklist Key Terms ACCESS Access Case 1: Examining Business Model Classifications Understanding Business Models The Most Common Business Models Managing Inventory Using E-Commerce Business Background Business Requirements Provided Files Analysis Questions Deliverables Case Checklist Key Terms Access Case 2: System Development Life Cycle Basics & Determining Business Requirements Understanding the Systems Development Life Cycle Phases of the SDLC The Planning Phase The Analysis Phase The Design Phase The Implementation Phase The Support Phase Developing a Phone App Business Background Business Requirements Provided Files Analysis Questions Deliverables Case Checklist Key Terms Access Case 3: Anticipating and Answering Business Questions with Advanced Queries Using Advanced Queries to Provide Business Information Grouping Data with Aggregate Queries Creating Subqueries Using the Query Wizards for Advanced Queries Using Action Queries in a Database </