Your Office: Microsoft Office 2016 Volume 1, 1st edition

Published by Pearson (January 14, 2016) © 2017

  • Amy S. Kinser Indiana University
  • Kristyn Jacobson
  • Eric Kinser Indiana University
  • Diane Kosharek Madison College
  • Brant Moriarity

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.
  • The real world focus reminds students that what they’re learning is practical and useful the minute they leave the classroom.
    • Real World Success features in the chapter opener share anecdotes from real former students, describing how knowledge of Office has helped them get ahead or be successful in their lives.
    • Real World Advice box offers notes on best practices for general use of important Office skills. The goal is to advise students as a manager might in a future job.
    • Business Application Icons appear with every case in the text and clearly identify which business application students are being exposed to, i.e., Finance, Marketing, Operations, etc.
    • Real World Interview Video icons appear with the Real World Success Story in the Business Unit and feature a real business person discussing how he or she actually uses the skills in the chapter on a day-to-day basis.
  •   NEW! MOS Appendix  in the book provides mapping of the content to 2016 MOS objectives.

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.

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 projects in MyITLab and offered with Read & Watch remediation assets to provide a more personalized learning experience for students.
  • NEW! Business Unit openers emphasize 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.

Windows
    Chapter 1: Understanding the Common Features of Microsoft Office

Common Features
    Chapter 1: Explore Windows and File Management

Word
Word Business Unit 1: Understanding Business Documents
    Chapter 1: Review and Modify a Document
    Chapter 2: Create and Edit a Document
Word Business Unit 1 CAPSTONE
Word Business Unit 2: Impressing with Sophisticated Documents
    Chapter 3: Include Tables and Objects
    Chapter 4: Special Document Formatting and Mail Merge
Word Business Unit 2 CAPSTONE

Excel
Excel Business Unit 1: Understanding the Fundamentals
    Chapter 1: Create, Navigate, Work With, and Print Worksheets
    Chapter 2: Formats, Functions, and Formulas
Excel Business Unit 1 CAPSTONE
Excel Business Unit 2: Conducting Business Analysis
    Chapter 3: Cell References, Named Ranges, and Functions
    Chapter 4: Effective Charts
Excel Business Unit 2 CAPSTONE

Access
Access Business Unit 1: Understanding and Using a Relational Database
    Chapter 1: The Four Main Database Objects
    Chapter 2: Tables, Keys, and Relationships
Access Business Unit 1 CAPSTONE
Access Business Unit 2: Accessing, Maintaining, and Presenting Information
    Chapter 3: Queries and Data Access
    Chapter 4: Using Forms and Reports in Access
Access Business Unit 2 CAPSTONE

PowerPoint
PowerPoint Business Unit 1: Understanding the Art of Presentation
    Chapter 1: Presentation Fundamentals
    Chapter 2: Text and Graphics
PowerPoint Business Unit 1 CAPSTONE
PowerPoint Business Unit 2: Collaborating and Invoking Emotion with the Audience
    Chapter 3: Multimedia and Motion
    Chapter 4: Customization and Collaboration
PowerPoint Business Unit 2 CAPSTONE
    Chapter 1: Word and Excel Integration
    Chapter 2: Word, Excel, and Access Integration
    Chapter 3: Word, Excel, Access, and PowerPoint Integration

Appendix
Glossary
Index

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.

Kristyn A. Jacobson

Kristyn holds an M.S. in Education from the University of Wisconsin-La Crosse and a B.S. in Business Education from the University of Wisconsin-Eau Claire. She has been a faculty member and department chair of the Business Technology department at Madison College in Madison, Wisconsin for over 14 years. She also serves as the curriculum coordinator for Microsoft Excel beginning, intermediate, and advanced level courses for the college. As well as teaching, Kristyn provides training to businesses on the Microsoft Office Suite including MS Project, project management, customer service, personal productivity, and time management. Prior to teaching at Madison College, she taught at a business college in Des Moines, Iowa where she helped implement their online learning program while also teaching traditional business courses.

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.

Diane L. Kosharek

Diane is a full-time Business Technology faculty member at Madison College in Madison, WI. In addition to her faculty role, she works closely with business and industry specialists, developing and delivering tailored training solutions to employees in areas such as customer service, software applications and business writing skills. Prior to joining Madison College, she worked as a Technology Training Consultant, providing consultation and production assistance to teaching faculty and staff to incorporate appropriate technology in their courses to enhance learning. Diane holds a Bachelor’s Degree in Education from the University of Wisconsin-Madison and a Master’s Degree in Educational Computing from Cardinal Stritch University.

Brant Moriarity

Brant P. Moriarity earned a B.A. in Religious Studies/Philosophy and a M.S. in Information Systems at Indiana University. He is a Senior Lecturer at the Indiana University’s Kelley School of Business where he teaches topics such as data management and analysis, as well as the strategic use of Information Systems in business. He is also the founder of Beats Per Minute Technologies, LLC, bringing the benefits of business analytics to small businesses and non-profit organizations.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle.Â