Maricopa Community Colleges  BPC104CC   19944-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC104CC 19944-19956 LEC 0.50 Credit(s) 0.50 Period(s)
Using SuperCalc: Level III
Use of SuperCalc to produce worksheets utilizing macros for template development and automation of repetitious tasks, and worksheet methods for the storage and management of data. Prerequisites: BPC104BC or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC104CC   19944-19956 Using SuperCalc: 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:
 
BPC104CC   19944-19956 Using SuperCalc: 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