Contents
Windows 8
Windows 8 Workshop 1: Understand the Windows 8 Interface
PREPARE CASE: Painted Paradise Golf Resort and Spa-Employee Introduction to Microsoft Windows 8
Understanding Windows 8
Starting and Shutting Down Windows 8
Exploring the Windows 8 Interface
Explore the Windows 8 Start Screen
Use the Snipping Tool
Use WordPad
Switch Between Programs
Open and Close Programs
Using Charms and Windows Search
Using Gestures
Protecting Windows 8
Log in Using a Microsoft Account
Use Picture Passwords
Add a PIN Login
Log in Using PINs and Picture Passwords
Add a Trusted PC
Using Internet Explorer 10
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Windows 8 WORKSHOP 2: Manage Files, Folders, and the Windows Desktop
PREPARE CASE: Painted Paradise Golf Resort and Spa Updates to Microsoft Windows 8
Using File Explorer
Open and Navigate File Explorer
Add Folders to Libraries
Working with Folders
Create and Name a New Folder
Copy, Move, Rename, and Delete Folders
Working with Files
Copy, Move, Rename, and Delete Files
Zip Files
Extract Files
Add Tags to Files
Exploring the Windows 8 Desktop
Identify Desktop Elements
Understand the Taskbar
Working with Windows
Open and Manage Windows
Work with Multiple Windows
Personalizing the Desktop
Change the Appearance of the Desktop
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Windows 8 MODULE 1 CAPSTONE
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
How Others Perform
Perform in Your Career
Common Features
Common Features WORKSHOP 1: The Common Features of Microsoft Office
PREPARE CASE: Painted Paradise Resort and Spa Employee Training Preparation
Working with the Office Interface
Understand Office Applications and Accounts
Start Office Programs and Manipulate Windows
Use the Office Ribbon, Contextual Tools, and Other Menus
Manipulating Files and Finding Help in Office
Manage Files in Office
Get Help
Understanding the Cloud and Touch Integration
Use Windows SkyDrive
Use Touch Mode, Gestures, and Reading Mode
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Perform in Your Life
Cloud Mobile computing
Cloud Mobile Computing WORKSHOP 1: Mobile Computing
PREPARE CASE: Women's Golf Getaway Collaboration
Understanding Mobile Computing
Understand Different Tablet Computers
View Documents on Mobile Devices
View and Edit Documents on an iPad
Share Documents with Mobile Devices
View and Edit Documents on an Android Tablet
View and Edit Documents on a Surface Tablet
Concept Check
Key Terms
Visual Summary
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
Word Module 1-Understanding Business Documents
Word WORKSHOP 1: Review and Modify a Document
PREPARE CASE: Putts for Paws Golf Tournament Memo
Understanding Business Communication
Using Word Processing Software
Develop Effective Business Documents
Work with Business Correspondence
Editing A Document
Explore the Word Interface
Format Characters
Format Paragraphs
Proofread a Document
Insert a Header and Footer
Save and Close a Document
Print a Document
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform In Your Life
Word WORKSHOP 2: Create and Edit a Document
PREPARE CASE: Red Bluff Caddy School Flyer
Creating and Styling a Document
Create a New Document
Understand Word Styles
Copy and Clear Formats
Add Bullets, Numbers, and Symbols
Set Line and Paragraph Indents
Work with Templates
Formatting a Document
Change Page Setup
Change Page Background
Use Themes
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
WORD MODULE 1 CAPSTONE
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Word Module 2-Impressing with Sophisticated Documents
Word WORKSHOP 3: Include Tables and Objects
PREPARE CASE: Turquoise Oasis Spa Services Publication
Including Objects in a Document
Use WordArt
Create SmartArt
Insert a Text Box
Insert Graphics
Working With Tabs and Tables
Set Tabs
Create a Table
Managing Pages
Work with Page Breaks
Work with Sections
Insert Text from Another Document
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Word WORKSHOP 4: Special Document Formatting and Mail Merge
PREPARE CASE: Turquoise Oasis Spa Newsletter
Creating a Research Paper
Format a Research Paper
Develop a Bibliography or Works Cited Page
Revising a Document
Inserting Comments
Tracking Changes
Creating a Newsletter
Work with Columns
Creating a Mail Merge Document
Using Mail Merge
Creating Labels and Envelopes
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
WORD MODULE 2 CAPSTONE
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Excel Module 1-Understanding the Fundamentals
Excel WORKSHOP 1: Navigate, Manipulate, and Print Worksheets
PREPARE CASE: Red Bluff Golf Course and Pro Shop Golf Cart Purchase Analysis
Excel Worksheets-What If Data and Information Could Speak?
Understand Spreadsheet Terminology and Components
Navigate Worksheets and Workbooks
Document Your Work!
Enter and Edit Data
Manipulate Cells and Cell Ranges
Manipulate Columns and Rows
Printing Worksheets and Manipulating Workbooks
Preview and Print Worksheets
Manipulate Worksheets and Workbooks
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Excel WORKSHOP 2: Formatting, Functions, and Formulas
PREPARE CASE: Red Bluff Golf Course & Pro Shop Sales Analysis
Worksheet Formatting
Format Cells, Cell Ranges, and Worksheets
Creating Information for Decision Making
What Is a Function?
What Is a Formula?
Decision Making
Documenting Your Work
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
EXCEL Module 1 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Excel Module 2-Conducting Business Analysis
Excel WORKSHOP 3: Cell References, Named Ranges, and Functions
PREPARE CASE: Painted Paradise Resort and Spa Wedding Planning
Cell References and Named Ranges
Types of Cell References
Naming a Cell Range
Functions
Function Structure and Construction
Common Math and Statistical Functions
Common Date and Time Functions
Text Functions and Flash Fill
Financial and Lookup & Reference Functions
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Excel WORKSHOP 4: Effective Charts
PREPARE CASE: Turquoise Oasis Spa Sales Reports
Designing a Chart
Exploring Chart Characteristics: Types, Layouts, and Styles
Chart Locations
Chart Types
Laying out a Chart
Chart Layouts, Styles, and Data
Editing and Formatting Charts
Strategic Statements with Charts
Recognizing and Correcting Confusing Charts
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
EXCEL Module 2 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Access Module 1-Understanding and Using a Relational Database
Access WORKSHOP 1: The Four Main Database Objects
PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament
Understanding Database Basics and Tables
Understand what Access Is
Maneuvering in the Navigation Pane
Understand what a Table Is
Manually Navigate a Database
Understanding Queries, Forms, and Reports
Understand what a Query Is
Understand what a Form Is
Understand what a Report Is
Backing Up Your Database
Compact and Repair a Database
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access WORKSHOP 2: Tables, Keys, and Relationships
PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament Database
Inserting Data into a Database
Importing Data from Other Sources
Manual Data Entry
Understanding Tables and Keys
Creating a Table in Design View
Understand Masks and Formatting
Understanding and Designating Keys
Understanding Relational Databases
Understanding Basic Principles of Normalization
Understanding Relationships
Create a One-to-Many Relationship
Create a Many-to-Many Relationship
Understanding Referential Integrity
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 1 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 2-Accessing, Maintaining, and Presenting Information
Access WORKSHOP 3: Queries and Data Access
PREPARE CASE: Turquoise Oasis Spa Data Management
Work With Datasheets
Find and Replace Records in the Datasheet
Modify Datasheet Appearance
Queries
Run Other Query Wizards
Create Queries in Design View
Sort Query Results
Define Selection Criteria for Queries
Create Aggregate Functions
Create Calculated Fields
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access WORKSHOP 4: Access Information from an Access Database
PREPARE CASE: Turquoise Oasis Spa's New Database
Creating Customized Forms
Navigate in datasheets and forms
Update Table Records Using Forms
Create a Form Using the Form Wizard
Modify a Form's Design
Creating Customized Reports
Create a Report Using the Report Wizard
Use and Customize Access Themes
Modify a Report's Design
Save a Report as a PDF File
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 2 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
PowerPoint Module 1
PowerPoint Module 1-Understanding the Art of Presentation
PowerPoint WORKSHOP 1: Presentation Fundamentals
PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Golf Tournament Presentation
Understanding the Purpose of PowerPoint
Presenting with a purpose for an intended outcome
Defining the purpose, scope, and audience of a presentation
Planning the presentation content
Working with the PowerPoint window and view modes
Navigating in slide show view and outline view
Understanding effective communication
Understanding the difference between a theme and a template
Creating a presentation from a template
Adding and deleting slides, changing slide layouts and rearranging slides
Editing slides and moving slide content
Using the research pane
Saving and Printing a Presentation
Saving a presentation
Previewing and appropriate printing of a presentation
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
PowerPoint WORKSHOP 2: Text and Graphics
PREPARE CASE: The Red Bluff Caddy School Presentation
Using Text Effectively
Modifying text
Using Text hierarchy to Convey Organization
Reusing formats
Using Special Symbols
Selecting and using appropriate graphics
Working with images and art
Selecting and using appropriate graphics
Working with shape and line graphics
Using Elements to Communicate Information
Creating a table
Creating and inserting charts
Creating a SmartArt graphic
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Power Point MODULE 1 CAPSTONE
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
PowerPoint Module 2-Collaborating and Invoking Emotion with the Audience
PowerPoint WORKSHOP 3: Multimedia and Motion
PREPARE CASE: The Turquoise Oasis Spa Presentation for Marketing
Using motion in a presentation
Using transitions and animations
Using Multimedia in a presentation
Using linking
Inserting audio
Inserting Video
Working with photo albums
Creating a custom slide show
Using Multimedia in a presentation
Saving and sending a presentation
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
PowerPoint WORKSHOP 4: Customization and Collaboration
PREPARE CASE: Corporate Identity Template
Creating a corporate identity with a custom template
Modifying the slide master
Customizing the Notes and handout master
Using a custom template
Importing an outline
Using Slide sections
Using Proofing Tools and Checking Spelling
Collaborating with others on a presentation
Co-authoring & Sharing Presentations
Creating speaker notes
Protecting presentations
Delivering a presentation
Overcoming presentation nerves and being prepared
Engaging your audience and providing a roadmap for your audience
Annotating slides
New Presentation Mode including Auto Extend
Using presenter view, widescreen and slide zoom
Concluding your presentation
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Life
Power Point MODULE 2 CAPSTONE
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Team
How Others Perform
Integrated Projects
WORKSHOP 1: Word and Excel Integration
PREPARE CASE: Updated Menu
Object Linking and Embedding
Object Linking and Embedding
Link an Object
Update a Linked Object
Embed an Object
Modify an Embedded Object
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Career
How Others Perform
WORKSHOP 2: Word, Excel, and Access Integration
PREPARE CASE: Coupon Mailing
Use Excel Data in Access
Prepare Excel Data for Import
Import Excel Data
Use Access Data in Word
Prepare Access Data for a Mail Merge
Export Query Results from Access to Word
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Career
How Others Perform
WORKSHOP 3: Integrating Word, Excel, Access, and PowerPoint
PREPARE CASE: Restaurant Training
Integrate Word and PowerPoint
Open Outline View
Integrate Access and PowerPoint
Insert Access Data into a PowerPoint Presentation
Integrate Access, Excel, and PowerPoint
Import Access Data into Excel
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Practice Case 2
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Career
How Others Perform
