Maricopa Community Colleges  BPC114AE   19926-99999 

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

BPC114AE  1992 Fall – 2011 Fall

L+L  1.0 Credit(s)  2.0 Period(s)  1.7 Load  Occ

Excel: Level I

Computer spreadsheet skills for solving business problems using Excel, including calculations, forecasting, and projections.

Prerequisites: None.

Cross-References: CIS114AE

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

BPC114AE  1992 Fall – 2011 Fall

Excel: Level I

 

1.

Load and set up the spreadsheet program. (I)

2.

Create a properly formatted worksheet file. (II)

3.

Build a template using labels, numbers, and formulas. (III)

4.

Enter, delete, and alter spreadsheet data. (IV)

5.

Save a spreadsheet on disk and retrieve it. (V)

6.

Print a spreadsheet on the printer and on disk. (VI)

7.

Sort a spreadsheet in a variety of ways. (VII)

8.

Create and print a graph. (VIII)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:

 

BPC114AE  1992 Fall – 2011 Fall

Excel: Level I

 

I. Speadsheet Concepts

A. Loading

B. Terminology

C. Set up

II. Creating a Worksheet file

A. Using proper keys

B. Aligning data within cells

C. Reformatting data within cells

III. Building an electronic spreadsheet template

A. Entering formulas

B. Using proper symbols

C. Algebraic hierarchy

IV. Entering Data

A. Entering new data

B. Deleting existing data

C. Modifying existing data

V. Saving and retrieving files

A. Saving a spreadsheet file on disk

B. Updating and correcting a spreadsheet file

C. Replacing a spreadsheet

VI. Printing a spreadsheet

A. Controlling margins and options

B. Printing on the printer

C. Printing on the disk

VII. Sorting a spreadsheet

A. Sorting in ascending order on rows or columns

B. Sorting in descending order on rows or columns

VIII. Creating and printing graphs

 

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