powered by
Center for Curriculum and Transfer Articulation
Advanced Computer Usage and Applications
Course: BPC210

First Term: 2018 Fall
 Lec + Lab   3.0 Credit(s)   4.0 Period(s)   4.0 Load  
Subject Type: Occupational
Load Formula: T


Description: Advanced application 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. 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)
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. 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
 
MCCCD Governing Board Approval Date: 11/28/2000

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.