Best Seller!

The Office Specialist.com, 2E

A Real-world, Client-based Document Production Simulation

Prepares students for Microsoft Office Specialist (MOS) Associate Certification in Word, Excel,
and PowerPoint 2016, 2019, and 365

The Perfect Resource to Pair with Our Learn-by-Doing Series

 video Watch Textbook Video Overview  
2016, 2019 & 365
Description

3 real-world simulations in 1 book, with computer applications projects preparing students for Microsoft Office Specialist (MOS) Associate Certification in Word, Excel, and PowerPoint 2016, 2019, and 365.

 

The Office Specialist.com, 2E challenges students to practice and master essential skills in preparation for success on the MOS Associate Certification Exam in Word, Excel, and PowerPoint 2016, 2019, and 365. The hands-on projects in this text helping students hone their proficiency in these key workplace applications make it the perfect resource to pair with the step-by-step instructions in our Learn-by-Doing Series.

 

Across over 65 projects, students will demonstrate mastery of the MOS Certification Exam skills as they plan and create professionally-designed word processing documents, spreadsheets, and presentations. The same essential skills students develop preparing for MOS certification will also help them succeed in the workplace and beyond. In The Office Specialist.com, 2E, students get a taste of the business world as they complete work orders for three new clients: an indoor sports facility, a pet daycare service, and a café. Whether formatting a menu, creating an order form, or developing a presentation about fitness classes, students will love the engaging projects in this simulation.

 

The Office Specliast.com, 2E is endorsed by Certiport, the leading provider of certification exams.

Features
  • Over 65 projects to practice and master skills in Microsoft Word, Excel, and PowerPoint
  • Aligned to the Microsoft Office Specialist Associate Certification Exam skills in 2016, 2019, and 365
  • Client logos and resource files help students create professionally-designed documents
  • Online Instructor Resources include Project Source Files, Answer Keys, and Grading Rubrics
Table of Contents

Curriculum Guide

 

Part 1: Microsoft Word

1.1 Ranch Services | Creating Your First Document

1.2 Mission Statement | Customizing Views

1.3 Fall Soccer Registration | Creating a Poster

1.4 Who’s Your Owner? | Working with Headers and Footers

1.5 The Daily Grind | Creating Lists

1.6 Safety First | Formatting Lists

1.7 Your New Best Friend | Inspecting a Document

1.8 Camps and Clinics Announcement | Working with Text Boxes

1.9 Raffle Contest Letter | Creating a Block Style Letter

1.10 Homesick Hound Letter | Formatting a Block Style Letter

1.11 Wi-Fi Access Sign | Designing a Sign

1.12 The Barkery Grand Opening | Designing an Advertisement

1.13 Client Agreement | Working with Signature Lines

1.14 Concussion Report | Creating an MLA Style Report

1.15 Pet Adoption Report | Formatting an MLA Style Report

1.16 Customer Loyalty Card | Working with SmartArt

1.17 Liability Waiver | Working with Footnotes and Endnotes

1.18 Training Certificate | Using Templates

1.19 Puppy Profile Form | Working with Page Breaks

1.20 What’s Brewin’? | Creating a Newsletter

1.21 Fundraising Steps | Creating a Memo

1.22 Common Issues Memo | Formatting a Memo

1.23 Soccer Player Registration | Formatting a Table of Contents

1.24 Everything You Need to Know | Working with Bookmarks

 

Part 2: Microsoft Excel

2.1 Our Pack | Creating Your First Workbook

2.2 Equipment List | Working with Named Ranges and Views

2.3 Player 411 | Printing Part of a Worksheet

2.4 Daycare Daily Schedule | Working with Cells

2.5 House Music Playlist | Working with Multiple Worksheets

2.6 Pack It Up | Viewing Data

2.7 Accounts Receivable Journal | Formatting Data

2.8 Customer Order Form | Working with Text Boxes, Images & Shapes

2.9 Doggie Report Card | Modifying Page Setup

2.10 Checkbook Register | Displaying Formulas

2.11 Projected Gross Sales | Creating Tables

2.12 Expense Report | Performing Calculations Using SUM

2.13 Referee Referral | Formatting Text

2.14 Doggie Data | Importing Data

2.15 Supplier Database | Working with Page Breaks & Themes

2.16 Order History | Performing More Calculations

2.17 How Are We Doing? | Performing Logical Operations

2.18 Doggie Drive | Outlining Data

2.19 Trophy Order Form | Inspecting Workbooks

2.20 Daily Sales Record | Apply Conditional Formatting

2.21 Sales Forecast | Creating Charts

2.22 Building Occupancy Trends | Inserting Sparklines

2.23 Combination Meal Nutrition | Analyzing Data

2.24 Profit and Loss Budget | Formatting Charts

2.25 Tournament Standings | Modifying Charts

 

Part 3: Microsoft PowerPoint

3.1 Meet Our Breeds | Creating Your First Presentation

3.2 Event Schedule | Formatting Text

3.3 Nutrition Class | Applying Transitions

3.4 Let’s Go Outside | Printing a Presentation

