Maricopa Community Colleges  BPC114DE   19926-99999 

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

BPC114DE  1992 Fall – 2011 Fall

L+L  3.0 Credit(s)  5.0 Period(s)  4.4 Load  Occ

Excel Spreadsheet

Computer spreadsheet skills for solving business problems using Excel, including calculations, forecasting, projections, macro programming, database searching, extraction, linking, statistics, and matrix manipulation. Production of graphs and reports. Project design using multiple, integrated spreadsheets.

Prerequisites: None.

Cross-References: CIS114DE

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

BPC114DE  1992 Fall – 2011 Fall

Excel Spreadsheet

 

1.

Load and set up the spreadsheet program. (I)

2.

Create a properly-formatted worksheet file. (II)

3.

Organize a problem for solution with spreadsheet software. (III)

4.

Apply the principles of effective worksheet and database layout in building a spreadsheet template, using labels, numbers, and formulas. (III)

5.

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

6.

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

7.

Print a spreadsheet on the printer and on disk, using spreadsheet print capabilities to enhance printed output. (VI)

8.

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

9.

Use spreadsheet functions to prepare and print graphs. (VIII)

10.

Create and use complex spreadsheet macros. (IX)

11.

Use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets. (X)

12.

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

13.

Manipulate matrices with spreadsheet software. (XII)

14.

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

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:

 

BPC114DE  1992 Fall – 2011 Fall

Excel Spreadsheet

 

I. Spreadsheet concepts

A. Loading

B. Terminology

C. Set up

II. Creating worksheet file

A. Using proper keys

B. Aligning data within cells

C. Reformatting data within cells

III. Spreadsheet template definition and design

A. Defining and organizing the problem

B. Designing a template to solve the problem

1. Entering the formulas

2. Using proper symbols

3. Algebraic hierarchy

4. Using the spreadsheet's built-in functions

IV. Entering and modifying data

A. Entering new data

B. Deleting existing data

C. Modifying existing data

V. Saving and retrieving files

A. Saving a spreadsheet on disk

B. Updating and correcting spreadsheet file

C. Replacing a spreadsheet file

VI. Printing a spreadsheet

A. Controlling margins and options

B. Printing on the printer

C. Printing on the disk

D. Enhancing reports

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

A. Creating graphs

B. Printing graphs

IX. Spreadsheet macros

A. Creation

B. Use

X. Spreadsheet database techniques

A. Searching

B. Linking

C. Extracting

D. Combining

XI. Use of spreadsheet statistical functions

XII. Matrix manipulation

XIII. Integrated spreadsheet project

A. Design of spreadsheets for integrated systems

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