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

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


Description: Introduction to business and personal computer operations and usage. Software applications for analyzing and solving business problems including word processing, spreadsheet, database, and presentation graphics



MCCCD Official Course Competencies
1. Describe the components and operations of a computer system. (I)
2. Analyze and explain social and ethical issues related to computer technology. (II)
3. Use operating system commands to facilitate and implement information management. (III)
4. Define the functions of word processing programs as used in business. (IV)
5. Analyze and apply word processing program features to create, edit, manipulate, format, print, and store common business documents. (IV)
6. Define the functions of spreadsheet programs as used in business. (V)
7. Construct, test, implement, and analyze spreadsheets that solve financial, mathematical, and statistical problems in business. (V)
8. Create and edit charts and graphs to interpret spreadsheet data. (V)
9. Define the functions of database programs as used in business. (VI)
10. Analyze, design, and create a database to extract, sort, calculate, and report business data. (VI)
11. Define functions of presentation graphics programs as used in business. (VII)
12. Design, create, and execute an artistic presentation to include graphics and animation. (VII)
13. Use the Internet as a source of information for computer- and software-related topics. (VIII)
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 Systems
   A. Computer operations
   B. Computer components
      1. Hardware
      2. Software
      3. Networking
      4. Disk handling
II. Computer Technology Issues
   A. Social
   B. Ethical
III. Operating System Commands
   A. Start-up/shut-down
   B. Disk management
      1. Initialize
      2. Format
   C. File management
      1. Save/copy
      2. Erase/delete
      3. Name/rename
      4. Directories/folders
   D. Print
IV. Word Processing
   A. Functions
      1. Input/create
      2. Edit
      3. Manipulate
      4. Format
      5. Print
      6. Store/save
   B. Analysis and applications
V. Spreadsheets
   A. Functions
      1. Input/construct
      2. Edit
      3. Manipulate
      4. Formulas/functions
         a. Financial
         b. Mathematical
         c. Statistical
      5. Print
      6. Store/save
   B. Charts and graphs
      1. Create
      2. Edit
      3. Interpret
   C. Analysis and applications
VI. Databases
   A. Design
      1. Record structure
      2. File structure
   B. Functions
      1. Input/create
      2. Edit
      3. Manipulate
         a. Extract
         b. Sort
         c. Calculate
      4. Generate reports
      5. Print
      6. Store/save
   C. Analysis and applications
VII. Presentation Graphics
   A. Design
      1. Style
      2. Graphics
      3. Animation
   B. Functions
      1. Input/create
      2. Edit
      3. Manipulate/execute
      4. Present
      5. Store/save
   C. Analysis and applications
VIII. Internet Resources
   A. Computer-related
   B. Software-related
 
MCCCD Governing Board Approval Date:  12/10/2002

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.