Maricopa Community Colleges  BPC250   20042-99999 
Official Course Description: MCCCD Approval: 02/24/04
BPC250 20042-99999 L+L 3 Credit(s) 4 Period(s)
Post-Advanced Computer Usage and Applications
Post-advanced applications of software for business and personal computers including word processing, spreadsheet, database, and presentation. Includes integration of applications and Internet. Prerequisites: BPC210 or permission of instructor
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC250   20042-99999 Post-Advanced Computer Usage and Applications
1. Define and apply ethics in computer usage. (I)
2. Apply post-advanced word processing features. (II)
3. Apply post-advanced spreadsheet features. (III)
4. Apply post-advanced database features. (IV)
5. Use integrity and security techniques related to software and data. (IV)
6. Apply post-advanced features of presentation software. (V)
7. Integrate data among applications using post-advanced features. (VI)
8. Formulate and apply data to the Internet using post-advanced features. (VII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC250   20042-99999 Post-Advanced Computer Usage and Applications
    I. Computer Ethics A Privacy
        B. Security
      II. Word Processing
          A. Post-advanced formatting
          B. Online forms
            1. Designing
            2. Modifying
            3. Utilizing
          C. Macros and beginning programming for applications
            1. Designing
              a. Recording
              b. Procedures
            2. Modifying
            3. Utilizing
          D. Master document, index, and table of contents
            1. Designing
            2. Modifying
            3. Utilizing
          E. Printing
          F. Other features
        III. Spreadsheets
            A. Post-advanced formatting
            B. Graphics
            C. Post-advanced formulas and functions
            D. Macros and Visual Basic for Applications (VBA)
              1. Designing
                a. Recording
                b. VBA procedures
              2. Modifying
              3. Utilizing
            E. Formula auditing
            F. Data validation
              1. Designing
              2. Modifying
              3. Reporting
            G. Complex problem solving
              1. Designing
              2. Modifying
              3. Utilizing
            H. Scenario manager
              1. Creating
              2. Modifying
              3. Utilizing
            I. Importing and exporting files
            J. Routing and reviewing tracked changes
            K. PivotCharts and PivotTables
              1. Designing
              2. Modifying
              3. Utilizing
            L. Post-advanced charts
          IV. Database
              A. Post-advanced creation
                1. Tables
                2. Forms
                3. Queries
                4. Reports
              B. Post-advanced modification
                1. Tables
                2. Forms
                3. Queries
                4. Reports
              C. Post-advanced utilization
                1. Tables
                2. Forms
                3. Queries
                4. Reports
              D. Programming for applications
                1. Designing
                2. Modifying
                3. Utilizing
              E. Relationships
              F. Administering a database system
                1. Modifying
                2. Utilizing
                  a. Tools
                  b. Integrity features
                  c. Replication
              G. PivotTables and PivotCharts
                1. Designing
                2. Modifying
                3. Utilizing
              H. Structured Query Language (SQL)
                1. Designing
                2. Modifying
                3. Utilizing
              I. Database security
                1. Designing
                2. Modifying
                3. Utilizing
              J. Printing
              K. Other features
            V. Presentation Software
                A. Design post-advanced presentations
                  1. Graphics
                  2. Animation
                  3. Chart/table
                  4. Timings
                  5. Other techniques
                B. Modify post-advanced presentations
                  1. Graphics
                  2. Animation
                  3. Chart/table
                  4. Timings
                  5. Other techniques
                C. Utilizing post-advanced presentations
                  1. Graphics
                  2. Animation
                  3. Chart/table
                  4. Timings
                  5. Other techniques
                D. Interactive documents
                  1. Designing
                  2. Modifying
                  3. Utilizing
                E. Printing
                F. Other features
              VI. Post-Advanced Data Integration
                  A. Linking
                  B. Embedding
                  C. Sharing
                  D. Other
                VII. Internet Data Applications
                    A. Hyperlinks
                    B. Integrating resources
                    C. Others
                Go to Description    Go to top of Competencies    Go to top of Outline