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