TRI-COUNTY TECHNICAL COLLEGE

COURSE SYLLABUS

Course Number: CPT 270

Course Title: Advanced Microcomputer Applications

Class Hours Lab Hours Credit

Per Week: 3 Per Week: 0 Awarded: 3

CataCCatalog Description: This course emphasizes the integration of popular microcomputer software packages using advanced concepts in microcomputer applications software. Some of the advanced features of Microsoft Office software will be applied to solve typical business problems.

Entry-Level Skills: The student should have:

· A desire to learn about microcomputers and application software

· The ability to read and comprehend text, including interpreting acronyms and technical terms

· The ability to read and follow directions

· The ability to perform basic mathematical operations based on a series of incremental processes

· The ability to write using appropriate business terms, grammar, and spelling

· Basic keyboarding skills

Other entry-level skills needed include knowledge of Windows and the ability to:

· Perform basic file management functions

· Produce, edit, format, and print documents using a word processing program

· Produce, edit, format, and print worksheets using a spreadsheet program

· Produce, edit, format, and print slide presentations using a presentation graphics program

Pre-requisites: CPT 170

Co-requisites: None

Text(s)/Required Materials:

· Text(s): Go with Microsoft Office 2007 Introductory, Gaskin/Ferrett/Vargas/Marks, Pearson/Prentice Hall,
© 2008

· MyITLab Assessment Software access code

· USB flash drive storage media

· An Internet-connected PC running Windows XP with Internet Explorer 7.0 and MS Office 2007 installed
(Students who do not have access to a PC configured as above may use the campus Open Computer Lab to complete coursework)

· Stereo headphones (1/8” jack) (optional)

Course Competencies and

Objectives:

Upon satisfactory completion of CPT 270, the student should be able to:

· Create and/or modify a document with specified formatting

· Use Word to create a Web page that includes graphics and hyperlinks

· Generate form letters and mailing labels using Mail Merge

· Build valid calculations and formulas in worksheets using formulas and functions

· Perform ‘What-If’ analysis

· Present data with tables and charts

· Generate an animated slide show

· Identify and create tables with appropriate relationships

· Define fields using properties and validate data appropriately

· Build valid expressions and formulas in queries

· Create custom forms and reports in Access

Major Course Topics:

Grade Calculation Method:

Microsoft Word, Excel, and PowerPoint

Microsoft Access

Integration of Word, Excel, PowerPoint and Access

There will be activity credit for each topic, and a test at the end of each application topic. Activity credit will be awarded for assignments and practice tests.

The final grade will be calculated as follows:

	Final Grade Percentage
Activity credit–Intro. Materials	5%
Activity credit–Word, Excel, and PowerPoint	10%
Test–Word, Excel, and PowerPoint	30%
Activity credit–Access	10%
Test–Access	30%
Activity credit–Integration	15%
Total	100%

Additional Information Pertaining to Grades:

Students must earn a minimum grade of ‘C’ in all CPT/IST courses used to fulfill graduation requirements of a Computer and Information Technology program.

Students should access the College's Acceptable Use of Information Technology Resources procedure and note the consequences for non-compliance.

Prepared by: G. Fiori Date written or revised: 05/05/2008