BAD 220 ADVANCED COMPUTER BUSINESS APPLICATIONS (2)

Summer 1 2009

 

Instructor:       Janine M. Smuda

Phone:             Dom: (708) 524-6997 ext 1333 Work: 847-653-7152

Email:              Jsmuda@dom.edu or Janine_Smuda@yahoo.com or JSmuda@coletaylor.com      

Office hours:   By appointment only.

 

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:                T&R    6:30 – 9:30pm

 

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 utilize Excel to work with external data.

Ø  Effectively use Pivot Tables to analyze data.

Ø  Effectively utilize Access and database concepts to analyze data.

Ø  Demonstrate knowledge of Project Management techniques.

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

 

 

 

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/Presentations:  42%

                                    Assignments:               52%

                                    Class Participation:     6%

 

                                    Total Points = 179

 

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

-    Working with external data

-    Protection

-    Pivot Tables

 

 

 

2.      Microsoft Access

-    Creating and maintain basic databases

-    Understanding basic database logic

-    Queries

 

3.      Microsoft Project 2003 

-    General Project Management Terminology and concepts

-    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 

4.       Accounting Software

 

-     Creating a company

-    Lists

-    Bank accounts

-    Registers

-    Sales and invoices

-    Memorization

-    Receiving payments

-    Making deposits

-    Analyzing financial data

 

 

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.