Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.

For Introductory Computer courses in Microsoft Office 2007 or courses in Computer Concepts with a lab component for Microsoft Office 2007 applications.

Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined projects for students and a one of a kind supplements package.

Q: Tired of spending all day and night creating and grading assignments?

Q: Challenged with diverse student audience with varied skill levels?

Q: Deliver your course in class, in lab, and online?

The GO! System Story…

 

As a professor for over 15 years, GO! Series author, Shelley Gaskin used many different Microsoft Office texts only to find that none of them addressed all of the needs and concerns of today’s diverse student body and faculty. That’s why she created the GO! System.

 

The GO! System was developed with all of your everyday classroom realities in mind. The primary goal of the system, aside from the obvious one of teaching Microsoft Office skills and concepts, is ease of implementation using any delivery method, including traditional lecture, self-paced or online. This is accomplished with the one of a kind GO! instructor supplements package.

 

The GO! System teaching approach is focused on student success. Students work through interesting real-life projects and activities that are clearly written and logically arranged. The GO! System ensures students don’t get lost or confused by misleading instruction while they learn computer skills and concepts.

 

The GO! System promises you can teach the course you want in less time!

 

For Office 2007, the GO! System will seamlessly integrate a textbook focused on student success, unique instructor resources, including fully Annotated Instructor Edition, and the new myitlab assessment and training software.

Q: Prefer your students to build real-life projects instead of just stepping through the features of Office?

GO! teaches using a realistic project-based approach.

 

The GO! System teaching approach is project-based so students actually learn Office application skills by applying them to real-world projects, instead of simply stepping through the features of each application.

Q: Find that students sometimes get lost in their textbook?

Q: Notice your students tend to skip the theory and jump right to the hands-on step-by-step activities?

Hallmark features of the GO! teaching approach ensure that students learn both Office skills and essential concepts without getting lost.

 

The first, Microsoft Procedural Syntax describes the way in which steps are written and makes sure students don’t get lost in the step-by-step. Every numbered step in a project teaches the student where to go and then what to do. For example, A GO! step instructs the student to… “In the lower portion of the Save As dialog box, click the Save button.”, as opposed to just indicating, “Click Save.”

 

GO! also incorporates Teachable Moment Theory which describes how the Office concepts or theory are woven into steps at teachable moment. Tedious paragraphs of expository text are avoided so students don’t skip the theory while they work through the step-by-step instruction

 

In addition, the GO! textbook is easy to navigate. Chapters are called chapters and every book is sequentially paginated (from page 1 to say 1,000) so students can quickly and easily find their assignments.

Q: Require a range of end-of-chapter review and assessment for students of varying skill levels?

Q: Ever thought of assigning a group project?

GO! provides several levels of assessment at the end of each chapter so you can assign everything from fill-in-the-blank concepts review to open-ended, project-based assessments to a case project.

 

New for Office 2007!...

 

GO!’s end-of-chapter is now organized into two sections: content—based assessments and outcomes-based assessments.

 

The content-based activities are those assessments that have a defined solution and can be graded with a solution file. The outcomes-based are non-defined or problem-solving assessments that can be graded using the GO! Rubric. 

 

Chapters now also include a Group Business Running Case provides a project that runs through the entire GO! Office textbook and is designed to be assigned to group of students.

Q: Ever find that students sometimes struggle with math skills when learning Excel?

NEW! Workshop features help student with essential math and presentation design skills.

 

The Workshop features for Excel and PowerPoint chapters help students better understand the soft skills related to these applications. For example, the Excel Workshop teaches formulas and other basic math skills and the PowerPoint Workshop teaches essential presentation design skills.

Q: Does it seem like you are always preparing for class?

The GO! System provides everything you need to prepare your course quickly and easily!

 

The GO! System’s unique Instructor Resources, including fully Annotated Instructor Edition are designed to save you time and is organized to help you prepare, teach and assess.

 

To help you get ready for lecture or lab, the GO! System offers a unique Annotated Instructor Edition which consists of the complete textbook in binder form with margin notes, teaching tips, and highlights on what’s new in Microsoft Office 2007.

Q: Spend too much time creating lecture presentations?

Q: Wish you had a way to capture and post your lectures to an online course?

The GO! System helps you teach in and out of the classroom with scripted lectures!

 

GO!’s Expert Demonstration Documents provide alternative scenarios of each project in the textbook. Teach using these documents and your students won’t be able to jump ahead in their textbook will in class or lab.

 

New for GO! with Office 2007…

 

Audio/Video Expert Demonstration Documents provide ready-to-use, multimedia versions of each EDD. These are supplied on CD and in OneKey courses, and are ideal for online courses, lecture reinforcement, or even lecture replacement when students miss class.

 

Click here to try a Audio/Video Expert Demonstration Documents.

Q: Taking too long to grade homework assignments?

The GO! System’s Highlighted Overlays and Assignment Tags work together to save you time!

 

The Highlighted Overlays are transparenciesof solution files that include annotations, when placed over student submitted homework, allow you to visually identify gradable items.

 

The Assignment Tags are the scoring checklists for each assignment that work with the highlighted overlays to let you quickly score students’ work.

 

The new GO! with Office 2007 System will also include Assignment Tags for GO!’s “Problem Solving” assignments.These new task-specific scoring checklists will save you time in grading open-ended assessments.

Q: Struggle creating new tests every semester?

The GO! System provides you with quizzes and tests so you don’t have to create them!

 

