Maricopa Community Colleges  BPC210   20012-99999 
Official Course Description:   MCCCD Approval:  11/28/00  
BPC210      20012-99999 L+L 3 Credit(s) 4 Period(s)
Advanced Computer Usage and Applications
Advanced application of software for business and personal computers including word processing, spreadsheet, database, and presentation. Includes integration of applications and Internet. Prerequisites: BPC110, or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC210   20012-99999 Advanced Computer Usage and Applications
1. Describe the components of a computer system. (I)
2. Use appropriate computer ethics. (II)
3. Use appropriate integrity and security techniques related to software and data. (III)
4. Apply advanced word processing features. (IV)
5. Apply advanced spreadsheet features. (V)
6. Apply advanced database features. (VI)
7. Apply the features of presentation software. (VII)
8. Integrate data among applications. (VIII)
9. Formulate and apply appropriate data to the Internet. (IX)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC210   20012-99999 Advanced Computer Usage and Applications
    I. Components of a Computer System
        A. Hardware
        B. Software
          1. Applications
          2. Operating systems
        C. Storage devices
        D. Networks
      II. Computer Ethics
        III. Integrity and Security
            A. Software
            B. Data
          IV. Word Processing
              A. Formatting
              B. Tables and columns
                1. Multiple
                2. Specialized
              C. Templates
                1. Designing
                2. Modifying
              D. Forms
                1. Designing
                2. Modifying
              E. Mail merge
                1. Creating data source
                2. Selecting and sort data
                3. Merging
                  a. Documents
                  b. Envelopes
                  c. Labels
              F. Printing
              G. Other features
            V. Spreadsheets
                A. Formatting
                B. Graphics
                C. Functions/formulas
                  1. Date/time
                  2. Statistical
                  3. Nested
                  4. Absolute references
                  5. Other
                D. Linking and consolidating
                E. Printing
                F. Other features
              VI. Database
                  A. Designing
                    1. Tables
                    2. Forms
                    3. Queries
                    4. Reports
                  B. Modifying
                    1. Tables
                    2. Forms
                    3. Queries
                    4. Reports
                  C. Relationships
                  D. Printing
                  E. Other features
                VII. Presentation Software
                    A. Design presentation
                    B. Customize presentation
                      1. Graphics
                      2. Animation
                      3. Chart/table
                      4. Other techniques
                    C. Printing
                    D. Other features
                  VIII. Data Integration
                      A. Linking
                      B. Embedding
                      C. Sharing
                      D. Other
                    IX. Internet Data Applications
                        A. Hyperlinks
                        B. Integrate resources
                        C. Others
                    Go to Description    Go to top of Competencies    Go to top of Outline