ITE 115

Basic Computer Literacy

NVCC COLLEGE-WIDE COURSE CONTENT SUMMARY
IST 117 - INTRODUCTION TO MICROCOMPUTER SOFTWARE (3 CR.)

COURSE DESCRIPTION

Provides a working introduction to microcomputer software, fundamentals, and applications. Includes operating systems, word processing, spreadsheet, and database software. Lecture 3 hours.

GENERAL COURSE PURPOSE

This course is designed to provide students with an introduction to the microcomputer and a working knowledge of representative commercial software packages.

ENTRY LEVEL COMPETENCIES

Students must be able to read and write at a college level.

COURSE OBJECTIVES

Upon completion of this course, the student should be able to: A. describe the typical components of a microcomputer
B. identify and discuss the four main functions of computer hardware: input, processing, output, and storage
C. identify the three important categories of microcomputer software, (word processing, spreadsheet, and database management) and explain what they do and how they work in general terms
D. use the operating system to perform disk management operations such as formatting, and copying
E. use the operating system to perform file management operations such as copying, moving, renaming, deleting and subdirectory organization
F. identify and discuss the basic activities involved in word processing
G. use a word processing program to:

1. create a document
2. input text
3.edit text
4. format a document
5. save and retrieve a document
6. print a document H. identify and discuss the basic activities involved in working with a spreadsheet
I. use a spreadsheet program to:
    1. create a worksheet
    2. input text, numbers and formulas
    3. edit text, numbers and formulas
    4. manipulate text, numbers and formulas
    5. execute spreadsheet commands
    6. save and retrieve a worksheet
    7. print a worksheet

Identify and discuss the basic activities involved in working with a database


Use a database management program to:

1. create the structure and contents of a database
2. modify and sequence the database
3. perform queries
4. create and run reports

MAJOR TOPICS TO BE INCLUDED

A. Understanding the microcomputer's typical components: input, processing, output, and storage
B. Using operating system commands
C. "Booting" the system
D. Formatting and copying disks
E. Naming, copying, deleting and renaming files
F. Basic word processing concepts
G. Inputting and editing text with a word processor
H. Formatting text with word processing software
I. Saving, loading, and printing spreadsheets
J. Basic spreadsheet concepts
K. Labels, numbers and formulas
L. Global and range commands
M. Saving, loading, and printing spreadsheets
N. Basic database management concepts
O. Organization of information and database management systems
P. Creating a database
Q. Viewing, modifying, and sorting the database
R. Performing queries
S. Creating and printing formatted reports
T. Basic presentation graphics concepts
U. Creating a slide show with text and graphics
V. Saving, editing, and viewing a slide show
W. Basic Internet concepts
X. Searching on the Internet
Y. Evaluating sites on the Internet
Z.Sending and receiving electronic mail

EXTRA TOPICS (optional) A. Evaluation and selection of microcomputer hardware and software
B. Integrated packages
 

 

 

 

BACK TO HOME PAGE