Description

The content associated with the traditional text has moved to Pearson Custom Library (PCL). PCL allows customers to create customized textbooks, giving students a more engaging and affordable education. If you would like to purchase the full test without customization, please use ISBN: 0558727883. For more information about customization opportunities, refer to www.pearsoncustomlibrary.com.

 

The goal of the Exploring series has been to move students beyond the point and click and help the student understand why and when they would perform a skill.   The system structure considers the following three points.

 

Students go to college now with a different set of skills than they did 5 years ago.  With this in mind, the new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  This ensures that students will be engaged from Chapter 1 throughout the book.

 

Students have diverse career goals. The examples in the text (and the accompanying Instructor Resources) include the health sciences, hospitality, urban planning, business and more so Exploring will be relevant to every student in the course.

 

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 bring students into the content and make the text easy to use.

 

Students will be more engaged, achieve a higher level understanding in Office, and will successfully complete this course.

Features

The Exploring Instructional System: Textbook, myitlab, and Annotated Instructor Resources

 

Instructor Resources

·        Reference Cards:

o       Case Study lecture Demonstration Document : 

Lecture demonstration that mimics each chapter project.

 

o       Concept Summary: 

Reference card that outlines chapter objectives and common pit falls.

 

Student Textbook

·        Beyond the Basics

o       More advanced skills are introduced earlier as students are learning basic skills faster.

·        White Pages/Yellow Pages

o       Clearly distinguish the theory from the skill exercises.

·        Objective Mapping

o       Allows students to skip the skills they know and quickly identify the skills they don't know.

·        Pull Quotes

o       Entice students into the theory/concepts by highlighting the most interesting points.

·        Case Study Related

o       Are icons that help students identify skills specific to the case study.

·        Conceptual Animations

o       Literally illustrates how Exploring connects the theory with the skills.

 

·        More Exercises

o       Offer the instructor even more options for assessment.  We offer 12-15 projects/chapter ranging from MC to open-ended projects.   Most competitors have 8-10.

·        Rubrics

o       Give both the instructors and students a guide to a solution.  Each Mini Cases has its own rubric.

·        Capstone Production Tests (one in the text and one in the IRCD)

o       Allow the instructors to assess all the skills in the chapter with a single project.

 

myitlab

·        Online Assessment and Training

o       Seamlessly integrate online assessment and training with the new myitlab for Microsoft Office 2007!

o       Project-Driven assessment and outcomes-based training share content between the Exploring text and myITlab.

o       No more software installations

Table of Contents

Exploring Microsoft Office Word 2007 Comprehensive

 

Chapter 5 - Advanced Features: Wizards, Templates, and Mail Merge

 

Section 1 Automated Features

    Using shortcuts

        Hands-On Exercise #1:  Using a Wizard

 

Section 2 Mail Merge

    Creating Form Letters

        Hands-On Exercise #2: Using the Mail Merge Wizard

 

Section 3 Merge with External Source Data

    Merging with Excel and Access Data

        Hands-On Exercise #3: Merge with External Source Data

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 6 - Desktop Publishing: Creating a Newsletter and Other Documents

 

Section 1 Introduction to Desktop Publishing

    The Newsletter

    Columns

        Hands-On Exercise #1: Newspaper columns

 

Section 2 Elements of Graphic Design

    The Grid

    The Drawing Toolbar

        Hands-On Exercise #2: Complete the Newsletter

 

Section 3 Object Linking and Embedding

    Inserting Objects from other Applications

        Hands-On Exercise #3: Object Linking and Embeddings

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 7 - The Expert User: Forms, Document Protection, and Macros

 

Section 1 Forms

    Creating an Electronic form

        Hands-On Exercise #1: Forms

 

Section 2 Protection and Authentication

    Adding Security

    Create an Electronic Stamp of Authenticity

        Hands-On Exercise #2: Secure a document and add a digital signature

 

Section 3 Automating Word

    Introduction to Macros

        Hands-On Exercise #3: Introduction to Macros

 

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 8 - Introduction to xHTML: Creating a Home Page and a Web Site

 

Section 1 Online Resources

    Microsoft Word and the Internet

        Hands-On Exercise #1: Microsoft Word and the World Wide Web

 

Section 2 Creating a Home Page

    Using Word to Create a Web Page

    Developing a Web Site

        Hands-On Exercise #2: World Wide Travel Home Page

 

Section 3 Introduction to XML

    Extensible Markup Language

        Hands-On Exercise #3 Introduction to XML

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

Exploring Microsoft Office Excel 2007 Comprehensive

 

