Maricopa Community Colleges  CIS114CE   19926-99999 

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

CIS114CE  1992 Fall – 2011 Fall

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

Excel: Level III

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

Prerequisites: BPC/CIS114BE or permission of Instructor.

Cross-References: BPC114CE

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

CIS114CE  1992 Fall – 2011 Fall

Excel: 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:

 

CIS114CE  1992 Fall – 2011 Fall

Excel: 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