This page includes aligned teaching resources for Computer Applications for Managers, including detailed instructor guides and instructional PowerPoints. Each resource has been designed with Lumen’s framework for Evidence-Based Teaching Practices in mind with a goal to support an active, engaged and connected classroom.
JUMP TO: Visual Syllabus | Instructor Guides + PPTs | Assignments and Discussions | Question Banks for Exams
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.
Visual Syllabus
This visual syllabus is designed to help you convey warmth and connection from the start of class. It includes sample language to describe Lumen One.
Download a Sample Visual Syllabus – for digital use
Download a Sample Visual Syllabus – for printing
Customizing the Syllabus
To customize the visual syllabus with your own photo or avatar, make a copy of the Google doc to edit for yourself. Click on the photo and then click “Edit” to open the editor. Click on the photo and then click “Replace image” on the menu bar. If you do not see the “Replace image” button, follow this video tutorial to replace the image. Ensure that your new image is centered within the editor. You will see horizontal and vertical lines appear to help you center the image.
To change the pie chart that displays your grading scheme, make a copy of this Google sheet, edit it to reflect your percentages and graded items, copy the new pie chart from the sheet, and replace it on the syllabus. Once you have pasted your new pie chart onto your syllabus, click on the pie chart and set the formatting option to “wrap text” and for the image to “Move with text” so that you can position it to your liking.
You can view the course topic list and a full list of the course learning outcomes below:
Topic List for Computer Applications for Managers
Computer Applications for Managers: Detailed Learning Outcomes
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.
Instructor Guides and Presentation Slides
Each instructor guide contains at least three activities for classroom use. All activities are accompanied by an online variation that may be copied to your LMS, suitable as written, graded work for hybrid or asynchronous classes.
To make a copy in your own Google Drive, click the link, and sign in to your own Google account. Then click “File” to access the drop down menu and click “Make a copy.” If you do not have a Google account, click the link, click “File”, then click “Download” in your preferred format.
Video List
Instructor Guides
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
Presentation Slides
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
Question Banks for Midterms and Finals
Lumen One provides access to outcome-aligned question banks that you can use to build your own midterms and finals. 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 (Canvas, Blackboard, etc.). These files cannot be opened outside of an LMS.
Note: It is your responsibility to handle question banks and answer keys securely and appropriately to prevent them from being widely available and searchable via the Internet.
Available Question Banks
The question banks include questions for every learning outcome throughout the entire course.
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.
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.
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.
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: Search the Internet | 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: Edit a Newsletter | 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: Create a New Presentation | 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: 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.
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 |
Course Improvements
We believe in making continuous improvements to our courses in order to enhance and facilitate student learning. This newest version of the course includes data-driven improvements to assessment questions and text content in order to better illustrate, clarify, and evaluate concepts.
This new Lumen One version of Computer Applications for Managers includes improvements and enhancements from the Waymaker version including:
- New content on cloud storage, instant messaging, and video conference tools.
- New projects and activities that can be accessed from the instructor guides.
- More scaffolded assignments built into the Apply It pages.
- All assignments and discussions now in Google Docs.