TRI-COUNTY TECHNICAL COLLEGE COURSE SYLLABUS
Course Prefix & Number:    AOT 267 Course Title:                          Integrated Information Processing
Class  Hours Per week:  3	Lab Hours Per Week:  0		Credits Awarded:  3
Catalog  Description: This course emphasizes the application of integrated computer software.
Entry Level Skills:  None
Pre-requisites:  AOT 105-Keyboarding
Co-requisites:  None
Text(s)/Required Materials: Go! with Microsoft Excel 2007, Volume 1 Gaskin, Vargas, and Preston Storage media: USB flash drive
Course Competencies and Objectives: Upon successful completion of this course, the student should be able to: 1. Enter data and manage spreadsheet calculations. 2. Design and create spreadsheets. 3. Create graphs, charts and reports. 4. Develop an understanding of spreadsheet management terminology.
Major Course Topics: 1. Creating a Worksheet and Charting Data 2. Managing Workbooks and Analyzing Data 3. Using Functions and Tables 4. Using Templates Range Names and Lookup Functions 5. Importing Data and Using Database Tools to Extract Information 6. Summarizing Data with Pivot Tables and Conditional Summary Formulas
Grade Calculation Method: Assignments Project Tests		=          40 percent =          60 percent           100 percent
Prepared by: Administrative Office Technology Faculty                          Date written or revised: June 2008

Tri-County Technical College

Course Syllabus Approval Form

Course Prefix and Number: AOT 267

Course Title: Integrated Information Processing

Syllabus prepared by: Administrative Office Technology Faculty

Date written or revised: June 2008

Approved: _______________________________               _____________

                   (Department Head)                                              (Date)

Approved: _______________________________               _____________

                   (Dean, Business and Public Services)                  (Date)