Information Technology

Microsoft Office Word 2007

 

    Chapter 1 - What Will Word Processing Do for Me?

 

    Section 1 Introduction to Word Processing

        Understanding Word Basics

        Using AutoText

        Viewing a Document

        Using the Mini Toolbar

            Hands-On Exercise #1:  Introduction to Microsoft Word

 

    Section 2 Document Formatting

        Setting Margins and Specifying Page Orientation

        Inserting Page Breaks

        Adding Page Numbers

        Inserting Headers and Footers

        Creating Sections

        Inserting a Cover Page

        Using Find and Replace Commands

            Hands-On Exercise #2: Document Organization

 

    Section 3 The Final Touches

        Checking Spelling and Grammar

        Using Save and Backup Options

        Selecting Printing Options

        Customizing Word

            Hands-On Exercise #3: The Final Touches

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

   Capstone Exercise

    Mini Cases

 

Chapter 2 - Gaining Proficiency: Editing and Formatting

 

    Section 1 Text Formatting

        Applying Font Attributes Through the Font Dialog Box

        Highlighting Text

        Controlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking Spaces

        Copying Formats with the Format Painter

            Hands-on exercise #1: Character Formatting

 

    Section 2 Paragraph Formats

        Setting Off Paragraphs with Tabs, Borders, Lists, and Columns

        Applying Paragraph Formats

            Hands-on exercise #2: Paragraph formatting

 

    Section 3 Styles and Document References

        Creating and Modifying Styles

            Hands-on exercise #3: Styles

        Table of Contents and Indexes

            Hands-on exercise #4: Reference Pages

 

    Summary

    Key Terms

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Microsoft Office Excel 2007

 

Chapter 1 - Introduction to Excel

 

    Section 1: Introduction to Spreadsheets

        Defining Worksheets and Workbooks

        Using Spreadsheets Across Disciplines

        Planning for Good Workbook and Worksheet Design

        Identifying Excel Window Components

        Entering and Editing Data in Cells

            Hands-On Exercise #1:  Introduction to Microsoft Excel

 

    Section 2: Mathematics and Formulas

        Describing and Using Symbols and the Order of Precedence

        Displaying Cell Formulas

        Inserting and Deleting Rows and Columns

        Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill

            Hands-On Exercise #2:  Jakes Gym Continued

 

    Section 3: Workbook and Worksheet Enhancements

        Managing Worksheets

        Formatting Worksheets

            Hands-On Exercise #3: Formatting Jake's Gym Worksheet

 

    Section 4: Page Setup and Printing

        Selecting Page Setup Options for Printing

        Managing Cell Comments

            Hands-On Exercise #4: Printing Jake's Gym Worksheet

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 2 - Microsoft Excel: Formulas and Functions 

 

    Section 1: Formula Basics         

        Creating and Copying Formulas  

        Using Relative and Absolute Cell Addresses        

            Hands-On Exercise #1:  Smithtown Hospital Radiology Department Payroll           

           

    Section 2: Function Basics        

        Using AutoSum

        Inserting Basic Statistical Functions       

        Using Date Functions    

            Hands-On Exercise #2:  Completing the Smithtown Hospital Radiology Department

 

    Section 3: Logical and Lookup Functions

        Using the IF Function

        Using the VLOOKUP Function

            Hands-On Exercise #3:  Athletic Department Eligibility Gradebook

           

    Section 4: Financial Functions   

        Using the PMT Function

        Using the FV Function   

            Hands-On Exercise #4: Purchasing a Van for the School for Exceptional Children  

 

 

    Summary         

    Key Terms       

    Multiple Choice 

    Practice Exercises        

    Mid-Level Exercises      

    Capstone Exercise        

    Mini Cases

 

Microsoft Access 2007

 

Chapter 1 - Introduction to Access: Finding Your Way through a Database

 

    Section 1: Data and Files Everywhere!

        Exploring, Describing, and Navigating Among the Objects in an Access Database

        Understanding the Difference Between Working in Storage and Memory

        Practicing Good File Management

        Backing up, Compacting, and Repairing Access Files

            Hands-On Exercises 1 Introduction to Databases

 

    Section 2: Filters, Sorts, and Access Versus Excel

        Creating Filters

        Sorting Table Data on One or More Fields

        Knowing When to Use Access or Excel  to Manage Data

            Hands-On Exercises 2: Data Manipulation: Filters and Sorts

 

    Section 3: The Relational Database

        Using the Relationship Window

        Understanding Relational Power

            Hands-On Exercises 3: Introduction to Relationships

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

 

    Section 1: Related Data

        Table Design, Properties, Views, and Wizards

        Designing Data

        Creating Tables

            Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

 

    Section 2: Multiple Table Database

        Understanding Table Relationships

        Sharing Data with Excel

        Establishing Table Relationships

            Hands-on Exercises 2: Imports and Relationships

 

    Section 3: Queries

        Creating a Query

        Specifying Criteria for Different Data Types

        Copying and Running a Query

        Using the Query Wizard

        Understanding Large Database Differences

            Hands-On Exercises 3: Multi-Table Query

         

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

 

