MCCCD Program Description

Excel: Level I

Course: CIS114AE

First Term: 2018 Fall

Lec + Lab 1.0 Credit(s) 2.0 Period(s) 2.0 Load
Subject Type: Occupational
Load Formula: T

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

MCCCD Official Course Competencies
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 Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.

MCCCD Official Course Outline
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

MCCCD Governing Board Approval Date: 10/22/1991

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.