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.

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.

Features

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.

Diversity: Students have diverse career goals. To target the variety of majors taking the course, Exploring offers examples relevant to every student.

Studying Made Easy: Students read, prepare, and study differently than they used to. Rather than reading a book cover-to-cover, students want to easily identify what they need to know, and then learn it efficiently. The key features found in the Exploring series bring students into the content, making the text easy to use.

White Pages/Yellow Pages:Clearly distinguishes the theory from the skill exercises.

NEW! Compass, an online reference tool designed to help students learn the 50 most essential skills in Microsoft Word, Excel, Access, and PowerPoint, is included as part of the Exploring System. Available online via your computer or mobile phone, Compass is an online, at-your-fingertips resource for tech savvy students who need help and answers right away.

NEW! Visual Reference Cards for each application provide visual summaries and quick tips that answer the questions asked most commonly by students. These are movable throughout the book and can also be used as a bookmark.

A Chapter Opening Case Study now not only introduces the scenario that the Hands-On Exercises in the chapter are built around, but also carries throughout the entire chapter to provide students with consistency of context to help them learn.

NEW! Set-Up Videos! These live-action videos act out the Case Study, describing skills that will be learned and showing the relevance of the skills to students' current lives and/or future careers. Professors are provided with exercises to help guide and assess students on their comprehension of the skills while watching the videos.

Objective Mapping enables students to skip the skills and concepts they know, and quickly find those they don’t, by scanning the chapter opener page for the page numbers of the material they need.

Pull Quotes entice students into the theory by highlighting the most interesting points.

End of Chapter material offers instructors several options for assessment. Each chapter has 12-15 exercises ranging from multiple choice questions to open-ended projects.

• Multiple Choice questions help students quickly and easily make sure they understand the concepts.
• Practice Exercises remove some of the hand-holding students had in the steps of the HOEs and challenge students with new case studies. Each Practice Exercise has its own case study for students to work through.
• Enhanced Mid-Level Exercises includes a Discover Step, which encourages students to use Help or to problem-solve to accomplish a task. This engages students hig

New to this Edition

NEW! Compass, an online reference tool designed to help students learn the 50 most essential skills in Microsoft Word, Excel, Access, and PowerPoint, is included as part of the Exploring System. Available online via your computer or mobile phone, Compass is an online, at-your-fingertips resource for tech savvy students who need help and answers right away.

NEW! Visual Reference Cards for each application provide visual summaries and quick tips that answer the questions asked most commonly by students. These are movable throughout the book and can also be used as a bookmark.

NEW! Chapter Opening Case Study now not only introduces the scenario that the Hands-On Exercises are built around, but also carries throughout the entire chapter to provide students with consistency of context to help them learn.

NEW! Set-Up Videos! These live-action videos act out the Case Study, describing skills that will be learned and showing the relevance of the skills to students' current lives and/or future careers. Professors are provided with exercises to help guide and assess students on their comprehension of the skills while watching the videos.

NEW! FYI Icon indicates that a step includes a skill common to more than one Office app. As a refresher, students can review the common skills via the Office Fundamentals chapter, the NEW Visual Reference Cards, or NEW Compass. FYI Icons are also located in the End of Chapter exercises to remind students to use their resources found inside and outside of their book.

NEW! myitlab icons have been included to show where individual exercises have been included in myitlab.

NEW! TROUBLESHOOTING sections give students a way to overcome common errors or frustrations that happen when working through the exercises.

TIPS are also NEWLY included in the Hands-On Exercises and provide brief, useful hints.

NEW! Enhanced Mid-Level exercises includes a Discover Step, which encourages students to use Help or to problem-solve to accomplish a task. This engages students higher level thinking and challenges students more. Other Mid-Levels may contain Creative Steps, which also ask more of the student.

NEW! myitlab:grader icon indicates that the Capstone Exercise in each chapter is available in myitlab. The Capstone Exercise allows professors to assess students on all of the skills covered in a chapter with a single project.

NEW! Beyond the Classroom exercises are open-ended exercises that ask students to complete a project with very little guidance, challenging them at the highest level.

Rubrics are available for instructors as part of their Instructor Resource Pack to aid in the grading of these cases. They are also in Word format so that professors can customize these for their classes.

NEW! Disaster Recovery Cases provide students with the ability to identify and correct errors within an existing project, helping them achieve one of the highest level of thinking, Analysis.

Table of Contents

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 EXERCISE 1: Files and Folders

MICROSOFT OFFICE SOFTWARE

Identifying Common Interface Components

Getting Office Help

HANDS-ON EXERCISE 2: Microsoft Office Software

BACKSTAGE VIEW TASKS

Opening a File

Printing a File

Closing a File and Application

HANDS-ON EXERCISE 3: Backstage View Tasks

HOME TAB TASKS

Selecting and Editing Text

Using the Clipboard Group Tasks

Using the Editing Group Tasks

HANDS-ON EXERCISE 4: Home Tab Tasks

INSERT TAB TASKS

Inserting Objects

REVIEW TAB TASKS

Reviewing a File

PAGE LAYOUT TAB TASKS

Changing Page Settings

HANDS-ON EXERCISE 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 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 EXERCISE 1: Introduction to Spreadsheets

MATHEMATICS AND FORMULAS

Using Symbols and the Order of Precedence

Using Auto Fill

Displaying Cell Formulas

HANDS-ON EXERCISE 2: Mathematics and Formulas

WORKBOOK AND WORKSHEET MANAGEMENT

Managing Worksheets

Managing Columns and Rows

Selecting, Moving, Copying, and Pasting

HANDS-ON EXERCISE 3: Workbook and Worksheet Management

FORMATTING

Applying Alignment and Font Options

Applying Number Formats

HANDS-ON EXERCISE 4: Formatting

PAGE SETUP AND PRINTING

Selecting Page Setup Options

Printing a Worksheet

HANDS-ON EXERCISE 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

HANDS-ON EXERCISE 1: Formula Basics

FUNCTION BASICS

Inserting a Function

Totaling Values with the SUM Function

Inserting Basic Statistical Functions

Using Date Functions

HANDS-ON EXERCISE 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 EXERCISE 3: Logical, Lookup, and Financial Functions

RANGE NAMES

Creating and Maintaining Range Names

Using Range Names in Formulas

HANDS-ON EXERCISE 4: Range Names

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER THREE ¿ Ch