Technology for Success and The Shelly Cashman Series Microsoft 365 & Office 2021 (MindTap Course List)

Cover
Brief Contents
Contents
Getting to Know Microsoft Office Versions
Using SAM Projects and Textbook Projects
Introduction to Technology for Success: Computer Concepts
Technology for Success: Computer Concepts
Module 1: Impact of Digital Technology
Explain Society's Reliance on Technology
Develop Personal Uses for Technology
Explain the Role of Technology in the Professional World
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
Module 2: The Web
Explain the Role of the Web in Daily Life
Describe Websites and Webpages
Use E-commerce
Apply Information Literacy Skills to Web Searches
Conduct Online Research
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
Module 3: Computer Hardware
Categorize the Various Types of Computer Hardware
Demonstrate Familiarity with Input and Output Devices
Maintain Hardware Components
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
Module 4: Operating Systems and File Management
Compare Operating Systems
Explain How an Operating System Works
Personalize an Operating System to Increase Productivity
Manage Files and Folders
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
Module 5: Software and Apps
Explain How to Use Apps as Part of Your Daily Life
Use Common Features of Productivity and Graphics Apps
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
Module 6: Security and Safety
Discuss Computer Safety and Health Risks
Use Protective Measures to Safeguard Computers and Data
Summary
Review Questions
Discussion Questions
Critical Thinking Activities
Key Terms
References
Word 2021
Module 1: Creating and Modifying a Flyer
Objectives
What Is Word?
Introduction
Project: Flyer with a Picture
Starting and Using Word
Entering Text in a Document
Formatting Paragraphs and Characters
Inserting and Formatting a Picture in a Word Document
Enhancing the Page
Correcting Errors and Revising a Document
Using Word Help
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 2: Creating a Research Paper
Objectives
Introduction
Project: Research Paper
Changing Document Settings
Creating a Header
Typing the Research Paper Text
Creating an Alphabetical Works Cited Page
Proofreading and Revising the Research Paper
Working with Comments in a Document
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 3: Creating a Business Letter
Objectives
Introduction
Project: Business Letter
Creating a Letterhead
Creating a Business Letter
Working with SmartArt Graphics
Addressing and Printing Envelopes and Mailing Labels
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
PowerPoint 2021
Module 1: Creating and Editing Presentations with Pictures
Objectives
What Is PowerPoint?
Project: Presentation with a Bulleted List and Pictures
Starting and Using PowerPoint
Creating a Title Slide
Formatting Characters
Adding a Slide with a Bulleted List
Adding Slides, Changing Slide Layouts, and Changing the Theme
Inserting, Resizing, and Moving Pictures
Resizing Photos and Illustrations
Making Changes to Slide Text Content
Saving and Printing Files
Using PowerPoint Help
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 2: Enhancing Presentations with Shapes and SmartArt
Objectives
Introduction
Project - Presentation with SmartArt and Shapes
Downloading a Theme and Editing Slides
Creating and Formatting a SmartArt Graphic
Inserting and Formatting a Shape
Positioning Slide Elements
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 3: Inserting WordArt, Charts, and Tables
Objectives
Introduction
Project - Presentation with WordArt, a Chart, and a Table
Adding a Chart to a Slide and Formatting
Adding a Table to a Slide and Formatting
Inserting and Formatting a Text Box
Inserting and Moving Slides
Inserting Pictures and Adding Effects
Creating and Formatting WordArt
Animating Slide Content
Adding Media to Slides
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Excel 2021
Module 1: Creating a Worksheet and a Chart
Objectives
Introduction
Project: Real Estate Budget Worksheet and Chart
Starting and Using Excel
Selecting a Cell
Entering Text
Entering Numbers
Calculating Sums and Using Formulas
Using the Fill Handle to Copy a Cell to Adjacent Cells
Calculating Average, Maximum, and Minimum Values
Saving the Project
Formatting the Worksheet
Adding a Pie Chart to the Worksheet
Changing the Sheet Tab Names and Colors
Document Properties
Printing a Worksheet
Viewing Automatic Calculations
Correcting Errors
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 2: Formulas, Functions, and Formatting
Objectives
Introduction
Project: Worksheet with Formulas and Functions
Entering the Titles and Numbers into the Worksheet
Flash Fill
Entering Formulas
Option Buttons
Using the AVERAGE, MAX, MIN, and Other Statistical Functions
Verifying Formulas Using Range Finder
Formatting the Worksheet
Checking Spelling
Printing the Worksheet
Displaying and Printing the Formulas Version of the Worksheet
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 3: Working with Large Worksheets, Charting, and What-If Analysis
Objectives
Introduction
Project: Financial Projection Worksheet with What-If Analysis and Chart
Rotating Text and Using the Fill Handle to Create a Series
Copying a Range of Cells to a Nonadjacent Destination Area
Inserting and Deleting Cells in a Worksheet
Absolute versus Relative Addressing
Making Decisions - The IF Function
Formatting the Worksheet
Adding a Clustered Column Chart to the Workbook
Organizing the Workbook
Changing the View of the Worksheet
What-If Analysis
Insights
Accessibility Features
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Access 2021
Module 1: Databases and Database Objects: An Introduction
Objectives
Introduction
Project - Database Creation
Creating a Database
The Access Window
Determining Tables and Fields
Creating a Table in Datasheet View
Additional Database Objects
Database Properties
Special Database Operations
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 2: Querying a Database
Objectives
Introduction
Project - Querying a Database
Creating Queries
Sorting
Joining Tables
Creating a Form for a Query
Exporting Data from Access to Other Applications
Adding Criteria to a Join Query
Calculations
Crosstab Queries
Customizing the Navigation Pane
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Lab
Module 3: Maintaining a Database
Objectives
Introduction
Project - Maintaining a Database
Updating Records
Filtering Records
Changing the Database Structure
Mass Changes
Validation Rules
Making Additional Changes to the Database
Changing the Appearance of a Datasheet
Multivalued Fields in Queries
Referential Integrity
Ordering Records
Summary
Apply Your Knowledge
Extend Your Knowledge
Expand Your World
In the Labs
Index