Maricopa Community Colleges  BPC104CA   19944-20016 
Official Course Description:   MCCCD Approval:  09/25/01
BPC104CA     19944-20016 LEC 0.50 Credit(s) 0.50 Period(s)
Using Lotus 1-2-3: Level III
Use of Lotus 1-2-3 to produce worksheets utilizing macros for template development and automation of repetitious tasks, and worksheet methods for the storage and management of data. Prerequisites: BPC104BA or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC104CA   19944-20016 Using Lotus 1-2-3: Level III
1. Create, execute and edit worksheet macros. (I)
2. Describe methods for saving macros and macro libraries. (II)
3. Define a database, criteria range, and extract location. (III)
4. Enter and modify data in database. (IV)
5. Selectively locate and retrieve data. (V)
6. Sort and generate data. (V)
7. Use database statistical functions to analyze data. (VI)
8. Define extracted data as print ranges for reporting purposes. (VII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC104CA   19944-20016 Using Lotus 1-2-3: Level III
    I. Methods for developing macros
        A. Create
        B. Execute
        C. Edit
      II. Methods for saving macros
          A. Saving with a single worksheet
          B. Creating macros libraries
        III. Data concepts
            A. Key terminology
            B. Database design
              1. Database location
              2. Extract location
              3. Criteria location
          IV. Data entry and modification
              A. Data entry input range or,
              B. Data entry form
              C. Data editing
            V. Working with data
                A. Locating target data
                B. Extracting target data
                C. Sorting data
                D. Data series, data fill
              VI. Data summarization
                  A. Database summary functions
                  B. Data table commands
                VII. Reporting database data
                    A. Printing extracted data
                    B. Printing database summary calculations
                Go to Description    Go to top of Competencies    Go to top of Outline