Description

Features

For students taking an introductory course using a project-based introduction to Microsoft Office 2007.

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 instructors.

Office 2007 Made Easy!

The GO! System is designed for ease of implementation on the instructor side and ease of understanding on the student.  It has been completely developed based on professor and student feedback.

• Microsoft Procedural Syntax - The procedural steps begin with where the action is to take place, followed by the action itself.  The instruction is error-free, clearly written, and logically arranged.
• Project-Based Instruction — Students do not practice features of the application; they create real projects that teach them skills needed for the real-world, which are color-coded for easy reference.
• Learning Objectives and Student Outcomes — Objectives are clustered around projects that result in student outcomes.  They help students learn how to solve problems, not just learn software features.

• A and B Projects — Each chapter contains two instructional projects —A and B.
• Visual Summary — Shows students upfront what their projects will look like when completed.
• Project Summary — Stated quickly and clearly in one paragraph.
• Teachable Moment — Expository text is woven into the steps–at the moment students need to know it–not chunked together in a block of text that will go unread.
• File Guide — Clearly shows students which files are needed for the project and the names they will use to save their documents.
• Screen Shots — Larger examples of what students will see when trying a skill themselves.
• Objective — The skills the student will learn are clearly stated at the beginning of each project and color coded to match projects listed on the chapter opener page.
• Steps — Color-coded to the current project, steps are provided to guide the students throughout.

• End-of-Project Icon — All projects in the GO! Series have clearly identifiable end points, useful in self-paced or online environments.
• Try It! Exercises — Teach readers additional skills or new Office features that are not included within the instructional portion of each chapter.
• Sequential Pagination — No longer are there any confusing letters and abbreviations.
• Alert Box — Draws students’ attention to make sure they are not getting too far off course.
• Another Way Box — Shows students alternate ways of doing tasks.
• More Knowledge Box — Expands on a topic by going deeper into the material.
• Note Box — Points out important items to remember.
• Rubric — A matrix that states the criteria and standards for grading student work that is used to grade open-ended assignments.

The GO! Instructional System is divided into three categories that reflect how an instructor might organize the course. 

Prepare

• Transition Guide — The authors have made it quick and easy to plan the format and activities for class.
• Syllabus Template — Includes course calendar planner for 8-, 12-, and 16-week formats.
• Assignment Sheet — One per chapter that lists all possible assignments.
• File Guide to the GO! Supplements — Tabular listing of all supplements and their file names.
• Assignment Planning Guide — Description of the GO! assignments with recommendations based on class size, delivery mode, and student needs.
• Student Data Files — Examples of homework submissions to serve as examples for students.
• PowerPoints — Slides that feature key points of each chapter.
• Online Study Guide for Students — Interactive objective-style questions based on chapter content.

Teach

• Annotated Instructors Edition — Includes the entire student text, three-hole punched and wrapped with teaching notes, annotations, troubleshooting tips, etc.
• Chapter Dividers clearly outline the resources per chapter by activity level: Prepare, Teach, Assess
• Instructor File Guide lists all of the Student Data Files and instructor solution files needed for the chapter
• Helpful Hints, Teaching Tips, and Expand the Project boxes correspond to what is being taught in the student textbook
• End of Chapter Concepts Assessments contain the answers for quick reference
• Rubric from the student text is included in the AIE with suggested weights for each of the criteria and levels of performance
• Expert Demonstration Documents — Scripted lectures provided to the instructor which mirror the A & B projects in each chapter and can be used for in-class instruction
• NEW! Audio-Video Expert Demonstration Documents — Multimedia versions of the Expert Demonstration Documents

Assess

• Assignment Tags — Scoring checklist for assignments that is also available for Problem-Solving projects.
• Point-Counted Production Tests (PCPT’s) — A cumulative exam for each chapter and project that is easy to score using the provided checklist with suggested points for each task.
• Solution Files — Application and PDF Format

New To This Edition

Table of Contents

Word 2007 

Objective 1 Create and Save a New Document

Objective 2 Edit Text

Objective 3 Select, Delete, and Format Text

Objective 4 Print a Document

Objective 5 Navigate the Word Window

Objective 6 Add a Graphic to a Document

Objective 7 Use the Spelling and Grammar Checker

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

Objective 9 Use the Microsoft Help System

Word Chapter 6 Formatting and Organizing Text

Objective 1 Change Document and Paragraph Layout

Objective 2 Change and Reorganize Text

Objective 3 Create and Modify Lists

Objective 4 Insert and Format Headers and Footers

Objective 5 Insert Frequently Used Text

