MCCCD Program Description

Excel: Level II

Course: CIS114BE

First Term: 2017 Fall

Lec + Lab 1 Credit(s) 1 Period(s) 1 Load
Subject Type: Occupational
Load Formula: S - Standard Load

Description: Additional Excel spreadsheet techniques, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs.

MCCCD Official Course Competencies
1. Organize a problem for solution with spreadsheet template. (I) 2. Apply the principles of effective worksheet and database layout in building a spreadsheet template. (I) 3. Create and use simple spreadsheet macros. (II) 4. Use the spreadsheet`s database techniques to locate, link, extract, and combine data from multiple spreadsheets. (III) 5. Use spreadsheet functions to prepare and print graphs. (IV) 6. Use spreadsheet print capabilities to enhance printed output. (IV)
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 template definition and design A. Defining and organizing the problem B. Designing a template to solve the problem II. Spreadsheet macros A. Creation B. Use III. Spreadsheet database techniques A. Searching B. Linking C. Extracting D. Combining IV. Graphing and printing A. Creating graphs B. Printing graphs C. Enhancing reports

MCCCD Governing Board Approval Date: June 27, 2017

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.