MANSFIELD UNIVERSITY
CIS 2203-190 COURSE SYLLABUS

revised 4/13/2003

GENERAL INFORMATION

Course number: CIS 2203-190
Credit/Contact hours: 3
Term: Summer I-A, May 12 - May 30, 2003
Course title: Software for Business Applications
College website: www.mansfield.edu

INSTRUCTOR INFORMATION

Instructor name: John Phillips
Instructor office location: Elliott 205 A
Instructor office hours: to be announced
Instructor telephone: 570-662-4704
Instructor e-mail address: jphillip@mnsfld.edu
Instructor website: www.programbetter.com

COURSE INFORMATION

Course Description

Advanced applications of spreadsheets, data base management systems, and graphics. Prerequisite: none

Textbook

New Perspectives on Microsoft Excel 2000 -- Comprehensive Enhanced, Parsons, Oja, Ageloff, Carey, 2001, Course Technology, ISBN: 0-619-04427-6.

Course Websites

www.programbetter.com for the syllabus and course information.

www.coursenotebook.com for the class discussion board.

Course Outline

1. Excel basics and graphical charts
2. Filtering and sorting Excel lists
3. Excel pivot tables
4. Integrating Excel with other programs and the Web
5. Excel applications and macros
6. Multiple worksheets, templates, and lookup tables
7. Data tables and reports
8. Advanced Excel topics
9. Database Management Systems

Class Schedule

This is an on-line course.

Equipment and Supplies

Access to the Internet and the Microsoft Excel 2000 software is required either using your own computer or by using a computer in the school's computer lab or library. You will need 10 diskettes.

Grading Scale and Policy

Refer to the Mansfield University Catalog for grades that can be awarded.

A >= 90%
B >= 80%
C >= 70%
D >= 60%
F < 60%

In addition, the instructor may choose to further differentiate grades with plus and minus subdivisions as outlined in the catalog.

Work Due Date Policy

Work that is completed and turned in at least one day before the due date will receive a 5% bonus added onto the score. Work submitted on the due date will recieve neither a bonus nor a penalty. Any work that is late will lose one letter grade for each day late. No excuses. Computer, server, ftp, and Internet problems will happen, therefore, make it a point to complete your work at least one day before the deadline.

Methods of Instruction

Assignments will be posted online at coursenotebook.com. Each assignment will include reading the textbook, working through chapter tutorials, and working case study problems. Each week you will take one or more online quizzes. Each quiz will be open book. A research report on Database Management Systems will be required.

Academic Integrity

It may be tempting to cheat in this class. Do not do it! You may be posting some of your work for all to view. Feel free to browse other students' posted work, on-line web sites, and other books for ideas. However, if you copy that work and you do not give credit for it, that is plagiarism. Likewise, if you discuss a quiz you have taken with another student before they take it, that is cheating. You may not do anything that gives you or another student an unfair advantage. If you are in doubt then discuss the situation with your instructor.

Withdrawal Policy for Individual Courses

The last day to withdraw from a College course with a "W" grade is published in the Academic Calendar. It is the responsibility of the student to complete and submit the necessary forms to the Registrar's Office. An official withdrawal would entitle the student to a grade of "W" in the course.

Syllabus Change Policy

The instructor reserves the right to make changes to this syllabus as the course progresses.

COURSE TIMELINE