GO!’s Point-Counted Production Tests supply you with pre-built quizzes so you can easily assess students on each GO! chapter project, a full chapter, or an entire Office application.

Q: Don’t have enough time to create and grade traditional paper tests?

Q: Looking for a new online assessment and training solution?

That’s why we built myitlab for Microsoft Office 2007, a solution designed by professors that allows you to easily deliver your Office course with outcomes-based training and defensible assessment.

 

The new GO! with Office 2007 System will seamlessly integrate online assessment and training with the new myitlab for Microsoft Office 2007!

Q: Wish your online tests and training matched your textbook?

Train your students on Microsoft Office 2007 with the exact same projects, activities, skills, and methods found in your GO! series textbook, and use two alternative assessment scenarios for quizzes, pre- and post-tests, and finals.

Q: Want to test and train on real-life projects?

With myitlab you can test and train students on entire projects just like in your textbook or you can break down assignments into individual Office 2007 application skills.

Q: No time for grading? Frustrated by multiple gradebooks?

myitlab's advanced reporting capabilities, including detailed student click-stream data, let you see exactly what actions your students completed click-by-click, for true defensible assessment.

 

A full-functioning gradebook will let you manage all of your course grades in one place. Import/export from popular learning management systems, manipulate and modify individual student grades, and even calculate final grades.

 

Visit us at www.myitlab.com to learn more about this classroom-changing product!

Sequential chapter numbering: In addition to sequential page numbering GO! chapters are now numbered 1 through 22 instead of Word Chapter 1, Excel Chapter 1, etc. This makes the text even easier to navigate.

Project-Based Approach: GO!’s project-based approach clusters the learning objectives around the projects rather than around software features. Teaches students to solve real problems as they practice and learn the features.

• Texts are now organized by objectives and student learning outcomes
• There are always two instructional projects per chapter

“There’s More You Can Do” feature

• Try It! exercises teach students additional skills or new office features that are not  included within the instructional portion of the chapter.

Workshop feature for Excel and PowerPoint chapters help students better understand the uses of these applications.

• The Excel Workshop teaches formulas and other basic math skills and a separate PowerPoint Workshop teaches essential presentation skills

End-of-Chapter organized into two sections: Content–Based Assessments and Outcomes-Based Assessments.

• Now your content-based or defined-solution assessments that can be graded with a solution file or GO! Highlighted Overlays are separated from your non-defined solution assessments that can be graded with the GO! Rubric. 

End-of-Chapter assessments provide even more options for quizzing and review.

• GO! with Help teaches the student to work with the Help feature in Office as a project.
• Group Business Running Case is a project that runs through entire textbook and designed to be assigned to group of students.

Audio/Video Expert Demonstration Documents (A/V-EDDs) are multimedia versions of theExpert Demonstration Documents that provide an alternative scripted lecture scenario of each chapter project in the text.

• Provided in Flash on CD and in OneKey courses for easy delivery
• Ideal for online, lecture reinforcement, and lecture replacement

Assignment Tags for Problem Solving assessments providetask-specific scoring checklists that save time in grading open-ended assessments (assessments without defined solutions).

• Conveniently provided as Excel files and include point values

GO!-Specific instructional content in the new MyITLab assessment and training software for Office 2007: New MyITLab training scenarios deliver the exact same step-by-step content as the projects in the GO! textbook while the assessment provides two additional scenarios of each GO! project.  

Windows XP

Chapter 1 Getting Started with Windows XP

    PROJECT 1A Start Windows XP and Work with Windows, Folders, and Files

        Objective 1 Get Started with Windows XP

            Activity 1.1 Getting Started with Windows XP

        Objective 2 Resize, Move, and Scroll Windows

            Activity 1.2 Resizing, Moving, and Scrolling Windows

        Objective 3 Maximize, Restore, Minimize, and Close Windows

            Activity 1.3 Maximizing, Restoring, Minimizing, and Closing a Window

        Objective 4 Create a New Folder

            Activity 1.4 Creating a New Folder

        Objective 5 Copy, Move, Rename, and Delete Files

            Activity 1.5 Copying Files and Folders

            Activity 1.6 Moving, Renaming, and Deleting Files

            Activity 1.7 Capturing an Image of a Screen

        Objective 6 Find Files and Folders

            Activity 1.8 Finding Files and Folders

        Objective 7 Compress Files

            Activity 1.9 Compressing Files

        Outlook 2007

Chapter 2 Getting Started with Outlook 2007

    PROJECT 2A Read and Respond to E-mail Using Outlook 2007

        Objective 1 Start and Navigate Outlook

            Activity 2.1 Starting Outlook

            Activity 2.2 Exploring Outlook Using the Navigation Pane and Folder List

            Activity 2.3 Using Menus, Toolbars, and ScreenTips

        Objective 2 Read and Respond to E-mail

            Activity 2.4 Importing Messages into the Inbox

            Activity 2.5 Opening, Navigating, and Closing an E-mail Message

            Activity 2.6 Configuring Outlook and Replying to a Message

            Activity 2.7 Printing the Inbox and a Message

        Objective 3 Delete Outlook Information and Close Outlook

            Activity 2.8 Deleting Outlook Messages

            Activity 2.9 Resetting Outlook Defaults and Closing Outlook

    PROJECT 2B Manage Personal Information Using Outlook 2007

        Objective 4 Store Contact Information

            Activity 2.10 Creating Contacts

            Activity 2.11 Editing Contacts and Printing the Contacts List

        Objective 5 Manage Tasks

            Activity 2.12 Creating and Printing a To-Do List

        Objective 6 Work with the Calendar

            Activity 2.13 Exploring the Calendar

            Activity 2.14 Scheduling Appointments and Tasks

            Activity 2.15 Printing a Calendar

