About the Courseware

Pages: 1,192 | Copyright: 2017

Author(s): Nita Rutkosky, Pierce College Puyallup; Audrey Roggenkamp, Pierce College Puyallup; and Ian Rutkosky, Pierce College Puyallup

Benchmark Series: Microsoft® Office 2016 is designed for students who want to learn how to use the new version of Microsoft's popular suite to enhance their productivity at school, work, and home. Throughout this text, students are expected to develop and execute strategies for solving information processing and management problems using Word 2016; for solving numeric and mathematical problems using Excel 2016; for organizing, querying, and retrieving data using Access 2016; and for writing, creating, and producing presentations using PowerPoint 2016.

Order today
View table of contents

Table of Contents

Word 2016

Unit 1. Editing and Formatting Documents

1. Preparing Documents

2. Formatting Characters and Paragraphs

3. Customizing Paragraphs

4. Formatting Pages

Unit 1 Performance Assessment

Word 2016

Unit 2. Enhancing and Customizing Documents

5. Applying, Formatting, and Inserting Objectives

6. Maintaining Documents

7. Creating Tables and SmartArt

8. Merging Documents

Unit 2 Performance Assessment

Excel 2016

Unit 1. Preparing and Formatting a Worksheet

1. Preparing an Excel Workbook

2. Inserting Formulas in a Worksheet

3. Formatting an Excel Worksheet

4. Enhancing a Worksheet

Unit 1 Performance Assessment

Excel 2016

Unit 2. Enhancing the Display of Workbooks

5. Moving Data within and between Workbooks

6. Maintaining Workbooks

7. Creating Charts and Inserting Formulas

8. Adding Visual Interest to Workbooks

Unit 2 Performance Assessment

Access 2016

Unit 1. Creating Tables and Queries

1. Managing and Creating Tables

2. Creating Relationships between Tables

3. Performing Queries

4. Creating and Modifying Tables in Design View

Unit 1 Performance Assessment

Access 2016

Unit 2. Creating Forms and Reports

5. Creating Forms

6. Creating Reports and Mailing Labels

7. Modifying, Filtering, and Viewing Data

8. Importing and Exporting Data

Unit 2 Performance Assessment

PowerPoint 2016

Unit 1. Creating and Formatting PowerPoint Presentations

1. Preparing a PowerPoint Presentation

2. Modifying a Presentation and Using Help

3. Formatting Slides

4. Inserting Elements in Slides

Unit 1 Performance Assessment

PowerPoint 2016

Unit 2. Customizing and Enhancing PowerPoint Presentations

5. Creating Tables, Charts, and SmartArt Graphics

6. Using Slide Masters and Action Buttons

7. Applying Custom Animation and Setting Up Shows

8. Integrating, Sharing, and Protecting Presentations

Unit 2 Performance Assessment

Courseware Features

After successfully completing a course using this textbook and digital courseware, students will be able to:

  • Analyze, synthesize, and evaluate school, work, or home information processing needs and use application software to meet those needs efficiently and effectively.
  • Create, design, and produce professional documents using word processing software.
  • Process, manipulate, and represent numeric data using spreadsheet software.
  • Plan, structure, and create databases for efficient data access and retrieval using database software.
  • Design and create informational and motivational slide shows that contain hyperlinks, tables, images, and animation using presentation software.
  • Learn strategies for merging and integrating source data from different applications.

Upon completing the text, students can expect to be proficient in using the major applications of the Office 2016 suite to organize, analyze, and present information.

SNAP 2016

SNAP is a web-based training and assessment platform that accelerates student success in Microsoft Office. Students get real-world experience working directly in the Microsoft software and instructors get a suite of powerful tools at their fingertips. Through real-time analytics, instructors get instant performance insight on their students' work, and students can identify their challenges to define their own individual learning paths to success.

Preview SNAP
SNAP features
  • Precheck quizzes test students' knowledge of the chapter content before they study the material. Students can use the results to help focus their study on the skills they need to learn.
  • Tutorials guide students through the steps for the skills and then allow them to practice on their own. These interactive tutorials include simple instructions and optional help.
  • Preview images show how students' file should look when they have completed each chapter, skill, review exercise, or assessment.
  • Recheck quizzes at the end of each chapter enable students to recheck their understanding of the chapter content.
  • The Workbook ebook provides study resources (such as presentations with audio support, study notes, and tips & hints), review exercises, and assessments to help reinforce students' understanding of the concepts, features, and skills covered in the textbook.