Maricopa Community Colleges  BPC104BE   19944-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC104BE 19944-19956 LEC 0.50 Credit(s) 0.50 Period(s)
Using Smart Spreadsheet: Level II
Use of Smart Spreadsheet 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: BPC104AE or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC104BE   19944-19956 Using Smart Spreadsheet: 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:
 
BPC104BE   19944-19956 Using Smart Spreadsheet: 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