Teaching Resources

This page provides aligned teaching materials for Computer Applications for Managers, including detailed instructor guides and instructional presentation slides. Each resource is built around Lumen’s framework for Evidence-Based Teaching Practices, with the goal of supporting an active, engaged, and connected classroom — while also making your job easier.

JUMP TO: Course Information | Instructor Guides | Slide Decks
Assignments and Discussions | Question Banks for Exams

Lumen provides files in either PDF or Google formats depending on its primary use case. PDFs will either pull up in your browser or download onto your computer. To edit Google files, you will need to make your own copy. If you are signed into your own Google Drive account, click the file link, then click the “File” dropdown menu, and click “Make a copy.” If you do not have a Google account, click the file link, then click the “File” dropdown menu, and select “Download” in your preferred file format.

Course Information

You may want to reference module titles, topic areas, or specific learning outcomes in your syllabus.

Sample Syllabus

This visual syllabus is designed to help you convey openness and connection from the start of class. It includes sample language to describe Lumen One.

Pacing Recommendations

Computer Applications for Managers contains 16 modules—roughly one module per week for a sixteen-week semester—and a final capstone assignment. The modules are grouped in order from most basic skills to more advanced skills; later modules will assume students have already covered previous modules. If you need to modify the pace and cover the material more quickly, the following modules work well together:

  • Module 1: Intro to Computers, Module 2: Internet Research, and Module 3: Cloud Computing
  • Module 4: Microsoft Word Basic Skills and Module 5: Microsoft Word Intermediate Skills
  • Module 7: Microsoft Excel Basic Skills and Module 8: Microsoft Excel Intermediate Skills
  • Module 10: Microsoft PowerPoint Basic Skills and Module 11: Microsoft PowerPoint Intermediate Skills
  • Module 13: Microsoft Access Basic Skills and Module 14: Microsoft Access Intermediate Skills

We recommend NOT doubling up any of the Advanced Skills modules or the Integration module, because they are long and especially challenging. Students will need more time for mastery and completion of assignments.

Additionally, the course can be scaled to your students’ knowledge: if your students have already mastered basic skills, the basic modules can be omitted. If your students aren’t ready for advanced skills, the advanced modules can be omitted.

This course is aimed at beginning to intermediate computer users. It teaches a range of computer skills from the basics of using Windows, to basic internet literacy, to creating projects using Microsoft Office. Assignments show step-by-step visuals to help students complete projects, and include integration across Microsoft Word, Excel, PowerPoint, and Access.

[return to top]

Instructor Guides

Instructor Guides are provided for each module to support active learning, conceptual investigation, and collaboration. Each guide includes an overview of the module content, a summary of what students encounter in key sections, and a list of learning outcomes. You’ll also find engaging classroom activities with accompanying materials such as handouts and worksheets. Activities come with a suggested instructional plan, alignment to evidence-based teaching practices, discussion prompts, and an online variation that can be integrated into your LMS for hybrid or asynchronous classes.

Module 1: Computer Basics
Module 2: Internet Research
Module 3: Cloud Computing
Module 4: Microsoft Word Basic Skills
Module 5: Microsoft Word Intermediate Skills
Module 6: Microsoft Word Advanced Skills
Module 7: Microsoft Excel Basic Skills
Module 8: Microsoft Excel Intermediate Skills
Module 9: Microsoft Excel Advanced Skills
Module 10: Microsoft PowerPoint Basic Skills
Module 11: Microsoft PowerPoint Intermediate Skills
Module 12: Microsoft PowerPoint Advanced Skills
Module 13: Microsoft Access Basic Skills
Module 14: Microsoft Access Intermediate Skills
Module 15: Microsoft Access Advanced Skills
Module 16: Integration of Microsoft Office Products

[return to top]

Presentation Slide Decks

Google Slides are available for each module to help you introduce and reinforce key concepts in class. Each deck of slides aligns with learning outcomes, providing concise explanations, visuals, video, and opportunities for active engagement. They’re designed to complement the Instructor Guides, offering a flexible framework you can adapt for lectures, discussions, or group activities.

