Description
For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.
The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom.
Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know. A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.
Table of Contents
| Contents |
| Windows 7 |
| Chapter One ¤ Getting Started with Windows 7 |
| Case Study: Cedar Cove Elementary School |
| Objectives |
| Windows 7 Fundamentals |
| Understanding the Desktop |
| Managing Windows |
| HANDS-ON EXERCI SE 1: |
| Windows 7 Fundamentals |
| Windows Programs and Security Features |
| Identifying Windows Accessories |
| Working with Security Settings and Software |
| HANDS-ON EXERCI SE 2: |
| Windows Programs and Security Features |
| WINDOWS SEARCH AND HELP |
| Performing a Search |
| Getting Help |
| HANDS-ON EXERCI SE 3: |
| Windows Search and Help |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Office Fundamentals and File Management |
| Chapter One ¤ Office Fundamentals and File Management |
| Case Study: Rails And Trails |
| Objectives |
| Files and Folders |
| Using Windows Explorer |
| Working with Folders and Files |
| Selecting, Copying, and Moving Multiple Files |
| and Folders |
| Hands-On Excercise 1: |
| Files and Folders |
| Microsoft Office Software |
| Identifying Common Interface Components |
| Getting Office Help |
| Hands-On Excercise 2: |
| Microsoft Office Software |
| Backstage View Tasks |
| Opening a File |
| Printing a File |
| Closing a File and Application |
| Hands-On Excercise 3: |
| Backstage View Tasks |
| Home Tab Tasks |
| Selecting and Editing Text |
| Using the Clipboard Group Tasks |
| Using the Editing Group Tasks |
| Hands-On Excercise 4: |
| Home Tab Tasks |
| Insert Tab Tasks |
| Inserting Objects |
| Review Tab Tasks |
| Reviewing a File |
| Page Layout Tab Tasks |
| Changing Page Settings |
| Hands-On Excercise 5: |
| Tasks on the Insert Tab, Page Layout Tab, and Review Tab |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Microsoft Office Word 2010 |
| Chapter One ¤ Introduction to Word |
| Case Study: First River Outfitter |
| Objectives |
| Introduction To Word Processing |
| Understanding How Word Processors Work |
| Customizing Word |
| Hands-On Excercise 1: |
| Introduction to Word Processing |
| Document Organization |
| Using Features That Improve Readability |
| Checking Spelling and Grammar |
| Displaying a Document in Different Views |
| Hands-On Excercise 2: |
| Document Organization |
| Finalize A Document |
| Preparing a Document for Distribution |
| Modifying Document Properties |
| Hands-On Excercise 3: |
| Finalize a Document |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Two ¤ Document Presentation |
| Case Study: Simserv-Pitka Enterprises |
| Objectives |
| Text Formatting Features |
| Applying Font Attributes Through the Font Dialog Box |
| Controlling Word Wrap |
| HAN DS-ON EXERCI SE 1: |
| Text Formatting Features |
| Paragraph Formatting Features |
| Setting Off Paragraphs with Tabs, Borders, Lists, |
| and Columns |
| Applying Paragraph Formats |
| HAN DS-ON EXERCI SE 2: |
| Paragraph Formatting Features |
| Styles |
| Understanding Styles |
| Creating and Modifying Styles |
| HAN DS-ON EXERCI SE 3: |
| Styles |
| Graphical Objects |
| Formatting a Graphical Object |
| Inserting Symbols into a Document |
| Hands-On Excercise 4: |
| Graphical Objects |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Three ¤ Collaboration and Research |
| Case Study: Marketing Plan For Take Note Paperie |
| Objectives |
| Document Revisions |
| Inserting Comments in a Document |
| Tracking Changes in a Document |
| Hands-On Excercise 1: |
| Document Revisions |
| Research Paper Basics |
| Acknowledging a Source |
| Creating and Modifying Footnotes and Endnotes |
| Hands-On Excercise 2: |
| Research Paper Basics |
| Research Paper Enhancements |
| Inserting a Table of Contents and Index |
| Adding Other Reference Tables |
| Creating Cross-References |
| HAN DS-ON EXERCI SE 3: |
| Research Paper Enhancements |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Four ¤ Document Productivity |
| Case Study: Community Disaster Relief Center |
| Objectives |
| TABLES |
| Inserting a Table |
| Formatting a Table |
| Hands-On Exercise 1: |
| Tables |
| Advanced Table Features |
| Sorting and Applying Formulas to Table Data |
| Converting Text to a Table |
| HANDS-ON EXERCISE 2: |
| Advanced Table Features |
| Mail Merge |
| Selecting a Main Document |
| Selecting or Creating Recipients |
| COLABORATION CAPSTONE |
| Word |
| Inserting Merge Fields |
| Merging a Main Document and a Data Source |
| HANDS-ON EXERCISE 3: |
| Mail Merge |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| COLLABORATION CAPSTONE ¤ Word |
| Chapter 1 Collaboration Exercise |
| Chapter 2 Collaboration Exercise |
| Chapter 3 Collaboration Exercise |
| Chapter 4 Collaboration Exercise |
| Microsoft Office Excel 2010 |
| Chapter One ¤ Introduction to Excel |
| Case Study: Ok Office Systems |
| Objectives |
| Introduction To Spreadsheets |
| Planning for Effective Workbook and Worksheet Design |
| Exploring the Excel Window |
| Entering and Editing Cell Data |
| Hands-On Excercise 1: |
| Introduction to Spreadsheets |
| Mathematics and Formulas |
| Using Symbols and the Order of Precedence |
| Using Auto Fill |
| Displaying Cell Formulas |
| Hands-On Excercise 2: |
| Mathematics and Formulas |
| Workbook And Worksheet Management |
| Managing Worksheets |
| Managing Columns and Rows |
| Selecting, Moving, Copying, and Pasting |
| Hands-On Excercise 3: |
| Workbook and Worksheet Management |
| Formatting |
| Applying Alignment and Font Options |
| Applying Number Formats |
| Hands-On Excercise 4: |
| Formatting |
| Page Setup And Printing |
| Selecting Page Setup Options |
| Printing a Worksheet |
| Hands-On Excercise 5: |
| Page Setup and Printing |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Two ¤ Formulas and Functions |
| Case Study: Denver Mortgage Company |
| Objectives |
| Formula Basics |
| Using Semi-Selection to Create a Formula |
| Using Relative, Absolute, and Mixed Cell References in Formulas |
| Avoiding Circular References |
| HAN DS-ON EXERCI SE 1: |
| Formula Basics |
| Function Basics |
| Inserting a Function |
| Totaling Values with the SUM Function |
| Inserting Basic Statistical Functions |
| Using Date Functions |
| Hands-On Excercise 2: |
| Function Basics |
| Logical, Lookup, and Financial Functions |
| Determining Results with the IF Function |
| Using Lookup Functions |
| Calculating Payments with the PMT Function |
| Hands-On Excercise 3: |
| Logical, Lookup, and Financial Functions |
| Range Names |
| Creating and Maintaining Range Names |
| Using Range Names in Formulas |
| Hands-On Excercise 4: |
| Range Names |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Three ¤ Charts |
| Case Study: Hort University Majors |
| Objectives |
| Chart Basics |
| Deciding Which Chart Type to Create |
| Creating a Chart |
| Hands-On Excercise 1: |
| Chart Basics |
| Chart Design |
| Changing the Chart Type |
| Changing the Data Source and Structure |
| Applying a Chart Layout and a Chart Style |
| Moving a Chart |
| Printing Charts |
| Inserting and Customizing a Sparkline |
| Hands-On Excercise 2: |
| Chart Design |
| Chart Layout |
| Selecting and Formatting Chart Elements |
| Customizing Chart Labels |
| Formatting the Axes and Gridlines |
| Adding a Trendline |
| Hands-On Excercise 3: |
| Chart Layout |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Four ¤ Datasets and Tables |
| Case Study: The Spa Experts |
| Objectives |
| Large Datasets |
| Freezing Rows and Columns |
| Printing Large Datasets |
| HAN DS-ON EXERCI SE 1: |
| Large Datasets |
| Excel Tables |
| Understanding Table Design |
| Creating a Table |
| Applying a Table Style |
| Hands-On Excercise 2: |
| Excel Tables |
| Table Manipulation and Aggregation |
| Sorting Data |
| Filtering Data |
| Using Structured References and a Total Row |
| Collaboration Capstone |
| Excel |
| Hands-On Excercise 3: |
| Table Manipulation and Aggregation |
| Conditional Formatting |
| Applying Conditional Formatting |
| Creating a New Rule |
| Sorting and Filtering Using Conditional Formatting |
| Hands-On Excercise 4: |
| Conditional Formatting |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| COLLABORATION CAPSTONE ¤ Excel |
| Chapter 1 Collaboration Exercise |
| Chapter 2 Collaboration Exercise |
| Chapter 3 Collaboration Exercise |
| Chapter 4 Collaboration Exercise |
| Microsoft Office Access 2010 |
| Chapter One ¤ Introduction to Access |
| Case Study: Managing A Business in the Global |
| Economy |
| Objectives |
| Databases Are Everywhere! |
| Navigating Among the Objects in an Access Database |
| Understanding the Difference Between Working |
| inStorage and Memory |
| Practicing Good Database File Management |
| Backing Up, Compacting, and Repairing Access Files |
| Hands-On Excercise 1: |
| Databases Are Everywhere! |
| Filters, Sorts, and Acess Versus Excel |
| Creating Filters |
| Sorting Table Data on One or More Fields |
| Knowing When to Use Access or Excel to Manage Data |
| Hands-On Excercise 2: |
| Filters, Sorts, and Access Versus Excel |
| Relational Database |
| Using the Relationships Windows |
| Understanding Relational Power |
| Hands-On Excercise 3: |
| Relational Database |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Two ¤ Relational Databases and Queries |
| Case Study: Bank Auditor Uncovers Midhandled |
| Funds |
| Objectives |
| Table Design, Properties, Views, and Wizards |
| Designing Data |
| Creating Tables |
| Hands-On Excercise 1: |
| Table Design, Properties, Views, and Wizards |
| Multiple Table Databases |
| Understanding Table Relationships |
| Sharing Data with Excel |
| Establishing Table Relationships |
| Hands-On Excercise 2: |
| Multiple Table Databases |
| Single-Table Queries |
| Creating a Single-Table Query |
| Specifying Criteria for Different Data Types |
| Copying and Running a Query |
| Using the Query Wizard |
| Hands-On Excercise 3: |
| Single-Table Queries |
| Multi-Table Queries |
| Creating a Multi-Table Query |
| Modifying a Multi-Table Query |
| Hands-On Excercise 4: |
| Multi-Table Queries |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Three ¤ Customize, Analyze, and Summarize Query Data |
| Case Study: Housing Slump Means |
| Opportunity for College Students |
| Objectives |
| Calculations, Expressions, and Functions |
| Understanding the Order of Operations |
| Creating a Calculated Field in a Query |
| Hands-On Excercise 1: |
| Calculations, Expressions, and Functions |
| Expression Builder, Functions, and Date Arithmetic |
| Creating Expressions with the Expression Builder |
| Using Built-In Functions in Access |
| Performing Date Arithmetic |
| Hands-On Exercise 2: |
| Expression Builder, Functions, and Date Arithmetic |
| Aggregate Functions |
| Adding Aggregate Functions to Datasheets and Queries |
| Hands-On Exercise 2: |
| Aggregate Functions |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Four ¤ Creating and Using Professional Forms and Reports |
| Case Study: Coffee Shop Starts new Business |
| Objectives |
| Form Basics |
| Creating Forms Using the Form Tools |
| Modifying a Form |
| Sorting Records in a Form |
| Hands-On Excercise 1: |
| Form Basics |
| Form Sections, Views, and Controls |
| Identifying Form Sections |
| Revising Forms Using Form Views |
| Identifying Control Types in Forms |
| Hands-On Excercise 2: |
| Form Sections, Views, and Controls |
| Report Basics |
| Creating Reports Using Report Tools |
| Modifying a Report |
| Sorting Records in a Report |
| Collaboration Capstone |
| Access |
| Hands-On Excercise 3: |
| Report Basics |
| Report Sections, Views, and Controls |
| Identifying Report Sections |
| Revising Reports Using Report Views |
| Identifying Control Types in Reports |
| Hands-On Excercise 4: |
| Report Sections, Views, and Controls |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| COLLABORATION CAPSTONE ¤ Access |
| Chapter 1 Collaboration Exercise |
| Chapter 2 Collaboration Exercise |
| Chapter 3 Collaboration Exercise |
| Chapter 4 Collaboration Exercise |
| Microsoft Office Powerpoint 2010 |
| Chapter One ¤ Introduction to PowerPoint |
| Case Study: Be A Trainer |
| Objectives |
| Introduction to Powerpoint |
| Using PowerPoint Views |
| Saving as a Slide Show |
| Hands-On Excercise 1: |
| Introduction to PowerPoint |
| Presentation Creation |
| Planning a Presentation |
| Assessing Presentation Content |
| Using Slide Layouts |
| Applying Themes |
| Reviewing the Presentation |
| Hands-On Excercise 2: |
| Presentation Creation |
| Presentation Development |
| Inserting Media Objects |
| Adding a Table |
| Using Animations and Transitions |
| Inserting a Header or Footer |
| Hands-On Excercise 3: |
| Presentation Development |
| Navigation and Printing |
| Running and Navigating a Slide Slow |
| Printing in PowerPoint |
| Hands-On Excercise 4: |
| Navigation and Printing |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Two ¤ Presentation Development |
| Case Study: The Wellness Education Center |
| Objectives |
| Templates |
| Creating a Presentation Using a Template |
| Modifying a Template |
| Hands-On Excercise 1: |
| Templates |
| Outlines |
| Creating a Presentation in Outline View |
| Modifying an Outline Structure |
| Printing an Outline |
| Hands-On Excercise 2: |
| Outlines |
| Data Imports |
| Importing an Outline |
| Adding Existing Content to a Presentation |
| Hands-On Excercise 3: |
| Data Imports |
| Design |
| Using Sections |
| Examining Slide Show Design Principles |
| Modifying a Theme |
| Hands-On Excercise 4: |
| Design |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Three ¤ Presentation Design |
| Case Study: Illustrations and Infographics |
| Mini-Camp |
| Objectives |
| Shapes |
| Creating Shapes |
| Applying Quick Styles and Customizing Shapes |
| Hands-On Excercise 1: |
| Shapes |
| Smartart and Wordart |
| Creating SmartArt |
| Modifying SmartArt |
| Creating WordArt |
| Modifying WordArt |
| Hands-On Excercise 2: |
| SmartArt and WordArt |
| Object Manipulation |
| Modifying Objects |
| Arranging Objects |
| Hands-On Excercise 3: |
| Object Manipulation |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| Chapter Four ¤ PowerPoint Rich Media Tools |
| Case Study: Wedding Albums |
| Objectives |
| Pictures |
| Inserting a Picture |
| Transforming a Picture |
| Using the Internet as a Resource |
| Hands-On Excercise 1: |
| Pictures |
| Video |
| Adding Video |
| Using Video Tools |
| Hands-On Excercise 2: |
| Video |
| Audio |
| Adding Audio |
| Changing Audio Settings |
| Hands-On Excercise 3: |
| Audio |
| Photo Albums |
| Creating a Photo Album |
| Setting Photo Album Options |
| Hands-On Excercise 4: |
| Photo Albums |
| Chapter Objectives Review |
| Key Terms |
| Multiple Choice |
| Practice Exercises |
| Mid-Level Exercises |
| Capstone Exercise |
| Beyond The Classroom |
| COLLABORATION CAPSTONE ¤ PowerPoint |
| Chapter 1 Collaboration Exercise |
| Chapter 2 Collaboration Exercise |
| Chapter 3 Collaboration Exercise |
| Chapter 4 Collaboration Exercise |
| CAPSTONE EXERCISES |
| VOLUME 1 ¤ Using Office in Paralegal, Zoo, and Medical Professions |
| Paralegal |
| Word |
| Excel |
| Access |
| PowerPoint |
| Integrated |
| Zoo |
| Word |
| Excel |
| Access |
| PowerPoint |
| Integrated |
| Medical |
| Word |
| Excel |
| Access |
| PowerPoint |
| Integrated |
| Glossary |
| Index |
Purchase Info 
With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.
Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.
Exploring Microsoft Office 2010, Volume 1, CourseSmart eTextbook, 2nd Edition
Format: Electronic Book
$62.99 | ISBN-13: 978-0-13-287718-3
