BAD 220 ADVANCED COMPUTER BUSINESS APPLICATIONS (2)

Fall 2008

 

Instructor:       Pete Peterson

Phone:             Dom: (708) 524-6889

Email:              ppeterson@dom.edu

Office / hours: Lewis 003D – IT Lab, basement of Lewis Hall / as available

 

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:                Tu – Th  10:00 – 11:15am

 

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

Ø  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

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

Ø  Employ basic computer security assessment techniques to computer workstations

 

 

myDU LMS:               All files required for the class will be placed on the Learning Management System (LMS) of myDU.  All students should have access to this information with your PIN.  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%

 

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 2003 

-     Introduction to Microsoft Project 2003 & 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

 

4.       SPSS or Minitab

 

-    Mean

-    Standard deviation

-    Correlations

-    Descriptive statistics

-    Confidence Intervals

-    Graphs and histograms

-    Distributions

 

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. 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. No points will be awarded to assignments submitted later than one week after the due date.  Sorry, NO EXCEPTIONS!

·                Assignment will not be accepted via email.  Assignments must be submitted as print copy in person, or via the course Blackboard website as dictated in the actual assignment requirements

·                Students who miss a class are responsible for obtaining notes from a classmate on what exactly was covered in the class.  The instructor does not use lecture notes for this class and so has none available for students.  It is also the responsibility of the student to find out what assignments were distributed for any class that the student was absent.  The course website at http:blackboard.dom.edu can aid in this process.  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.

 

·                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 By Craig Stinson and Mark Dodge

·                Accessing and Analyzing data with Mircosoft Excel – By Paul Cornell

·                Quickbooks in the Classroom – By A.L. Craig