Internet Explorer

Chapter 3 Getting Started with Internet Explorer 7.0

    PROJECT 3A Use Internet Explorer 7.0 to Navigate and Search the Internet, Create and Manage Your Favorite Internet Sites, and Save and Print Web Pages

        Objective 1 Start Internet Explorer 7.0 and Identify Screen Elements

            Activity 3.1 Starting Internet Explorer

        Objective 2 Navigate the Internet

            Activity 3.2 Performing Commands Using the Toolbar

            Activity 3.3 Accessing Web Sites from the Address Bar

            Activity 3.4 Opening a Second Web Site

            Activity 3.5 Displaying Web Pages with Hyperlinks

            Activity 3.6 Using Internet Explorer History

        Objective 3 Create and Manage Favorites

            Activity 3.7 Adding an Address to the Favorites List

            Activity 3.8 Displaying a Favorite Web Site

            Activity 3.9 Deleting a Web Address from Favorites

        Objective 4 Search the Internet

            Activity 3.10 Adding a Search Engine and Searching the Internet

        Objective 5 Save and Print Web Pages

            Activity 3.11 Downloading and Saving a Web Page

            Activity 3.12 Downloading and Saving Graphics from a Web Page

            Activity 3.13 Printing Web Pages

            Activity 3.14 Printing Web Graphics

            Activity 3.15 Printing Selected Text from Web Pages

Chapter 4 Basic Computer Concepts

        Objective 1 Define Computer and Identify the Four Basic Computing Functions

        Objective 2 Identify the Different Types of Computers

            Microcomputers

            Servers

            Mainframe Computers

            Supercomputers

            Embedded Computers

        Objective 3 Describe Hardware Devices and Their Uses

            System Unit

            Storage Devices

            Evaluating Your System

            Ports

            Input Devices

            Output Devices

        Objective 4 Identify Types of Software and Their Uses

             System Software

            Application Software

        Objective 5 Describe Networks and Define Network Terms

        Objective 6 Identify Safe Computing Practices

            Computer Maintenance

            Viruses

            Spyware

            Protecting Yourself and Your Computer

    PROJECT 5A Create, Edit, Save, and Print a Document

        Objective 1 Create and Save a New Document

            Activity 5.1 Starting Word and Identifying Parts of the Word Window

            Activity 5.2 Beginning a New Document and Displaying Formatting Marks

            Activity 5.3 Entering Text and Inserting Blank Lines

            Activity 5.4 Creating Folders for Document Storage and Saving a Document

        Objective 2 Edit Text

            Activity 5.5 Editing Text with the Delete and Backspace Keys

            Activity 5.6 Inserting New Text

        Objective 3 Select, Delete, and Format Text

            Activity 5.7 Selecting and Deleting Text

            Activity 5.8 Changing Font and Font Size

            Activity 5.9 Adding Emphasis to Text

    Objective 4 Print a Document

            Activity 5.10 Accessing Headers and Footers

            Activity 5.11 Printing a Document

    PROJECT 5B Navigate the Word Window and Check Your Work

        Objective 5 Navigate the Word Window

            Activity 5.12 Opening and Closing an Existing Document

            Activity 5.13 Inserting Existing Text into a New Document

            Activity 5.14 Navigating a Document

            Activity 5.15 Changing Document Views

            Activity 5.16 Using the Zoom Slider

            Activity 5.17 Splitting Windows and Arranging Panes

    Objective 6 Add a Graphic to a Document

            Activity 5.18 Inserting Clip Art

    Objective 7 Use the Spelling and Grammar Checker

            Activity 5.19 Checking Individual Spelling and Grammar Errors

            Activity 5.20 Checking Spelling and Grammar in an Entire Document

    Objective 8 Preview and Print Documents, Close a Document, and Close Word

            Activity 5.21 Previewing and Printing a Document

            Activity 5.22 Closing a Document and Closing Word

    Objective 9 Use the Microsoft Help System

            Activity 5.23 Getting Help

Chapter 6 Formatting and Organizing Text

    PROJECT 6A Format Text and Use Lists

        Objective 1 Change Document and Paragraph Layout

            Activity 6.1 Setting Margins

            Activity 6.2 Aligning Text

            Activity 6.3 Changing Line Spacing

            Activity 6.4 Adding Space After Paragraphs

            Activity 6.5 Using the Format Painter

        Objective 2 Change and Reorganize Text

            Activity 6.6 Finding and Replacing Text

            Activity 6.7 Cutting, Copying, and Pasting Text

            Activity 6.8 Moving Text to a New Location

            Activity 6.9 Undoing and Redoing Changes

            Activity 6.10 Inserting a Nonbreaking Spaces and Hyphens

            Activity 6.11 Entering a Line Break

        Objective 3 Create and Modify Lists

            Activity 6.12 Creating a Bulleted List

            Activity 6.13 Using AutoFormat to Create a Numbered List

            Activity 6.14 Formatting Lists

            Activity 6.15 Customizing Bullets

    PROJECT 6B Create a Research Paper

        Objective 4 Insert and Format Headers and Footers

            Activity 6.16 Inserting and Formatting Page Numbers

            Activity 6.17 Inserting the Current Date and Time

        Objective 5 Insert Frequently Used Text

            Activity 6.18 Recording AutoCorrect Entries

            Activity 6.19 Inserting Symbols

        Objective 6 Insert and Format References

            Activity 6.20 Inserting Footnotes

            Activity 6.21 Modifying a Footnote Style

            Activity 6.22 Adding Citations

            Activity 6.23 Creating a Reference Page

            Activity 6.24 Managing Document Properties