Objective 6 Insert and Format References

Word Chapter 7 Using Graphics and Tables

Objective 1 Insert and Format Graphics

Objective 2 Set Tab Stops

Objective 3 Insert and Modify Text Boxes and Shapes

Objective 4 Create a Table

Objective 5 Format a Table

Word Chapter 8 Special Document Formats, Columns, and Mail Merge

Objective 1 Collect and Paste Text and Graphics

Objective 2 Create and Format Columns

Objective 3 Use Special Character and Paragraph Formatting

Objective 4 Create Mailing Labels Using Mail Merge

Objective 5 Insert Hyperlinks

Objective 6 Insert a SmartArt Graphic

Objective 7 Preview and Save a Document as a Web Page

Excel Chapter 9 Creating a Worksheet and Charting Data

Objective 1 Create, Save, and Navigate an Excel Workbook

Objective 2 Enter and Edit Data in a Worksheet

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

Objective 4 Format Data, Cells, and Worksheets

Objective 5 Close and Reopen a Workbook

Objective 6 Chart Data

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

Objective 8 Design a Worksheet

Objective 9 Construct Formulas for Mathematical Operations

Objective 10 Format Percentages and Move Formulas

Objective 11 Create a Pie Chart and a Chart Sheet

Objective 12 Use the Excel Help System

Excel Chapter 10 Managing Workbooks and Analyzing Data

Objective 1 Create and Save a Workbook from an Existing Workbook

Objective 2 Navigate a Workbook and Rename Worksheets

Objective 3 Enter Dates, Clear Contents, and Clear Formats

Objective 4 Move, Copy, and Paste Cell Contents

Objective 5 Edit and Format Multiple Worksheets at the Same Time

Objective 6 Create a Summary Sheet

Objective 7 Format and Print Multiple Worksheets in a Workbook

Objective 8 Design a Worksheet for What-If Analysis

Objective 9 Perform What-If Analysis

Objective 10 Compare Data with a Line Chart

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

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

Objective 3 Use a Date Function

Objective 4 Freeze Panes and Create an Excel Table

Objective 5 Format and Print a Large Worksheet

Objective 6 Use Financial Functions

Objective 7 Use Goal Seek

Objective 8 Create a Data Table

Access 2007

Objective 1 Start Access and Create a New Blank Database

Objective 2 Add Records to a Table

Objective 3 Rename Table Fields in Datasheet View

Objective 4 Modify the Design of a Table

Objective 5 Add a Second Table to a Database

Objective 6 Print a Table

Objective 7 Create and Use a Query

Objective 8 Create and Use a Form

Objective 9 Create and Print a Report

Objective 10 Close and Save a Database

Objective 11 Create a Database Using a Template

Objective 12 Organize Database Objects in the Navigation Pane

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

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

Objective 15 Use the Access Help System

Access Chapter 13 Sort and Query a Database

Objective 1 Open an Existing Database

Objective 2 Create Table Relationships

Objective 3 Sort Records in a Table

Objective 4 Create a Query in Design View

Objective 5 Create a New Query from an Existing Query

Objective 6 Sort Query Results

Objective 7 Specify Criteria in a Query

Objective 8 Create a New Table by Importing an Excel Spreadsheet

Objective 9 Specify Numeric Criteria in a Query

Objective 10 Use Compound Criteria

Objective 11 Create a Query Based on More Than One Table

Objective 12 Use Wildcards in a Query

Objective 13 Use Calculated Fields in a Query

Objective 14 Group Data and Calculate Statistics in a Query

Access Chapter 14 Forms, Filters, and Reports

Objective 1 Create a Form

Objective 2 Use a Form to Add and Delete Records

Objective 3 Create a Form by Using the Form Wizard

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

Objective 5 Filter Records

Objective 6 Create a Report by Using the Report Tool

Objective 7 Create a Report by Using the Blank Report Tool

Objective 8 Create a Report by Using the Report Wizard

Objective 9 Modify the Design of a Report

Objective 10 Print a Report and Keep Data Together

PowerPoint 2007

PowerPoint Chapter 15 Getting Started with Microsoft PowerPoint 2007

Objective 1 Open, View, and Save a Presentation

Objective 2 Edit a Presentation

Objective 3 Format a Presentation

Objective 4 Create Headers and Footers and Print a Presentation

Objective 5 Create a New Presentation

Objective 6 Use Slide Sorter View

Objective 7 Add Pictures to a Presentation

Objective 8 Use the Microsoft Help System

PowerPoint Chapter 16 Designing a PowerPoint Presentation

