WAKE TECHNICAL COMMUNITY COLLEGE DIVISION OF COMPUTER & ENGINEERING TECHNOLOGIES COURSE SYLLABUS
COURSE NO: CTS 245 TITLE: Integrated Apps Expert
Title: Microsoft Office 2010, Post Advanced
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
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.
the student with post advanced skills in the areas of
Microsoft Office 2010 Word, Excel, PowerPoint, and Access
the student with pre-and post-test assessments that test
their mastery of skills
opportunities to practice for certification testing
for certification testing in Microsoft Office 2010 Word,
Excel, PowerPoint, and Access
the student with post advanced skills to be used in a
Student Learning Outcomes:
Upon successful completion, students will be able to demonstrate (through
completion of classwork and assignments):
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
Instructor and students will foster an environment that is respectful of all.
Instructor and students will foster an environment that promotes taking responsibility for one's actions and obligations.
Instructor and students will strive to improve the critical thinking skills of analysis, synthesis, and evaluation.
Instructor and students will strive to ensure that both written and oral communications are clearly understood.
Instructor and students will strive to develop collaborative skills.
Grading Is As Follows:
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.
Expect a quiz
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 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.
90-100 = A, 80-89 = B, 70-79 = C, 60-69 = D, Below 60 = F
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.
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.
Topics to be covered
Introduction to Course
Review of Concepts
Word Chapter 8:
Using Document Collaboration and Integration Tools
Practice for certification testing
Word Chapter 9:
Creating a Reference Document with a Table of Contents and an Index
Word Chapters 10 and 11:
Creating a Template for an Online Form and
Enhancing an Online Form, Using Macros, and Adding Digital Signatures
Portions of PowerPoint Chapters
Review and a few new topics
Test 1-Microsoft Word and PowerPoint and
Overview of Outlook 2010
Excel Chapter 8:
Working with Trendlines, PivotTable Reports, PivotChart Reports and Slicers
Excel Chapter 9:
Formula Auditing, Data Validation, and Complex Problem Solving
Excel Chapter 10:
Using Macros and Visual Basic for Applications (VBA) with Excel
Excel Chapter 11:
Collaboration Features for Workbooks
Access Chapter 8:
Advanced Form Techniques
Access Chapter 9:
Macros, Navigation Forms, PivotTables, and PivotCharts
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