MCCCD Official Course Competencies:

CIS114AE  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)

MCCCD Official Course Outline:

CIS114AE  1992 Fall – 2011 Fall

Excel: Level I

I. Spreadsheet 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