powered by
Center for Curriculum and Transfer Articulation
Post-Advanced Computer Usage and Applications
Course: BPC250

First Term: 2004 Spring
 Lec + Lab   3 Credit(s)   4 Period(s)   3.7 Load  
Subject Type: Occupational
Load Formula: S


Description: Post-advanced applications of software for business and personal computers including word processing, spreadsheet, database, and presentation. Includes integration of applications and Internet



MCCCD Official Course Competencies
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)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.
 
MCCCD Official Course Outline
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
 
MCCCD Governing Board Approval Date:  2/24/2004

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.