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