Your Office

Amy S. Kinser, Esq., Series Editor Amy 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 Kinser Eric 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 Massart Jennifer 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