|
Official Course Description:
MCCCD Approval: 10-22-1991 |
|||||
|
CIS114BE
1992 Fall – 2011 Fall |
L+L 1.0 Credit(s) 2.0 Period(s) 1.7 Load Occ |
||||
|
Excel:
Level II |
|||||
|
Additional Excel spreadsheet techniques, including macro
programming, database searching, extraction, and linking to obtain prescribed
reports and graphs. Prerequisites: BPC/CIS114AE or permission
of Instructor. |
|||||
|
Cross-References:
BPC114BE
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
CIS114BE 1992
Fall – 2011 Fall |
Excel: Level II |
|
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) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
||
|
|
||
|
CIS114BE 1992
Fall – 2011 Fall |
Excel: Level II |
|
|
||
|
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 |
|
|