Request for consultation
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.
- 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.
- 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.
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.
Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.
Instructor's Resource CD-ROM
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.