Microsoft Office PowerPoint 2007

 

Chapter 1 - Introduction to PowerPoint

 

        Purpose of PowerPoint Presentations

        Understanding the PowerPoint Interface

        Creating a Basic Slide Show

        Running a Slide Show

        Page Setup

        Printing with PowerPoint

 

            Hands-on Exercises 1-4

            Capstone Exercise

            Mini-Cases 1-3

            (Content Application, Disaster Recovery, Research)

 

    Chapter 2 - Developing a Presentation

 

        Planning Process

        AutoContent Wizard

        Outline Tab

        Import Outlines

        Animate Text

        Print Outline

        Export Outline to Word

        Headers and Footers

 

            Hands-on Exercises 1-4

            Capstone Exercise

            Mini-Cases 1-3

            (Content Application, Disaster Recovery, Research)

 

Exploring MS Office 2007 Brief Student CD
Grauer
©2008 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0132319241 | ISBN-13: 9780132319249

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0131588346 | ISBN-13: 9780131588349
Buy from myPearsonStore

PHIT Tips: File Management
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588354 | ISBN-13: 9780131588356
Buy from myPearsonStore

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332221 | ISBN-13: 9780132332224
Buy from myPearsonStore

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050625 | ISBN-13: 9780132050623
Buy from myPearsonStore

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332558 | ISBN-13: 9780132332552
Buy from myPearsonStore

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050617 | ISBN-13: 9780132050616
Buy from myPearsonStore

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0131588311 | ISBN-13: 9780131588318
Buy from myPearsonStore

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128017 | ISBN-13: 9780136128014
Buy from myPearsonStore

Shortcut Key Card: Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 0132050609 | ISBN-13: 9780132050609

Shortcut Key Card: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332531 | ISBN-13: 9780132332538
Buy from myPearsonStore

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588400 | ISBN-13: 9780131588400
Buy from myPearsonStore

Shortcut Key Card: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 013158832X | ISBN-13: 9780131588325

Shortcut Key Card: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0136128009 | ISBN-13: 9780136128007
Buy from myPearsonStore

Windows Vista PHIT Tip
CIS Prentice Hall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128025 | ISBN-13: 9780136128021
Buy from myPearsonStore

This title is a member of the The Exploring Series Series, which also contains the titles below . You can also visit the Exploring Series Series page.

• 
  Exploring Microsoft Access 2003, Comprehensive and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Out of Print
  ISBN-10: 0131791206 | ISBN-13: 9780131791206
  Brief Description

  

  For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

   

  This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

• 
  Exploring Microsoft Access 2003, Vol. 2 and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Out of Stock
  ISBN-10: 0131791184 | ISBN-13: 9780131791183
  Brief Description

  

  For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

   

  This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

• 
  Exploring Microsoft Excel 2003, Vol. 2 and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
  ISBN-10: 0132303949 | ISBN-13: 9780132303941
  Brief Description | Buy from myPearsonStore

  

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

                        
  Master the How and Why of Office 2003!  Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

   

• 
  Exploring Microsoft Office 2007 Brief
  Grauer, Hulett, Krebs, Mulbery, Lockley & Scheeren
  ©2008 | Prentice Hall | Paper; 656 pp | Out of Stock
  ISBN-10: 0132240041 | ISBN-13: 9780132240048
  

• 
  Exploring Microsoft Office 2007 Getting Started with the Online Experience
  Grauer & McCloud
  ©2008 | Prentice Hall | Spiral Bound; 96 pp | Instock
  ISBN-10: 013235053X | ISBN-13: 9780132350532
  Buy from myPearsonStore

• 
  Exploring Microsoft Office 2007 Volume 2
  Grauer, Hulett, Krebs, Lockley & Scheeren
  ©2008 | Prentice Hall | Paper; 1296 pp | Instock
  ISBN-10: 0136130372 | ISBN-13: 9780136130376
  Brief Description | Buy from myPearsonStore

  

  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.

