Maricopa Community Colleges  BPC114BB   19926-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC114BB 19926-19956 L+L 1 Credit(s) 2 Period(s)
Multiplan: Level II
Additional Multiplan spreadsheet techniques, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs. Prerequisites: BPC/CIS114AB or permission of instructor.
Cross-References: CIS114BB
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC114BB   19926-19956 Multiplan: 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:
 
BPC114BB   19926-19956 Multiplan: 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
          Go to Description    Go to top of Competencies    Go to top of Outline