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)