Computer Applications-S00

Catalog Descriptions of Course

This course provides "hands-on" computer literacy by developing specific skills in the types of standard application software used in most organizations. The instructions includes the introduction of a graphical user interface (GUI), computer word processing, spreadsheets, and database management along with graphics, telecommunications and other pertinent topics such as computer ethics. Although Computer Information Systems majors can benefit from this course, it is especially recommended for students in other majors.

Objectives

The student will be able to use operating system and software.
The student will be able to develop proficiency in using word processing, spreadsheets and database management program along with some graphics.
The student will be able to demonstrate proficiency in the use of graphical user interface (GUI).
The student will be able to analyze and solve a specific information need through the selection of an appropriate application package.

Outline of Course Content

Introduction (20 %)

Using computers: computer system basics, user interface, operating system
Software: software basics, systems software, applications software
Computer files/data storage: data, information, files, storage technologies
Computer architecture: digital architecture, memory, CPU, input/output

Word Processing (15 %)

Word Processing basics: creating and editing a document
Word Processing features: advanced editing, text formatting, printing.
Advanced Word Processing: convenience features, page breaks, dictionaries, form letters, large documents, spell checks, style checks.

Spreadsheets (20 %)

Electronic spreadsheet basics: worksheet, data entry/editing. commands.
Spreadsheet features: advanced editing, worksheet appearance, formula recalculation, printing.
Advanced spreadsheet: special feature/functions

Database Management (20 %)

Database management basics: record management, files, table, query, report generation, forms.
Database management systems: concepts, relational DBMS, input screen formatting, other features.

Presentation Package (10 %)

Creating a slide show, templates, importing objects, transitions, effects.

Other Applications (15 %)

                    The Internet: How it works, the web browsers
                    Telecommunications: Local Area Networks, Network hardware and software
                    Data Security and Control: Viruses, Computer crime, Data security and risk     management, backup

Textbook and Disks

Parsons, June Jamrich and Oja, Dan. Computer Concepts. Third Edition. Course Technology ? ITP.

Shelly, Gary, Cashman, Thomas and Vermaat, Misty. Microsoft Office 97 Introductory Concepts and Techniques. 1998. Course Technology ? ITP.

Barron, Ann and Lyskawa, Chet. Microsoft Windows NT 4 Workstation Illustrated Brief Edition. 1997. Course Technology ? ITP.

Disks: 5-6 high density 3.5’ floppy disks to work on the IBM PC’s in the lab (and elsewhere) to accomplish a series of assignments.