| Course Title: | Computer Applications for Business (With Lab) |
|---|---|
| Course Number: | COMP100 |
| Course Description: | This course introduces basic concepts and principles underlying personal productivity tools widely used in business, such as word processors, spreadsheets, presentation tools, and web navigation. Students also learn basic computer terminology and concepts. Hands-on exercises provide students with experience in the use of PCs and current personal productivity tools. |
| Course Prerequisites: | N/A |
Syllabus
Course Information
Course Specific Requirements
The COMP100 course uses a simulated Microsoft Office Environment called MyITLab for homework assignments.
To set up the simulation at home, use the COMP100 Home Setup link in the MyITLab page (below Week 8), and then select the Browser Tune-Up for PC or MAC.
- Unzip the download and run the setup file (allow the program to make changes).
- Launch the program that installs. This is how you will access the course shell from now on.
- Log in to the course and navigate to the MyITLab page. To access the homework, click the MyITLab Assignments link.
Note: You will need to disable popup blockers and allow popups in your browser.
Discussion posts count for attendance in this course; all online students must post at least once every 7 days to remain enrolled in the course. Even if the student is fully up to date on other assignments, lack of discussion participation alone will prompt an attendance-based withdrawal.
Textbooks and Resources
Required Textbooks
The following books are required for this course:
Exploring Microsoft Office 2016 (Volume 1)
First Edition
by Mary Anne Poatsey, Keith Mulbery, Jason Davidson, Robert T. Grauer
2016 Pearson Education
Required Software: Vital Source
Physical Books and Supplies
Your course may require additional materials, such as a course kit. Visit the online bookstore if you have not yet ordered your books and supplies.
If you are a Chamberlain student, visit the online Chamberlain bookstore to obtain all your books and supplies.
Campus Additional Information
Please check with your Professor about the local attendance policy. On many campuses, COMP100 is considered “self-paced” and attendance is relaxed for students who have completed their work (either all the work in the course, or the work for that week). Discussions, which are used for attendance online, may have the points re-purposed at the discretion of the Professor.
Terminal Course Objectives
DeVry University course content is constructed from curriculum guides developed for each course that are in alignment with specific Terminal Course Objectives (TCOs). The TCOs define the learning objectives that the student will be required to comprehend and demonstrate by course completion. The TCOs that will be covered in detail each week can be found in the Objectives section for that particular week. Whenever possible, a reference will be made from a particular assignment or discussion back to the TCO that it emphasizes.
1
In Microsoft Word 2016: begin and edit a document; customize program settings; use features that improve readability.
2
In Microsoft Word 2016: view a document in different ways; prepare a document for distribution; modify document properties.
3
In Microsoft Word 2016: use font selection as yet another method of conveying the message of the document; format selected paragraphs for added emphasis of the document.
4
In Microsoft Word 2016: apply a theme that will visually coordinate various page elements; create custom formatting, or style, for each commonly used element; modify and enhance objects within the document.
5
In Microsoft Word 2016: insert a table into a document; apply table styles to enhance the document; summarize the data in a table; add captions to enhance the table data.
6
In Microsoft Word 2016: use accepted writing styles and acknowledge sources; correctly use footnotes and end notes; include features such as table of contents or index; keep track of all additions, deletions, and formatting changes.
7
In Microsoft PowerPoint 2016: plan a presentation slideshow using a theme or template; add media, tables, transitions and animations; navigate various views and create speaker notes.
8
In Microsoft PowerPoint 2016: download, modify, and save a template; use sections to group slides; apply design principles to increase presentation appeal and professionalism; update slide masters and properties that affect the entire show.
9
In Microsoft Excel 2016: identify window elements; plan worksheet design, enter, and format data; create formulas using cell references and applying mathematical order of precedence; copy formulas using auto fill; display cell formulas and values.
10
In Microsoft Excel 2016: rename worksheet, change tab color, and insert, delete, move, copy worksheet; insert and delete columns and rows and adjust column width and row height; select and move ranges, copy and paste ranges; apply formatting to cells; modify page layout options and ensure data will print properly.
11
In Microsoft Excel 2016: use and differentiate between relative, absolute, and mixed cell addresses; correct a circular reference; understand function syntax; insert basic math, statistics, and miscellaneous functions.
12
In Microsoft Excel 2016: design an IF function including logical text and value_if_true and value_if_false arguments; implement a LOOKUP function; calculate payments with the PMT function; create and maintain range names and use range names in formulas.
13
In Microsoft Excel 2016: choose appropriate chart type for the data and conclusions; create a chart, change the chart type, change the data source and structure; apply a chart layout and chart style.
14
In Microsoft Excel 2016: move a chart and print charts; insert and customize a sparkline; select and format chart elements; customize chart labels; format the axes and gridlines; add a trendline.
Lab Schedule
Week 1
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 2
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 3
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 4
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 5
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 6
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 7
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Week 8
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
EDUPE (MySQL)
Course Schedule
| Week, TCOs, and Topics | Readings and Class Preparation | Activities and Assignments |
|---|---|---|
Week 1 TCOs 1 and 2 Word Chapter 1 | Read Word Chapter 1 Review written lesson in eCollege | Accessing MyITLab Training Exercises for Word Chapter 1 Word Chapter 1 Exam Graded Discussion |
Week 2 TCOs 3 and 4 Word Chapter 2 | Read Word Chapter 2 Review written lesson in eCollege | Training Exercises for Word Chapter 2 Word Chapter 2 Exam Graded Discussion |
Week 3 TCOs 5 and 6 Word Chapters 3 and 4 | Read Word Chapters 3 and 4 Review written lesson in eCollege | Training Exercises for Word Chapters 3 and 4 Word Chapters 3 and 4 Exam Graded Discussion (attendance) |
Week 4 TCOs 7 and 8 PowerPoint Chapters 1 and 2 | Read PowerPoint Chapters 1 and 2 Review written lesson in eCollege | Training Exercises for PowerPoint Chapters 1 and 2 PowerPoint Chapters 1 and 2 Exam Graded Discussion |
Week 5 TCOs 9 and 10 Excel Chapter 1 | Read Excel Chapter 1 Review written lesson in eCollege | Training Exercises for Excel Chapter 1 Excel Chapter 1 Exam Graded Discussion |
Week 6 TCOs 11 and 12 Excel Chapter 2 | Read Excel Chapter 2 Review written lesson in eCollege | Training Exercises for Excel Chapter 2 Excel Chapter 2 Exam Graded Discussion |
Week 7 TCOs 13 and 14 Excel Chapter 3 | Read Excel Chapter 3 Review written lesson in eCollege | Training Exercises for Excel Chapter 3 Excel Chapter 3 Exam Graded Discussion |
Week 8 | Complete all Exercises and Chapter Exams Comprehensive Final Exam | |
Blended E-Learning
This course is an 8-week, intensive course that includes both classroom-based and e-learning activities. Your participation in both areas is essential to your success in this course. You should expect to spend time each week participating in the prescribed activities both before and after our class meeting.
Participation before, during, and after class meetings is critical to your success in this intensive environment.
To get the most out of our weekly class meetings, it is essential that you come to class prepared. The weekly readings listed in the Course Schedule will prepare you for class. Our class meetings, in turn, will prepare you for upcoming exams and assignments.
Through the DeVry e-learning platform, you will be able to
- review the Syllabus and weekly assignment information;
- submit completed work for grading;
- take quizzes and exams;
- obtain copies of class handouts and notes;
- e-mail the instructor and other students; and
- participate in online discussion of class material.
Due Dates for Assignments & Exams
Unless otherwise specified, the following applies.
- Access to most weeks begins on Sunday at 12:01 a.m. mountain time (MT).
- All assignments are to be submitted on or before Sunday at the end of the specified week that they are due, by 11:59 p.m. (MT).
- All quizzes and exams are to be completed on or before Sunday at the end of the specified week that they open, by 11:59 p.m. (MT).
Week 8 opens at 12:01 a.m. (MT) on the ending Sunday of Week 7. Any assignments or exams must be completed by 11:59 p.m. (MT) Saturday of the eighth week.
Due Dates for Assignments & Exams
All assignments, quizzes, and exams are to be completed per the schedule indicated by your instructor.
Assignment Values and Letter Grades
The maximum score in this class is 386 points. The categories, which contribute to your final grade, are weighted as follows.
| Assignment | Points | Weighting |
|---|---|---|
| Discussions (12 points, Weeks 1–7) | 84 | 8.4% |
| Training Exercises (12-24 points, Weeks 1–7) | 116 | 11.6% |
| Chapter Exams (12-24 points, Weeks 1–7) | 116 | 70% |
| Comprehensive Final Exam (70 points, Week 8) | 70 | 10% |
| Total Points | 386 | 100% |
All of your course requirements are graded using points. At the end of the course, the points are converted to a letter grade using the scale in the table below.
Final grades are based on the percentage equivalent in the chart below and are not rounded to the next higher letter grade.
| Letter Grade | Points | Percentage |
|---|---|---|
| A | 347-386 | 90% to 100% |
| B | 309-346 | 80% to 89.9% |
| C | 270-308 | 70% to 79.9% |
| D | 232-269 | 60% to 69.9% |
| F | 231 and below | Below 60% |
DeVry Graduate Academic Policy and Relevant Resources
DeVry Undergraduate Academic Policy and Relevant Resources
Frequently Asked Questions
When are grades calculated, and how can I view my grades?
- You must complete any quizzes and post your written assignments (if necessary) to the weekly Dropbox by Sunday 11:59 p.m. (MT) each week, except Week 8 which closes at 11:59 p.m. (MT) Saturday.
- Once your work is reviewed, you should see comments and total points for each assignment in the Gradebook. Instructors should have Discussion work graded by the following Tuesday and all other assignments by the following Friday.
- You may check your progress at any time by going to the Gradebook, selecting the week and then your name.
- Click on the points earned for each assignment in the Gradebook to see any instructor comments.
What should I do if a discrepancy is found with my grade?
- Double-check the error and try to determine what caused it.
- Send your instructor an email explaining your findings.
- Trust that any error in grading will be corrected quickly
What if I cannot get my work submitted on time?
- If you have an emergency that will cause your work to be late, please contact your instructor in advance of the due date so that arrangements can be made. Your instructor may reserve the right to deduct points for work turned in late based on the reason and the timeliness of notice.
- If a technical problem prevents you from meeting the scheduled due date, please contact the Help Desk at 1-800-594-2402 and immediately email your instructor about the situation.
How can I get extra credit?
Extra credit is not an option.
Questions and Concerns
Please feel free to contact me for help with coursework or other areas that may impact your progress. Here are some examples.
- Do you have general questions about attendance, deadlines regarding your courses, student financial aid, or other areas?
- Are you a member of the military service? Do you need to adjust your schedule due to active duty, or do you have questions about your GI Bill® benefits or have other unforeseen military and veteran-related issues that have developed?
- Do you need supplementary student assistance? Please let me know if you are having academic difficulty and would like an ADA accommodation. Although I can talk with you about getting assistance, an excellent point of contact is the Office of Student Disability Services. You can reach the Office by calling 877-496-9050, option 3, or by e-mailing adaofficer@devry.edu or adaofficer@keller.edu.
Regardless of your situation, please feel free to contact me for assistance in whatever area of concern you might have. I will do everything I can to assist you or put you in contact with University colleagues who are trained to assist you in whatever area of concern you might have.
"GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by the VA is available at the official U.S. government website: www.benefits.va.gov/gibill.”