Chapter 5 - Convert Data to Information

 Section 1 Table Management

    Exploring Table and Data Theory

    Working with a Table Form

    Importing Text

        Hands-on Exercise 1:  Import Data and Maintain a List

 

Section 2 Data Management

    Defining Data and Information

        Hands-on Exercise 2: Data Versus Information

 

Section 3 Data Analysis

    Exploring Pivot Tables and Pivot Charts

        Hands-on Exercise 3: Pivot Tables and Pivot Charts

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 6 - Consolidate Data and Link Files   

 

Section 1 Data Consolidation

    Consolidating Data from multiple Worksheets

    Defining the Three-Dimensional Workbook

        Hands-on Exercise 1: Copy Worksheets

 

Section 2 Worksheet 3-D References

    Working with 3-D Refernces

        Hands-on Exercise 2: Worksheet References

 

Section 3 Workbook Linking and Documentation

    Linking Workbooks

    Creating the Cover Sheet

        Hands-on Exercise 3: Linking and Documentation

 

    Summary         

    Key Terms       

    Multiple Choice 

    Practice Exercises        

    Mid-Level Exercises      

    Capstone Exercise        

    Mini Cases

 

Chapter 7 - What-IF Analysis--Forecasting and Amortization

 

Section 1 Financial Analysis

    Defining Forecasting

    Using Scenario Manager

    Solving Problems with Goal Seek

        Hands-on Exercise 1: The Financial Forecast

 

Section 2 Functions for Amortization Table

    Working with Functions

    Using Name Manager

        Hands-on Exercise 2: The Amortization Schedule

 

Section 3 Workgroups and Auditing

    Validating Data

    Auditing Formulas

    Setting up a Watch Window

        Hands-on Exercise 3: Auditing

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 8 - Templates, Themes, and Web Pages

 

Section 1 Worksheet Automation

    Working with Existing Templates, Themes, and Styles

    Creating a Template

    Using Styles for Advanced Formatting

        Hands-on Exercise 1: Creating a Template

 

Section 2 Web Pages

    Creating a Web page

        Hands-on Exercise 2: Creating a Web Page

 

Section 3 Web Queries and  Web Data

    Creating Web Queries

        Hands-on Exercise 3: Web Queries

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 9 - Collaboration and Macros

 

Section 1 Excel Collaboration

    Sharing Data

    Copying to Word

    Copying to Power Point

        Hands-on Exercise 1:

 

Section 2 Repetitive Tasks

    Working with Macros

        Hands-on Exercise 2:

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Project

    Mini Cases

 

Chapter 10 - Data Analysis--A Capstone Chapter

 

Section 1 Drowning in Data

    The Admissions Office

        Hands-on Exercise 1: Case Relevant Scenario

 

Section 2 The Case Worksheet

        Hands-on Exercise 2: Case Relevant Scenario

 

Section 3 The Case Worksheet

        Hands-on Exercise 3: Case Relevant Scenario

 

Section 4 The Case Worksheet

        Hands-on Exercise 4: Case Relevant Scenario

 

Exploring Microsoft Access 2007 Comprehensive

 

Chapter 5 - Sub-reports, More Query Types, Pivot Tables and Charts

 

Section 1 Pivot Tables

    Creating Pivot Tables

        Hands-on Exercise 1: Pivot Tables

 

Section 2 Pivot Charts

    Recognizing Good Chart Design

    Creating Pivot Charts

    Editing Pivot Charts

        Hands-on Exercise 2: Pivot Charts

 

Section 3 Interactive Pivots

    Creating Multiple Pivots

        Hands-on Exercise 3: Interactive Pivots

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 6 - Data Protection - Working with Data Integrity

Section 1 Protecting Table Data

    Creating a table validation rule

        Hands-on Exercise 1: Data Validation

 

Section 2 Understanding the need for forms

    Planning the form

    Selecting and modifying Controls

        Hands-on Exercise 2: Form Creation

 

Section 3 - Advanced Forms

    Creating a calculated control in a form

    Adding a sub form

        Hands-on Exercise 3: Advanced Forms

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 7 - Database Maintenance - Creating Advanced Queries

 

Section 1 Maintenance Query Types

    Creating a Make Table Query

    Creating an Append Query

    Creating a Delete Query

    Creating an Update Query

        Hands-on Exercise 1: Creating Maintenance Queries

     

Section 2 Advanced Queries

    Crosstab Queries

    Using Table Field Indexes

        Hands-On Exercise 2: Cross tabbing and Indexing

 

Section 3 Housekeeping

    Setting the database to compact automatically

    Converting a database to previous Access versions

        Hands-on Exercise 3: Maintenance

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 8 - Integrating Access with the Internet

 

