Maricopa Community Colleges  BPC114CE   19926-99999 

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

BPC114CE  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: CIS114CE

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

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

 

BPC114CE  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