Objective 1 Format Slide Elements

Objective 2 Insert and Format Pictures and Shapes

Objective 3 Apply Slide Transitions

Objective 4 Reorganize Presentation Text and Clear Formats

Objective 5 Create and Format a SmartArt Graphic

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

Objective 1 Customize Slide Backgrounds and Themes

Objective 2 Animate a Slide Show

Objective 3 Create and Modify Tables

Objective 4 Create and Modify Charts

Integrated Projects

Chapter 18 Using Access Data with Other Office Programs

Objective 1 Export Access Data to Excel

Objective 2 Create a Formula in Excel

Objective 3 Create a Chart in Excel

Objective 4 Copy Access Data into a Word Document

Objective 5 Copy Excel Data into a Word Document

Objective 6 Insert an Excel Chart into a PowerPoint Presentation

Chapter 19 Using Tables in Word and Excel

Objective 1 Plan a Table in Word

Objective 2 Enter Data and Format a Table in Word

Objective 3 Create a Table in Word from Excel Data

Objective 4 Create an Excel Worksheet from a Word Table

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

Objective 1 Prepare a Mail Merge Document for Mailing Labels

Objective 2 Choose an Excel Worksheet as a Data Source

Objective 3 Produce and Save Merged Mailing Labels

Objective 4 Open a Saved Main Document for Mail Merge

Chapter 21 Linking Data in Office Documents

Objective 1 Insert and Link an Excel Object in Word

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

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

Chapter 22 Creating Presentation Content from Office Documents

Objective 1 Insert a Word Outline into PowerPoint

Objective 2 Import Excel Data into a PowerPoint Chart

Objective 3 Insert a Hyperlink into a PowerPoint Slide

Courses

Office Applications  [GO! SERIES OFFICE 2007/ 2003]   (CIS: Office Applications)

Previous Edition(s)

• GO! with Microsoft Office 2007 Introductory
  Gaskin, Ferrett, Vargas & Marks
  ©2008  |  Prentice Hall  |  Paper; 1504 pp  |  Out of Print
  ISBN-10: 0131679996  |  ISBN-13: 9780131679993
    Brief Description  | 

  

  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.

  More Info
  

Next Edition(s)