Section 1 Access and the Web

    Creating a Hyperlinked Field

    Inserting Hyperlinks to a File or Web Page

    Linking to an E-mail Address

        Hands-on Exercise 1: Getting Connected

 

Section 2 Access and the Web

    Exporting database objects as an HTML document

    Importing or Linking to an HTML File

    Viewing a Data Access Page

        Hands-on Exercise 2:

 

Section 3 Access and Excel

    Creating Data for Excel Users

        Hands-on Exercise 3:

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 9 - Bulletproofing the Database

 

Section 1 Data Protection

    Analyzing Database performance

    Managing and Securing the Data

    Using Performance Analyzer

    Using the Linked Table Manager

    Creating a database Replica

    Synchronizing the design and replica

        Hands-on Exercise 1: Performance Measurements

 

Section 2 Helping Database Users

    Creating a user interface

    Creating a switchboard

    Creating a dialog box

    Adding command buttons

    Viewing and testing a switchboard

        Hands-on Exercise 2: Switchboards and Commands

 

Section 3 Splits and Security

    Splitting a database

    Encrypting the data

    Establishing User-level security

    Testing security levels

    Normalizing a Database

        Hands-on Exercise 3: Split Database and User Securities

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 10 - Customizing a database with programming languages

 

Section 1

    Using SQL

    Viewing SQU statements in a query

    Modifying a SQL statement

 

Section 2

    Using VBA

    Introducing Events

    Working with procedures

    Creating Modules

    Displaying an Event Procedure

    Testing a procedure in an intermediate window

    Creating Class modules

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Exploring Microsoft Office PowerPoint 2007 Comprehensive

 

Chapter 5 - Working with Charts and Graphs

    

Text-based Charts

    Basic Statistical Charts and Graphs

    Advanced Statistical Charts and Graphs

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

 

Chapter 6 - Customizing a Slideshow

 

    Masters

    Color Schemes

    Custom Template

    Custom Animation

    Create a Custom Show

    Hidden Slides

    Macros

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

 

Chapter 7 - Saving a Web Page and Adding Interactivity

 

    Hyperlinks

    Buttons

    Web Pages

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

 

Chapter 8 - Collaborating with Others

 

    Comments

    Merge and Compare

    Package for CD

    Broadcast

 

        Hands-on Exercises 1-4

        Capstone Exercise

        Mini-Cases 1-3

        (Content Application, Disaster Recovery, Research)

Author

Dr. Robert T. Grauer

Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business.  He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy.

 

Dr. Grauer has written more than 50 books on programming and information systems.  His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels.

 

Dr. Grauer also has been a consultant to several major corporations including IBM and American Express.  He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.

 

Judith Scheeren

Judith Scheeren is a professor of computer technology at Westmoreland County Community College in Youngwood, Pennsylvania where she received the Outstanding Teacher award.  She holds an M.S.I.S. She holds an M.S. from the University of Pittsburgh and an advanced certificate in online teaching and learning from the University of California at Hayward.  She has several years of experience in the computer industry with Fortune 500 companies.  She has developed and written training materials for custom applications in both the public and private sectors.  She also has written books on desktop publishing.

 

Maurie Wigman Lockley

Maurie Wigman Lockley teaches desktop applications and management information systems classes at the University of North Carolina Greensboro.  She has been an instructor there since 1990.

 

She lives in a tiny piedmont North Carolina town with her husband, daughter, and two preschool-aged grandsons.  She spends her free time playing with the boys, reading, camping, playing computer games, and singing.  She serves on several not-for-profit boards and is active at her church.

 

Michelle Hulett

Michelle Hulett received a B.S. degree in CIS from the University of Arkansas and a M.B.A. from Missouri State University.  She has worked for various organizations as a programmer, network administrator, computer literacy coordinator, and educator.  She currently teaches computer literacy and Web design classes at Missouri State University.

 

When not teaching or writing, she enjoys flower gardening, traveling (Alaska and Hawaii are favorites), hiking, canoeing, and camping with her husband, John, and dog, Dakota.

 

Cynthia Krebs

Cynthia Krebs is a professor in the Digital Media Department at Utah Valley State College, where she has taught since 1988.  In addition to teaching classes in basic computer proficiency using Microsoft Office, she teaches classes in business presentations, business graphics, and an introduction to multimedia.  She has received the Teacher-of-the-Year Award in the School of Business twice during her tenure at UVSC.

 

She has written chapters for many texts, co-authored a text on advanced word processing, and has presented locally and nationally.  A graduate of Utah State University, Cynthia lives in Springville, Utah.

 

She has four children and one granddaughter.  When she isn't teaching or writing, she enjoys spending time with her children and spoiling her granddaughter.