Course Prefix & Number:    AOT 267

Course Title:                          Integrated Information Processing


Class  Hours

Per week:  3

Lab Hours

Per Week:  0


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:



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)