MCCCD Program Description

Using Excel: Level III

Course: BPC104CD

First Term: 1994 Summer I

Lecture 0.5 Credit(s) 0.5 Period(s) 0.5 Load
Subject Type: Occupational
Load Formula: S

Description: Use of Excel to produce worksheets utilizing macros for template development and automation of repetitious tasks, and worksheet methods for the storage and management of data

MCCCD Official Course Competencies
1. Create, execute and edit worksheet macros. (I) 2. Describe methods for saving macros and macro libraries. (II) 3. Define a database, criteria range, and extract location. (III) 4. Enter and modify data in database. (IV) 5. Selectively locate and retrieve data. (V) 6. Sort and generate data. (V) 7. Use database statistical functions to analyze data. (VI) 8. Define extracted data as print ranges for reporting purposes. (VII)
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. Methods for developing macros A. Create B. Execute C. Edit II. Methods for saving macros A. Saving with a single worksheet B. Creating macros libraries III. Data concepts A. Key terminology B. Database design 1. Database location 2. Extract location 3. Criteria location IV. Data entry and modification A. Data entry input range or, B. Data entry form C. Data editing V. Working with data A. Locating target data B. Extracting target data C. Sorting data D. Data series, data fill VI. Data summarization A. Database summary functions B. Data table commands VII. Reporting database data A. Printing extracted data B. Printing database summary calculations

MCCCD Governing Board Approval Date: 2/22/1994

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.