Some slides contain notes or links to our Instructor Guides. If you share slide decks with your students but wish to leave out the notes or links, downloading a PDF version will result in a file that contains all the slides without the speaker notes.

Module 1 Slides: Computer Basics
Module 2 Slides: Internet Research
Module 3 Slides: Cloud Computing
Module 4 Slides: Microsoft Word Basic Skills
Module 5 Slides: Microsoft Word Intermediate Skills
Module 6 Slides: Microsoft Word Advanced Skills
Module 7 Slides: Microsoft Excel Basic Skills
Module 8 Slides: Microsoft Excel Intermediate Skills
Module 9 Slides: Microsoft Excel Advanced Skills
Module 10 Slides: Microsoft PowerPoint Basic Skills
Module 11 Slides: Microsoft PowerPoint Intermediate Skills
Module 12 Slides: Microsoft PowerPoint Advanced Skills
Module 13 Slides: Microsoft Access Basic Skills
Module 14 Slides: Microsoft Access Intermediate Skills
Module 15 Slides: Microsoft Access Advanced Skills
Module 16 Slides: Integration of Microsoft Office Products

Question Banks for Midterms and Finals

Lumen One provides access to outcome-aligned question banks that you can use to build your own exams. We provide these banks as QTI files, a standard format that allows you to import questions, build, and customize quizzes in most learning management systems. These files cannot be opened outside of an LMS. 

IMPORTANT NOTE: It is your responsibility to handle question banks and answer keys securely and appropriately to prevent them from being widely available.

How to Import

You must download the question bank specific to your LMS, open the file on your computer, and follow LMS-specific instructions for importing each module.

Please use the import instructions in our Lumen One knowledge-base for Blackboard, Brightspace, Canvas, and Moodle.

Available Question Banks

The question banks include at least 4 questions for every learning outcome throughout the entire course.

IMPORTANT NOTE: After downloading the QTI Zip file, you must open the main file folder in order to import the individual module files. You cannot import the main file folder.

[return to top]

Assignments and Discussions

The assignments for Computer Apps for Managers build on one another and culminate in the submission of a finished project.

You can view them below or throughout the course on the Apply It pages.

Assignments and Alignment
Assignment Module
Assignment: Download Files Module 1: Introduction to Computers
Assignment: Identify Your OS* Module 1: Introduction to Computers
Assignment: Empty the Recycle Bin* Module 1: Introduction to Computers
Assignment: Folder Organization Module 1: Introduction to Computers
Assignment: Search the Internet Module 2: Internet Research
Assignment: Ethics Audit Module 2: Internet Research
Assignment: Personalize Your Outlook.com Inbox Module 3: Cloud Computing
Assignment: Create a Basic Document Module 4: Microsoft Word Basic Skills
Assignment: Create Document with Tables and Images Module 5: Microsoft Word Intermediate Skills
Assignment: Community Guide Module 5: Microsoft Word Intermediate Skills
Assignment: Campus Improvement Proposal  Module 5: Microsoft Word Intermediate Skills
Assignment: Edit a Newsletter Module 6: Microsoft Word Advanced Skills
Assignment: Small Business Launch Kit Module 6: Microsoft Word Advanced Skills
Assignment: Organize Sales Data Module 7: Microsoft Excel Basic Skills
Assignment: Analyze Yearly Trends Module 8: Microsoft Excel Intermediate Skills
Assignment: Create Macro for Car Loan Spreadsheet Module 9: Microsoft Excel Advanced Skills
Assignment: Present Sales Information Module 10: Microsoft PowerPoint Basic Skills
Assignment: Community Business Spotlight Module 10: Microsoft PowerPoint Basic Skills
Assignment: Create a New Presentation Module 11: Microsoft PowerPoint Intermediate Skills
Assignment: Dream Vacation Module 11: Microsoft PowerPoint Intermediate Skills
Assignment: Modify Existing PowerPoint Presentations Module 12: Microsoft PowerPoint Advanced Skills
Assignment: Create New Access Database Module 13: Microsoft Access Basic Skills
Assignment: Modify Access Database Module 14: Microsoft Access Intermediate Skills
Assignment: Create Queries for Access Database Module 15: Microsoft Access Advanced Skills
Assignment: Library Database Module 15: Microsoft Access Advanced Skills
Assignment: Create Mail Merge Letters Module 16: Integration
Assignment: Create an Industry Analysis (Word, PowerPoint, and Excel Only)* Module 16: Integration (Word, PowerPoint, and Excel Only)
Assignment: Create Capstone Presentation Capstone Assignment
Assignment: Create Capstone Presentation (Word, PowerPoint, and Excel Only) Capstone Assignment (Word, PowerPoint, and Excel Only)
 Please note: These assignments are not imported into your LMS, but the linked Google Doc can be copied if you would like to use a version of the assignment that includes Word, PowerPoint, and Excel only (No Access). To make a copy, click File > Make a Copy

