| |
| |
Windows 8 | |
| |
| |
| |
Getting Started with Windows 8 | |
| |
| |
Objectives | |
| |
| |
Case Study Cedar Grove Elementary School | |
| |
| |
Windows 8 Fundamentals | |
| |
| |
Understanding the Start Screen | |
| |
| |
Configuring the Start Screen | |
| |
| |
Running Windows 8 Apps | |
| |
| |
Closing Apps | |
| |
| |
Understanding the Desktop | |
| |
| |
Managing Windows 8 Apps and Windows | |
| |
| |
| |
Windows 8 Fundamentals | |
| |
| |
Windows Programs and Security Features | |
| |
| |
Identifying Windows Accessories | |
| |
| |
Working with Security Settings and Software | |
| |
| |
| |
Windows Programs and Security Features | |
| |
| |
Windows Search and Help | |
| |
| |
Performing a Search | |
| |
| |
Using Targeted Searches | |
| |
| |
Getting Help | |
| |
| |
| |
Windows Search and Help | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Microsoft Office 2013 | |
| |
| |
| |
Office Fundamentals and File Management: Taking the First Step | |
| |
| |
Objectives | |
| |
| |
Case Study Spotted Begonia Art Gallery | |
| |
| |
Windows 8 Startup | |
| |
| |
Logging In with Your Microsoft Account | |
| |
| |
Identifying the Start Screen Components | |
| |
| |
Interacting with the Start Screen | |
| |
| |
Accessing the Desktop | |
| |
| |
| |
Windows 8 Startup | |
| |
| |
Files and Folders | |
| |
| |
Using File Explorer | |
| |
| |
Working with Folders and Files | |
| |
| |
Selecting, Copying, and Moving Multiple Files and Folders | |
| |
| |
| |
Files and Folders | |
| |
| |
Microsoft Office Software | |
| |
| |
Identifying Common Interface Components | |
| |
| |
Getting Office Help | |
| |
| |
| |
Microsoft Office Software | |
| |
| |
The Backstage View Tasks | |
| |
| |
Opening a File | |
| |
| |
Printing a File | |
| |
| |
Closing a File and Application | |
| |
| |
| |
The Backstage View Tasks | |
| |
| |
Home Tab Tasks | |
| |
| |
Selecting and Editing Text | |
| |
| |
Using the Clipboard Group Commands | |
| |
| |
Using the Editing Group Commands | |
| |
| |
| |
Home Tab Tasks | |
| |
| |
Insert Tab Tasks | |
| |
| |
Inserting Objects | |
| |
| |
Review Tab Tasks | |
| |
| |
Reviewing a File | |
| |
| |
Page Layout Tab Tasks | |
| |
| |
Using the Page Setup Dialog Box | |
| |
| |
| |
Insert Tab Tasks, Page Layout Tab Tasks, and Review Tab Tasks | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Introduction to Word: Organizing a Document | |
| |
| |
Objectives | |
| |
| |
Case Study Swan Creek National Wildlife Refuge | |
| |
| |
Introduction to Word Processing | |
| |
| |
Beginning and Editing a Document | |
| |
| |
Customizing Word | |
| |
| |
| |
Introduction to Word Processing | |
| |
| |
Document Organization | |
| |
| |
Using Features That Improve Readability | |
| |
| |
Viewing a Document in Different Ways | |
| |
| |
| |
Document Organization | |
| |
| |
Document Settings and Properties | |
| |
| |
Preparing a Document for Distribution | |
| |
| |
Modifying Document Properties | |
| |
| |
| |
Document Settings and Properties | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Microsoft Office Word 2013 | |
| |
| |
| |
Document Presentation: Editing and Formatting | |
| |
| |
Objectives | |
| |
| |
Case Study Phillips Studio L Photography | |
| |
| |
Text and Paragraph Formatting | |
| |
| |
Applying Font Attributes | |
| |
| |
Formatting a Paragraph | |
| |
| |
| |
Text and Paragraph Formatting | |
| |
| |
Document Appearance | |
| |
| |
Formatting a Document | |
| |
| |
Applying Styles | |
| |
| |
| |
Document Formatting | |
| |
| |
Objects | |
| |
| |
Inserting and Formatting Objects | |
| |
| |
| |
Objects | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Document Productivity: Working with Tables and Mail Merge | |
| |
| |
Objectives | |
| |
| |
Case Study Traylor University Economic Impact Study | |
| |
| |
Tables | |
| |
| |
Inserting a Table | |
| |
| |
Formatting a Table | |
| |
| |
| |
Tables | |
| |
| |
Advanced Table Features | |
| |
| |
Managing Table Data | |
| |
| |
Enhancing Table Data | |
| |
| |
| |
Advanced Table Features | |
| |
| |
Mail Merge | |
| |
| |
Creating a Mail Merge Document | |
| |
| |
Completing a Mail Merge | |
| |
| |
| |
Mail Merge | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Collaboration and Research: Communicating and Producing Professional Papers | |
| |
| |
Objectives | |
| |
| |
Case Study Literature Analysis | |
| |
| |
Research Paper Basics | |
| |
| |
Using a Writing Style and Acknowledging Sources | |
| |
| |
Creating and Modifying Footnotes and Endnotes | |
| |
| |
Exploring Special Features | |
| |
| |
| |
Research Paper Basics | |
| |
| |
Document Tracking | |
| |
| |
Reviewing a Document | |
| |
| |
Tracking Changes | |
| |
| |
| |
Document Tracking | |
| |
| |
Online Document Collaboration | |
| |
| |
Using SkyDrive | |
| |
| |
Sharing and Collaborating on Documents | |
| |
| |
| |
Online Document Collaboration | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Microsoft Office Excel 2013 | |
| |
| |
| |
Introduction to Excel: What Is a Spreadsheet? | |
| |
| |
Objectives | |
| |
| |
Case Study Ok Office Systems | |
| |
| |
Introduction to Spreadsheets | |
| |
| |
Exploring the Excel Window | |
| |
| |
Entering and Editing Cell Data | |
| |
| |
| |
Introduction to Spreadsheets | |
| |
| |
Mathematics and Formulas | |
| |
| |
Creating Formulas | |
| |
| |
Using Auto Fill | |
| |
| |
Displaying Cell Formulas | |
| |
| |
| |
Mathematics and Formulas | |
| |
| |
Workbook and Worksheet Management | |
| |
| |
Managing Worksheets | |
| |
| |
Managing Columns and Rows | |
| |
| |
| |
Workbook and Worksheet Management | |
| |
| |
Clipboard Tasks | |
| |
| |
Selecting, Moving, Copying, and Pasting Data | |
| |
| |
| |
Clipboard Tasks | |
| |
| |
Formatting | |
| |
| |
Applying Alignment and Font Options | |
| |
| |
Applying Number Formats | |
| |
| |
| |
Formatting | |
| |
| |
Page Setup and Printing | |
| |
| |
Selecting Page Setup Options | |
| |
| |
Previewing and Printing a Worksheet | |
| |
| |
| |
Page Setup and Printing | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Formulas and Functions: Performing Quantitative Analysis | |
| |
| |
Objectives | |
| |
| |
Case Study Townsend Mortgage Company | |
| |
| |
Formula Basics | |
| |
| |
Using Relative, Absolute, and Mixed Cell References in Formulas | |
| |
| |
Correcting Circular References | |
| |
| |
| |
Formula Basics | |
| |
| |
Function Basics | |
| |
| |
Inserting a Function | |
| |
| |
Inserting Basic Math and Statistics Functions | |
| |
| |
Using Date Functions | |
| |
| |
| |
Function Basics | |
| |
| |
Logical, Lookup, and Financial Functions | |
| |
| |
Determining Results with the IF Function | |
| |
| |
Using Lookup Functions | |
| |
| |
Calculating Payments with the PMT Function | |
| |
| |
| |
Logical, Lookup, and Financial Functions | |
| |
| |
Range Names | |
| |
| |
Creating and Maintaining Range Names | |
| |
| |
Using Range Names in Formulas | |
| |
| |
| |
Range Names | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Charts: Depicting Data Visually | |
| |
| |
Objectives | |
| |
| |
Case Study Computer Job Outlook | |
| |
| |
Chart Creation Basics | |
| |
| |
Selecting the Data Source | |
| |
| |
Choosing a Chart Type | |
| |
| |
Moving, Sizing, and Printing a Chart | |
| |
| |
| |
Chart Creation Basics | |
| |
| |
Chart Elements | |
| |
| |
Adding Chart Elements | |
| |
| |
Formatting Chart Elements | |
| |
| |
| |
Chart Elements | |
| |
| |
Chart Design and Sparklines | |
| |
| |
Applying a Chart Style and Colors | |
| |
| |
Modifying the Data Source | |
| |
| |
Creating and Customizing Sparklines | |
| |
| |
| |
Chart Design and Sparklines | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Datasets and Tables: Managing Large Volumes of Data | |
| |
| |
Objectives | |
| |
| |
Case Study Reid Furniture Store | |
| |
| |
Large Datasets | |
| |
| |
Freezing Rows and Columns | |
| |
| |
Printing Large Datasets | |
| |
| |
| |
Large Datasets | |
| |
| |
Excel Tables | |
| |
| |
Designing and Creating Tables | |
| |
| |
Applying a Table Style | |
| |
| |
| |
Excel Tables | |
| |
| |
Table Manipulation | |
| |
| |
Sorting Data | |
| |
| |
Filtering Data | |
| |
| |
| |
Table Manipulation | |
| |
| |
Table Aggregation | |
| |
| |
Using Structured References and a Total Row | |
| |
| |
| |
Table Aggregation | |
| |
| |
Conditional Formatting | |
| |
| |
Applying Conditional Formatting | |
| |
| |
Creating a New Rule | |
| |
| |
| |
Conditional Formatting | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Microsoft Office Access 2013 | |
| |
| |
| |
Introduction to Access: Finding Your Way Through an Access Database | |
| |
| |
Objectives | |
| |
| |
Case Study Managing a Business in the Global Economy | |
| |
| |
Databases Are Everywhere! | |
| |
| |
Understanding Database Fundamentals | |
| |
| |
Using an Existing Database | |
| |
| |
| |
Databases Are Everywhere! | |
| |
| |
Sorts and Filters | |
| |
| |
Sorting Table Data on One or Multiple Fields | |
| |
| |
Creating, Modifying, and Removing Filters | |
| |
| |
| |
Sorts and Filters | |
| |
| |
Access Versus Excel, and Relational Databases | |
| |
| |
Knowing When to Use Access or Excel to Manage Data | |
| |
| |
Understanding Relational Power | |
| |
| |
| |
Access Versus Excel, and Relationship Databases | |
| |
| |
Access Database Creation | |
| |
| |
Creating a Database | |
| |
| |
| |
Access Database Creation | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Tables and Queries in Relational Databases: Designing Databases and Extracting Data | |
| |
| |
Objectives | |
| |
| |
Case Study Bank Audit | |
| |
| |
Table Design, Creation, and Modification | |
| |
| |
Designing a Table | |
| |
| |
Creating and Modifying Tables | |
| |
| |
| |
Table Design, Creation, and Modification | |
| |
| |
Multiple-Table Databases | |
| |
| |
Sharing Data | |
| |
| |
Establishing Table Relationships | |
| |
| |
| |
Multiple-Table Databases | |
| |
| |
Single-Table Queries | |
| |
| |
Creating a Single-Table Query | |
| |
| |
Specifying Query Criteria for Different Data Types | |
| |
| |
Understanding Query Sort Order | |
| |
| |
Running, Copying, and Modifying a Query | |
| |
| |
Using the Query Wizard | |
| |
| |
| |
Single-Table Queries | |
| |
| |
Multitable Queries | |
| |
| |
Creating a Multitable Query | |
| |
| |
Modifying a Multitable Query | |
| |
| |
| |
Multitable Queries | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions | |
| |
| |
Objectives | |
| |
| |
Case Study Housing Slump Means Opportunity For College Students | |
| |
| |
Calculations and Expressions | |
| |
| |
Creating a Calculated Field in a Query | |
| |
| |
Formatting and Saving Calculated Results | |
| |
| |
| |
Calculations and Expressions | |
| |
| |
The Expression Builder and Functions | |
| |
| |
Creating Expressions with the Expression Builder | |
| |
| |
Using Built-In Functions in Access | |
| |
| |
| |
The Expression Builder and Functions | |
| |
| |
Aggregate Functions | |
| |
| |
Adding Aggregate Functions to Datasheets | |
| |
| |
Creating Queries with Aggregate Functions | |
| |
| |
| |
Aggregate Functions | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries | |
| |
| |
Objectives | |
| |
| |
Case Study Coffee Shop Starts New Business | |
| |
| |
Form Basics | |
| |
| |
Creating Forms Using Form Tools | |
| |
| |
Using Form Views | |
| |
| |
Working with a Form Layout Control | |
| |
| |
Sorting Records in a Form | |
| |
| |
| |
Create and Modify forms | |
| |
| |
Report Basics | |
| |
| |
Creating Reports Using Report Tools | |
| |
| |
Using Report Views | |
| |
| |
Modifying a Report | |
| |
| |
Sorting Records in a Report | |
| |
| |
| |
Report Basics | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Microsoft Office PowerPoint 2013 | |
| |
| |
| |
Introduction to PowerPoint: Creating a Basic Presentation | |
| |
| |
Objectives | |
| |
| |
Case Study Be a Trainer | |
| |
| |
Introduction to PowerPoint | |
| |
| |
Using PowerPoint Views | |
| |
| |
Typing a Speaker Note | |
| |
| |
Saving As a Slide Show | |
| |
| |
| |
Introduction to PowerPoint | |
| |
| |
Presentation Creation | |
| |
| |
Planning a Presentation | |
| |
| |
Assessing Presentation Content | |
| |
| |
Reviewing the Presentation | |
| |
| |
| |
Presentation Creation | |
| |
| |
Presentation Enhancement | |
| |
| |
Inserting Media Objects | |
| |
| |
Adding a Table | |
| |
| |
Using Animations and Transitions | |
| |
| |
Inserting a Header or Footer | |
| |
| |
| |
Presentation Enhancement | |
| |
| |
Navigation and Printing | |
| |
| |
Running and Navigating a Slide Show | |
| |
| |
Printing in PowerPoint | |
| |
| |
| |
Navigation and Printing | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Presentation Development: Planning and Preparing a Presentation | |
| |
| |
Objectives | |
| |
| |
Case Study The Wellness Education Center | |
| |
| |
Templates | |
| |
| |
Creating a Presentation Using a Template | |
| |
| |
Modifying a Presentation Based on a Template | |
| |
| |
| |
Templates | |
| |
| |
Outlines | |
| |
| |
Creating a Presentation in Outline View | |
| |
| |
Modifying an Outline Structure | |
| |
| |
Printing an Outline | |
| |
| |
| |
Outlines | |
| |
| |
Data Imports | |
| |
| |
Importing an Outline | |
| |
| |
Reusing Slides from an Existing Presentation | |
| |
| |
| |
Data Imports | |
| |
| |
Design | |
| |
| |
Using Sections | |
| |
| |
Examining Slide Show Design Principles | |
| |
| |
Modifying a Theme | |
| |
| |
Modifying the Slide Master | |
| |
| |
| |
Design | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
Presentation Design: Illustrations and Infographics | |
| |
| |
Objectives | |
| |
| |
Case Study Illustrations and Infographics Mini-Camp | |
| |
| |
Shapes | |
| |
| |
Creating Shapes | |
| |
| |
Applying Quick Styles and Customizing Shapes | |
| |
| |
| |
Shapes | |
| |
| |
Smartart and Wordart | |
| |
| |
Creating SmartArt | |
| |
| |
Modifying SmartArt | |
| |
| |
Creating WordArt | |
| |
| |
Modifying WordArt | |
| |
| |
| |
SmartArt and WordArt | |
| |
| |
Object Manipulation | |
| |
| |
Modifying Objects | |
| |
| |
Arranging Objects | |
| |
| |
| |
Object Manipulation | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
| |
PowerPoint Rich Media Tools: Enhancing with Multimedia | |
| |
| |
Objectives | |
| |
| |
Case Study Engagement Album | |
| |
| |
Pictures | |
| |
| |
Inserting a Picture | |
| |
| |
Transforming a Picture | |
| |
| |
Using the Internet as a Resource | |
| |
| |
| |
Pictures | |
| |
| |
Video | |
| |
| |
Adding Video | |
| |
| |
Using Video Tools | |
| |
| |
| |
Video | |
| |
| |
Audio | |
| |
| |
Adding Audio | |
| |
| |
Changing Audio Settings | |
| |
| |
| |
Audio | |
| |
| |
Photo Albums | |
| |
| |
Creating a Photo Album | |
| |
| |
Setting Photo Album Options | |
| |
| |
| |
Photo Albums | |
| |
| |
Chapter Objectives Review | |
| |
| |
Key Terms Matching | |
| |
| |
Multiple Choice | |
| |
| |
Practice Exercises | |
| |
| |
Mid-Level Exercises | |
| |
| |
Beyond the Classroom | |
| |
| |
Capstone Exercise | |
| |
| |
Application Capstone Exercises | |
| |
| |
Word | |
| |
| |
Excel | |
| |
| |
Access | |
| |
| |
PowerPoint | |
| |
| |
Glossary | |
| |
| |
Index | |