• 
  Exploring Microsoft Office 2007, Volume 1, 2/E
  Grauer, Barber, Hulett, Krebs, Lockley, Scheeren & Mulbery
  ©2008 | Prentice Hall | Paper; 1312 pp | Instock
  ISBN-10: 0131577298 | ISBN-13: 9780131577299
  Brief Description | Buy from myPearsonStore

  

  For introductory computer courses in Microsoft 2007 or courses in computer concepts with a lab component for Microsoft Office 2007 applications, using Windows Vista as the operating system.

   

  The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

• 
  Exploring Microsoft Office Access 2007, Comprehensive
  Grauer & Lockley
  ©2008 | Prentice Hall | Paper; 736 pp | Instock
  ISBN-10: 0131567888 | ISBN-13: 9780131567887
  

• 
  Exploring Microsoft Office Access 2007, Volume 1
  Grauer & Lockley
  ©2008 | Prentice Hall | Paper; 368 pp | Instock
  ISBN-10: 0132252120 | ISBN-13: 9780132252126
  Buy from myPearsonStore

• 
  Exploring Microsoft Office SharePoint Designer 2007 and Microsoft Windows Sharepoint Services 3.0
  Marghitu & Grauer
  ©2010 | Prentice Hall | Electronic Book; 100 pp | Estimated Availability : 06/15/2009
  ISBN-10: 0136121802 | ISBN-13: 9780136121800
  Brief Description

  

  For introductory courses in Microsoft Office SharePoint Designer.

   

  The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

• 
  Exploring Microsoft Office Word 2007, Comprehensive
  Grauer & Hulett
  ©2008 | Prentice Hall | Paper; 560 pp | Instock
  ISBN-10: 0132328526 | ISBN-13: 9780132328524
  Buy from myPearsonStore

• 
  Exploring Microsoft Office Word 2007, Volume 1
  Grauer & Hulett
  ©2008 | Prentice Hall | Paper; 424 pp | Instock
  ISBN-10: 0131572733 | ISBN-13: 9780131572737
  Buy from myPearsonStore

• 
  Exploring Microsoft PowerPoint 2003 Comprehensive and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
  ISBN-10: 0132303957 | ISBN-13: 9780132303958
  Brief Description | Buy from myPearsonStore

  

  For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

   

  This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

• 
  Exploring Microsoft PowerPoint 2003, Vol. 1 and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
  ISBN-10: 0132303965 | ISBN-13: 9780132303965
  Brief Description | Buy from myPearsonStore

  

  For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

   

  This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

• 
  Exploring Microsoft PowerPoint 2003, Vol. 2 and Student Resource CD Package
  Grauer & Barber
  ©2004 | Prentice Hall | Kit/Package/ShrinkWrap | Instock
  ISBN-10: 0132303973 | ISBN-13: 9780132303972
  Brief Description | Buy from myPearsonStore

  

  For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.

   

  This series gives the “how and why” of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!

• 
  Exploring MS Office PowerPoint 2007, Comprehensive
  Grauer & Krebs
  ©2008 | Prentice Hall | Paper; 656 pp | Instock
  ISBN-10: 013232847X | ISBN-13: 9780132328470
  

• 
  Exploring with Microsoft SharePoint Designer 2007, Brief
  Grauer & Marghitu
  ©2008 | Prentice Hall | Spiral Bound; 448 pp | Instock
  ISBN-10: 0132350513 | ISBN-13: 9780132350518
  Brief Description | Buy from myPearsonStore

  

  For introductory courses in Microsoft Office SharePoint Designer.

   

  The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

   

• 
  IRCD Exploring Microsoft Word 2007
  Grauer
  ©2008 | Prentice Hall | CD-ROM Only | Instock
  ISBN-10: 0132328569 | ISBN-13: 9780132328562
  

• 
  TestGen Exploring Microsoft Word 2007
  Grauer
  ©2008 | Prentice Hall | On-line Supplement | Instock
  ISBN-10: 0132328577 | ISBN-13: 9780132328579
  Brief Description

  

  The TestGen application for this title is available for download via the web. To install or upgrade the TestGen application, go to http://www.pearsoned.com/testgen. Note that you will not be able to open and use the test bank files below unless you have installed the TestGen application in your system.

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: 0135056950 | ISBN-13: 9780135056950
©2008 | Not Yet Published | Suggested retail price: $204.60
This package contains:

Package ISBN-10: 0135058805 | ISBN-13: 9780135058800
©2008 | Not Yet Published | Suggested retail price: $153.40
This package contains:

Package ISBN-10: 0136083102 | ISBN-13: 9780136083108
©2008 | Not Yet Published | Suggested retail price: $124.00
This package contains: