Maricopa Community Colleges  CIS114BA   19926-20016 
Official Course Description:   MCCCD Approval:  09/25/01
CIS114BA     19926-20016 L+L 1 Credit(s) 2 Period(s)
Lotus 1-2-3: Level II
Additional Lotus 1-2-3 spreadsheet techniques, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs. Prerequisites: BPC/CIS114AA or permission of instructor.
Cross-References:   BPC114BA
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS114BA   19926-20016 Lotus 1-2-3: 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:
 
CIS114BA   19926-20016 Lotus 1-2-3: 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