CISM 2201 Fundamentals of Computer Applications
Generic Example of a Syllabus
Abraham Baldwin Agricultural College

Instructor: Amy P. Willis

Office:   Conger 222A
Phone:   229-391-4861
E-mail:   apwillis@abac.edu
Website: http://www.abac.edu/apwillis
 

COURSE DESCRIPTION

A course designed to assure a basic level of computer applications literacy to include word processing, spreadsheet, presentation software, database, LAN, e-mail, and Internet utilization.

Expected Student Outcomes:

 Upon completion of the course, the student will:

 

  1. understand how information technology aids business decision making. 
  2. identify the components of a typical microcomputer system. 
  3. identify and describe the most widely used general microcomputer software applications, the difference between application software and system software and understand the role of operating system software. 
  4. demonstrate a knowledge of computer hardware and software, including “multimedia” and be familiar with the legal, ethical, and privacy issues relating to the use of hardware and software in a business environment. 
  5. be familiar with computer networks and know the basic components of communications system to include e-mail, user interfaces, communications and the Internet. 
  6. effectively use application software which includes:
    1. word processing
    2. spreadsheet
    3. database management
    4. presentation software

 

Teaching Methods:

  1. Students should plan to take notes, however, all material can be found in the texts or readings. Discussion is encouraged using the Bulletin Board and private e-mail
  2. Assignments: Review Assignments, Case Problems, and readings will be periodically assigned to help support and supplement material found in the text. These assignments may require the application of various software packages.
  3. Quizzes: scheduled quizzes will be given to help ensure students stay up with assigned material.
  4. Exams: The exams will be closed book/note and will test assigned readings and material discussed in class or on-line.
  5. Internet: All material will be distributed on the Internet. Class notes, instructional material, and student assignments will be posted on 'the net' in a class Website (WebCT).

 

Text/Materials:
Text : Carey/Zimmerman/Shaffer/Adamski/Finnegan, New Perspectives on Microsoft Office 2003 – First Course, Second Edition, Course Technology, 2006.

Software: Microsoft Office 2003 Suite, Internet Explorer, and Windows XP will be used. Instructor will provide information on how to use these packages.

SAM 2003 access code.  You must purchase this from the bookstore. Do not order this on-line from publisher.

 

Course Policies:
Missed /Tests: The student is responsible for keeping track of tests and due dates for assignments posted on the calendar. There are no makeup exams.  Any uncoordinated, unexcused missed exam will result in a score of 0 for that exam.  If you have a doctor's excuse, see me.  You must call/e-mail the instructor within 24 hrs if you are unable to take an exam.

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the college. For more information refer to the "Academic Dishonesty" policy in the ABAC Catalog.

Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as outlined here, or which will require academic accommodations, please notify the instructor as soon as possible.

Prerequisite:

This course covers a full semester and no prerequisites are necessary.

 

 **This course is required in Area F of the University System of Georgia Core Curriculum. You should not expect it to transfer to a School of Business in a senior college or university within the system unless your grade is a “C” or better.

 

Grading:

Letter grades will be determined using a standard  point evaluation with only tests counting toward the final grade.
 

Course Outline for Full

A more detailed outline will be available in WebCT on the calendar.

 

Course Outline for Full Semester

Weeks

Topic

Quizzes

Exams

1

Introduction to Course/WebCT

 

 

1

SAM setup, review WebCT Vista

 

 

1

Concepts & Quizzes

Concepts

Train & Quiz

2

Windows XP: Exploring the Basics

WinXP Tutorial

T&Q

2

Managing Your Files

FM Tutorial

 

2

Browser Basics Overview

BEB Tutorial

T&Q

2

Exams #1-3

 

Exam #1-3

3

Using Common Features of Office

Common Features

 

3

Word 2003: Creating a Document

Word Tutorial 1

T&Q

3

Word 2003: Editing and Formatting a Document

Word Tutorial 2

T&Q

3

Word 2003: Creating a Multiple-Page Report

Word Tutorial 3

T&Q

3

Word 2003: Desktop Publishing

Word Tutorial 4

T&Q

4

Exam #4 Word Tuts 1-4

 

 Exam #4

4

Excel 2003: Using Excel to Manage Data

Excel Tutorial 1

T&Q

4

Excel 2003: Working with Formulas and Functions

Excel Tutorial 2

T&Q

5

Excel 2003: Developing a Professional-Looking Worksheet

Excel Tutorial 3

T&Q

5

Excel 2003: Working with Charts and Graphics

Excel Tutorial 4

T&Q

5

Exam #5 Excel Tuts 1-4

 

Exam #5

6

Access 2003: Introduction to Microsoft Access 2003

Access Tutorial 1

T&Q

6

Access 2003: Creating and Maintaining a Database

Access Tutorial 2

T&Q

6

Access 2003: Querying a Database

Access Tutorial 3

 T&Q

6

Access 2003: Creating Forms and Reports

Access Tutorial 4

T&Q

7

Exam #6 Access Tuts 1-4

 

Exam #6

7

PowerPoint 2003: Creating a Presentation

PPT Tutorial 1

T&Q

7

PowerPoint 2003: Applying and Modifying Text and Graphic Objects

PPT Tutorial 2

T&Q

8

Exam #7 PowerPoint Tuts 1-2 & Quizzes

 

Exam #7

Final Exam

Final Exam (Comprehensive) See Review Quiz

 Per 2 Final Wednesday Exam at 8:00 am -10:00am

--

Exam #8