Skip Navigation
 
 

ITCC112 - Advanced Productivity Applications

Course Details

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.





Course Schedule

Registration Dates Course Dates Session Weeks
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I 8 Week session
12/31/18 - 05/31/19 06/03/19 - 07/28/19 Spring 2019 Session D 8 Week session
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
02/25/19 - 08/02/19 08/05/19 - 09/29/19 Summer 2019 Session I 8 Week session
03/25/19 - 08/30/19 09/02/19 - 10/27/19 Summer 2019 Session D 8 Week session
04/29/19 - 10/04/19 10/07/19 - 12/01/19 Fall 2019 Session B 8 Week session

Current Syllabi

After completing this course the student will be able to:

  1. Explain the impact of the Microsoft Application Suite on Information Technology Management as it applies to office productivity, collaboration, and security.
  2. Demonstrate the application skills that are needed to be an effective employee in a productive workplace.
  3. Use Microsoft Excel to create and format spreadsheets, manipulate data, with formulas, charts, conditional logic, graphics, and security features.
  4. Examine the manual formatting and customization techniques within Microsoft Excel.
  5. Use application methods to improve office productivity.
  6. 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.

TEXTBOOK READINGS
This course uses open-source online resources. Review the sources provided in the syllabus to see assigned readings for each week.

FORUMS

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.

NameGrade %
Forum 35.00 %
Forum 1 4.38 %
Forum 2 4.38 %
Forum 3 4.38 %
Forum 4 4.38 %
Forum 5 4.38 %
Forum 6 4.38 %
Forum 7 4.38 %
Forum 8 4.38 %
Quizzes 15.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 %
Assignments 35.00 %
Week 1 Exercise 5.83 %
Week 2 Exercise 5.83 %
Week 3 Exercise 5.83 %
Week 4 Project 1 5.83 %
Week 5 Project 2 5.83 %
Week 6 Exercise 5.83 %
Final Project/Assignment 15.00 %
Week 7 Final Project 15.00 %
Book Title: Various resources from the APUS Library & the Open Web are used. Links provided inside the classroom in the Lessons section.
Author:
Publication Info:
ISBN: N/A

Book Title:Various resources from the APUS Library & the Open Web are used. Links provided inside the classroom in the Lessons section.
Author: No Author Specified

Previous Syllabi

Not current for future courses.