Your Office
Getting Started with Advanced Problem Solving Cases
Paperback Engels 2017 1e druk 9780134480954Samenvatting
This book is the perfect complement to the Excel or Access Comprehensive texts, particularly for instructors looking for more complex, real world cases for students to work through. Included are 15 total cases (6 Excel, 6 Access, and 3 integrated).
Real world problem solving for business and beyond
The Your Office series prepares students to use both technical and soft skills in the real world. Hands-on technical content is woven into realistic business scenarios and focuses on using Microsoft Office® as a decision-making tool. The series features a unique running business scenario that connects all of the cases together and exposes students to using Office to solve problems relating to business areas like finance and accounting, production and operations, sales and marketing.
Each chapter introduces a realistic business case for students to complete via hands-on steps that are easily identified in blue shaded boxes. Each blue box teaches a skill and comes complete with video and interactive support. Chapters are grouped into Business Units, which collectively illustrate a specific set of business concepts to achieve AACSB-related outcomes. Each Business Unit ends with a Capstone section, testing students' ability to apply concepts and skills beyond a single chapter.
Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.
Specificaties
Lezersrecensies
Inhoudsopgave
Excel Case 1: Creating Spreadsheet Models to Support Decisions
Understanding Spreadsheet Models
The Basic Components of Spreadsheet ModelsCreating Spreadsheet Models to Support Decisions
The Basic Design Principles of Spreadsheet Models
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 BusinessEvaluating 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 HeuristicsEvaluating the Risk of Healthcare Plan Pricing
Controlling for Conditions of Uncertainty
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 InputsDetermining Economic Order Quantity and Optimal Product Mix to Maximize Profits
Calculating a Reorder Point with Uncertain Demand
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 AnalysisCreating and Analyzing a Financial Business Plan
Calculating NPV and IRR
Depreciating Assets
Applying Basic Statistical Methods and Using Descriptive Statistical Analysis
Applying Probability Distributions and Finding Data Relationships
Loan AnalysisBusiness Background
NPV Analysis
Depreciation Expense
Statistical Analysis
Data Relationships
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 ForcesIdentify Business Trends and Visualize Data with Dashboards
Porter’s Four Competitive Strategies
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 ModelsManaging 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
Developing a Phone AppThe Planning Phase
The Analysis Phase
The Design Phase
The Implementation Phase
The Support Phase
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
</
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan