Computer Applications for Business
Required Texts
Shelly
Cashman Series Collection, Microsoft® Office 365 & Office 2019
by Sandra
Cable, Steven M. Freund, Ellen Monk, Susan L. Sebok, Joy L. Starks, Misty E.
Vermaat
ISBN: 9780357026229
Office 365
This course requires the use of Microsoft Office. As a Grantham University student, you have access to the cloud based Office365 product. You may also use Office 2016 or newer for the assignments if you already have that product. If you are using an older version of MS Office, be aware some assignments may require functionality not available in those versions. This may impact your grade for a given assignment. If you are unsure what version you have, or prefer to use an older version of MS Office, please discuss this with your instructor.
Using MindTap
This course uses MindTap resources. The readings, trainings, exams will open in MindTap.
Pop-up Blockers:
MindTap resources will open in a pop-up window. If a window does not open, you will need to verify that your browser is not set to block pop-up windows. This will vary by browser. For instructions on how to enable pop-up windows select your browser and follow the provided instructions:
MindTap Assignments:
Once you have completed an assignment in MindTap you must select the SUBMIT button. If the submit button is not selected it may not transfer to the blackboard gradebook and the instructor may only see that the assignment is ‘in progress’, even if you have completed it. They will also not be able to view any work you have performed while it is in that status. In other words, the assignment will not be graded until you submit it.
Course Description
This course explores applications within the Microsoft Office Suite with an emphasis on the tools needed in a business context. While covering Word, Excel, and PowerPoint, focus is placed on the use of Excel for analyzing and presenting data. Techniques for the creation of professional documents are addressed.
Course Objectives
Upon completion of the course, students should be able to:
·
Create
written documents with tables, pictures, headers, and various formatting styles
in Microsoft Word
·
Create
spreadsheet workbooks in Microsoft Excel
·
Use
functions, formulas, charts, and what-if analysis to analyze and present
information
·
Create
professional graphic presentations with transitions, pictures, shapes, and
lists in Microsoft PowerPoint
Credit Hours: 3
Prerequisites: None
Tentative Course Schedule
|
Course Week |
Weekly Content |
|
Week 1 Microsoft Word |
·
Readings
MindTap: o
Windows
Module 1: Introduction to Windows 10 o
Windows
Module 3: File and Folder Management o
Word
Module 1: Creating and Modifying a Flyer ·
Discussion:
Introduction and Lists ·
MindTap
Training: o
Module
4 Computer Concepts Skills Training o
Module
14 Computer Concepts Skills Training o
Module
11.2 Importance of Netiquette o
Word
Module 1 Training ·
Assignment:
MS Word Flyer ·
MindTap
Exam- Word: Module 1 |
|
Week 2 Microsoft Word |
·
Readings
MindTap: o
Word
Module 2: Creating a Research Paper o
Word
Module 3: Creating a Business Letter ·
Discussion:
Letters ·
Video Lecture ·
MindTap
Training: Word Module 2,3 ·
Assignment: MS Word Letter ·
MindTap
Exam: Word Module 2 |
|
Week 3 Microsoft PowerPoint |
·
Readings
MindTap: o
PowerPoint
Module 1: Creating and Editing Presentations with Pictures o
PowerPoint
Module 2: Enhancing Presentations with Shapes and SmartArt ·
Discussion:
Presentation Peeves and best practices ·
Video
Lecture ·
MindTap
Training: PowerPoint Module 1,2 ·
Assignment: Microsoft PowerPoint Assignment · MindTap Exams: PowerPoint Module 1 |
|
Week 4 Microsoft Excel |
o Excel Module 1: Creating a Worksheet
and a Chart ·
Discussion: SUM function ·
MindTap
Training: Excel Module 1 ·
Video
Lecture ·
Assignment: Microsoft Excel Assignment ·
MindTap
Exam: Excel Module 1 |
|
Week 5 Microsoft Excel |
·
Readings
MindTap: o
Excel
Module 2: Formulas, Functions, and FormattingDiscussion: Conditional Formatting ·
Video
Lecture ·
MindTap
Training: Excel Module 2 ·
MindTap
Exam: Excel Module 2 · Assignment: Microsoft Excel Module 2 Assignment Sales summary |
|
Week 6 Microsoft Excel |
·
Readings
MindTap: o
Excel
Module 3: Working with Large Worksheets, Charting, and What-If Analysis
Discussion: Best Practices ·
Video
Lecture ·
MindTap
Training: Excel Module 3 ·
MindTap
Exam: Excel Module 3 · Assignment: Microsoft Excel Module 3 Assignment Weekly payroll |
|
Week 7 Microsoft Excel |
·
Readings
MindTap: o
Excel
Module 4: Financial Functions, Data Tables, and Amortization Schedules o
Excel
Module 6: Creating, Sorting, and Querying a Table ·
Discussion: Excel help and errors ·
Video
Lecture ·
MindTap
Training: Excel Module 4,6 ·
MindTap
Exam: Excel Module 6 · Assignment: Microsoft Excel Module 6 Assignment Querying |
|
Week 8 Microsoft Excel |
·
Readings
MindTap: o
Excel
Module 5: Working with Multiple Worksheets and Workbooks o
Excel
Module 8: Working with Trendlines, Pivot Table Reports, PivotChart Reports,
and Slicers ·
Discussion: Class review ·
Video
Lecture ·
MindTap
Training: Excel –Module 5,8 ·
Assignment: Microsoft Excel Module 8 Budget Analysis ·
MindTap
Exam: Excel Module 8 |
Grading Policy
|
Grading Category |
Grade Weight |
|
Discussions |
20% |
|
Assignments |
60% |
|
Exams |
20% |
Estimated Student Workload
The following table outlines the academic effort required by students to become successful in this course. While the times in the table are hourly approximations, it is presented to help students with their time management. Please note, depending on the student’s background knowledge and experience of the course subject, and an individual student’s academic capabilities, these times will vary.
|
Course Week |
Activity and Time Required |
|
Week 1 |
·
Reading/Watching:
5.3 ·
Discussion:
4.0 ·
Homework:
9.0 · Total Time Estimated: 18.3 |
|
Week 2 |
· Reading/Watching: 4.9 · Discussion: 4.0 · Homework: 8.0 · Total Time Estimated: 16.9 |
|
Week 3 |
· Reading/Watching: 4.9 · Discussion: 4.0 · Homework: 11.0 · Total Time Estimated: 19.9 |
|
Week 4 |
· Reading/Watching: 2.4 · Discussion: 4.0 · Homework: 8.0 · Total Time Estimated: 14.4 |
|
Week 5 |
· Reading/Watching: 2.4 · Discussion: 4.0 · Homework: 8.0 · Total Time Estimated: 14.4 |
|
Week 6 |
· Reading/Watching: 2.7 · Discussion: 4.0 · Homework: 8.0 · Total Time Estimated: 14.7 |
|
Week 7 |
· Reading/Watching: 4.6 · Discussion: 4.0 · Homework: 9.0 · Total Time Estimated: 17.6 |
|
Week 8 |
· Reading/Watching: 5.0 · Discussion: 4.0 · Homework: 9.0 · Total Time Estimated: 18.0 |