Chapter 7 Using Graphics and Tables

    PROJECT 7A Insert and Modify Graphics and Set Tab Stops

        Objective 1 Insert and Format Graphics

            Activity 7.1 Formatting Text Using WordArt

            Activity 7.2 Inserting Pictures from Files

            Activity 7.3 Resizing a Graphic

            Activity 7.4 Wrapping Text Around a Graphic

            Activity 7.5 Moving a Graphic

            Activity 7.6 Applying Picture Styles

            Activity 7.7 Adding a Page Border

        Objective 2 Set Tab Stops

            Activity 7.8 Setting Tab Stops and Using Click and Type

            Activity 7.9 Formatting and Removing Tab Stops

            Activity 7.10 Using Tab Stops to Enter Text

            Activity 7.11 Moving Tab Stops

        Objective 3 Insert and Modify Text Boxes and Shapes

            Activity 7.12 Inserting a Text Box

            Activity 7.13 Moving, Resizing, and Formatting a Text Box

            Activity 7.14 Inserting a Predefined Shape

    PROJECT 7B Create and Format a Table

        Objective 4 Create a Table

            Activity 7.15 Creating and Entering Text into a Table

            Activity 7.16 Adding a Row to a Table

            Activity 7.17 Changing the Width of a Table Column

            Activity 7.18 Adding a Column to a Table

            Activity 7.19 Converting Text to Tables

        Objective 5 Format a Table

            Activity 7.20 Formatting Text in Cells and Shading Cells

            Activity 7.21 Changing the Table Border

            Activity 7.22 Centering a Table

            Activity 7.23 Merging Cells

            Activity 7.24 Applying a Predefined Format to a Table

Chapter 8 Special Document Formats, Columns, and Mail Merge

    PROJECT 8A Create a Multicolumn Newsletter and Print Mailing Labels

        Objective 1 Collect and Paste Text and Graphics

            Activity 8.1 Using Collect and Paste to Gather Images and Text

            Activity 8.2 Pasting Information from the Clipboard Task Pane

        Objective 2 Create and Format Columns

            Activity 8.3 Changing One Column Text to Two Columns

            Activity 8.4 Formatting Multiple Columns

            Activity 8.5 Inserting a Column Break

            Activity 8.6 Adding Graphics to Columns

        Objective 3 Use Special Character and Paragraph Formatting

            Activity 8.7 Using Small Caps and Changing Font Color

            Activity 8.8 Adding a Border and Shading to a Paragraph

        Objective 4 Create Mailing Labels Using Mail Merge

            Activity 8.9 Opening the Mail Merge Wizard Template

            Activity 8.10 Completing the Mail Merge Wizard

            Activity 8.11 Previewing and Printing the Mail Merge Document

    PROJECT 8B Create and Preview a Web Page

        Objective 5 Insert Hyperlinks

            Activity 8.12 Inserting Text Hyperlinks

            Activity 8.13 Adding a Hyperlink to a Graphic

            Activity 8.14 Testing and Modifying Hyperlinks

        Objective 6 Insert a SmartArt Graphic

            Activity 8.15 Inserting a SmartArt Graphic

            Activity 8.16 Adding Text to a SmartArt Graphic

        Objective 7 Preview and Save a Document as a Web Page

            Activity 8.17 Previewing a Document as a Web Page

            Activity 8.18 Saving a Document as a Web Page

Excel 2007

Chapter 9 Creating a Worksheet and Charting Data

    PROJECT 9A Create a Worksheet and Chart Data

        Objective 1 Create, Save, and Navigate an Excel Workbook

            Activity 9.1 Starting Excel and Naming and Saving a Workbook

            Activity 9.2 Navigating a Worksheet and a Workbook

            Activity 9.3 Selecting Parts of a Worksheet

        Objective 2 Enter and Edit Data in a Worksheet

            Activity 9.4 Entering Text, Using AutoComplete, Filling a Series with Auto Fill, and Using Spelling Checker and Undo to Correct Typing Errors

            Activity 9.5 Aligning Text and Adjusting the Size of Columns and Rows

            Activity 9.6 Entering Numbers

            Activity 9.7 Inserting and Deleting Rows and Columns, and Using the Insert Options Button

        Objective 3 Construct and Copy Formulas, Use the Sum Function, and Edit Cells

            Activity 9.8 Constructing a Formula, Using the Sum Function, and Editing Numbers in Cells

            Activity 9.9 Copying a Formula by Using the Fill Handle

        Objective 4 Format Data, Cells, and Worksheets

            Activity 9.10 Formatting Financial Numbers, Using Column AutoFit, and Using Format Painter

            Activity 9.11 Formatting Text and Using Merge and Center

        Objective 5 Close and Reopen a Workbook

            Activity 9.12 Closing and Reopening an Existing Workbook

        Objective 6 Chart Data

            Activity 9.13 Charting Data

        Objective 7 Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel

            Activity 9.14 Changing Views, Creating a Footer, and Using Print Preview

            Activity 9.15 Deleting Unused Sheets in a Workbook

            Activity 9.16 Printing a Worksheet

            Activity 9.17 Displaying, Printing, and Hiding Formulas

