GO! with Microsoft Office 2010 Getting Started

GO! with Microsoft Office 2010 Getting Started

by Shelley Gaskin, Robert Ferrett, Alicia Vargas, Carolyn McLellan
     
 

View All Available Formats & Editions

ISBN-10: 0135088658

ISBN-13: 9780135088654

Pub. Date: 07/13/2010

Publisher: Pearson

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

Overview

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.

Product Details

ISBN-13:
9780135088654
Publisher:
Pearson
Publication date:
07/13/2010
Series:
GO! Series
Edition description:
New Edition
Pages:
336
Product dimensions:
8.60(w) x 10.80(h) x 0.40(d)

Table of Contents

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >