BAD 220 ADVANCED COMPUTER BUSINESS APPLICATIONS
Fall 2013

INSTRUCTOR:

James W Miller (Jim)

PHONE #:

847-530-0550 (cell)

email usually works faster

EMAIL:

jmiller@dom.edu

Usually well within 24 hours

Office Hours:

By appointment (Fine Arts 200)

 

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. 

Pre-requisites:   Math 120, CIS 120 or equivalent

Class Times:                Tuesday and Thursday 3:30 – 4:45pm Room: Parmer 428

Textbook:                     No textbook is required

 

Expected Learning Outcomes:

Upon completion of this course, students should be able to:
-   Effectively utilize common Excel financial functions and data tables

-   Effectively utilize Excel for decision analysis such as scenario/what-if analysis and goal seeking analysis

-   Effectively construct Excel macros for appropriate common applications

-   Effectively use data and text manipulation and summarization functions (subtotal, right, left, mid, concatenate, if, sum, count)

-   Demonstrate effective use of MS Project to construct flowcharts, organizational charts, and project schedules manifested in Gantt charts, PERT charts, and Network Diagrams

-  Effectively generate reports and presentations of project information captured and maintained in MS Project.

-  Effectively utilize QuickBooks to maintain a company’s accounting information including vendor lists, customer lists, financial accounts, sales and invoice records, payment processing and financial data analysis


- Demonstrate the ability to create a business web site.

 

All files required for the class will be placed in the Dominican Learning Mangement System.. A Dominican University E-mail address is required to use this system.  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, please contact me by email before the class. 


Grading:                       Exams:                         40%
Assignments:               60%

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

A:

93-100%

A-:

90-92.9%

B+:

87-89.9%

B:

83-86.9%

B-:

80-82.9%

C+:

77-79.9%

C:

72-76.9%

C-:

70-71.9%

D:

60-69.9%

F:

  0-59.9%

Course Topics:

  1. Advanced Excel
  2. Microsoft Project
  3. Quick Books or other accounting software
  4. Building Business Web Site
  5. Discuss new terminologies and latest Computer Application software packages

OTHER NOTES OF INTEREST: 
Exams are always announced in advance. Exams must be taken on the scheduled day and time of the exam. Any exception requires arrangements in advance.


Assignments are to be submitted to Blackboard by the due date and time. Late assignments will be penalized by up to 10%. No points will be awarded to assignments submitted later than one week after the due date. 

Assignments will not be accepted via email.  Assignments must be submitted to Blackboard. If printed copy is required for an assignment, the print out must be submitted at the start of the class in which the printed copy is due.


Students who miss a class are responsible for obtaining notes from a classmate on what was covered in the class. I don't use scripts for lectures but as much softcopy as possible will be posted in our Learning Management System.  It is also the responsibility of the student to find out what assignments were given in any class that the student was absent.  Absence from class is NOT a valid reason for late assignments.  Assignments received after the due date and time are considered late, regardless of absence, in fairness to the other students in the class.


All assignments are to be completed by one person individually unless otherwise specified.  Group work on assignments not specified as group assignments results in zero points being awarded to all members of the group.  Unauthorized group work is also considered cheating and will be reported to the Dean of the Brennan School of Business. However, you can ask for my help via email, in class, or by arrangement in the Tech Center. Also, you can ask each other questions as long as you each do your own work and completely understand all the work you have done. The line between "help" and "doing" the other person's work" is when you take control of the mouse.

Note: Plagiarism will not be tolerated and may result in an automatic failure (F) for the semester. 

Please take the time to read the web page below that provides details of Dominican’s Academic Integrity policy.   http://domweb.dom.edu/library/Crown/plagiarism.htm
Also, please see the following website, which discusses how plagiarism is being combated in our Internet enabled age http://www.plagiarism.org/.

**This syllabus is subject to change**