GO! with Microsoft Office 2010 Getting Started
Published on 5. August 2010
Book
Mixed media product
336 pages
978-0-13-508865-4 (ISBN)
Description
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.
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.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Professional and scholarly
Dimensions
Height: 274 mm
Width: 222 mm
Thickness: 21 mm
Weight
690 gr
ISBN-13
978-0-13-508865-4 (9780135088654)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Shelley Gaskin | Robert Ferrett | Alicia Vargas
GO! with Microsoft Office 2010 Getting Started: Pearson New International Edition
Book
09/2013
Pearson Education Limited
€88.03
Article exhausted; check different version
Previous edition
Alicia Vargas | Suzanne Marks | Sally Preston
GO! with Office 2007 Getting Started
Book
06/2007
Pearson
€89.27
Article exhausted; check for reprint
Persons
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.
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.
Content
GO! with Microsoft Office 2010 Getting Started
Table of Contents
Common Features
Chapter 1 Using the Common Features of Office 2010
Scenario: Oceana Palm Grill
Project 1A: Menu Plan
Objective 1 Use Windows Explorer to Locate Files and Folder
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 Program
Activity 1.03 Entering and Editing Text in an Office 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 Print a File
Activity 1.06 Printing a File
Project 1B: Memo
Objective 7 Open an Existing File and Save it With a New Name
Activity 1.07 Opening an Existing File and Saving it With a New Name
Objective 8 Explore Application Options
Activity 1.08 Viewing Application Options
Objective 9 Perform Commands from the Ribbon
Activity 1.09 Performing Commands from the Ribbon
Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon
Objective 10 Apply Formatting in Office Programs
Activity 1.11 Formatting and Viewing Pages
Activity 1.12 Formatting Text
Activity 1.13 Using the Office Clipboard to Cut, Copy, and Paste
Objective 11 Use the Microsoft Office 2010 Help System
Activity 1.14 Using the Microsoft Office 2010 Help System in Excel
Objective 12 Compress Files
Activity 1.15 Compressing Files
Word Chapter 1 Using Graphics and Lists
Scenario: Laurel College
Project 1A: Flyer
Objective 1 Create a New Document and Insert Text
Activity 1.1 Starting a New Word Document and Inserting Text
Objective 2 Insert and Format Graphics
Activity 1.2 Formatting Text Using Text Effects
Activity 1.3 Inserting and Resizing Pictures
Activity 1.4 Wrapping Text Around a Picture
Activity 1.5 Moving a Picture
Activity 1.6 Applying Picture Styles and Artistic Effects
Activity 1.7 Adding a Page Border
Objective 3 Insert and Modify Text Boxes and Shapes
Activity 1.8 Inserting a Shape
Activity 1.9 Inserting a Text Box
Activity 1.10 Moving, Resizing, and Formatting Shapes and Text Boxes
Objective 4 Preview and Print a Document
Activity 1.11 Adding a File Name to the Footer
Activity 1.12 Previewing and Printing a Document
Project 1B: Information Handout
Objective 5 Change Document and Paragraph Layout
Activity 1.13 Setting Margins
Activity 1.14 Aligning Text
Activity 1.15 Changing Line Spacing
Activity 1.16 Indenting Text and Adding Space After Paragraphs
Objective 6 Create and Modify Lists
Activity 1.17 Creating a Bulleted List
Activity 1.18 Creating a Numbered List
Activity 1.19 Customizing Bullets
Objective 7 Set and Modify Tab Stops
Activity 1.20 Setting Tab Stops
Activity 1.21 Modifying Tab Stops
Objective 8 Insert a SmartArt Graphic
Activity 1.22 Inserting a SmartArt Graphic
Activity 1.23 Modifying a SmartArt Graphic
Excel Chapter 1 Creating a Worksheet and Charting Data
Scenario: Texas Spectrum Wireless
Project 1A: Quarterly Sales Report with Embedded Column Chart
Objective 1 Create, Save, and Navigate an Excel Workbook
Activity 1.01 Starting Excel and Naming and Saving a Workbook
Activity 1.02 Navigating a Worksheet and a Workbook
Objective 2 Enter Data in a Worksheet
Activity 1.03 Entering Text and Using AutoComplete
Activity 1.04 Filling a Series with Auto Fill and Using Excel Keyboard Shortcuts
Activity 1.05 Aligning Text and Adjusting the Size of Columns
Activity 1.06 Entering Numbers
Objective 3 Construct and Copy Formulas and Use the Sum Function
Activity 1.07 Constructing a Formula and Using the Sum Function
Activity 1.08 Copying a Formula by Using the Fill Handle
Objective 4 Format Cells with Merge & Center and Cell Styles
Activity 1.09 Using Merge & Center and Applying Cell Styles
Activity 1.10 Formatting Financial Numbers
Objective 5 Chart Data in a Column Chart
Activity 1.11 Charting Data in a Column Chart
Objective 6 Prepare a Worksheet for Printing and Close Excel
Activity 1.12 Changing Views, Creating a Footer, and Using Print Preview
Activity 1.13 Deleting Unused Sheets in a Workbook
Activity 1.14 Printing a Worksheet
Activity 1.15 Displaying, Printing, and Hiding Formulas
Project 1B: Inventory Valuation
Objective 7 Check Spelling in a Worksheet
Activity 1.16 Checking Spelling in a Worksheet
Objective 8 Enter Data by Range
Activity 1.17 Entering Data by Range
Objective 9 Construct Formulas for Mathematical Operations
Activity 1.18 Using Arithmetic Operators
Activity 1.19 Copying Formulas Containing Absolute Cell References
Objective 10 Edit Values in a Worksheet
Activity 1.20 Editing Values in a Worksheet
Activity 1.21 Formatting Cells with the Percent Style
Objective 11 Format a Worksheet
Activity 1.22 Inserting and Deleting Rows and Columns
Activity 1.23 Adjusting Column Widths and Wrapping Text
Access Chapter 1 Getting Started with Access Databases
Scenario: Capital Cities Community College
Project 1A: Contact Information
Objective 1: Identify Good Database Design
Activity 1.01 Using Good Design Techniques to Plan a Database
Objective 2: Create a Table and Define Fields in a New Blank Database
Activity 1.02 Starting with a New Blank Database
Activity 1.03 Creating Fields in a Table
Activity 1.04 Renaming Field in a Table
Activity 1.05 Adding a Record to a Table
Activity 1.06 Assigning the Data Type of a Field in Datasheet View
Activity 1.07 Adding Additional Records to a Table
Activity 1.08 Importing Data from an Excel Workbook to an Existing Access Table
Objective 3: Add and Change the Structure of Tables
Activity 1.09 Deleting a Table Field in Design View
Activity 1.10 Modifying a Field Size and Description in Design View
Activity 1.11 Setting a Primary Key and Saving a Table
Activity 1.12 Adding a Second Table to a Database by Importing an Excel Spreadsheet
Activity 1.13 Adjusting Column Widths
Activity 1.14 Printing a Table
Objective 4: Create and Use a Query, a Form, and a Report
Activity 1.15 Using the Simple Query Wizard to Create a Query
Activity 1.16 Creating a Form
Activity 1.17 Creating, Modifying, and Printing a Report
Objective 5: Save, Close, and Change the Properties of a Database
Activity 1.18 Changing Database Properties
Activity 1.19 Closing and Saving a Database
Project 1B: Student Workshops
Objective 6: Create a Database Using a Template
Activity 1.20 Creating a New Database Using a Template
Activity 1.21 Building a Table by Entering Records in a Multiple Items Form
Objective 7: Organize Database Objects in the Navigation Pane
Activity 1.22 Organizing Database Objects in the Navigation Pane
Objective 8: Create a New Table in a Database Created with a Template
Activity 1.23 Creating a New Table and Changing Its Design
Objective 9: View a Report and Print a Table in a Database Created with a Template
Activity 1.24 Viewing a Report
Activity 1.25 Printing a Table
PowerPoint Chapter 1 Getting Started with Microsoft Office PowerPoint
Scenario: Lehua Hawaiian Tours
Project 1A: Company Overview
Objective 1: Create a New Presentation
Activity 1.1 Identifying Parts of the PowerPoint Window
Activity 1.2 Entering Presentation Text and Saving a Presentation
Activity 1.3 Applying a Presentation Theme
Objective 2: Edit a Presentation in Normal View
Activity 1.4 Inserting a New Slide
Activity 1.5 Increasing and Decreasing List Levels
Activity 1.6 Adding Speakers Notes to a Presentation
Activity 1.7 Displaying and Editing Slides in the Slide Pane
Objective 3: Insert and Format Pictures to a Presentation
Activity 1.8 Inserting a Picture from a File
Activity 1.9 Applying a Style to a Picture
Activity 1.10 Applying Artistic Effects to a Picture
Objective 4: Print and View a Presentation
Activitiy 1.11 Viewing a Slide Show
Activity 1.12 Inserting Headers and Footers
Activity 1.13 Printing a Presentation
Project 1B: New Product Announcement
Objective 5: Edit an Existing Presentation
Activity 1.14 Displaying and Editing the Presentation Outline
Activity 1.15 Inserting Slides from an Existing Presentation
Activity 1.16 Finding and Replacing Text
Objective 6: Format a Presentation
Activity 1.17 Changing Fonts, Font Sizes, Font Styles, and Font Colors
Activity 1.18 Aligning Text and Changing Line Spacing
Activity 1.19 Modifying Slide Layout
Objective 7: Use Slide Sorter View
Activity 1.20 Deleting Slides in Slide Sorter View
Activity 1.21 Moving Slides in Slide Sorter View
Objective 8: Apply Slide Transitions
Activity 1.22 Applying Slide Transitions to a Presentation
Objective 9: Use Reading View
Activity 1.23 Viewing and Editing a Presentation in Reading View
Table of Contents
Common Features
Chapter 1 Using the Common Features of Office 2010
Scenario: Oceana Palm Grill
Project 1A: Menu Plan
Objective 1 Use Windows Explorer to Locate Files and Folder
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 Program
Activity 1.03 Entering and Editing Text in an Office 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 Print a File
Activity 1.06 Printing a File
Project 1B: Memo
Objective 7 Open an Existing File and Save it With a New Name
Activity 1.07 Opening an Existing File and Saving it With a New Name
Objective 8 Explore Application Options
Activity 1.08 Viewing Application Options
Objective 9 Perform Commands from the Ribbon
Activity 1.09 Performing Commands from the Ribbon
Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon
Objective 10 Apply Formatting in Office Programs
Activity 1.11 Formatting and Viewing Pages
Activity 1.12 Formatting Text
Activity 1.13 Using the Office Clipboard to Cut, Copy, and Paste
Objective 11 Use the Microsoft Office 2010 Help System
Activity 1.14 Using the Microsoft Office 2010 Help System in Excel
Objective 12 Compress Files
Activity 1.15 Compressing Files
Word Chapter 1 Using Graphics and Lists
Scenario: Laurel College
Project 1A: Flyer
Objective 1 Create a New Document and Insert Text
Activity 1.1 Starting a New Word Document and Inserting Text
Objective 2 Insert and Format Graphics
Activity 1.2 Formatting Text Using Text Effects
Activity 1.3 Inserting and Resizing Pictures
Activity 1.4 Wrapping Text Around a Picture
Activity 1.5 Moving a Picture
Activity 1.6 Applying Picture Styles and Artistic Effects
Activity 1.7 Adding a Page Border
Objective 3 Insert and Modify Text Boxes and Shapes
Activity 1.8 Inserting a Shape
Activity 1.9 Inserting a Text Box
Activity 1.10 Moving, Resizing, and Formatting Shapes and Text Boxes
Objective 4 Preview and Print a Document
Activity 1.11 Adding a File Name to the Footer
Activity 1.12 Previewing and Printing a Document
Project 1B: Information Handout
Objective 5 Change Document and Paragraph Layout
Activity 1.13 Setting Margins
Activity 1.14 Aligning Text
Activity 1.15 Changing Line Spacing
Activity 1.16 Indenting Text and Adding Space After Paragraphs
Objective 6 Create and Modify Lists
Activity 1.17 Creating a Bulleted List
Activity 1.18 Creating a Numbered List
Activity 1.19 Customizing Bullets
Objective 7 Set and Modify Tab Stops
Activity 1.20 Setting Tab Stops
Activity 1.21 Modifying Tab Stops
Objective 8 Insert a SmartArt Graphic
Activity 1.22 Inserting a SmartArt Graphic
Activity 1.23 Modifying a SmartArt Graphic
Excel Chapter 1 Creating a Worksheet and Charting Data
Scenario: Texas Spectrum Wireless
Project 1A: Quarterly Sales Report with Embedded Column Chart
Objective 1 Create, Save, and Navigate an Excel Workbook
Activity 1.01 Starting Excel and Naming and Saving a Workbook
Activity 1.02 Navigating a Worksheet and a Workbook
Objective 2 Enter Data in a Worksheet
Activity 1.03 Entering Text and Using AutoComplete
Activity 1.04 Filling a Series with Auto Fill and Using Excel Keyboard Shortcuts
Activity 1.05 Aligning Text and Adjusting the Size of Columns
Activity 1.06 Entering Numbers
Objective 3 Construct and Copy Formulas and Use the Sum Function
Activity 1.07 Constructing a Formula and Using the Sum Function
Activity 1.08 Copying a Formula by Using the Fill Handle
Objective 4 Format Cells with Merge & Center and Cell Styles
Activity 1.09 Using Merge & Center and Applying Cell Styles
Activity 1.10 Formatting Financial Numbers
Objective 5 Chart Data in a Column Chart
Activity 1.11 Charting Data in a Column Chart
Objective 6 Prepare a Worksheet for Printing and Close Excel
Activity 1.12 Changing Views, Creating a Footer, and Using Print Preview
Activity 1.13 Deleting Unused Sheets in a Workbook
Activity 1.14 Printing a Worksheet
Activity 1.15 Displaying, Printing, and Hiding Formulas
Project 1B: Inventory Valuation
Objective 7 Check Spelling in a Worksheet
Activity 1.16 Checking Spelling in a Worksheet
Objective 8 Enter Data by Range
Activity 1.17 Entering Data by Range
Objective 9 Construct Formulas for Mathematical Operations
Activity 1.18 Using Arithmetic Operators
Activity 1.19 Copying Formulas Containing Absolute Cell References
Objective 10 Edit Values in a Worksheet
Activity 1.20 Editing Values in a Worksheet
Activity 1.21 Formatting Cells with the Percent Style
Objective 11 Format a Worksheet
Activity 1.22 Inserting and Deleting Rows and Columns
Activity 1.23 Adjusting Column Widths and Wrapping Text
Access Chapter 1 Getting Started with Access Databases
Scenario: Capital Cities Community College
Project 1A: Contact Information
Objective 1: Identify Good Database Design
Activity 1.01 Using Good Design Techniques to Plan a Database
Objective 2: Create a Table and Define Fields in a New Blank Database
Activity 1.02 Starting with a New Blank Database
Activity 1.03 Creating Fields in a Table
Activity 1.04 Renaming Field in a Table
Activity 1.05 Adding a Record to a Table
Activity 1.06 Assigning the Data Type of a Field in Datasheet View
Activity 1.07 Adding Additional Records to a Table
Activity 1.08 Importing Data from an Excel Workbook to an Existing Access Table
Objective 3: Add and Change the Structure of Tables
Activity 1.09 Deleting a Table Field in Design View
Activity 1.10 Modifying a Field Size and Description in Design View
Activity 1.11 Setting a Primary Key and Saving a Table
Activity 1.12 Adding a Second Table to a Database by Importing an Excel Spreadsheet
Activity 1.13 Adjusting Column Widths
Activity 1.14 Printing a Table
Objective 4: Create and Use a Query, a Form, and a Report
Activity 1.15 Using the Simple Query Wizard to Create a Query
Activity 1.16 Creating a Form
Activity 1.17 Creating, Modifying, and Printing a Report
Objective 5: Save, Close, and Change the Properties of a Database
Activity 1.18 Changing Database Properties
Activity 1.19 Closing and Saving a Database
Project 1B: Student Workshops
Objective 6: Create a Database Using a Template
Activity 1.20 Creating a New Database Using a Template
Activity 1.21 Building a Table by Entering Records in a Multiple Items Form
Objective 7: Organize Database Objects in the Navigation Pane
Activity 1.22 Organizing Database Objects in the Navigation Pane
Objective 8: Create a New Table in a Database Created with a Template
Activity 1.23 Creating a New Table and Changing Its Design
Objective 9: View a Report and Print a Table in a Database Created with a Template
Activity 1.24 Viewing a Report
Activity 1.25 Printing a Table
PowerPoint Chapter 1 Getting Started with Microsoft Office PowerPoint
Scenario: Lehua Hawaiian Tours
Project 1A: Company Overview
Objective 1: Create a New Presentation
Activity 1.1 Identifying Parts of the PowerPoint Window
Activity 1.2 Entering Presentation Text and Saving a Presentation
Activity 1.3 Applying a Presentation Theme
Objective 2: Edit a Presentation in Normal View
Activity 1.4 Inserting a New Slide
Activity 1.5 Increasing and Decreasing List Levels
Activity 1.6 Adding Speakers Notes to a Presentation
Activity 1.7 Displaying and Editing Slides in the Slide Pane
Objective 3: Insert and Format Pictures to a Presentation
Activity 1.8 Inserting a Picture from a File
Activity 1.9 Applying a Style to a Picture
Activity 1.10 Applying Artistic Effects to a Picture
Objective 4: Print and View a Presentation
Activitiy 1.11 Viewing a Slide Show
Activity 1.12 Inserting Headers and Footers
Activity 1.13 Printing a Presentation
Project 1B: New Product Announcement
Objective 5: Edit an Existing Presentation
Activity 1.14 Displaying and Editing the Presentation Outline
Activity 1.15 Inserting Slides from an Existing Presentation
Activity 1.16 Finding and Replacing Text
Objective 6: Format a Presentation
Activity 1.17 Changing Fonts, Font Sizes, Font Styles, and Font Colors
Activity 1.18 Aligning Text and Changing Line Spacing
Activity 1.19 Modifying Slide Layout
Objective 7: Use Slide Sorter View
Activity 1.20 Deleting Slides in Slide Sorter View
Activity 1.21 Moving Slides in Slide Sorter View
Objective 8: Apply Slide Transitions
Activity 1.22 Applying Slide Transitions to a Presentation
Objective 9: Use Reading View
Activity 1.23 Viewing and Editing a Presentation in Reading View