Maricopa Community Colleges  BPC110   20034-99999 

Official Course Description: MCCCD Approval: 12-10-2002

BPC110  2003 Summer I - 9999

L+L  3.0 Credit(s)  4.0 Period(s)  3.7 Load  Occ

Computer Usage and Applications

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.

Prerequisites: None.

 

Course Attribute(s):

General Education Designation: Computer/Statistics/Quantitative Applications - [CS]

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:

 

BPC110  2003 Summer I - 9999

Computer Usage and Applications

 

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)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:

 

BPC110  2003 Summer I - 9999

Computer Usage and Applications

 

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

 

Go to Description    Go to top of Competencies    Go to top of Outline