GO! with Microsoft Office 2010 Volume 2
, by Gaskin, Shelley; Graviett, Nancy; Madsen, Donna; Marucco, Toni
- ISBN: 9780135090909 | 0135090903
- Cover: Paperback
- Copyright: 9/3/2010
For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 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. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.
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.
Carolyn McLellan is the Dean of the Division of Information Technology and Business at Tidewater Community College in Virginia Beach, Virginia. She has an M.A. degree in Secondary Education from Regent University and a B.S. degree in Business Education from Old Dominion University. She taught for Norfolk Public Schools for 17 years in Business Education and served as a faculty member at Tidewater Community College for eight years teaching networking, where she developed over 23 new courses and earned the Microsoft Certified Trainer and Microsoft Certified System Engineer industry certifications. In addition to teaching, Carolyn loves to play volleyball, boogie board at the beach, bicycle, crochet, cook, and read.
Common Features Chapter 1 Using the Common Features of Office 2010
Objective 1 Use Windows Explorer to Locate Files and Folders
Activity 1.01 Using Windows Explorer to Locate Files and Folders
Objective 2 Locate and Start a Microsoft Office 2010 Program
Activity 1.02 Locating and Starting a Microsoft Office 2010 Program
Objective 3 Enter and Edit Text in an Office 2010 Program
Activity 1.03 Entering and Editing Text in an Office 2010 Program
Objective 4 Perform Commands from a Dialog Box
Activity 1.04 Performing Commands from a Dialog Box
Objective 5 Create a Folder,Save a File,and Close a Program
Activity 1.05 Creating a Folder, Saving a File, and Closing a Program
Objective 6 Add Document Properties and Print a File
Activity 1.06 Adding Document Properties and Printing a File
Word Chapter 4 Using Styles and Creating Multilevel Lists and Charts
Case: Lehua Hawaiian Adventures
PROJECT 4A — Customer Handout
Objective 1: Apply and Modify Quick Styles
Activity 4.01 Applying Quick Styles
Activity 4.02 Modifying Quick Styles
Activity 4.03 Changing the Theme
Objective 2: Create New Styles
Activity 4.04 Creating New Styles
Objective 3: Manage Styles
Activity 4.05 Modifying a Style in the Styles Window
Activity 4.06 Clearing Formats
Activity 4.07 Removing a Quick Style
Objective 4: Create a Multilevel List
Activity 4.08 Creating a Multilevel List
Activity 4.09 Modifying a Multilevel List Style
Activity 4.10 Applying the Current List Style
PROJECT 4B — Planning Memo with a Chart
Objective 5: Change the Style Set and Paragraph Spacing of a Document
Activity 4.11 Formatting a Memo
Activity 4.12 Changing the Style Set
Activity 4.13 Changing Paragraph Spacing of a Document
Objective 6: Insert a Chart and Enter Data into a Chart
Activity 4.14 Selecting a Chart Type
Activity 4.15 Entering Chart Data
Activity 4.16 Editing Data
Objective 7: Change a Chart Type
Activity 4.17 Changing the Chart Type
Objective 8: Format a Chart
Activity 4.18 Adding Chart Elements
Activity 4.19 Changing the Chart Style and Formatting Chart Elements
Activity 4.20 Resizing and Positioning a Chart
Word Chapter 5 Creating Web Pages and Using Advanced Proofing Options
Case: Texas Spectrum Wireless
PROJECT 5A — Web Page
Objective 1: Create a Web Page from a Word Document
Activity 5.01 Saving a Document as a Web Page
Activity 5.02 Applying Background Color
Activity 5.03 Inserting a Drop Cap in Text
Activity 5.04 Sorting Paragraphs
Activity 5.05 Inserting a Horizontal Line
Objective 2: Insert and Modify Hyperlinks in a Web Page
Activity 5.06 Inserting a Hyperlink
Activity 5.07 Inserting a Hyperlink That Opens an E-mail Message Form
Activity 5.08 Creating a Web Page for an Internal Link
Activity 5.09 Testing Web Pages in a Browser
Activity 5.10 Editing and Removing Hyperlinks
Objective 3: Create a Blog Post
Activity 5.11 Creating a Blog Post
Activity 5.12 Inserting Hyperlinks in a Blog Post
PROJECT 5B — FAQ List
Objective 4: Locate Word Settings to Personalize Word 2010
Activity 5.13 Examining the Word Options Dialog Box
Activity 5.14 Zooming from the View Tab
Objective 5: Collect and Paste Images and Text
Activity 5.15 Collecting Images and Text from Multiple Documents
Activity 5.16 Pasting Information from the Clipboard Task Pane
Objective 6: Locate Supporting Information
Activity 5.17 Using the Research Task Pane to Locate Information
Activity 5.18 Translating Text from the Research Task Pane
Objective 7: Use Advanced Find and Replace and Proofing Options
Activity 5.19 Using Find and Replace to Change Text Formatting
Activity 5.20 Using Wildcards in Find and Replace
Activity 5.21 Using the Spelling and Grammar Checker
Objective 8: Save in Other Formats
Activity 5.22 Saving a document in RTF Format
Word Chapter 6 Building Documents from Reusable Content and Revising Documents Using Markup Tools
Case: Lakefield Public Library
PROJECT 6A Newsletter with Reusable Content and Custom Theme
Objective 1: Create Building Blocks
Activity 6.01 Creating a Building Block in the Text Box Gallery
Activity 6.02 Viewing Building Blocks in the Building Blocks Organizer
Activity 6.03 Creating a Building Block in the Quick Tables Gallery
Activity 6.04 Creating a Graphic Building Block
Objective 2: Create and Save a Theme Template
Activity 6.05 Customizing a Theme
Activity 6.06 Saving a Theme Template
Objective 3: Create a Document by Using Building Blocks
Activity 6.07 Creating a Document Using Building Blocks
Activity 6.08 Managing Files and Restoring Settings
PROJECT 6B Events Schedule with Tracked Changes
Objective 4: Use Comments in a Document
Activity 6.09 Inserting Comments
Activity 6.10 Editing and Deleting Comments
Objective 5: Track Changes in a Document
Activity 6.11 Managing Tracked Changes
Activity 6.12 Using the Reviewing Pane
Activity 6.13 Viewing Revisions in a Document
Activity 6.14 Turning on Track Changes
Activity 6.15 Accepting or Rejecting Changes in a Document
Objective 6: View Side by Side, Compare, and Combine Documents
Activity 6.16 Using View Side by Side
Activity 6.17 Combining Documents
Excel CHAPTER 4: Use Financial and Lookup Functions, Define Names, and Validate Data
Case: Rubanne Specialties
PROJECT 4A Amortization Schedule
Objective 1 Use Financial Functions
Activity 4.01 Inserting the PMT Financial Function
Objective 2 Use Goal Seek
Activity 4.02 Using Goal Seek to Produce a Desired Result
Activity 4.03 Using Goal Seek to Find an Increased Period
Objective 3 Create a Data Table
Activity 4.04 Designing a Two-Variable Data Table
Activity 4.05 Using a Data Table to Calculate Options
PROJECT 4B Quarterly Cost Report and Lookup Form
Objective 4 Define Names
Activity 4.06 Defining a Name
Activity 4.07 Inserting New Data in a Named Range
Activity 4.08 Changing a Defined Name
Activity 4.09 Creating a Defined Name by Using Row and Column Titles
Objective 5 Use Defined Names in a Formula
Activity 4.10 Using Defined Names in a Formula
Objective 6 Use Lookup Functions
Activity 4.11 Defining a Range of Cells for Lookup Function
Activity 4.12 Inserting the VLOOKUP Function
Objective 7 Validate Data
Activity 4.13 Creating a Validation List
Excel CHAPTER 5: Managing Large Workbooks and Using Advanced Sorting and Filtering
Case: Capital Cities Community College
PROJECT 5A Large Worksheet
Objective 1 Navigate and Manage Large Worksheets
Activity 5.01 Using the Go To Special Command
Activity 5.02 Hiding Columns
Activity 5.03 Using the Go To Command
Activity 5.04 Arranging Multiple Workbooks and Splitting Worksheets
Objective 2 Enhance Worksheets with Themes and Styles
Activity 5.05 Changing and Customizing a Workbook Theme
Activity 5.06 Creating and Applying a Custom Table Style
Objective 3 Format a Worksheet to Share with Others
Activity 5.07 Previewing and Modifying Page Breaks
Activity 5.08 Repeating Column or Row Titles
Activity 5.09 Inserting a Hyperlink in a Worksheet
Activity 5.10 Modifying a Hyperlink
Objective 4 Save Excel Data in Other File Formats
Activity 5.11 Viewing and Saving a Workbook as a Web Page
Activity 5.12 Saving Excel Data in CSV File Format
Activity 5.13 Saving an Excel Data as a PDF or XPS File
PROJECT 5B Sort, Filter, and Outline a Database
Objective 5 Use Advanced Sort Techniques
Activity 5.14 Sorting on Multiple Columns
Activity 5.15 Sorting By Using a Custom List
Objective 6 Use Custom and Advanced Filters
Activity 5.16 Filtering by Format and Values Using AutoFilter
Activity 5.17 Filtering by Custom Criteria Using AutoFilter
Activity 5.18 Inserting the Sheet Name and Page Numbers in a Footer
Activity 5.19 Filtering by Using Advanced Criteria
Activity 5.20 Extracting Filtered Rows
Objective 7 Subtotal, Outline, and Group a List of Data
Activity 5.21 Subtotaling, Outlining, and Grouping a List of Data
Excel CHAPTER 6: Creating Charts, Diagrams, and Templates
Case: New York-New Jersey Job Fair
PROJECT 6A Organization Charts and Diagrams
Objective 1 Create and Format Sparklines and a 3-D Column Chart
Activity 6.01 Creating and Formatting Sparklines
Activity 6.02 Creating a 3-D Column Chart
Activity 6.03 Changing the Display of Chart Data
Activity 6.04 Editing and Formatting the Chart Title
Activity 6.05 Adding, Formatting, and Aligning Titles
Activity 6.06 Editing Source Data
Activity 6.07 Formatting the Chart Floor and Chart Walls
Objective 2 Create and Format a Line Chart
Activity 6.08 Creating a Line Chart
Activity 6.09 Deleting a Legend and Changing a Chart Title
Activity 6.10 Changing the Values on the Value Axis
Activity 6.11 Formatting the Plot Area and the Data Series
Activity 6.12 Inserting a Trendline
Objective 3 Create and Modify a SmartArt Graphic
Activity 6.13 Creating a Process SmartArt Graphic
Activity 6.14 Modifying and Changing the Diagram Style
Objective 4 Create and Modify an Organization Chart
Activity 6.15 Creating and Modifying a SmartArt Organization Chart
Activity 6.16 Adding Effects to a SmartArt Graphic
Activity 6.17 Preparing Worksheets With Charts and Diagrams for Printing
PROJECT 6B Expense Report and Order Form
Objective 5 Create an Excel Template
Activity 6.18 Entering Template Text
Activity 6.19 Formatting a Template
Activity 6.20 Entering Template Formulas
Activity 6.21 Inserting and Modifying an Image
Activity 6.22 Inserting and Modifying a WordArt Image
Activity 6.23 Saving a File as a Template
Objective 6 Protect a Worksheet
Activity 6.24 Protecting a Worksheet
Objective 7 Create a Worksheet Based on a Template
Activity 6.25 Creating a Worksheet Based on a Template
Access Chapter 4: Enhancing Tables
Project 4A Maneuver Data and Enforce Data Integrity
Objective 1 Manage Existing Tables
Activity 4.01 Backing Up a Database
Activity 4.02 Adding File Locations to Trusted Locations
Activity 4.03 Copying a Table and Modifying the Structure
Activity 4.04 Appending Records to a Table
Activity 4.05 Splitting a Table into Two Tables
Activity 4.06 Appending Records from Another Database
Objective 2 Modify Existing Tables
Activity 4.07 Finding and Deleting Records
Activity 4.08 Finding and Modifying Records
Activity 4.09 Adding and Moving Fields in Design View and Datasheet View
Activity 4.10 Checking Spelling
Objective 3 Create and Modify Table Relationships
Activity 4.11 Creating Table Relationships and Testing Referential Integrity
Activity 4.12 Setting and Testing Cascade Options
Project 4B Format Tables and Validate Data Entry
Objective 4 Create a table in design view
Activity 4.13 Creating a Table in Design View
Objective 5 Change Data types
Activity 4.14 Changing Data Types
Objective 6 Create a Lookup Field
Activity 4.15 Creating a Lookup Field Based on a List of Values
Activity 4.16 Creating a Lookup Field Based on Data in Another Table
Objective7 Set Field Properties
Activity 4.17 Creating an Input Mask using the Input Mask Wizard
Activity 4.18 Creating an Input Mask using the Input Mask Properties Box
Activity 4.19 Specifying a Required Field
Activity 4.20 Setting Default Values for Fields
Activity 4.21 Indexing Fields in a Table
Objective 8 Create Data Validation Rules and Validation Text
Activity 4.22 Creating Data Validation Rules and Validation Text
Activity 4.23 Testing Table Design and Field Properties
Objective 9 Attach Files to Records
Activity 4.24 Attaching a Word Document to a Record
Access Chapter 5 Enhancing Queries
Project 5A Create Special-Purpose Queries
Objective 1 Create Calculated Fields in a Query
Activity 5.01 Creating a Calculated Field Based on Two Existing Fields
Activity 5.02 Creating a Calculated Field Based on One Existing Field and a Number
Objective 2 Use Aggregate Functions in a Query
Activity 5.03 Adding a Total Row to a Query
Activity 5.04 Creating a Totals Query
Objective 3 Create a Crosstab Query
Activity 5.05 Creating a Select Query as the Source for a Crosstab Query
Activity 5.06 Creating a Crosstab Query
Objective 4 Find Duplicate and Unmatched Records
Activity 5.07 Finding Duplicate Records
Activity 5.08 Finding Unmatched Records
Objective 5 Create a Parameter Query
Activity 5.09 Creating a Parameter Query Using One Criteria
Activity 5.10 Creating a Parameter Query Using Multiple Criteria
Project 5B Create Action Queries and Modify Join Types
Objective 6 Create a Make Table Query
Activity 5.11 Creating a Select Query
Activity 5.12 Converting a Select Query to a Make Table Query
Objective 7 Create an Append Query
Activity 5.13 Creating an Append Query for a Table in the Current Database
Activity 5.14 Creating an Append Query for a Table in Another Database
Objective 8 Create a Delete Query
Activity 5.15 Creating a Delete Query
Objective 9 Create an Update Query
Activity 5.16 Creating an Update Query
Activity 5.17 Creating an Update Query with an Expression
Objective 10 Modify the Join Type
Activity 5.18 Viewing the Results of a Query Using an Inner Join
Activity 5.19 Changing the Join Type to an Outer Join
Access Chapter 6 Customizing Forms and Reports
Project 6A Customize Forms
Objective 1 Create a Form in Design View
Activity 6.01 Creating a Form in Design View
Activity 6.02 Adding Sections to the Form
Objective 2 Change and Add Controls
Activity 6.03 Changing Controls on a Form
Activity 6.04 Adding Controls to a Form
Objective 3 Format a Form
Activity 6.05 Adding a Background Color
Activity 6.06 Adding a Background Picture to a Form
Activity 6.07 Modifying the Borders of Controls
Objective 4 Make a Form User Friendly
Activity 6.08 Adding a Message to the Status Bar
Activity 6.09 Creating Custom ControlTips
Activity 6.10 Changing the Tab Order
Project 6B Customize Reports
Objective 5 Create a Report Based on a Query Using a Wizard
Activity 6.11 Creating a Report Using a Wizard
Activity 6.12 Modifying a Report Created Using a Wizard
Objective 6 Create a Report in Design View
Activity 6.13 Creating a Report in Design view
Activity 6.14 Modifying the Sections of a Report
Objective 7 Add Controls to a Report
Activity 6.15 Adding Label and Text Box Controls to a Report
Activity 6.16 Adding an Image Control and a Line Control to a Report
Objective 8 Group, Sort, and Total Records in Design View
Activity 6.17 Adding a Grouping and Sort Level to a Report
Activity 6.18 Adding Calculated Controls to a Report
PowerPoint Chapter 4: Create Templates, Save and Protect Presentations
Project 4A: Create and Apply a Custom Template
Objective 1 Create a Custom Template by Modifying Slide Masters
Activity 4.01 Displaying and Editing Slide Masters
Activity 4.02 Saving a Presentation as a Template
Activity 4.03 Formatting a Slide Master with a Gradient Fill
Activity 4.04 Formatting Slide Masters by Adding Pictures and Shapes
Activity 4.05 Customizing Placeholders on a Slide Master
Activity 4.06 Displaying and Editing the Handout Master
Activity 4.07 Displaying and Editing Notes Master
Objective 2 Apply a Custom Template to a Presentation
Activity 4.08 Applying a Template to a Presentation
Activity 4.09 Editing Slide Masters in an Existing Presentation
Project 4B: Review, Publish, and Protect Presentations
Objective 3 Create and Edit Comments
Activity 4.10 Adding Comments
Activity 4.11 Reading Comments
Activity 4.12 Editing Comments
Objective 4 Prepare a Presentation for Distribution
Activity 4.13 Publishing a Presentation in PDF and XPS format
Activity 4.14 Creating Handouts in Microsoft Word
Objective 4 Protect a Presentation
Activity 4.15 Using the Compatibility Checker
Activity 4.16 Marking a Presentation as Final
PowerPoint Chapter 5: Applying Advanced Graphic Techniques and Inserting Media
Project 5A: Enhance a Presentation with Graphics and Media
Objective 1: Use Picture Corrections
Activity 5.01 Using Sharpen and Soften on a Picture
Activity 5.02 Changing the Brightness and Contrast of a Picture
Activity 5.03 Recoloring a Picture
Objective 2: Add a Border to a Picture
Activity 5.04 Adding a Border to a Picture
Objective 3: Change the Shape of a Picture
Activity 5.05 Changing the Shape of a Picture
Objective 4: Add a Picture to a WordArt Object
Activity 5.06 Adding a WordArt Object and Embedding a Picture
Objective 5: Enhance a Presentation with Audio and Video
Activity 5.07 Adding an Embedded Sound to a Presentation
Activity 5.08 Setting a Trigger for an Embedded Audio in a Presentation
Activity 5.09 Adding a Linked Video to a Presentation
Activity 5.10 Changing the Trigger for a Linked Video in a Presentation
Project 5B: Create a Photo Album
Objective 6: Create a Photo Album
Activity 5.11 Creating a Photo Album
Objective 6: Edit a Photo Album and Add a Caption
Activity 5.12 Editing a Photo Album and Adding a Caption
Objective 7: Crop a Picture
Activity 5.13 Cropping a Picture
PowerPoint Chapter 6: Delivering a Presentation
Project 6A Penn Liberty Motors
Objective 1: Apply and Modify Slide Transitions
Activity 6.01 Applying and Modifying Slide Transitions
Activity 6.02 Advancing Slides Automatically
Objective 2: Apply Custom Animation Effects
Activity 6.03 Adding Entrance Effects
Activity 6.04 Adding Emphasis Effects
Activity 6.05 Adding Exit Effects
Activity 6.06 Adding Motion Paths
Objective 3: Modify Animation Effects
Activity 6.07 Modifying Animation Effects
Activity 6.08 Setting Effect Options
Project 6B Penn Liberty Motors Advertisement
Objective 4: Insert Hyperlinks
Activity 6.09 Inserting a Hyperlink to a Web Page
Activity 6.10 Inserting a Hyperlink to a Slide in Another Presentation
Activity 6.11 Inserting a Hyperlink to an E-Mail Address
Activity 6.12 Inserting a Hyperlink to a New File
Activity 6.13 Creating an Action Button
Objective 5: Create Custom Slide Shows
Activity 6.14 Creating a Basic Custom Slide Show
Activity 6.15 Creating a Hyperlinked Custom Slide Show
Objective 6: Present and View a Slide Presentation
Activity 6.16 Hiding a Slide
Activity 6.17 Using the Onscreen Navigation Tools
Activity 6.18 Using the Annotation Tool
Activity 6.19 Creating a Self-Running Presentation
What is included with this book?
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Please wait while the item is added to your bag...
