BAD 220-02 ADVANCED COMPUTER BUSINESS APPLICATIONS

Fall 2009

 

INSTRUCTOR:

Dr. Elias A. Demetriades

PHONE #:

312-301-1025

 

EMAIL:

edemetriades@dom.edu

Office Hours:

By 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. 

 

Pre-requisites:   Math 120, CIS 120 or equivalent

 

Class Times:                 M - W  3:30 – 4:45pm

 

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

Ø   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 Peachtree software to maintain a company’s accounting information including vendor lists, customer lists, financial accounts, sales and invoice records, payment processing and financial data analysis

Ø  Effectively utilize a statistical package to analyze data means, deviation measures, correlations, distributions, descriptive statistics, and graphical presentations

 

 

myDU:                          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%

 

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 

-     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 Tables

 

 

2.     Microsoft Project  

-     Introduction to Microsoft Project & overview of formatting

-    Flowcharts and Algorithms

-    Organizational Charts

-    Project schedules

i.      Timelines

ii.     Gantt Charts

iii.    Pert Charts

-     Report generation 


3.      Peachtree Accounting Software

 

-     Creating a company

-    Lists

-    Bank accounts

-    Registers

-    Sales and invoices

-    Memorization

-    Receiving payments

-    Making deposits

-    Analyzing financial data

 

4.      SPSS or Minitab

 

-    Mean

-    Standard deviation

-    Correlations

-    Descriptive statistics

-    Confidence Intervals

-    Graphs and histograms

-    Distributions

 

 

OTHER NOTES OF INTEREST: 

·                Exams are always announced in advance. Exams must be taken on the scheduled day and time of the exam. Failure to do so must be accompanied by a valid and verifiable excuse and advance notification.


·                Assignments are to be submitted at the beginning of class time on the scheduled due date. Late assignments will be penalized by 10% each day beyond the due date/time up until one week after the due date.


·                Students who miss a class are responsible for obtaining notes from a classmate on what exactly was covered in the class.  It is also the responsibility of the student to find out what assignments were distributed for 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. 

 

 

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

 

 

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/.


**NOTE ANY PART OF THIS SYLLABUS IS SUBJECT TO CHANGE AT ANY TIME AS THE SITUATION WARRANTS**