Course:  ITSC 1309 INTEGRATED SOFTWARE I

BCIS 1301 MICROCOMPUTER APPLICATIONS

COSC 1301 MICROCOMPUTER APPLICATIONS

 

Textbooks & Materials:  MICROSOFT OFFICE 2003, INTRODUCTORY CONCEPTS AND TECHNIQUES, WINDOWS XP EDITION, (WORD 2003, EXCEL 2003, ACCESS 2003, POWERPOINT 2003); Second Edition, Gary B. Shelly, Thomas Cashman, and Misty Vermaat. Course Technology Publishing.

 

Two  3 1/2 in. High Density Diskettes or Flash Drive

Three Packages of Test Answer Sheets, Form Number 19641

 

Credit:  3 Credit Hours (3 Lecture, 1 Lab)

Description:  This course provides a working knowledge of microcomputers and various prepackaged software applications.  Hardware and software selection, integration, and implementation are included in this course.  Specific emphasis is placed on business applications, including word-processing, spreadsheets and databases, among others.  Keyboarding skills are recommended. Lab required.

 

Outline:

 

I.                     Introduction to Computers

A.      Micros and Personal Computing

B.       Meet Your Microcomputer System

C.       Concepts and Terminology

 

II.                   The Operating Environment

A.      An Introduction to Windows XP

1.        Windows XP:  Fundamentals

2.        Working with Windows XP

3.        File and Disk Concepts

4.        Using WordPad and other Accessory Programs

5.        Increasing Productivity using Windows XP

 

III.                 Presentation

A.      Fundamentals of PowerPoint 2003

B.       Creating a Presentation using PowerPoint 2003

 

IV.                Word Processing

A.      Microsoft Word 2003:  Fundamentals

B.       Creating an announcement, business letter, resume, and term paper

C.       Formatting Commands

D.      Editing and Proofing Tools

E.       Printing and File Management

F.       Advanced Features

 

V.                  Electronic Spreadsheet

A.      Excel 2003:  Fundamentals

1.        Building a Worksheet

2.        Formulas, Functions, Formatting, and Creating Charts

B.       Enhancing a Worksheet and Chart

C.       Increasing Productivity

D.      Managing a Spreadsheet

E.       Solving “what if” problems

 

VI.                Database

A.      The Fundamentals of Access 2003:  Fundamentals

1.        The Access 2003 Environment

2.        Data File Creation

B.       Managing and Organizing Data with Access 2003

C.       Querying Information from a Database

D.      Creating and Using Forms and Reports

E.       Managing Files and Advanced Topics

 

Grading for the Course

 

Test 1                                       Introduction and Windows XP              1/6

Test 2                                       Word-processing (Word 2003)            1/6

Test 3                                       Spreadsheet (Excel 2003)                     1/6

Final Exam                               Access 2003 and Comprehensive         1/6

Chapter quizzes                                                                                    1/6

Homework assignments (Lab work)                                                      1/6

                                                                                                            100%