PROJECT 9B Perform Calculations and Make Comparisons by Using a Pie Chart

        Objective 8 Design a Worksheet

            Activity 9.18 Setting Column Widths and Creating Row and Column Titles

            Activity 9.19 Entering Data by Range

        Objective 9 Construct Formulas for Mathematical Operations

            Activity 9.20 Using Arithmetic Operators

            Activity 9.21 Copying Formulas Containing Absolute Cell References

        Objective 10 Format Percentages and Move Formulas

            Activity 9.22 Formatting Cells with the Percent Style Button

            Activity 9.23 Inserting Rows in a Worksheet Containing Formulas and Wrapping Text in a Cell Objective 11 Create a Pie Chart and a Chart Sheet

            Activity 9.24 Creating a Pie Chart and a Chart Sheet

        Objective 12 Use the Excel Help System

            Activity 9.25 Using the Excel Help System

Chapter 10 Managing Workbooks and Analyzing Data

    PROJECT 10A Create a Summary Sheet from Multiple Worksheets

        Objective 1 Create and Save a Workbook from an Existing Workbook

            Activity 10.1 Creating and Saving a Workbook from an Existing Workbook

        Objective 2 Navigate a Workbook and Rename Worksheets

            Activity 10.2 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of a Worksheet

        Objective 3 Enter Dates, Clear Contents, and Clear Formats

            Activity 10.3 Entering and Formatting Dates

            Activity 10.4 Clearing Cell Contents and Formats

        Objective 4 Move, Copy, and Paste Cell Contents

            Activity 10.5 Copying, Pasting, and Moving Cell Contents

        Objective 5 Edit and Format Multiple Worksheets at the Same Time

            Activity 10.6 Wrapping Text in a Cell in Several Worksheets at the Same Time

            Activity 10.7 Entering Data and Constructing Formulas on Multiple Worksheets

        Objective 6 Create a Summary Sheet

            Activity 10.8 Constructing Formulas that Refer to Cells in Another Worksheet

        Objective 7 Format and Print Multiple Worksheets in a Workbook

            Activity 10.9 Moving and Formatting Worksheets in a Workbook

            Activity 10.10 Printing All the Worksheets in a Workbook

PROJECT 10B Make Projections Using What-If Analysis

        Objective 8 Design a Worksheet for What-If Analysis

            Activity 10.11 Using Parentheses in a Formula

            Activity 10.12 Formatting as You Type

            Activity 10.13 Calculating a Value After an Increase

        Objective 9 Perform What-If Analysis

            Activity 10.14 Performing What-If Analysis and Using Paste Special

        Objective 10 Compare Data with a Line Chart

            Activity 10.15 Creating a Line Chart

Chapter 11 Using Functions and Tables

    PROJECT 11A Track Inventory by Using Math, Logical, and Statistical Functions and by Creating an Excel Table

        Objective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

            Activity 11.1 Using the SUM, AVERAGE, and MEDIAN Functions

            Activity 11.2 Using the MIN and MAX Functions

            Activity 11.3 Moving Data, Adding Borders, and Rotating Text

        Objective 2 Use COUNTIF and IF Functions, and Apply Conditional Formatting

            Activity 11.4 Using the COUNTIF Function

            Activity 11.5 Using the IF Function and Applying Conditional Formatting

            Activity 11.6 Applying Conditional Formatting Using Custom Formats and Data Bars

            Activity 11.7 Using Find and Replace

        Objective 3 Use a Date Function

            Activity 11.8 Using the NOW Function

        Objective 4 Freeze Panes and Create an Excel Table

            Activity 11.9 Freezing and Unfreezing Panes

            Activity 11.10 Sorting and Filtering in an Excel Table

            Activity 11.11 Inserting a Second Table in a Worksheet

            Activity 11.12 Converting a Table to a Range of Data

        Objective 5 Format and Print a Large Worksheet

            Activity 11.13 Printing Large Worksheets

    PROJECT 11B Make Financial Decisions by Using Financial Functions and What-If Analysis

        Objective 6 Use Financial Functions

            Activity 11.14 Designing a Loan Worksheet

            Activity 11.15 Inserting the PMT Financial Function

        Objective 7 Use Goal Seek

            Activity 11.16 Using Goal Seek to Produce the Desired Result

            Activity 11.17 Using Goal Seek to Find an Increased Period

        Objective 8 Create a Data Table

            Activity 11.18 Designing a Two-Variable Data Table

            Activity 11.19 Using a Data Table to Calculate Options

    PROJECT 12A Create a New Blank Database

        Objective 1 Start Access and Create a New Blank Database

            Activity 12.1 Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database

        Objective 2 Add Records to a Table

            Activity 12.2 Adding Records to a Table

        Objective 3 Rename Table Fields in Datasheet View

            Activity 12.3 Renaming the Fields In a Table in Datasheet View

            Activity 12.4 Changing the Data Type of a Field in Datasheet View

        Objective 4 Modify the Design of a Table

            Activity 12.5 Deleting a Field in Design View

            Activity 12.6 Modifying a Field Size and Description in Design View

            Activity 12.7 Setting a Primary Key and Saving a Table

        Objective 5 Add a Second Table to a Database

            Activity 12.8 Adding a Second Table to a Database

            Activity 12.9 Adding Records to a Second Table

        Objective 6 Print a Table

            Activity 12.10 Adjusting Column Widths and Printing a Table

        Objective 7 Create and Use a Query

            Activity 12.11 Using the Simple Query Wizard to Create a Query

        Objective 8 Create and Use a Form

            Activity 12.12 Creating a Form

        Objective 9 Create and Print a Report

            Activity 12.13 Creating and Printing a Report

        Objective 10 Close and Save a Database

            Activity 12.14 Closing and Saving a Database

    PROJECT 12B Create a Database from a Template

        Objective 11 Create a Database Using a Template

            Activity 12.15 Creating a New Database Using a Template

            Activity 12.16 Building a Table by Entering Records in a Multiple Items Form

        Objective 12 Organize Database Objects in the Navigation Pane

            Activity 12.17 Organizing Database Objects in the Navigation Pane

        Objective 13 Create a New Table in a Database Created with a Template

            Activity 12.18 Creating a New Table and Changing Its Design

        Objective 14 View a Report and Print a Table in a Database Created with a Template

            Activity 12.19 Viewing a Report

            Activity 12.20 Printing a Table

        Objective 15 Use the Access Help System

            Activity 12.21 Using the Access Help System