3.5 App Design | Creating a Wireframe Presentation

3.6 Sports Complex Map | Working with Images

3.7 Agility Course Design | Applying Animation

3.8 Make Your Own Hot Cocoa Bar | Formatting SmartArt

3.9 Be Careful | Printing Notes and Handouts

3.10 Puppy Cam | Working with Comments

3.11 Pastry Chef Profile | Saving a Presentation As a Video

3.12 Entrepreneurship Expo | Presenting a Slide Show

3.13 Fitness Class Schedule | Creating Tables

3.14 Menu | Rehearsing a Presentation

3.15 Pet Care Check | Modifying Slide Order

3.16 Latte Art | Working with Multiple Presentations

3.17 Trampoline Park Investors | Formatting the Slide Masters

3.18 Franchise Pitch | Using Templates

3.19 Name That Coffee | Formatting Charts

FREE Online Instructor and Student Resources

The Free Online Instructor and Student Resources for The Office Specialist.com, 2E are housed on eReadiness.com.

Online Instructor and Student Resources Include:

  • Project Source Files
    • Application source files offer instructors the option to conserve class time spent keying each project's text and data, or to require students to key for additional practice.
  • Project Key Files
  • Project Grading Rubrics
    • Grading Rubrics are specific to each project and facilitate assessing student's finished work and mastery of MOS Certification skills.
  • Student Resource Files
    • Client logos, graphic images, and supplemental files (Word, Excel, PowerPoint, .txt, .pdf, etc.) provide students the resources they need to complete complex and realistic projects.
sources for this textbook are housed on our interactive digital eLearning platform, eCTE
Resources for this textbook are housed on our interactive digital eLearning platform, eCTE
Resources for this textbook are housed on our interactive digital eLearning platform, eCTE
Resources for this textbook are housed on our interactive digital eLearning platform, eCTE

Resources for this textbook are housed on our interactive digital eLearning platform, eCTE

 

Online Instructor and Student Resources (Required) Include:

Resources for this textbook are housed on our interactive digital eLearning platform, eCTE

 

Online Instructor and Student Resources (Required) Include:

Resources for this textbook are housed on our interactive digital eLearning platform, eCTE

 

Online Instructor and Student Resources (Required) Include:

  • Teacher Edition eText (5 Year License)
MOS Certification Information
The Office Specialist.com, 2E is designed to be used as practice and mastery of the skills assessed in the Microsoft Office Specialist Associate Certification Exams in Microsoft Word, Excel, and PowerPoint (2016, 2019, and 365). MOS is an industry-leading certification powered by Certiport allowing students to demonstrate their mastery of the key functions of Microsoft applications for future success in the classroom and the workplace.

 

The Office Specialist.com, 2E is endorsed by Certiport as preparation for Microsoft Office Specialist Associate Certification. This following correlations list the projects in which each exam skill is practiced. Since skills appear in multiple projects, correlations can be used to help students focus on specific skills for extra practice or preparing for MOS Certification.

 

eTextbook License Information

Transferable eTextbook Student License: One license is required per student per term within a given school year. Once a term is completed, licenses can be reused. The number of licenses required is equal to the maximum number of students using an eTextbook within one term. See example below:

Example to Determine Number of eTextbook Licenses Required
  Semester 1
Student Enrollment
Semester 2
Student Enrollment
eTextbook Licenses
Required
Course A 60 30 60
Course B 90 90 90

Minimum: A minimum purchase of 15 licenses is required.

Term: Licenses are valid for 5 years (transferable term to term).

Instructor Resources: Included FREE for unlimited number of instructors; 5-year access.

Format/Delivery: eTextbook is delivered in PDF format. The eTextbook and student/instructor resources can be uploaded to any LMS or accessed through eReadiness.com.

License Pricing: Pricing is determined by the number of licenses purchased. If the number of licenses you require exceeds the quantity displayed, call or email for volume pricing.

Specifications

Grade: 6-8, 9-12

The Office Specialist, 2E (Print) - Min. 15
ISBN: 9781626892514
Author: The Development Team at B.E. Publishing and Joy Tavano
© 2019
Size: 8.5" x 11"
Page Count: 336
Print Color: Full Color
Binding: Spiral Bound

The Office Specialist.com, 2E (eTextbook 5 Yr. Student License) - Min. 15
ISBN: 9781626896512
Author: The Development Team at B.E. Publishing and Joy Tavano
© 2019
Page Count: 336
Print Color: Full Color

Purchase Options

Item # Item Name ISBN Qty. Unit Price Total
TB-TOS2E-WB The Office Specialist, 2E (Print) - Min. 15 9781626892514 $94.95
TB-TOS2E-ET The Office Specialist.com, 2E (eTextbook 5 Yr. Student License) - Min. 15 Call or email for volume pricing. 9781626896512 $56.95
Order More & Save: Qty. of 15-49 $56.95 ea.
Qty. of 50-99 $48.95 ea.
Qty. of 100+

Call or email for volume pricing.
$37.95 ea.
Product Total: $0.00