Maricopa Community Colleges  BPC104CF   19944-20086 
Official Course Description: MCCCD Approval: 07/22/08
BPC104CF 19944-20086 LEC 0.50 Credit(s) 0.50 Period(s)
Using Quattro-Pro: Level III
Use of Quattro-Pro to produce worksheets utilizing macros for template development and automation of repetitious tasks, and worksheet methods for the storage and management of data.
Prerequisites: BPC104BF or permission of Instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC104CF   19944-20086 Using Quattro-Pro: 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:
 
BPC104CF   19944-20086 Using Quattro-Pro: 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