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

Text Boxes: Fresh Take

  • Create and modify text boxes

Inserting Textboxes

You can view the transcript for “How to Insert Text Boxes in Microsoft Word” here (opens in new window).

Shapes

You can view the transcript for “How to Insert Shapes into Word Document” here (opens in new window).

Previous/next navigation

Previous: Text Boxes: Apply It 1
Next: Tables: Learn It 1 – Creating Tables