Chapter 13 Sort and Query a Database

    PROJECT 13A Sort and Query a Database

        Objective 1 Open an Existing Database

            Activity 13.1 Renaming and Opening an Existing Database

            Activity 13.2 Opening an Existing Database and Resolving Security Alerts

        Objective 2 Create Table Relationships

            Activity 13.3 Creating Table Relationships and Enforcing Referential Integrity

            Activity 13.4 Printing a Relationship Report

        Objective 3 Sort Records in a Table

            Activity 13.5 Sorting Records in a Table in Ascending or Descending Order

            Activity 13.6 Sorting Records in a Table on Multiple Fields

        Objective 4 Create a Query in Design View

            Activity 13.7 Creating a New Select Query in Design View

            Activity 13.8 Running, Saving, Printing, and Closing a Query

        Objective 5 Create a New Query from an Existing Query

            Activity 13.9 Creating a New Query From an Existing Query

        Objective 6 Sort Query Results

            Activity 13.10 Sorting Query Results

        Objective 7 Specify Criteria in a Query

            Activity 13.11 Specifying Text Criteria in a Query

            Activity 13.12 Specifying Criteria Using a Field Not Displayed in the Query Result

            Activity 13.13 Using Is Null Criteria to Find Empty Fields

    PROJECT 13B Create a Database Table from an Excel Spreadsheet and Create Complex Queries

        Objective 8 Create a New Table by Importing an Excel Spreadsheet

            Activity 13.14 Opening an Existing Database and Preparing to Import an Excel Spreadsheet

            Activity 13.15 Creating a New Table by Importing an Excel Spreadsheet

        Objective 9 Specify Numeric Criteria in a Query

            Activity 13.16 Specifying Numeric Criteria in a Query

            Activity 13.17 Using Comparison Operators

            Activity 13.18 Using the Between. . . And Comparison Operator

        Objective 10 Use Compound Criteria

            Activity 13.19 Using AND Criteria in a Query

            Activity 13.20 Using OR Criteria in a Query

        Objective 11 Create a Query Based on More Than One Table

            Activity 13.21 Creating a Query Based on More Than One Table

        Objective 12 Use Wildcards in a Query

            Activity 13.22 Using a Wildcard in a Query

        Objective 13 Use Calculated Fields in a Query

            Activity 13.23 Using Calculated Fields in a Query

        Objective 14 Group Data and Calculate Statistics in a Query

            Activity 13.24 Using the MIN, MAX, AVG and SUM Functions in a Query

            Activity 13.25 Grouping Data in a Query

Chapter 14 Forms, Filters, and Reports

    PROJECT 14A Create Forms to Enter and Display Data in a Database

        Objective 1 Create a Form

            Activity 14.1 Creating a Form

        Objective 2 Use a Form to Add and Delete Records

            Activity 14.2 Adding Records to a Table by Using a Form

            Activity 14.3 Deleting Records from a Table by Using a Form

            Activity 14.4 Printing a Form

        Objective 3 Create a Form by Using the Form Wizard

            Activity 14.5 Creating a Form Using the Form Wizard

        Objective 4 Modify a Form in Design View and in Layout View

            Activity 14.6 Modifying a Form in Design View

            Activity 14.7 Adding, Resizing, and Moving Controls in Layout View

            Activity 14.8 Formatting and Aligning Controls in Layout View

        Objective 5 Filter Records

            Activity 14.9 Filtering Data by Selection on One Field

            Activity 14.10 Using Filter by Form

    PROJECT 14B Create Reports to Display Database Information

        Objective 6 Create a Report by Using the Report Tool

            Activity 14.11 Creating and Modifying a Report by Using the Report Tool and Layout View

        Objective 7 Create a Report by Using the Blank Report Tool

            Activity 14.12 Creating a Report by Using the Blank Report Tool

        Objective 8 Create a Report by Using the Report Wizard

            Activity 14.13 Creating a Report by Using the Report Wizard

        Objective 9 Modify the Design of a Report

            Activity 14.14 Modifying a Report in Layout View

            Activity 14.15 Modifying a Report in Design View

        Objective 10 Print a Report and Keep Data Together

            Activity 14.16 Keeping Data Together and Printing a Report

    PROJECT 15A Open, Edit, Save, and Print a Presentation

        Objective 1 Open, View, and Save a Presentation

            Activity 15.1 Starting PowerPoint and Identifying Parts of the PowerPoint Window

            Activity 15.2 Opening a Presentation

            Activity 15.3 Viewing a Slide Show

            Activity 15.4 Creating Folders and Saving a Presentation

        Objective 2 Edit a Presentation

            Activity 15.5 Editing Slide Text

            Activity 15.6 Inserting a New Slide

            Activity 15.7 Increasing and Decreasing List Levels

            Activity 15.8 Checking Spelling

            Activity 15.9 Editing Text by Using the Thesaurus

            Activity 15.10 Adding Speaker’s Notes to a Presentation

        Objective 3 Format a Presentation

            Activity 15.11 Changing Font and Font Size

            Activity 15.12 Applying Font Styles

            Activity 15.13 Aligning Text and Changing Line Spacing

            Activity 15.14 Modifying Slide Layout

            Activity 15.15 Changing the Presentation Theme

        Objective 4 Create Headers and Footers and Print a Presentation

            Activity 15.16 Creating Headers and Footers

            Activity 15.17 Previewing and Printing a Presentation and Closing PowerPoint

    PROJECT 15B Create and Format a Presentation

        Objective 5 Create a New Presentation

            Activity 15.18 Starting a New Presentation

            Activity 15.19 Inserting Slides from an Existing Presentation

        Objective 6 Use Slide Sorter View

            Activity 15.20 Selecting and Deleting Slides

            Activity 15.21 Moving Slides

        Objective 7 Add Pictures to a Presentation

            Activity 15.22 Inserting Clip Art

            Activity 15.23 Moving and Sizing Images

            Activity 15.24 Applying a Style to a Picture

        Objective 8 Use the Microsoft Help System

            Activity 15.25 Accessing PowerPoint Help

