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