BAD 220 ADVANCED COMPUTER BUSINESS APPLICATIONS (2)

SPRING 2007

Instructor: Gary Wojciechowski

Phone: (708) 524-6997 x1356

Office hours: M: 5:30-6:15pm. In the Cyber Café. Please try and make an appointment.

Course Details:

The main objective of this course is to increase the student’s ability to use personal computer software as a tool for applied coursework and in business. The course covers advanced topics using spreadsheets, statistical packages, and business application software. It emphasizes a hands-on approach and encourages the student to experiment. Class meetings will be a mix of lecture, discussion, and hands-on computer work. Assignments will make use of “mini-cases” to apply software tools to business problems. A group presentation may be assigned time permitting.

Pre-requisites: Math 120, CIS 120 or equivalent

Class Times: M 6:30-9:30pm

Textbook: No textbook is required.

Blackboard: All files required for the class will be placed on blackboard. All students are required to have a Blackboard account and enroll in the course. Also, a Dominican University E-mail address is required. Please see the Computer Lab aid to set one up if you do not already have one.

Attendance: This is a “hands-on” course in which you learn and practice skills in class time. You are responsible for all material covered in class. If for some reason you cannot attend, you must contact me. Your attendance will also count towards class participation.

Grading: Exams: 40%

Assignments: 50%

Class Participation: 10%

Exams will be announced at least one week in advance.

Assignments are due by the start of class time on the due date.

All assignments must be submitted as print copy in person.

Late Penalties: 25% penalty if one class late. No credit if more than one class late.

These penalties do not apply if you have a genuine excuse and have contacted me before the due date.

All assignments must be done individually, unless it is a group assignment. Turning in another

person’s work as your own is not permitted; all those involved in copying are at risk of receiving a

zero on the assignment or exam, or getting an F for the entire course.

TOPICS OF DISCUSSION

1. Advanced Excel

- Overview of Excel formatting, including Headers and Footers

- Creating references

- Naming cells, spreadsheets

- Functions –general functions, and financial functions such as PMT, PV and FV

- Data tables – one input and two input, and “what if” analysis

- Scenarios

- Goal seek

- Solver

- Macros

- Protection

- Pivot Table

2. Microsoft Project 2003

- Introduction to Microsoft Project 2003 and overview of formatting

- Flowcharts and Algorithms

- Organizational Charts

- Project schedules

i. Timelines

ii. Gantt Charts

iii. Pert Charts

- Report generation

3. Quick Books

- Creating a company

- Lists

- Bank accounts

- Registers

- Sales and invoices

- Memorization

- Receiving payments

- Making deposits

- Analyzing financial data

5. SPSS or Minitab

- Mean

- Standard deviation

- Correlations

- Descriptive statistics

- Confidence Intervals

- Graphs and histograms

- Distributions

6. Discuss new terminologies and latest Computer Application software packages

OTHER NOTES OF INTEREST:

The final letter grade assigned will be based on the scale:

A 93-100%

A- 90-92.9%

B+ 87-89.9%

B 80-86.9%

C+ 77-79.9

C 72-76.9%

C- 70-71.9%

D 60-69.9%

F 59.9-0.0%

There are a number of textbooks that you can refer for the class. However, taking notes and studying the handouts should be sufficient. Here is the list of reference books.

· Using Microsoft Excel 2003

By Patrick Blattner

· Microsoft Office Excel 2003 – Inside Out

By Craig Stinson and Mark Dodge

· Accessing and Analyzing data with Mircosoft Excel

By Paul Cornell

· Quickbooks in the Classroom

By A.L. Craig