Skip to content

Computer Applications for Managers

Book Contents Navigation

Book Contents
  1. Faculty Resources
    1. Teaching Resources

    2. Technical Resources

    3. Evidence-Based Teaching Practices

  2. Course Resources
    1. Students: How to Use Lumen Course Materials

    2. Students: Additional Lumen Resources

  3. Module 1: Introduction to Computers
    1. Cheat Sheet: Introduction to Computers

    2. Introduction to Computers: Background You’ll Need 1

    3. Introduction to Computers: Background You’ll Need 2

    4. Introduction to Computers: Background You Need 3

    5. Computer Concepts: Learn It 1 - Hardware

    6. Computer Concepts: Learn It 2 - Software

    7. Computer Concepts: Learn It 3 - Software Cont.

    8. Computer Concepts: Learn It 4 - Security

    9. Computer Concepts: Learn It 5 - Privacy

    10. Computer Concepts: Apply It 1

    11. Computer Concepts: Fresh Take

    12. Operating Systems: Learn It 1 - Identifying Your Operating System (OS)

    13. Operating Systems: Apply It 1

    14. Operating Systems: Fresh Take

    15. Navigate Programs: Learn It 1 - Managing Windows

    16. Navigate Programs: Learn It 2 - Keyboard Shortcuts

    17. Navigate Programs: Apply It 1

    18. Navigate Programs: Fresh Take

    19. Finding Programs and Files: Learn It 1 - Start Menu

    20. Finding Programs and Files: Learn It 2 - Creating Files and Folders

    21. Finding Programs and Files: Learn It 3 - Organizing Files and Folders

    22. Finding Programs and Files: Learn It 4 - Deleting Files and Folders

    23. Finding Programs and Files: Apply It 1

    24. Finding Programs and Files: Fresh Take

    25. File Management: Learn It 1 - Local Files

    26. File Management: Learn It 2 - Network Files

    27. File Management: Learn It 3 - Online Files

    28. File Management: Apply It 1

    29. File Management: Fresh Take

    30. Get Stronger: Introduction to Computers

  4. Module 2: Internet Research
    1. Cheat Sheet: Internet Research

    2. Internet Research: Background You’ll Need 1

    3. Internet Research: Background You’ll Need 2

    4. Using and Searching the Internet: Learn It 1 - Internet Browsers

    5. Using and Searching the Internet: Learn It 2 - Basic Browser Tools

    6. Using and Searching the Internet: Apply It 1

    7. Using and Searching the Internet: Fresh Take

    8. Ethical Business Research: Learn It 1 - Ethical Research

    9. Ethical Business Research: Learn It 2 - Data and Customer Rights

    10. Ethical Business Research: Apply It 1

    11. Ethical Business Research: Fresh Take

    12. Basic Searches: Learn It 1 - Web Searching

    13. Basic Searches: Learn It 2 - Identifying Search Results

    14. Basic Searches: Learn It 3 - Opening Search Results

    15. Basic Searches: Apply It 1

    16. Basic Searches: Fresh Take

    17. Advanced Searches: Learn It 1 - Adjusting Search Parameters

    18. Advanced Searches: Learn It 2 - Image Searches

    19. Advanced Searches: Apply It 1

    20. Advanced Searches: Fresh Take

    21. Get Stronger: Internet Research

  5. Module 3: Cloud Computing
    1. Cheat Sheet: Cloud Computing

    2. Cloud Computing: Background You’ll Need 1

    3. Cloud Computing: Background You’ll Need 2

    4. Email Etiquette and Security: Learn It 1 - Email Etiquette

    5. Email Etiquette and Security: Learn It 2 - Security Threats in Email

    6. Email Etiquette and Security: Apply It 1

    7. Email Etiquette and Security: Fresh Take

    8. Email Tools: Learn It 1 - Sending and Receiving Emails and Attachments

    9. Email Tools: Learn It 2 - Organizing and Searching Email

    10. Email Tools: Apply It 1

    11. Email Tools: Fresh Take

    12. Automate Email: Learn It 1 - Signatures and Auto Reply

    13. Automating Email: Learn It 2- Email Rules

    14. Automate Email: Apply It

    15. Automate Email: Fresh Take

    16. Calendar Tools: Learn It 1 - Creating Appointments and Meetings

    17. Calendar Tools: Learn It 2 -Scheduling Assistant and Room Finder

    18. Calendar Tools: Learn It 3 - Shared Calendars

    19. Calendar Tools: Apply It 1

    20. Calendar Tools: Fresh Take

    21. Instant Messaging and Video Conferencing: Learn It 1 - Instant Messaging and Video Conference Applications

    22. Instant Messaging and Video Conferencing: Learn It 2 - Choosing a Communication Tool

    23. Instant Messaging and Video Conferencing: Apply It 1

    24. Instant Messaging and Video Conferencing: Fresh Take

    25. Cloud Storage Tools: Learn It 1 - Using OneNote

    26. Cloud Storage Tools: Learn It 2 - Using OneDrive

    27. Cloud Storage Tools: Apply It 1

    28. Cloud Storage Tools: Fresh Take

    29. Get Stronger: Cloud Computing

  6. Module 4: Microsoft Word Basic Skills
    1. Cheat Sheet: Microsoft Word Basic Skills

    2. Microsoft Word Basic Skills: Background You Need 1

    3. Microsoft Word Basic Skills: Background You Need 2

    4. Using Word: Learn It 1

    5. Using Word: Learn It 2

    6. Using Word: Learn It 3

    7. Using Word: Learn It 4

    8. Using Word: Apply It 1

    9. Using Word: Fresh Take

    10. Basic Text Formatting: Learn It 1

    11. Basic Text Formatting: Learn It 2

    12. Basic Text Formatting: Learn It 3

    13. Basic Text Formatting: Learn It 4

    14. Basic Text Formatting: Learn It 5

    15. Basic Text Formatting: Learn It 6

    16. Basic Text Formatting: Apply It 1

    17. Basic Text Formatting: Apply It 2

    18. Basic Text Formatting: Fresh Take

    19. Workplace Tools: Learn It 1 - Spell Check and Dictionaries

    20. Workplace Tools: Learn It 2 - Find and Replace

    21. Workplace Tools: Learn It 3

    22. Workplace Tools: Learn It 4

    23. Workspace Tools: Apply It 1

    24. Workspace Tools: Fresh Take

    25. Lists: Learn It 1

    26. Lists: Apply It 1

    27. Lists: Fresh Take

    28. Get Stronger: Microsoft Word Basic Skills

  7. Module 5: Microsoft Word Intermediate Skills
    1. Cheat Sheet: Microsoft Word Intermediate Skills

    2. Microsoft Word Intermediate Skills: Background You'll Need 1

    3. Microsoft Word Intermediate Skills: Background You'll Need 2

    4. Page Layout: Learn It 1 - Tab Stops

    5. Page Layout: Learn It 2 - Columns

    6. Page Layout: Learn It 3 - Headers and Footers

    7. Page Layout: Apply It 1

    8. Page Layout: Fresh Take

    9. Text Boxes: Learn It 1

    10. Text Boxes: Learn It 2

    11. Text Boxes: Apply It 1

    12. Text Boxes: Fresh Take

    13. Tables: Learn It 1 - Creating Tables

    14. Tables: Learn It 2 - Converting Text to a Table

    15. Tables: Learn It 3 - Formatting Tables

    16. Tables: Apply It 1

    17. Tables: Fresh Take

    18. Images: Learn It 1 - Adding Images

    19. Images: Learn It 2 - Text Wrap

    20. Images: Apply It 1

    21. Images: Fresh Take

    22. Graphics: Learn It 1 - Graphics

    23. Graphics: Learn It 2 - Modify Graphics

    24. Graphics: Learn It 3 - Format Graphics

    25. Graphics: Apply It 1

    26. Graphics: Fresh Take 1

    27. Hyperlinks: Learn It 1 - Hyperlinks

    28. Hyperlinks: Apply It 1

    29. Hyperlinks: Fresh Take 1

    30. Get Stronger: Microsoft Word Intermediate Skills

  8. Module 6: Microsoft Word Advanced Skills
    1. Cheat Sheet: Microsoft Word Advanced Skills

    2. Microsoft Word Advanced Skills: Background You'll Need 1

    3. Advanced File Creation and Text Formatting: Learn It 1 - Creating a New Document from a Template

    4. Advanced File Creation and Text Formatting: Learn It 2 - Text Effects

    5. Advanced File Creation and Text Formatting: Apply It 1

    6. Advanced File Creation and Text Formatting: Fresh Take

    7. Watermarks and Icons: Learn It 1 - Watermarks

    8. Watermarks and Icons: Learn It 2 - Icons in Word

    9. Watermarks and Icons: Apply It 1

    10. Watermarks and Icons: Fresh Take

    11. Citations: Learn It 1 - Citations

    12. Citations Learn It 2

    13. Citations: Apply It 1

    14. Citations: Fresh Take

    15. Mail Merge: Learn It 1 - Mail Merge

    16. Mail Merge: Apply It 1

    17. Mail Merge: Fresh Take

    18. Internet and Word: Learn It 1 - Internet and Word

    19. Internet and Word: Apply It 1

    20. Internet and Word: Fresh Take

    21. Get Stronger: Microsoft Word Advanced Skills

  9. Module 7: Microsoft Excel Basic Skills
    1. Cheat Sheet: Microsoft Excel Basic Skills

    2. Microsoft Excel Basic Skills: Background You'll Need 1

    3. Using Excel: Learn It 1 - Creating a New Workbook

    4. Using Excel: Learn It 2 - Creating a Workbook with Multiple Worksheets

    5. Using Excel: Learn It 3 - Entering Data

    6. Using Excel: Learn It 4 - Rearranging Tables

    7. Using Excel: Learn It 5 - Changing Width of Columns and Rows

    8. Using Excel: Apply It 1

    9. Using Excel: Fresh Take

    10. Basic Formatting and Layout: Learn It 1 - Table Styles

    11. Basic Formatting and Layout: Learn It 2 - Cell Styles

    12. Basic Formatting and Layout: Learn It 3 - Cell Format

    13. Basic Formatting and Layout: Learn It 4 - Comma Styles

    14. Basic Formatting and Layout: Apply It 1

    15. Basic Formatting and Layout: Fresh Take

    16. Get Stronger: Microsoft Excel Basic Skills

  10. Module 8: Microsoft Excel Intermediate Skills
    1. Cheat Sheet: Microsoft Excel Intermediate Skills

    2. Microsoft Excel Intermediate Skills: Background You'll Need 1

    3. Using Excel for Data Analysis: Learn It 1 - Sorting Data

    4. Using Excel for Data Analysis: Learn It 2 - Filtering Data

    5. Using Excel for Data Analysis: Learn It 3 - Functions

    6. Using Excel for Data Analysis: Apply It 1

    7. Using Excel for Data Analysis: Fresh Take

    8. Automating Data Entry: Learn It 1 - Flash Fill

    9. Automating Data Entry: Learn It 2 - SUM Data

    10. Automating Data Entry: Learn It 3 - Simple Math

    11. Automating Data Entry: Apply It 1

    12. Automating Data Entry: Fresh Take

    13. Charts: Learn It 1 - Charts

    14. Charts: Learn It 2 - Clustered Column Charts

    15. Charts: Learn It 3 - Chart Types

    16. Charts: Learn It 4 - Sparklines

    17. Charts: Apply It 1

    18. Charts: Fresh Take

    19. Get Stronger: Microsoft Excel Intermediate Skills

  11. Module 9: Microsoft Excel Advanced Skills
    1. Cheat Sheet: Microsoft Excel Advanced Skills

    2. Microsoft Excel Advanced Skills: Background You'll Need 1

    3. More Formatting and Layout: Learn It 1 - Conditional Formatting

    4. More Formatting and Layout: Learn It 2 - Viewing a Worksheet

    5. More Formatting and Layout: Apply It 1

    6. More Formatting and Layout: Fresh Take

    7. Pivot Tables: Learn It 1

    8. Pivot Tables: Apply It 1

    9. Pivot Tables: Fresh Take

    10. Macros: Learn It 1 - Macros

    11. Macros: Learn It 2 - Recording a Macro

    12. Macros: Apply It 1

    13. Macros: Fresh Take

    14. Statistical Functions and Formulas: Learn It 1 - What is a Function?

    15. Statistical Functions and Formulas: Learn It 2 - Lookup Functions and Formulas

    16. Statistical Functions and Formulas: Learn It 3 - Logical Functions and Formulas

    17. Statistical Functions and Formulas: Learn It 4 - Financial Functions and Formulas

    18. Statistical Functions and Formulas: Apply It 1

    19. Statistical Functions and Formulas: Fresh Take

    20. Add-Ins: Learn It 1

    21. Add-Ins: Learn It 2 - Internet and Excel

    22. Add-Ins: Apply It 1

    23. Add-Ins: Fresh Take

    24. Get Stronger: Microsoft Excel Advanced Skills

  12. Module 10: Microsoft PowerPoint Basic Skills
    1. Cheat Sheet: Microsoft PowerPoint Basic Skills

    2. Microsoft PowerPoint Basic Skills: Background You'll Need 1

    3. Using PowerPoint: Learn It 1 - New Presentations

    4. Using PowerPoint: Learn It 2 - Themes

    5. Using PowerPoint: Learn It 3 - Editing a Presentation

    6. Using PowerPoint: Learn It 4 - Organizing Slides

    7. Using PowerPoint: Learn It 5 - Views

    8. Using PowerPoint: Apply It 1

    9. Using PowerPoint: Fresh Take

    10. Objects in PowerPoint: Learn It 1 - Text Boxes

    11. Objects in PowerPoint: Learn It 2 - Headers and Footers

    12. Objects in PowerPoint: Learn It 3 - Images and Clip Art

    13. Objects in PowerPoint: Learn It 4 - SmartArt

    14. Objects in PowerPoint: Apply It 1

    15. Objects in PowerPoint: Fresh Take

    16. Arranging Objects: Learn It 1 - Arranging Objects

    17. Arranging Objects: Learn It 2 - Grouping Objects

    18. Arranging Objects: Apply It 1

    19. Arranging Objects: Fresh Take

    20. Get Stronger: Microsoft PowerPoint Basic Skills

  13. Module 11: Microsoft PowerPoint Intermediate Skills
    1. Cheat Sheet: Microsoft PowerPoint Intermediate Skills

    2. Microsoft PowerPoint Intermediate Skills: Background You'll Need

    3. Colors: Learn It 1 - Color Themes

    4. Colors: Learn It 2 - Custom Color Themes

    5. Colors: Apply It 1

    6. Colors: Fresh Take

    7. Lists: Learn It 1 - Creating Lists

    8. Lists: Learn It 2 - Modifying Lists

    9. Lists: Apply It 1

    10. Lists: Fresh Take

    11. Videos in PowerPoint: Learn It 1 - Adding Audio in PowerPoint

    12. Videos in PowerPoint: Learn It 2- Inserting Videos in PowerPoint

    13. Videos in PowerPoint: Learn It 3 - Embedding Videos in PowerPoint

    14. Videos in PowerPoint: Learn It 4 - Uploading Videos in PowerPoint

    15. Videos in PowerPoint: Apply It 1

    16. Videos in PowerPoint: Fresh Take

    17. Get Stronger: Microsoft PowerPoint Intermediate Skills

  14. Module 12: Microsoft PowerPoint Advanced Skills
    1. Cheat Sheet: Microsoft PowerPoint Advanced Skills

    2. Microsoft PowerPoint Advanced Skills: Background You'll Need 1

    3. Tables in PowerPoint: Learn It 1 - Create Tables

    4. Tables in PowerPoint: Learn It 2 - Format Tables

    5. Tables in PowerPoint: Learn It 3 - Modify Tables

    6. Tables in PowerPoint: Apply It 1

    7. Tables in PowerPoint: Fresh Take 1

    8. Transition Effects: Learn It 1

    9. Transition Effects: Learn It 2 - Animations in PowerPoint

    10. Transition Effects: Apply It 1

    11. Transition Effects: Fresh Take

    12. Charts in PowerPoint: Learn It 1 - Create Charts

    13. Charts in PowerPoint: Learn It 2 - Format Charts

    14. Charts in PowerPoint: Learn It 3 - Modify Charts

    15. Charts in PowerPoint: Apply It 1

    16. Charts in PowerPoint: Fresh Take 1

    17. Internet and PowerPoint: Learn It 1 - Customized PowerPoint Templates

    18. Internet and PowerPoint: Learn It 2

    19. Internet and PowerPoint: Apply It 1

    20. Internet and PowerPoint: Fresh Take

    21. Get Stronger: Microsoft PowerPoint Advanced Skills

  15. Module 13: Microsoft Access Basic Skills
    1. Cheat Sheet: Microsoft Access Basic Skills

    2. Microsoft Access Basic Skills: Background You'll Need 1

    3. Creating Database Tables: Learn It 1 - Creating a Database

    4. Creating Database Tables: Learn It 2 - Naming Databases

    5. Creating Database Tables: Learn It 3 - Creating an Access Table

    6. Creating Database Tables: Apply It 1

    7. Creating Database Tables: Fresh Take 1

    8. Fields in Access: Learn It 1 - Field Properties

    9. Fields in Access: Learn It 2 - Field Names and Data Types

    10. Fields in Access: Apply It 1

    11. Fields in Access: Fresh Take 1

    12. Table Primary Key: Learn It 1 - Primary Key

    13. Table Primary Key: Learn It 2 - Set a Primary Key

    14. Table Primary Key: Apply It 1

    15. Table Primary Key: Fresh Take 1

    16. Indexes: Learn It 1 - What is an Index?

    17. Indexes: Apply It 1

    18. Indexes: Fresh Take 1

    19. Get Stronger: Microsoft Access Basic Skills

  16. Module 14: Microsoft Access Intermediate Skills
    1. Cheat Sheet: Microsoft Access Intermediate Skills

    2. Microsoft Access Intermediate Skills: Background You'll Need 1

    3. Table Relationships: Learn It 1 - Database Principles

    4. Table Relationships: Learn It 2 - Flat File vs Normalized Data

    5. Table Relationships: Learn It 3 - Types of Table Relationships

    6. Table Relationships: Apply It 1

    7. Table Relationships: Fresh Take 1

    8. Working with Tables: Learn It 1 - Datasheets

    9. Working with Tables: Learn It 2 - Entering Data

    10. Working with Tables: Learn It 3 - Changing Values

    11. Working with Tables: Apply It 1

    12. Working with Tables: Fresh Take 1

    13. Working with Datasheets: Learn It 1 - Adding Values and Records in Datasheets

    14. Working with Datasheets: Learn It 2 - Deleting Records in Datasheets

    15. Working with Datasheets: Apply It 1

    16. Working with Datasheets: Fresh Take 1

    17. Sorting and Filtering Data: Learn It 1 - Displaying Records in Datasheets

    18. Sorting and Filtering Data: Learn It 2 - Sorting Data

    19. Sorting and Filtering Data: Learn It 3 - Aggregating Data

    20. Sorting and Filtering Data: Learn It 4 - Printing Records

    21. Sorting and Filtering Data: Apply It 1

    22. Sorting and Filtering Data: Fresh Take 1

    23. Get Stronger: Microsoft Access Intermediate Skills

  17. Module 15: Microsoft Access Advanced Skills
    1. Cheat Sheet: Microsoft Access Advanced Skills

    2. Microsoft Access Advanced Skills: Background You'll Need 1

    3. Importing and Exporting Data: Learn It 1 - External Data

    4. Importing and Exporting Data: Learn It 2 - Import and Export Options

    5. Importing and Exporting Data: Apply It 1

    6. Importing and Exporting Data: Fresh Take 1

    7. Queries: Learn It 1 - What Are Queries?

    8. Queries: Learn It 2 - Adding Criteria to a Query

    9. Queries: Learn It 3 - Saving Queries

    10. Queries: Apply It 1

    11. Queries: Fresh Take 1

    12. Forms and Reports: Learn It 1 - Understanding Forms

    13. Forms and Reports: Learn It 2 - Creating Basic Forms

    14. Forms and Reports: Learn It 3 - Form Controls and Views

    15. Forms and Reports: Learn It 4 - Presenting Data on Reports

    16. Forms and Reports: Apply It 1

    17. Forms and Reports: Fresh Take 1

    18. Analyzing Data: Learn It 1 - Transforming Data

    19. Analyzing Data: Learn It 2 - Understanding Calculations

    20. Analyzing Data: Learn It 3 - Using Conditional Analysis

    21. Analyzing Data: Learn It 4 - Using Subqueries

    22. Analyzing Data: Learn It 5 - Understanding Domain Aggregation

    23. Analyzing Data: Apply It 1

    24. Analyzing Data: Fresh Take 1

    25. Get Stronger: Microsoft Access Advanced Skills

  18. Module 16: Integration
    1. Cheat Sheet: Integration

    2. Integration: Background You'll Need 1

    3. Using Word with Excel and PowerPoint: Learn It 1 - Customized Word Templates

    4. Using Word with Excel and PowerPoint: Learn It 2 - Excel Table in Word Document

    5. Using Word with Excel and PowerPoint: Learn It 3 - Excel Chart in Word Document

    6. Using Word with Excel and PowerPoint: Learn It 4 - PowerPoint in Word Document

    7. Using Word with Excel and PowerPoint: Apply It 1

    8. Using Word with Excel and PowerPoint: Fresh Take 1

    9. Using PowerPoint with Excel: Learn It 1 - Excel Table in PowerPoint

    10. Using PowerPoint with Excel: Learn It 2 - Excel Chart in PowerPoint

    11. Using PowerPoint with Excel: Apply It 1

    12. Using PowerPoint with Excel: Fresh Take 1

    13. Integrating Access: Learn It 1 - Access and Mail Merge

    14. Integrating Access: Learn It 2 - Excel Table from Access Data

    15. Integrating Access: Learn It 3 - Access Data from Excel Table

    16. Integrating Access: Apply It 1

    17. Integrating Access: Fresh Take 1

    18. Get Stronger: Integration

  19. Resources: Discussions and Assignments
    1. Capstone Assignment: Download Files

    2. Assignment: Create Capstone Presentation

    3. Module 1 Assignment: Identify Your OS

    4. Module 1 Assignment: Empty the Recycle Bin

    5. Module 1 Discussion: Computers vs. Smartphones

    6. Module 2 Assignment: Search the Internet

    7. Module 2 Discussion: Search Results

    8. Module 2 Discussion: Personal Data and Ethical Business Use

    9. Module 3 Assignment: Personalize Your Outlook.com Inbox

    10. Module 3 Discussion: Notifications

    11. Module 4 Assignment: Create Basic Document

    12. Module 4 Discussion: Paragraph Styles

    13. Module 5 Assignment: Create Document with Tables and Images

    14. Module 5 Discussion: Cover Pages

    15. Module 6 Assignment: Edit a Newsletter

    16. Module 6 Discussion: Advanced Shortcuts

    17. Module 7 Assignment: Organize Sales Data

    18. Module 7 Discussion: Merging and Centering Cells

    19. Module 8 Assignment: Analyze Yearly Trends

    20. Module 8 Discussion: Hard Return within a Cell

    21. Module 9 Assignment: Create Macro for Car Loan Spreadsheet

    22. Module 9 Discussion: Excel Worksheet as a Webpage

    23. Module 10 Assignment: Present Sales Information

    24. Module 10 Discussion: Infographics and Custom Shapes

    25. Module 11 Assignment: Create a New Presentation

    26. Module 11 Discussion: Making a PowerPoint Presentation into a Video

    27. Module 12 Assignment: Modify Existing PowerPoint Presentations

    28. Module 12 Discussion: Ten Extra Tips for PowerPoint

    29. Module 13 Assignment: Create New Access Database

    30. Module 13 Discussion: Selecting Primary Key Tips

    31. Module 14 Assignment: Modify Access Database

    32. Module 14 Discussion: Moving Columns and Fields

    33. Module 15 Assignment: Create Queries for Access Database

    34. Module 15 Discussion: Ways to Manage Access Tables

    35. Module 16 Assignment: Create Mail Merge Letters

    36. Module 16 Discussion: Audio Integration

    37. Capstone Assignment: Create Capstone Presentation

Email Etiquette and Security: Fresh Take

  • Identify good email etiquette
  • Identify security threats in emails

Email Etiquette

You can view the transcript for “Email Etiquette Tips – How to Write Better Emails at Work” here (opens in new window).

Email Security

You can view the transcript for “Email security” here (opens in new window).

Previous/next navigation

Previous: Email Etiquette and Security: Apply It 1
Next: Email Tools: Learn It 1 – Sending and Receiving Emails and Attachments