Maricopa Community Colleges  BPC104BF   19944-20086 
Official Course Description: MCCCD Approval: 07/22/08
BPC104BF 19944-20086 LEC 0.50 Credit(s) 0.50 Period(s)
Using Quattro-Pro: Level II
Use of Quattro-Pro to enhance worksheets to include graphing and formatting data, using complex formula and function expressions to build and analyze data, and special print options to output worksheets and graphs.
Prerequisites: BPC104AF or permission of Instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC104BF   19944-20086 Using Quattro-Pro: Level II
1. Describe and identify the key components of a graph. (I)
2. Create a graph based on worksheet data. (I)
3. Choose an appropriate graph type, label and identify its data. (I)
4. Output the results of a graph. (II)
5. Format numeric data as appropriate. (III)
6. Enhance appearance of text and worksheet. (III)
7. Use summary functions to calculate column/row totals. (IV)
8. Convert the appearance of data by using conversion functions. (IV)
9. Select and conditionally process data using selection functions. (IV)
10. Redefine printed output using advanced printing/layout options. (V)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC104BF   19944-20086 Using Quattro-Pro: Level II
    I. Worksheet graphs
        A. Define the data series (y-values)
        B. Define the data category (x-axis)
        C. Select the graph type
        D. Label the graph
      II. Graph output options
          A. Save the graph
          B. Print the graph
        III. Formatting data
            A. Numeric formats
            B. Text formatting
            C. Cell formatting
          IV. Functions
              A. Summary functions
              B. Conversion funtions
              C. Selection functions
            V. Special print options
                A. Layout
                B. Scope and size of output
            Go to Description    Go to top of Competencies    Go to top of Outline