Maricopa Community Colleges  CIS114CG   19926-99999 

Official Course Description: MCCCD Approval: 10-22-1991

CIS114CG  1992 Fall – 2011 Summer II

LEC  1.0 Credit(s)  1.0 Period(s)  1.0 Load  Occ

Quattro Pro: Level III

Additional Quattro Pro spreadsheet techniques, including complex macros, statistics, and matrix manipulation. Project design using multiple, integrated spreadsheets.

Prerequisites: BPC/CIS114BG or permission of Instructor.

Cross-References: BPC114CG

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

CIS114CG  1992 Fall – 2011 Summer II

Quattro Pro: Level III

 

1.

Create and use complex spreadsheet macros. (I)

2.

Use built-in statistical analysis features of spreadsheet software. (II)

3.

Manipulate matrices with spreadsheet software. (III)

4.

Design and implement a spreadsheet project which includes multiple, integrated spreadsheets. (IV)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:

 

CIS114CG  1992 Fall – 2011 Summer II

Quattro Pro: Level III

 

I. Complex macros

A. Creation

B. Use

II. Use of spreadsheet statistical functions

III. Matrix manipulation

IV. Integrated spreadsheet project

A. Design of spreadsheets for integrated system

B. Building of templates

C. Entry and manipulation of data

D. Production of appropriate reports and graphs

 

Go to Description    Go to top of Competencies    Go to top of Outline