Higher Education

Microsoft® Office 2010 Certification Prep, 1st Edition

  • Laura Story
  • Dawna Walls
  • ISBN-10: 113319107X  |  ISBN-13: 9781133191070
  • 576 Pages
  • © 2012 | Published
  • College Bookstore Wholesale Price = $115.50
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.

About

Overview

MICROSOFT OFFICE 2010 CERTIFICATION PREP: MICROSOFT OFFICE SPECIALIST 2010 fully prepares students to take any of the Microsoft Office Specialist (MOS) 2010 certification exams. The text fully maps to all of the exam objectives for the Specialist level MOS certification for Word, Excel, Access, PowerPoint and Outlook as well as the Expert level exams for Word and Excel giving students the skills they need to pass the certification exams. If you want to prepare your students to pass the MOS 2010 certification exams or if you want to give your students an overview of widely used skills within each application, this text is the perfect fit for your course.

Features and Benefits

  • Updated to map to the MOS 2010 certification exams for Word, Excel, Access, PowerPoint and Outlook 2010.
  • Full color screenshots and icons provide visual reinforcement of the skills being covered.
  • End of Lesson material will appear at the end of each Objective section and will map to 100% of the exam objectives for each application.
  • Hands-on exercises include Review Questions, Projects, and Critical Thinking activities.
  • Exam Tips appendix provides background information about the MOS 2010 program, general process for taking the certification exams, and helpful hints for successfully passing the exams.

Table of Contents

Microsoft Office Word 2010 Exam Reference.
WORD GETTING STARTED.
Word Core Objective 1: Sharing and Maintaining Documents .
Word Core Objective 2: Formatting Content .
Word Core Objective 3” Applying Page Layout and Reusable Content.
Word Core Objective 4: Including Illustrations and Graphics in a Document.
Word Core Objective 5: Proofreading Documents.
Word Core Objective 6: Applying References and Hyperlinks.
Word Core Objective 7: Performing Mail Merge Operations.
Word Expert Objective 1: Sharing and Maintaining Documents.
Word Expert Objective 2: Formatting Content.
Word Expert Objective 3: Tracking and Referencing Documents.
Word Expert Objective 4: Performing Mail Merge Operations.
Word Expert Objective 5: Managing Macros and Forms.
Microsoft Office Excel 2010 Exam Reference.
EXCEL GETTING STARTED.
Excel Core Objective 1: Managing the Worksheet Environment.
Excel Core Objective 2 Creating Cell Data.
Excel Core Objective 3: Formatting Cells and Worksheets.
Excel Core Objective 4: Managing Worksheets and Workbooks.
Excel Core Objective 5: Applying Formulas and Functions.
Excel Core Objective 6: Presenting Data Visually.
Excel Core Objective 7: Sharing Worksheet Data with other users.
Excel Core Objective 8: Analyzing and Organizing Data.
Excel Expert Objective 1: Sharing and Maintaining Workbooks.
Excel Expert Objective 2: Applying Formulas and Functions.
Excel Expert Objective 3: Presenting Data Visually.
Excel Expert Objective 4: Working with Macros and Forms.
Microsoft Office Access 2010 Exam Reference.
ACCESS GETTING STARTED.
Access Objective 1: Managing the Access Environment .
Access Objective 2: Building Tables .
Access Objective 3: Building Forms .
Access Objective 4: Creating and Managing Queries.
Access Objective 5: Designing Reports.
Microsoft Office PowerPoint 2010 Exam Reference.
POWERPOINT GETTING STARTED.
PowerPoint Objective 1: Managing the PowerPoint Environment.
PowerPoint Objective 2: Creating a Slide Presentation.
PowerPoint Objective 3: Working with Graphical and Multimedia Elements.
PowerPoint Objective 4: Creating Charts and Tables.
PowerPoint Objective 5: Applying Transitions and Animations.
PowerPoint Objective 6: Collaborating on Presentations.
PowerPoint Objective 7: Preparing Presentations for Delivery.
PowerPoint Objective 8: Delivering Presentations.
Microsoft Office Outlook 2010 Exam Reference.
OUTLOOK GETTING STARTED.
Outlook Objective 1: Managing the Outlook Environment.
Outlook Objective 2: Creating and Formatting Item Content.
Outlook Objective 3: Managing Email Messages.
Outlook Objective 4: Managing Contacts.
Outlook Objective 5: Managing Calendar Objects.
Outlook Objective 6: Working with Tasks, Notes, and Journal Entries.
Windows 7 Appendix.
Exam Tips.

What's New

  • Each application is broken down into numerous Exam Objectives so it’s easy to see which skills correlate to each exam objective as you work through each unit.

Supplements

All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

Instructor's Resource CD-ROM  (ISBN-10: 1133191061 | ISBN-13: 9781133191063)

Instructor Resources help you make the most of your classroom and lessons. Here you will find additional information on how to use our text as well as teaching and testing aids. Data and Solution Files for the Step-by-Steps and Projects conveniently located within your course can be accessed for immediate use. Answer keys with solutions to the end-of-lesson and unit review questions. Solutions to Exercises for all end-of-lesson and lesson reinforcement exercises. Rubrics and Annotated Solution Files that assist you in quick and consistent grading for student assignments. Critical Thinking solution files that show possible solutions for critical thinking activities for easy grading. Electronic Figure Files Illustrations, both with and without callouts, to help you customize handouts and presentations for your students. ExamView test banks with true/false, modified true/false, multiple choice, completion, matching, case-based critical thinking, and essay question types to help students gain confidence in the material learned through additional practice. Instructor’s Manual complete with lecture notes summarizing the lessons sections, figures and boxed elements found in every lesson, teacher tips, and classroom & lab activities. This Instructor’s Manual will provide you with all the resources you need to teach your course with efficiency and effectiveness while also giving you insight on how to fully engage your students. Easily Customizable PowerPoint Lecture Presentations that provide slides on key concepts and terms from each lesson along with an outline discussing lesson objectives in your class. This handy PowerPoint feature will help you save a great deal of time in preparation for each class lecture. Customizable Sample syllabus with block, two-quarter, and 18-week schedules to help you design your course from beginning to end with ease and convenience.

Review Pack  (ISBN-10: 1133274358 | ISBN-13: 9781133274353)

All data files necessary to complete chapter projects are conveniently located on this CD for students who do not have reliable internet access.

List Price = $12.95  | CengageBrain Price = $12.95  | College Bookstore Wholesale Price = $9.50

Student Supplements

Review Pack  (ISBN-10: 1133274358 | ISBN-13: 9781133274353)

All data files necessary to complete chapter projects are conveniently located on this CD for students who do not have reliable internet access.

List Price = $12.95  | CengageBrain Price = $12.95  | College Bookstore Wholesale Price = $9.50

Meet the Author

Author Bio

Laura Story

Laura Story and Dawna Walls, both graduates of Texas Tech University, have co authored three books together for Course Technology and have collaborated on dozens of other writing and editing projects during the past two decades, including software textbooks, user's guides, tutorials, i-manuals, site documentation, training material, and supplements. With similar backgrounds in technical writing, Web development, computer education, and the IT industry, they bring a breadth of experience and expertise to the teaching process.

Dawna Walls

Laura Story and Dawna Walls, both graduates of Texas Tech University, have co authored three books together for Course Technology and have collaborated on dozens of other writing and editing projects during the past two decades, including software textbooks, user's guides, tutorials, i-manuals, site documentation, training material, and supplements. With similar backgrounds in technical writing, Web development, computer education, and the IT industry, they bring a breadth of experience and expertise to the teaching process.