• GO! with Microsoft Office 2007 Introductory, 3/E
  Gaskin, Ferrett, Vargas & McLellan
  ©2010  |  Prentice Hall  |  Paper; 1104 pp  |  Instock
  ISBN-10: 0135059232  |  ISBN-13: 9780135059234
  Suggested retail price: $146.67  Buy from myPearsonStoreNet price: $110.00  (What's this?)Brief Description  | 

  

  For courses on Microsoft Office 2007

   

  Teach the course YOU want in LESS TIME! 

   

  The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.

   

  GO! With Microsoft Office 2007 Introductory, 3/e, contains the same essential content as the previous edition, with some pedagogical changes that were made based on user feedback.

  More Info
  

Author Bios

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.

Companion Website for GO! with Office 2007, Introductory, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0132418576  |  ISBN-13: 9780132418577
This online resource is available at no cost at http://www.prenhall.com/gaskin.
More Info

Downloadable Instructor Resources

Show All Downloadable Files

Hide All Downloadable Files

|

Help Downloading Files

Instructor Resource Center on CD-ROM, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  CD-ROM Only  |  Instock
ISBN-10: 013241855X  |  ISBN-13: 9780132418553

Show Downloadable Files

Hide Downloadable Files

|

More Info

TestGen® Computerized Test Bank for GO! with Office 2007, Introductory, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  On-line Supplement  |  Out of Stock
ISBN-10: 0132418541  |  ISBN-13: 9780132418546
This online resource is available at no cost.

Show Downloadable Files

Hide Downloadable Files

|

More Info

Back to top

Companion Website for GO! with Office 2007, Introductory, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0132418576  |  ISBN-13: 9780132418577
This online resource is available at no cost at http://www.prenhall.com/gaskin.
More Info

Back to top

Companion Website for GO! with Office 2007, Introductory, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0132418576  |  ISBN-13: 9780132418577
This online resource is available at no cost at http://www.prenhall.com/gaskin.
More Info

Back to top

AV-EDDs and PodCasts for GO! Office 2007 Introductory, 2/E
Gaskin
©2009  |  Prentice Hall  |  CD-ROM Only  |  Instock
ISBN-10: 0135045983  |  ISBN-13: 9780135045985
Suggested retail price:  $66.67    Buy from myPearsonStoreNet price: $50.00  (What's this?)More Info

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0131588346  |  ISBN-13: 9780131588349
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: File Management
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588354  |  ISBN-13: 9780131588356
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128017  |  ISBN-13: 9780136128014
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332221  |  ISBN-13: 9780132332224
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050625  |  ISBN-13: 9780132050623
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332558  |  ISBN-13: 9780132332552
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050617  |  ISBN-13: 9780132050616
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card  |  Instock
ISBN-10: 0131588311  |  ISBN-13: 9780131588318
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588400  |  ISBN-13: 9780131588400
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

Windows Vista PHIT Tip
Prentice Hall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128025  |  ISBN-13: 9780136128021
Suggested retail price:  $8.67    Buy from myPearsonStoreNet price: $6.50  (What's this?)More Info

Back to top

Companion Website for GO! with Office 2007, Introductory, 2/E
Gaskin, Ferrett, Vargas & Marks
©2009  |  Prentice Hall  |  Website  |  Live
ISBN-10: 0132418576  |  ISBN-13: 9780132418577
This online resource is available at no cost at http://www.prenhall.com/gaskin.
More Info

Back to top

Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

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, see the Packages Tab.

• Custom PHIT: The Pearson Custom Program for CIS
  Pearson
  ©2009  |  Prentice Hall  |  On-line Supplement  |  Live
  ISBN-10: 0135075491  |  ISBN-13: 9780135075494
  This online resource is available at no cost at http://www.pearsoncustom.com/custom-library/custom-phit.
  Brief Description  | 

  

  In a field as broad as information technology, it’s difficult to find content that’s a perfect fit for your course.  Custom PHIT — with access to the best Prentice Hall series Exploring, GO!, In Business, Skills For Success, and more — allows instructors like you to create the ideal resource for their students, one that completely matches the topics they want to teach.

   

  Perfectly suited for Computing Concepts, Office Applications, Word Processing, Excel, Access, Operating Systems, and countless other courses, Custom PHIT enables you to pull together the right chapters for a book that matches your personal approach.

   

  Preview our extensive library online and build your perfect course text quick and easy. 

   

  We're so confident in our ability to deliver a solution that works best for you and your students, we'll send you a sample student copy in a slittle as little as 3-4 weeks so you can judge for yourself.

   

  Help your students; help yourself.  Create a resource that delivers the best possible value — all of the content they need to succeed, and no wasted material or unnecessary expense.

  More Info
  

• GO! with Office 2007, Introductory, CourseSmart eTextbook, 2/E
  Gaskin, Ferrett, Vargas & Marks
  ©2009  |  Prentice Hall  |  Electronic Book; 1280 pp  |  Available
  ISBN-10: 0135044707  |  ISBN-13: 9780135044704
  Online purchase price: $58.99Brief Description  | 

  

  CourseSmart eTextbooks are a creative digital solution that offers the freedom and convenience of online, offline, and mobile access using a single platform. With a CourseSmart eTextbook, students can:

  • search the text

  • make notes online

  • print out reading assignments that incorporate lecture notes

  • bookmark important passages for later review

  • save money. As an alternative to purchasing the print textbook, students can subscribe to the same content online for a significant discount off the suggested list price of the print text.

  For more information, or to subscribe to the CourseSmart eTextbook, visit www.coursesmart.com (for customers in U.S. and Canada) or www.coursesmart.co.uk (for customers in Europe, Middle East, and Africa).

  More Info  |  Students, buy access
  

This product is a member of the following series. Click on the series name to see the full list of products in the series.

• Custom PHIT: The Pearson Custom Program for CIS

• Go! Series

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: 0137028083 | ISBN-13: 9780137028085
©2009 | Instock
Suggested retail price: $130.27  Buy from myPearsonStore
Net price: $97.70  (What's this?)
This package contains:

Package ISBN-10: 013706537X | ISBN-13: 9780137065370
©2009 | Instock
Suggested retail price: $162.27  Buy from myPearsonStore
Net price: $121.70  (What's this?)
This package contains:

Package ISBN-10: 013268991X | ISBN-13: 9780132689915
©2009 | Instock
Suggested retail price: $152.00  Buy from myPearsonStore
Net price: $114.00  (What's this?)
This package contains:

Package ISBN-10: 0135056497 | ISBN-13: 9780135056493
©2009 | Not Yet Published
Suggested retail price: $117.00  
Net price: $87.75  (What's this?)
This package contains:

Package ISBN-10: 0137042906 | ISBN-13: 9780137042906
©2009 | Not Yet Published
Suggested retail price: $218.67  
Net price: $164.00  (What's this?)
This package contains: