Book Contents Navigation
Teaching Resources
Technical Resources
Evidence-Based Teaching Practices
Students: How to Use Lumen Course Materials
Students: Additional Lumen Resources
Cheat Sheet: Introduction to Computers
Introduction to Computers: Background You’ll Need 1
Introduction to Computers: Background You’ll Need 2
Introduction to Computers: Background You Need 3
Computer Concepts: Learn It 1 - Hardware
Computer Concepts: Learn It 2 - Software
Computer Concepts: Learn It 3 - Software Cont.
Computer Concepts: Learn It 4 - Security
Computer Concepts: Learn It 5 - Privacy
Computer Concepts: Apply It 1
Computer Concepts: Fresh Take
Operating Systems: Learn It 1 - Identifying Your Operating System (OS)
Operating Systems: Apply It 1
Operating Systems: Fresh Take
Navigate Programs: Learn It 1 - Managing Windows
Navigate Programs: Learn It 2 - Keyboard Shortcuts
Navigate Programs: Apply It 1
Navigate Programs: Fresh Take
Finding Programs and Files: Learn It 1 - Start Menu
Finding Programs and Files: Learn It 2 - Creating Files and Folders
Finding Programs and Files: Learn It 3 - Organizing Files and Folders
Finding Programs and Files: Learn It 4 - Deleting Files and Folders
Finding Programs and Files: Apply It 1
Finding Programs and Files: Fresh Take
File Management: Learn It 1 - Local Files
File Management: Learn It 2 - Network Files
File Management: Learn It 3 - Online Files
File Management: Apply It 1
File Management: Fresh Take
Get Stronger: Introduction to Computers
Cheat Sheet: Internet Research
Internet Research: Background You’ll Need 1
Internet Research: Background You’ll Need 2
Using and Searching the Internet: Learn It 1 - Internet Browsers
Using and Searching the Internet: Learn It 2 - Basic Browser Tools
Using and Searching the Internet: Apply It 1
Using and Searching the Internet: Fresh Take
Ethical Business Research: Learn It 1 - Ethical Research
Ethical Business Research: Learn It 2 - Data and Customer Rights
Ethical Business Research: Apply It 1
Ethical Business Research: Fresh Take
Basic Searches: Learn It 1 - Web Searching
Basic Searches: Learn It 2 - Identifying Search Results
Basic Searches: Learn It 3 - Opening Search Results
Basic Searches: Apply It 1
Basic Searches: Fresh Take
Advanced Searches: Learn It 1 - Adjusting Search Parameters
Advanced Searches: Learn It 2 - Image Searches
Advanced Searches: Apply It 1
Advanced Searches: Fresh Take
Get Stronger: Internet Research
Cheat Sheet: Cloud Computing
Cloud Computing: Background You’ll Need 1
Cloud Computing: Background You’ll Need 2
Email Etiquette and Security: Learn It 1 - Email Etiquette
Email Etiquette and Security: Learn It 2 - Security Threats in Email
Email Etiquette and Security: Apply It 1
Email Etiquette and Security: Fresh Take
Email Tools: Learn It 1 - Sending and Receiving Emails and Attachments
Email Tools: Learn It 2 - Organizing and Searching Email
Email Tools: Apply It 1
Email Tools: Fresh Take
Automate Email: Learn It 1 - Signatures and Auto Reply
Automating Email: Learn It 2- Email Rules
Automate Email: Apply It
Automate Email: Fresh Take
Calendar Tools: Learn It 1 - Creating Appointments and Meetings
Calendar Tools: Learn It 2 -Scheduling Assistant and Room Finder
Calendar Tools: Learn It 3 - Shared Calendars
Calendar Tools: Apply It 1
Calendar Tools: Fresh Take
Instant Messaging and Video Conferencing: Learn It 1 - Instant Messaging and Video Conference Applications
Instant Messaging and Video Conferencing: Learn It 2 - Choosing a Communication Tool
Instant Messaging and Video Conferencing: Apply It 1
Instant Messaging and Video Conferencing: Fresh Take
Cloud Storage Tools: Learn It 1 - Using OneNote
Cloud Storage Tools: Learn It 2 - Using OneDrive
Cloud Storage Tools: Apply It 1
Cloud Storage Tools: Fresh Take
Get Stronger: Cloud Computing
Cheat Sheet: Microsoft Word Basic Skills
Microsoft Word Basic Skills: Background You Need 1
Microsoft Word Basic Skills: Background You Need 2
Using Word: Learn It 1
Using Word: Learn It 2
Using Word: Learn It 3
Using Word: Learn It 4
Using Word: Apply It 1
Using Word: Fresh Take
Basic Text Formatting: Learn It 1
Basic Text Formatting: Learn It 2
Basic Text Formatting: Learn It 3
Basic Text Formatting: Learn It 4
Basic Text Formatting: Learn It 5
Basic Text Formatting: Learn It 6
Basic Text Formatting: Apply It 1
Basic Text Formatting: Apply It 2
Basic Text Formatting: Fresh Take
Workplace Tools: Learn It 1 - Spell Check and Dictionaries
Workplace Tools: Learn It 2 - Find and Replace
Workplace Tools: Learn It 3
Workplace Tools: Learn It 4
Workspace Tools: Apply It 1
Workspace Tools: Fresh Take
Lists: Learn It 1
Lists: Apply It 1
Lists: Fresh Take
Get Stronger: Microsoft Word Basic Skills
Cheat Sheet: Microsoft Word Intermediate Skills
Microsoft Word Intermediate Skills: Background You'll Need 1
Microsoft Word Intermediate Skills: Background You'll Need 2
Page Layout: Learn It 1 - Tab Stops
Page Layout: Learn It 2 - Columns
Page Layout: Learn It 3 - Headers and Footers
Page Layout: Apply It 1
Page Layout: Fresh Take
Text Boxes: Learn It 1
Text Boxes: Learn It 2
Text Boxes: Apply It 1
Text Boxes: Fresh Take
Tables: Learn It 1 - Creating Tables
Tables: Learn It 2 - Converting Text to a Table
Tables: Learn It 3 - Formatting Tables
Tables: Apply It 1
Tables: Fresh Take
Images: Learn It 1 - Adding Images
Images: Learn It 2 - Text Wrap
Images: Apply It 1
Images: Fresh Take
Graphics: Learn It 1 - Graphics
Graphics: Learn It 2 - Modify Graphics
Graphics: Learn It 3 - Format Graphics
Graphics: Apply It 1
Graphics: Fresh Take 1
Hyperlinks: Learn It 1 - Hyperlinks
Hyperlinks: Apply It 1
Hyperlinks: Fresh Take 1
Get Stronger: Microsoft Word Intermediate Skills
Cheat Sheet: Microsoft Word Advanced Skills
Microsoft Word Advanced Skills: Background You'll Need 1
Advanced File Creation and Text Formatting: Learn It 1 - Creating a New Document from a Template
Advanced File Creation and Text Formatting: Learn It 2 - Text Effects
Advanced File Creation and Text Formatting: Apply It 1
Advanced File Creation and Text Formatting: Fresh Take
Watermarks and Icons: Learn It 1 - Watermarks
Watermarks and Icons: Learn It 2 - Icons in Word
Watermarks and Icons: Apply It 1
Watermarks and Icons: Fresh Take
Citations: Learn It 1 - Citations
Citations Learn It 2
Citations: Apply It 1
Citations: Fresh Take
Mail Merge: Learn It 1 - Mail Merge
Mail Merge: Apply It 1
Mail Merge: Fresh Take
Internet and Word: Learn It 1 - Internet and Word
Internet and Word: Apply It 1
Internet and Word: Fresh Take
Get Stronger: Microsoft Word Advanced Skills
Cheat Sheet: Microsoft Excel Basic Skills
Microsoft Excel Basic Skills: Background You'll Need 1
Using Excel: Learn It 1 - Creating a New Workbook
Using Excel: Learn It 2 - Creating a Workbook with Multiple Worksheets
Using Excel: Learn It 3 - Entering Data
Using Excel: Learn It 4 - Rearranging Tables
Using Excel: Learn It 5 - Changing Width of Columns and Rows
Using Excel: Apply It 1
Using Excel: Fresh Take
Basic Formatting and Layout: Learn It 1 - Table Styles
Basic Formatting and Layout: Learn It 2 - Cell Styles
Basic Formatting and Layout: Learn It 3 - Cell Format
Basic Formatting and Layout: Learn It 4 - Comma Styles
Basic Formatting and Layout: Apply It 1
Basic Formatting and Layout: Fresh Take
Get Stronger: Microsoft Excel Basic Skills
Cheat Sheet: Microsoft Excel Intermediate Skills
Microsoft Excel Intermediate Skills: Background You'll Need 1
Using Excel for Data Analysis: Learn It 1 - Sorting Data
Using Excel for Data Analysis: Learn It 2 - Filtering Data
Using Excel for Data Analysis: Learn It 3 - Functions
Using Excel for Data Analysis: Apply It 1
Using Excel for Data Analysis: Fresh Take
Automating Data Entry: Learn It 1 - Flash Fill
Automating Data Entry: Learn It 2 - SUM Data
Automating Data Entry: Learn It 3 - Simple Math
Automating Data Entry: Apply It 1
Automating Data Entry: Fresh Take
Charts: Learn It 1 - Charts
Charts: Learn It 2 - Clustered Column Charts
Charts: Learn It 3 - Chart Types
Charts: Learn It 4 - Sparklines
Charts: Apply It 1
Charts: Fresh Take
Get Stronger: Microsoft Excel Intermediate Skills
Cheat Sheet: Microsoft Excel Advanced Skills
Microsoft Excel Advanced Skills: Background You'll Need 1
More Formatting and Layout: Learn It 1 - Conditional Formatting
More Formatting and Layout: Learn It 2 - Viewing a Worksheet
More Formatting and Layout: Apply It 1
More Formatting and Layout: Fresh Take
Pivot Tables: Learn It 1
Pivot Tables: Apply It 1
Pivot Tables: Fresh Take
Macros: Learn It 1 - Macros
Macros: Learn It 2 - Recording a Macro
Macros: Apply It 1
Macros: Fresh Take
Statistical Functions and Formulas: Learn It 1 - What is a Function?
Statistical Functions and Formulas: Learn It 2 - Lookup Functions and Formulas
Statistical Functions and Formulas: Learn It 3 - Logical Functions and Formulas
Statistical Functions and Formulas: Learn It 4 - Financial Functions and Formulas
Statistical Functions and Formulas: Apply It 1
Statistical Functions and Formulas: Fresh Take
Add-Ins: Learn It 1
Add-Ins: Learn It 2 - Internet and Excel
Add-Ins: Apply It 1
Add-Ins: Fresh Take
Get Stronger: Microsoft Excel Advanced Skills
Cheat Sheet: Microsoft PowerPoint Basic Skills
Microsoft PowerPoint Basic Skills: Background You'll Need 1
Using PowerPoint: Learn It 1 - New Presentations
Using PowerPoint: Learn It 2 - Themes
Using PowerPoint: Learn It 3 - Editing a Presentation
Using PowerPoint: Learn It 4 - Organizing Slides
Using PowerPoint: Learn It 5 - Views
Using PowerPoint: Apply It 1
Using PowerPoint: Fresh Take
Objects in PowerPoint: Learn It 1 - Text Boxes
Objects in PowerPoint: Learn It 2 - Headers and Footers
Objects in PowerPoint: Learn It 3 - Images and Clip Art
Objects in PowerPoint: Learn It 4 - SmartArt
Objects in PowerPoint: Apply It 1
Objects in PowerPoint: Fresh Take
Arranging Objects: Learn It 1 - Arranging Objects
Arranging Objects: Learn It 2 - Grouping Objects
Arranging Objects: Apply It 1
Arranging Objects: Fresh Take
Get Stronger: Microsoft PowerPoint Basic Skills
Cheat Sheet: Microsoft PowerPoint Intermediate Skills
Microsoft PowerPoint Intermediate Skills: Background You'll Need
Colors: Learn It 1 - Color Themes
Colors: Learn It 2 - Custom Color Themes
Colors: Apply It 1
Colors: Fresh Take
Lists: Learn It 1 - Creating Lists
Lists: Learn It 2 - Modifying Lists
Videos in PowerPoint: Learn It 1 - Adding Audio in PowerPoint
Videos in PowerPoint: Learn It 2- Inserting Videos in PowerPoint
Videos in PowerPoint: Learn It 3 - Embedding Videos in PowerPoint
Videos in PowerPoint: Learn It 4 - Uploading Videos in PowerPoint
Videos in PowerPoint: Apply It 1
Videos in PowerPoint: Fresh Take
Get Stronger: Microsoft PowerPoint Intermediate Skills
Cheat Sheet: Microsoft PowerPoint Advanced Skills
Microsoft PowerPoint Advanced Skills: Background You'll Need 1
Tables in PowerPoint: Learn It 1 - Create Tables
Tables in PowerPoint: Learn It 2 - Format Tables
Tables in PowerPoint: Learn It 3 - Modify Tables
Tables in PowerPoint: Apply It 1
Tables in PowerPoint: Fresh Take 1
Transition Effects: Learn It 1
Transition Effects: Learn It 2 - Animations in PowerPoint
Transition Effects: Apply It 1
Transition Effects: Fresh Take
Charts in PowerPoint: Learn It 1 - Create Charts
Charts in PowerPoint: Learn It 2 - Format Charts
Charts in PowerPoint: Learn It 3 - Modify Charts
Charts in PowerPoint: Apply It 1
Charts in PowerPoint: Fresh Take 1
Internet and PowerPoint: Learn It 1 - Customized PowerPoint Templates
Internet and PowerPoint: Learn It 2
Internet and PowerPoint: Apply It 1
Internet and PowerPoint: Fresh Take
Get Stronger: Microsoft PowerPoint Advanced Skills
Cheat Sheet: Microsoft Access Basic Skills
Microsoft Access Basic Skills: Background You'll Need 1
Creating Database Tables: Learn It 1 - Creating a Database
Creating Database Tables: Learn It 2 - Naming Databases
Creating Database Tables: Learn It 3 - Creating an Access Table
Creating Database Tables: Apply It 1
Creating Database Tables: Fresh Take 1
Fields in Access: Learn It 1 - Field Properties
Fields in Access: Learn It 2 - Field Names and Data Types
Fields in Access: Apply It 1
Fields in Access: Fresh Take 1
Table Primary Key: Learn It 1 - Primary Key
Table Primary Key: Learn It 2 - Set a Primary Key
Table Primary Key: Apply It 1
Table Primary Key: Fresh Take 1
Indexes: Learn It 1 - What is an Index?
Indexes: Apply It 1
Indexes: Fresh Take 1
Get Stronger: Microsoft Access Basic Skills
Cheat Sheet: Microsoft Access Intermediate Skills
Microsoft Access Intermediate Skills: Background You'll Need 1
Table Relationships: Learn It 1 - Database Principles
Table Relationships: Learn It 2 - Flat File vs Normalized Data
Table Relationships: Learn It 3 - Types of Table Relationships
Table Relationships: Apply It 1
Table Relationships: Fresh Take 1
Working with Tables: Learn It 1 - Datasheets
Working with Tables: Learn It 2 - Entering Data
Working with Tables: Learn It 3 - Changing Values
Working with Tables: Apply It 1
Working with Tables: Fresh Take 1
Working with Datasheets: Learn It 1 - Adding Values and Records in Datasheets
Working with Datasheets: Learn It 2 - Deleting Records in Datasheets
Working with Datasheets: Apply It 1
Working with Datasheets: Fresh Take 1
Sorting and Filtering Data: Learn It 1 - Displaying Records in Datasheets
Sorting and Filtering Data: Learn It 2 - Sorting Data
Sorting and Filtering Data: Learn It 3 - Aggregating Data
Sorting and Filtering Data: Learn It 4 - Printing Records
Sorting and Filtering Data: Apply It 1
Sorting and Filtering Data: Fresh Take 1
Get Stronger: Microsoft Access Intermediate Skills
Cheat Sheet: Microsoft Access Advanced Skills
Microsoft Access Advanced Skills: Background You'll Need 1
Importing and Exporting Data: Learn It 1 - External Data
Importing and Exporting Data: Learn It 2 - Import and Export Options
Importing and Exporting Data: Apply It 1
Importing and Exporting Data: Fresh Take 1
Queries: Learn It 1 - What Are Queries?
Queries: Learn It 2 - Adding Criteria to a Query
Queries: Learn It 3 - Saving Queries
Queries: Apply It 1
Queries: Fresh Take 1
Forms and Reports: Learn It 1 - Understanding Forms
Forms and Reports: Learn It 2 - Creating Basic Forms
Forms and Reports: Learn It 3 - Form Controls and Views
Forms and Reports: Learn It 4 - Presenting Data on Reports
Forms and Reports: Apply It 1
Forms and Reports: Fresh Take 1
Analyzing Data: Learn It 1 - Transforming Data
Analyzing Data: Learn It 2 - Understanding Calculations
Analyzing Data: Learn It 3 - Using Conditional Analysis
Analyzing Data: Learn It 4 - Using Subqueries
Analyzing Data: Learn It 5 - Understanding Domain Aggregation
Analyzing Data: Apply It 1
Analyzing Data: Fresh Take 1
Get Stronger: Microsoft Access Advanced Skills
Cheat Sheet: Integration
Integration: Background You'll Need 1
Using Word with Excel and PowerPoint: Learn It 1 - Customized Word Templates
Using Word with Excel and PowerPoint: Learn It 2 - Excel Table in Word Document
Using Word with Excel and PowerPoint: Learn It 3 - Excel Chart in Word Document
Using Word with Excel and PowerPoint: Learn It 4 - PowerPoint in Word Document
Using Word with Excel and PowerPoint: Apply It 1
Using Word with Excel and PowerPoint: Fresh Take 1
Using PowerPoint with Excel: Learn It 1 - Excel Table in PowerPoint
Using PowerPoint with Excel: Learn It 2 - Excel Chart in PowerPoint
Using PowerPoint with Excel: Apply It 1
Using PowerPoint with Excel: Fresh Take 1
Integrating Access: Learn It 1 - Access and Mail Merge
Integrating Access: Learn It 2 - Excel Table from Access Data
Integrating Access: Learn It 3 - Access Data from Excel Table
Integrating Access: Apply It 1
Integrating Access: Fresh Take 1
Get Stronger: Integration
Capstone Assignment: Download Files
Assignment: Create Capstone Presentation
Module 1 Assignment: Identify Your OS
Module 1 Assignment: Empty the Recycle Bin
Module 1 Discussion: Computers vs. Smartphones
Module 2 Assignment: Search the Internet
Module 2 Discussion: Search Results
Module 2 Discussion: Personal Data and Ethical Business Use
Module 3 Assignment: Personalize Your Outlook.com Inbox
Module 3 Discussion: Notifications
Module 4 Assignment: Create Basic Document
Module 4 Discussion: Paragraph Styles
Module 5 Assignment: Create Document with Tables and Images
Module 5 Discussion: Cover Pages
Module 6 Assignment: Edit a Newsletter
Module 6 Discussion: Advanced Shortcuts
Module 7 Assignment: Organize Sales Data
Module 7 Discussion: Merging and Centering Cells
Module 8 Assignment: Analyze Yearly Trends
Module 8 Discussion: Hard Return within a Cell
Module 9 Assignment: Create Macro for Car Loan Spreadsheet
Module 9 Discussion: Excel Worksheet as a Webpage
Module 10 Assignment: Present Sales Information
Module 10 Discussion: Infographics and Custom Shapes
Module 11 Assignment: Create a New Presentation
Module 11 Discussion: Making a PowerPoint Presentation into a Video
Module 12 Assignment: Modify Existing PowerPoint Presentations
Module 12 Discussion: Ten Extra Tips for PowerPoint
Module 13 Assignment: Create New Access Database
Module 13 Discussion: Selecting Primary Key Tips
Module 14 Assignment: Modify Access Database
Module 14 Discussion: Moving Columns and Fields
Module 15 Assignment: Create Queries for Access Database
Module 15 Discussion: Ways to Manage Access Tables
Module 16 Assignment: Create Mail Merge Letters
Module 16 Discussion: Audio Integration
Capstone Assignment: Create Capstone Presentation
Previous/next navigation