Your Office

Description

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.

 

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.

 

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.

 

Also available with MyITLab

MyITLab^® is an online homework and assessment program designed for Information Technology (IT) courses, to engage students and improve results. Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success.

 

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
</

About the Book

• The Outcomes focus allows students and instructors to know the higher level learning goals and how those are achieved through discreet objectives and skills.
• Outcomes are written at the course level and the Business Unit level.
• Chapter Objectives list identifies the learning objectives to be achieved as students work through the chapter. Page numbers are included for easy reference. These are revisited in the Concepts Check at the end of the chapter.
• MOS Certification Guide directs anyone interested in prepping for the Microsoft Office Specialist (MOS) exam to the specific series resources to find all content required for the test.
• Features for active learning help students learn by doing, and immerse them in the business world using Microsoft Office.
• Blue boxes represent the hands-on portion of the chapter and helps students quickly identify what steps they need to follow to complete the chapter Prepare Case. This is easily distinguishable from explanatory text by the blue shaded background.
• Starting and ending files appear before every case in the text. Starting Files identify exactly which Student Data Files are needed to complete each case. Ending Files are provided to show students the naming conventions they should use when saving their files. Each file icon is color coded by application.
• Side note conveys a brief tip or piece of information aligned visually with a step in the chapter, quickly providing key information to students completing that particular step.
• Consider This offers critical thinking questions and topics for discussion, set apart as a boxed feature, allowing students to step back from the project and think about the application of what they are learning and how these concepts might be used in the future.
• Soft Skills icons appear with other boxed features and identify specific places where students are being exposed to lessons on soft skills.
• Study aids help students review and retain the material so they can recall it at a moment’s notice.
• Quick Reference boxes summarize generic or alternative instructions on how to accomplish a task. This feature enables students to quickly find important skills.
• Concept Check review questions appear at the end of the chapter, which require students to demonstrate their understanding of the objectives.
• Visual Summary offers a review of the objectives learned in the chapter using images from the completed solution file, mapped to the chapter objectives with callouts and page references, so students can easily find the section of text to refer to for a refresher.
• MyITLab™ icons identify which cases from the book match those in MyITLab™.
• Blue Box Video icons appear with each Active Text box and identify the brief video, demonstrating how students should complete that portion of the Prepare Case.
• Extensive cases allow students to progress from a basic understanding of Office through to proficiency.
• Chapters all conclude with Practice, Problem Solve, and Perform Cases at the end of chapters to allow full mastery at the chapter level.  Alternative versions of each of these cases are available in Instructor Resources.
• Business Unit Capstones all include More Practice, Problem Solve, and Perform Cases that require students to synthesize objectives from the two previous chapters to extend their mastery of the content.  Alternative versions of each of these cases are available in Instructor Resources.
• More Grader Projects offered with this edition, which include Prepare cases as well as Problem Solve cases at both the chapter and business unit capstone levels.
• T

New to the Your Office Series:

• NEW! Grader-First is the new MyITLab approach for the Your Office series, providing everything instructors need to both train and assess students using live in the application Grader projects with built-in learning aids.
• NEW! Prepare Cases built as auto-graded Grader proejcts in MyITLab and offered with Read & Watch remediation assets to provide a more personalized learning experience for students.
• NEW! Business Unit openersemphasize the business concepts students learn in the chapters. These showcase the Real World Interview Videos & Real World Success features so students do not overlook them.
• NEW! Course-level and Chapter-level outcomes, aligned with AACSB requirements, are all identified in the Business Unit openers so students have a big picture overview of what they need to get from using this book.
• NEW! All new Problem Solve cases keep this book fresh and current.
• NEW! Critical thinking steps, added to the end of chapter and capstone cases, require students to answer objective questions by interpreting the data they are working with.
• NEW! Updated design includes wide screen images, similar to what students see on their own monitors.

 

Also available with MyITLab

MyITLab^® is an online homework and assessment program designed for Information Technology (IT) courses, to engage students and improve results. Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success.

 

Additional information

Dimensions	0.60 × 8.30 × 10.70 in
Series	Your Office for Office 2016 Series
Imprint	Pearson
Format	gen
ISBN-13	09780134480954
ISBN-10	0134480953
Author	Amy S. Kinser, Eric Kinser, Jennifer Paige Nightingale
Subjects	higher education, information technology, business and economics, IT / MIS, Computer Applications