Assignment Rubric

Most assignments have individual rubrics, but below is a suggested generalized rubric for grading assignments.

Technical Rubric for Assignments
Criteria Ratings Points
Assignment
Submission
Submitted on time Submitted late with permission Submitted late at instructor discretion No submission
 5.0 pts  4.0 pts 3.0 pts  0.0 pts 5.0 pts
Proper File
Construction
Submitted with specified file structure and naming convention Submitted with specific file structure but without proper naming convention Submitted with readable but non-specified file formate and/or lacking proper file name No submission
5.0 pts  4.0 pts  3.0 pts  0.0 pts 5.0 pts
Technical
Specifications
Submission contains and is developed using all specified elements and parameters such as formats, constructs, fonts, margins, and formulas Submission contains most of the specified elements but contains some forced or hard coded areas that should be constructed with parameters Submission has some limited use of the specified elements but is primarily constructed with author created elements No submission or the submission is missing the specified elements and appears to be a rushed submission to meet the deadline
10.0 pts  8.0 pts  6.0 pts  0.0 pts 10.0 pts
Presentation
Quality
Submission matches the example provided or described or matches using the student supplied parameter changes that were made to the assignment Submission matches the overall example but has changes in the various elements that are not specified by the student at the time of submission Submission is clearly different from the example and does not contain either the overall context/content or an explanation for the difference No submission or the submission lacks any connection or recognition to the example provided
5.0 pts 4.0 pts 3.0 pts 0.0 pts 5.0 pts
Total:      25.0 pts

Discussions

The following discussion assignments are also available to add to your LMS. They can be used as is, modified, or removed. You can view them below or within each instructor guide.

Discussions and Alignment
Discussion Module
Discussion: Computers vs. Smartphones Module 1: Introduction to Computers
Discussion: Search Results Module 2: Internet Research
Discussion: Personal Data and Ethical Business Use Module 2: Internet Research
Discussion: Notifications Module 3: Cloud Computing
Discussion: Paragraph Styles Module 4: Microsoft Word Basic Skills
Discussion: Cover Pages Module 5: Microsoft Word Intermediate Skills
Discussion: Advanced Shortcuts Module 6: Microsoft Word Advanced Skills
Discussion: Merging and Centering Cells Module 7: Microsoft Excel Basic Skills
Discussion: Hard Return within a Cell Module 8: Microsoft Excel Intermediate Skills
Discussion: Excel Worksheet as a Webpage Module 9: Microsoft Excel Advanced Skills
Discussion: Infographics and Custom Shapes Module 10: Microsoft PowerPoint Basic Skills
Discussion: Making a PowerPoint Presentation into a Video Module 11: Microsoft PowerPoint Intermediate Skills
Discussion: Ten Extra Tips for PowerPoint Module 12: Microsoft PowerPoint Advanced Skills
Discussion: Selecting Primary Key Tips Module 13: Microsoft Access Basic Skills
Discussion: Moving Columns and Fields Module 14: Microsoft Access Intermediate Skills
Discussion: Ways to Manage Access Tables Module 15: Microsoft Access Advanced Skills
Discussion: Audio Integration Module 16: Integration