WAKE TECHNICAL COMMUNITY COLLEGE
DIVISION OF COMPUTER & ENGINEERING TECHNOLOGIES
COURSE SYLLABUS
COURSE NO: CTS 245
TITLE: Integrated Apps Expert
Textbook(s):
     Title: Microsoft Office 2010, Post Advanced
     Author: Shelly/Vermaat
     ISBN: 1-4390-7899-8
     Publisher: Course Technology


     Title: SAM 2010 Assessment Code
     Author: **See special instructions below**

Special Instructions: SAM assessment software will be used for this course. If you purchased SAM for CTS 135 in Fall of 2010, you will be able to use the same login. However, if you took CTS 135 prior to Fall of 2010, you will need to purchase a code. The code that can be purchased from the bookstore: SAM 2010 Assessment, Training, and Projects v2.0 Printed Access Card, 1st Edition, ISBN: 1111667373 The code that can be purchased through the publisher site, www.cengagebrain.com: SAM 2010 Assessment, Training, and Projects v2.0 Instant Access Code, 1st Edition, ISBN: 1111669368

Software used to complete coursework: Microsoft Windows 7, Vista, or XP with Service Pack 2 (book will show Windows 7); Firefox 3.6 internet browser; Microsoft Office 2010 COMPLETE that includes Word, Excel, PowerPoint, Access, Outlook, and Publisher; WinZip or Windows built-in Compression. Contact the instructor for alternate ways to gain access to the Office Products; specifically through our Virtual Computing Lab.
Credit Hours: Three (3) Semester Hours
Pre-requisites: CTS 235
Co-requisites: none

Course Description:

This course provides an emphasis on mastery features in each of the application program areas. Emphasis is placed on end-user skills to achieve advanced support level proficiency by utilizing software for cross-platform integration, automation of processing, and application problem solving. Upon completion, the student should be able to demonstrate expert level skills in the utilization of the advanced features of the software in the workplace.

 Course Goals:
  1. To provide the student with post advanced skills in the areas of Microsoft Office 2010 Word, Excel, PowerPoint, and Access
  2. To provide the student with pre-and post-test assessments that test their mastery of skills
  3. To provide opportunities to practice for certification testing
  4. To prepare for certification testing in Microsoft Office 2010 Word, Excel, PowerPoint, and Access
  5. To equip the student with post advanced skills to be used in a practical environment.
     
Student Learning Outcomes:
Upon successful completion, students will be able to demonstrate (through completion of classwork and assignments):
  • Create and enhance Word documents using post advanced features
  • Use post advanced features of Excel to analyze and troubleshoot Excel worksheets
  • Use post advanced features of PowerPoint to work with slide masters and integrate among other applications
  • Use post advanced features of Access
The Core Values of Wake Technical Community College
Respect Instructor and students will foster an environment that is respectful of all.
Responsibility Instructor and students will foster an environment that promotes taking responsibility for one's actions and obligations.
Critical Thinking Instructor and students will strive to improve the critical thinking skills of analysis, synthesis, and evaluation.
Communication Instructor and students will strive to ensure that both written and oral communications are clearly understood.
Collaboration Instructor and students will strive to develop collaborative skills.
Grading Is As Follows:
Participation/Attendance 10% Attendance of at least 90% of all scheduled course hours is required. Three tardies equal one absence. If you are absent more than 10% of the required course hours, you could be withdrawn. If this occurs prior to the "withdrawal without penalty deadline", you will receive a "W"; after the deadline, you will receive a "WP" or "WF". A "WF" affects the GPA.
Quizzes 20% Expect a quiz each week.
Assignments 30% It is not the responsibility of the instructor to advise you of missed work during the term or on the last week of the term.
Exams 40% Exams must be taken on the assigned date; otherwise a grade of zero will be assigned. Any exception to this policy must be the result of a documented emergency or prior arrangement with the instructor. A PowerPoint presentation project may be given in lieu of a PowerPoint Exam.
Grading Scaleis:90-100 = A, 80-89 = B, 70-79 = C, 60-69 = D, Below 60 = F


Classroom Policies:
  • Students are responsible for all of the information presented in the Wake Technical Community College Student Handbook.
  • Please note that computers are to be used at all times for official course purposes. Use of computers for general web surfing, e-mailing, chat room discussions, social networking, and any other non-course related task is forbidden. Violation of this rule will result in a grade deduction and possible loss of computer privileges.
  • The college forbids the use of all audible electronic equipment during instructional time. Forbidden devices include but are not limited to: cell phones, smart phones, MP3 players, and PDAs.
  • If you miss a lecture or arrive late, you are responsible for the material presented, handouts distributed, and any announcements made that day. The instructor will not provide notes for missed classes.

Note: Wake Tech provides every student with an official e-mail account which is to be used for all e-mail correspondence with instructors and college officials. Some information such as instructor to student correspondence, WebAdvisor registration information, and financial aid information will ONLY be e-mailed from Wake Tech to your official e-mail account. Students in all curriculum classes must activate and use their my.waketech.edu account. Once you have activated your e-mail account, you may choose to re-direct your e-mail to another account of your choosing. Please be advised that Wake Tech will only send e-mail to your Wake Tech e-mail account. Furthermore, college officials and instructors may decline to accept e-mail from accounts other than the college-issued my.waketech.edu account.

For more information about your Wake Tech-provided e-mail account, please visit the Wake Tech student portal at my.waketech.edu and click on Support. You must wait 24 hours after activating your my.waketech.edu account before you can activate your e-mail account.
Tentative Schedule
 Note: This schedule is subject to some changes/modifications per Instructor -- This offered as only a study guide. The pace of each class differs according to the instructional needs of the students in the class. Always consult with your instructor.
Unit Topics to be covered
1 
Introduction to Course
Review of Concepts

Word Chapter 8:
Using Document Collaboration and Integration Tools
Practice for certification testing
2 
Word Chapter 9:
Creating a Reference Document with a Table of Contents and an Index
3 
Word Chapters 10 and 11:
Creating a Template for an Online Form and 
Enhancing an Online Form, Using Macros, and Adding Digital Signatures
4 Portions of PowerPoint Chapters

Review and a few new topics
5 
Test 1-Microsoft Word and PowerPoint and
Overview of Outlook 2010
6 
Excel Chapter 8:
Working with Trendlines, PivotTable Reports, PivotChart Reports and Slicers
7 
Excel Chapter 9:
Formula Auditing, Data Validation, and Complex Problem Solving
8 
Excel Chapter 10:
Using Macros and Visual Basic for Applications (VBA) with Excel
Excel Chapter 11: 
Collaboration Features for Workbooks
9 
Access Chapter 8:
Advanced Form Techniques 
Access Chapter 9:
Macros, Navigation Forms, PivotTables, and PivotCharts
10 
Portion of Access Chapter 10:
Administering a Database System

Test 2-Microsoft Excel, Access and Macros (all applications)
Practice for certification testing

Disability Support Services (DSS) is available for students who require academic accommodations due to any physical, psychological, or learning disability. To determine eligibility, contact the office at 108-S Holding Hall or call
919-866-5500

Copyright - 2012 - Wake Technical Community College All Rights Reserved