Chapter 16 Designing a PowerPoint Presentation

    PROJECT 16A Format a Presentation

        Objective 1 Format Slide Elements

            Activity 16.1 Selecting Placeholder Text and Using the Repeat Key

            Activity 16.2 Changing a Bulleted List to a Numbered List

            Activity 16.3 Modifying the Bulleted List Style

            Activity 16.4 Applying WordArt Styles to Text

            Activity 16.5 Using Format Painter

        Objective 2 Insert and Format Pictures and Shapes

            Activity 16.6 Inserting a Picture Using a Content Layout

            Activity 16.7 Changing the Size and Shape of a Picture

            Activity 16.8 Inserting and Positioning a Text Box

            Activity 16.9 Inserting, Sizing, and Positioning Shapes

            Activity 16.10 Adding Text to Shapes

            Activity 16.11 Applying Shape and Picture Styles

            Activity 16.12 Duplicating and Aligning Objects

        Objective 3 Apply Slide Transitions

            Activity 16.13 Applying Slide Transitions to a Presentation

    PROJECT 16B Enhance a Presentation with SmartArt Graphics

        Objective 4 Reorganize Presentation Text and Clear Formats

            Activity 16.14 Moving and Copying Text

            Activity 16.15 Copying Multiple Selections by Using the Office Clipboard

            Activity 16.16 Undoing and Redoing Changes

            Activity 16.17 Clearing Formatting from a Selection

        Objective 5 Create and Format a SmartArt Graphic

            Activity 16.18 Creating a SmartArt Diagram by Using a Content Layout

            Activity 16.19 Adding and Removing Shapes in a Diagram

            Activity 16.20 Changing the Diagram Type and Size

            Activity 16.21 Creating a SmartArt Diagram from Bullet Points

            Activity 16.22 Changing the Color and Style of a Diagram

Chapter 17 Enhancing a Presentation with Animation, Tables, and Charts

    PROJECT 17A Customize a Presentation

        Objective 1 Customize Slide Backgrounds and Themes

            Activity 17.1 Applying a Background Style

            Activity 17.2 Hiding Background Graphics

            Activity 17.3 Formatting a Slide Background with a Picture

            Activity 17.4 Applying a Background Fill Color and Resetting a Slide Background

            Activity 17.5 Modifying Font Themes

        Objective 2 Animate a Slide Show

            Activity 17.6 Applying Entrance Effects

            Activity 17.7 Setting Effect and Timing Options

            Activity 17.8 Applying Animation to a SmartArt Graphic

    PROJECT 17B Present Data with Tables and Charts

        Objective 3 Create and Modify Tables

            Activity 17.9 Creating a Table

            Activity 17.10 Modifying the Layout of a Table

            Activity 17.11 Modifying a Table Design

        Objective 4 Create and Modify Charts

            Activity 17.12 Creating a Column Chart and Applying a Chart Style

            Activity 17.13 Deleting Chart Data and Changing the Chart Type

            Activity 17.14 Animating a Chart

    PROJECT 18A Use Access Data with Other Office Programs

        Objective 1 Export Access Data to Excel

            Activity 18.1 Exporting Access Data to Excel

        Objective 2 Create a Formula in Excel

            Activity 18.2 Creating a Formula for Calculation in Excel

        Objective 3 Create a Chart in Excel

            Activity 18.3 Creating a Chart in Excel

        Objective 4 Copy Access Data into a Word Document

            Activity 18.4 Copying Access Data to a Word Document

        Objective 5 Copy Excel Data into a Word Document

            Activity 18.5 Copying Excel Data to a Word Document

        Objective 6 Insert an Excel Chart into a PowerPoint Presentation

            Activity 18.6 Adding an Excel Chart to a PowerPoint Presentation

