Course Code: ITCC112 Course ID: 3831 Credit Hours: 3 Level: Undergraduate
This course is a study of the concepts and technology trends essential to office productivity applications. Students will explore the principles, practices, features, and functions of the electronic spreadsheet application in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Excel to create and format spreadsheets; they will also manipulate data and use formulas, charts, workbooks, styles, hyperlinks, themes, functions, conditional logic, graphics, comments, and security features. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. The course content maps to the Microsoft Office Specialist (MOS): to Microsoft Office Excel Certification. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty.
|Registration Dates||Course Dates||Session||Weeks|
|10/26/20 - 04/02/21||04/05/21 - 05/30/21||Spring 2021 Session B||8 Week session|
|11/30/20 - 04/30/21||05/03/21 - 06/27/21||Spring 2021 Session I||8 Week session|
|12/28/20 - 06/04/21||06/07/21 - 08/01/21||Spring 2021 Session D||8 Week session|
|01/25/21 - 07/02/21||07/05/21 - 08/29/21||Summer 2021 Session B||8 Week session|
|02/22/21 - 07/30/21||08/02/21 - 09/26/21||Summer 2021 Session I||8 Week session|
After completing this course the student will be able to:
- Explain the impact of the Microsoft Application Suite on Information Technology Management as it applies to office productivity, collaboration, and security.
- Demonstrate the application skills that are needed to be an effective employee in a productive workplace.
- Use Microsoft Excel to create and format spreadsheets, manipulate data, with formulas, charts, conditional logic, graphics, and security features.
- Examine the manual formatting and customization techniques within Microsoft Excel.
- Use application methods to improve office productivity.
- Use the Microsoft Application Suite to create formulas, format and use spreadsheets to make business decisions.
Students are expected to maintain routine contact with the instructor throughout the course. While the number of contacts may vary according to the specific course and individual student need, the University requires periodic weekly contacts during the semester. Contact will consist of professor notes, forum interaction, and email feedback. The method of discussion will be online related to issues concerning forum assignments, quizzes, excercises, and projects.
This course uses open-source online resources. Review the sources provided in the syllabus to see assigned readings for each week.
The Forum assignments for this course are designed to promote interactivity among students and enhance the online learning process. The Forum provides maximum flexibility because you do not have to be online at the same time as another person and you can read what other students have written.
Forum Timing: For the forum, you must post your work by midnight on Thursday, continue to follow your classmates' posts for the remainder of the week, and post the follow-up peer responses prior to midnight on Sunday, except for week one. Your follow-up posts can add additional insight to a classmate's opinions or can challenge their opinions. Use examples from the readings, or from your own research, to support your views, as appropriate. Be sure to read the follow-up posts to your own posts and reply to any questions or requests for clarification. You are encouraged to conduct research and use other sources to support your answers.
Required Participation: Please keep in mind that the forum assignments require you to make at least 1 post to the forum with at least 250 words about the topic and also respond to at least 2 peers’ posts with at least 150 words. Please be advised that there will be point deductions if you do not comply with these requirements of the assignment. Each one of you will have a different and unique experience that we can all learn from. Your participation in the Forums unleashes the power of synergy in our classroom. To facilitate this interaction, please be prompt when posting your forum work for each week; this provides time for the others to actively engage in the dialogue. For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. There is no need to also post your forum work in the assignments area of the classroom. Refer to the forum and the syllabus for more details on grading.
QUIZZES & ASSESSMENTS
There will be 8 quizzes to be taken after the readings are completed. Each quiz is located in MyLabsPlus.
EXERCISES AND PROJECTS
The exercises will allow you to develop a vocabulary of different concepts and commands in the application; and the projects will require you to apply your knowledge and skills to produce different documents in MS Word.
|Forum 1||5.00 %|
|Forum 2||5.00 %|
|Forum 3||5.00 %|
|Forum 5||5.00 %|
|Forum 6||5.00 %|
|Forum 8||5.00 %|
|Quiz 1||1.88 %|
|Quiz 2||1.88 %|
|Quiz 3||1.88 %|
|Quiz 4||1.88 %|
|Quiz 5||1.88 %|
|Quiz 6||1.88 %|
|Quiz 7||1.88 %|
|Quiz 8||1.88 %|
|Week 1 Exercise||6.67 %|
|Week 2 Exercise||6.67 %|
|Week 3 Exercise||6.67 %|
|Week 4 Project 1||6.67 %|
|Week 5 Project 2||6.67 %|
|Week 6 Exercise||6.67 %|
|Final Project||15.00 %|
|Week 7 Final Project||15.00 %|
|Book Title:||Various resources from the APUS Library & the Open Web are used. Please visit http://apus.libguides.com/er.php to locate the course eReserve.*|
Not current for future courses.