Product Cover Image

Exploring Microsoft Office 2010, Volume 1, CourseSmart eTextbook, 2nd Edition

By Robert T. Grauer, Mary Anne Poatsy, Michelle Hulett, Cynthia Krebs, Keith Mast, Keith Mulbery, Lynn Hogan

Published by Prentice Hall

Published Date: Jun 15, 2012

More Product Info

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.

Buy Access

Exploring Microsoft Office 2010, Volume 1, CourseSmart eTextbook, 2nd Edition
Format: Safari Book

$67.99 | ISBN-13: 978-0-13-287718-3