Chapter 19 Using Tables in Word and Excel

    PROJECT 19A Use Tables in Word and Excel

        Objective 1 Plan a Table in Word

            Activity 19.1 Starting Word and Planning the Table

        Objective 2 Enter Data and Format a Table in Word

            Activity 19.2 Entering Data

            Activity 19.3 Formatting a Table

        Objective 3 Create a Table in Word from Excel Data

            Activity 19.4 Creating a Table in Word from Excel Data

        Objective 4 Create an Excel Worksheet from a Word Table

            Activity 19.5 Creating an Excel Worksheet from a Word Table

Chapter 20 Using Excel as a Data Source in a Mail Merge

    PROJECT 20A Use Excel as a Data Source in a Mail Merge

        Objective 1 Prepare a Mail Merge Document for Mailing Labels

            Activity 20.1 Setting up Mailing Labels Using the Mailings Tab

        Objective 2 Choose an Excel Worksheet as a Data Source

            Activity 20.2 Selecting the Data Source for the Mailing Labels

        Objective 3 Produce and Save Merged Mailing Labels

            Activity 20.3 Adding Merge Fields to the Mailing Labels

            Activity 20.4 Producing the Mailing Labels

        Objective 4 Open a Saved Main Document for Mail Merge

            Activity 20.5 Opening a Main Document for Mail Merge

Chapter 21 Linking Data in Office Documents

    PROJECT 21A Link Data in Office Documents

        Objective 1 Insert and Link an Excel Object in Word

            Activity 21.1 Inserting and Linking an Excel Object

        Objective 2 Revise a Linked Excel Worksheet and Update Links in Word

            Activity 21.2 Revising a Linked Worksheet and Updating Links in a Document

        Objective 3 Open a Word Document that Includes a Linked Object and Update Links

            Activity 21.3 Opening a Word Document That Includes a Linked Object

            Activity 21.4 Updating a Linked Object

Chapter 22 Creating Presentation Content from Office Documents

 PROJECT 22A Create Presentation Content from Office Documents

        Objective 1 Insert a Word Outline into PowerPoint

            Activity 22.1 Inserting a Word Outline into PowerPoint

        Objective 2 Import Excel Data into a PowerPoint Chart

            Activity 22.2 Importing Excel Data into a Chart in PowerPoint

        Objective 3 Insert a Hyperlink into a PowerPoint Slide

            Activity 22.3 Inserting a Hyperlink into a PowerPoint Slide

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Robert L. Ferret recently retired as the director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty.  He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, and Word.  Before writing the GO! Series, Bob was a series editor and author for the Learn Series.  He has a bachelor’s degree in psychology, a master’s degree in geography, and a master’s degree in interdisciplinary technology from Eastern Michigan University.  Bob’s doctoral studies were in instructional technology at Wayne State University.  For fun, Bob teaches a four-week computers and genealogy class and has written genealogy and local history books.

Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College.  She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Suzanne Marks is a faculty member in Business Technology Systems at Bellevue Community College, Bellevue, Washington.  She holds a bachelor’s degree in business education from Washington State University, and was project manager for the first IT Skills Standards in the United States.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0132458993 | ISBN-13: 9780132458993
©2008 | Instock
Suggested retail price: $132.67  Buy from myPearsonStore
Net price: $99.50  (What's this?)
This package contains:

Package ISBN-10: 0138020558 | ISBN-13: 9780138020552
©2008 | Instock
Suggested retail price: $149.40  Buy from myPearsonStore
Net price: $112.05  (What's this?)
This package contains:

Package ISBN-10: 0137009917 | ISBN-13: 9780137009916
©2008 | Instock
Suggested retail price: $186.60  Buy from myPearsonStore
Net price: $139.95  (What's this?)
This package contains:

Package ISBN-10: 0136077595 | ISBN-13: 9780136077596
©2008 | Instock
Suggested retail price: $137.80  Buy from myPearsonStore
Net price: $103.35  (What's this?)
This package contains:

Package ISBN-10: 0136113710 | ISBN-13: 9780136113713
©2008 | Instock
Suggested retail price: $130.87  Buy from myPearsonStore
Net price: $98.15  (What's this?)
This package contains:

Package ISBN-10: 013209178X | ISBN-13: 9780132091787
©2008 | Instock
Suggested retail price: $222.40  Buy from myPearsonStore
Net price: $166.80  (What's this?)
This package contains:

Package ISBN-10: 0136084664 | ISBN-13: 9780136084662
©2008 | Instock
Suggested retail price: $164.00  Buy from myPearsonStore
Net price: $123.00  (What's this?)
This package contains:

Package ISBN-10: 0136084303 | ISBN-13: 9780136084303
©2008 | Instock
Suggested retail price: $151.53  Buy from myPearsonStore
Net price: $113.65  (What's this?)
This package contains:

Package ISBN-10: 013286438X | ISBN-13: 9780132864381
©2008 | Instock
Suggested retail price: $163.00  Buy from myPearsonStore
Net price: $122.25  (What's this?)
This package contains:

Package ISBN-10: 0138153868 | ISBN-13: 9780138153861
©2009 | Not Yet Published
Suggested retail price: $122.00  
Net price: $91.50  (What's this?)
This package contains:

This package contains:
•   Gaskin, AV-EDDs and PodCasts for GO! Office 2007 Introductory, 2/E (2009)
•   Gaskin, Ferrett, Vargas & Marks, GO! with Microsoft Office 2007 Introductory (2008)