Dominican University – Brennan School of Business
Bad 492/491: Special Topics in Management & Finance
Spring 2017

Name:

James W Miller (Jim)

Anne Drougas

Phone:

847-530-0550 (cell)

847-868-6652 (cell)
708-524-6938 (office)

Office:

 

by email and cell phone

Fine Arts 219

Email:

jmiller@dom.edu

adrougas@dom.edu

Office hours:

electronic

By appointment

REQUIRED RESOURCES & TEXTBOOK INFORMATION

The following information will help you prepare for your first session. If you are not purchasing the text from Dominican University, please be sure you possess the correct version of the text.

Required Text:

There are no required books for this course. During the course, it is possible that we will recommend that you subscribe to safaribooksonline.com for 1-2 months.

Software:

You will need to use software on the Dominican Server ACATSNEW. This includes Excel 2016, Microsoft Access 2016, Microsoft Project 2016, and Adobe Dreamweaver, during this course. R and R Studio will also be used. We intend to run the course in a way that will not require you to pay any software licensing fees.    

Access to Software:

You are required to access the Dominican Server ACATSNEW each week. You can do this using Remote Desktop from machines at Dominican. You might be able to install Remote Desktop on your own machine. If you are successful, you will be able to work on this course from home. If you are not successful, you will need to do most work in this course in the Dominican Tech Center.

Canvas:

All files required for the class will be placed in Canvas. In order to use Canvas, you must be registered for this course. If you have trouble accessing this course in Canvas you can submit at help ticket at http://helpdesk.dom.edu/ or you can email me at jmiller@dom.edu.

COURSE DESCRIPTION & GOALS

The main goal of this course is to increase the student’s ability to use software as a tool in business and finance. A secondary objective is to expose the student to basic concepts in Management Information Systems such as Project Management; Database Management; Cloud Computing; and Big Data. 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. Canvas Modules will contain a mix of lecture (videos), reading, discussion, and hands-on computer work. Hands on work will include Excel time value of money functions, pivot tables, and use of macros. Simulations and advanced techniques in financial modelling and use of large sets of data will also be included.

COURSE OBJECTIVES

Upon successful completion of this course, a student should be able to:

 
COURSE GRADING & DISTRIBUTION

Your grade will consist of the following components:

Item

Points

 

Grade

Percentage

Attendance

0

 

A

93 -100

Online Discussions

30

 

A-

90-92.9

Homework and Quizzes (13 x 20)

260

 

B+

87-89.9

Exams 2 X 40

80

 

B

83-86.9

Projects

30

 

B-

80-82.9

Total Possible Points

400

 

C+

77-79.9

 

 

 

C

72-76.9

 

 

 

C-

70-71.9

 

 

 

D

60-69.9

 

 

 

F

Below 60

Attendance: You are required to log into this course several times each week in order to watch videos, participate in online discussions, and complete your assignments and exams.

Online Discussions: In some weeks in this course, you will be required to participate in online discussions. During those weeks, you are required to post at least three times on three separate days to each Discussion. (Example: In a week with two Discussions, you must post at least six times). One of your postings in each Discussion should be your answer to the question(s). The other postings should be comments, questions, and responses to your fellow students.
Assignments: Assignments are generally not accepted via email.  Assignments must be submitted to Canvas. If you have difficulty with Canvas logistics, please send Jim Miller (jmiller@dom.edu)an email explaining the problem.

All assignments are to be completed by one person individually.  Group work on assignments results in zero points being awarded to all members of the group.  However, you can ask for our help via email. 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 or keyboard or provide copies of your work.

Exams: Exams will consist of multiple choice, definitions, short answers, and problems. A part of the exam may be distributed as a project. Students are expected to follow the directions and use appropriate technology. It is an individualized exam, regardless of whether portions of the exam are provided as a take-home. Students may not consult with each other or solicit help from anyone (except the instructors). No substitute exams will be administered without prior notification and instructor consent.

 

SUGGESTIONS FOR SUCCESS IN A TEAM-TAUGHT COURSE
 
Although the responsibility for learning rests upon the student, we are always available and provide assistance. Each student should realize that this course can be very rigorous and requires assignments. Because we want every student to be successful, we have provided suggestions and resources for the students to use to increase the likelihood of success.

POLICIES ON REVIEWING YOUR GRADED ASSIGNMENTS

When exams/cases/projects are graded in Canvas, you have seven days from the grading timestamp in Canvas or 36 hours before the grade for the course is due to the registrar (whichever comes first) to review the work with the instructor by appointment. Before the expiration of the deadline, a written extension may be requested by the student. If granted, the request will be for as many days as the instructor feels are warranted in the circumstances and will apply only to those students whose requests for extension have been granted.

ACADEMIC INTEGRITY

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

All your work must be your own unless collaboration has been authorized. If collaboration is authorized, you must acknowledge the collaboration in writing. Your grade will be based in large part on the originality of your ideas and your written presentation of these ideas. Presenting as one's own the words, ideas, or expression of another in any form is cheating through plagiarism.

Warning: Plagiarism will not be tolerated and may result in an automatic failure (F) for the semester. Plagiarism will not be tolerated and the claim of ignorance is no excuse. Those found plagiarizing may fail the course. Collaboration with other students is not permitted without explicit permission from the instructor. This is a form of plagiarism. Roommates and spouses taking the same course should be particularly careful.

Students with Disabilities: Students requesting classroom accommodations must first register with the Dean of Students. If you have documentation from our Disability Support Offices, please provide me with paper during the first week of classes.
COURSE CALENDAR. Subject to change. (A full course calendar is available online via CANVAS)

Date

 

Topic

Week #1
Wed., Jan 11th–
Tues, Jan 17

 

Introduction and Project Management

Week #2
Wed.,Jan 18
Tues, Jan 24

 

Learn Project Management Concepts and use Microsoft Project

Week #3
Wed, Jan 25–
Tues Jan 31

 

Complete Project Mangement Unit. Begin Excel and Personal Finance.

 

Week #4
Wed, Feb 1 –
Tues, Feb 7

 

Excel Personal Finance.  Use PMT function for car payments.  Project net worth at age 65.  Use absolute addressing and goal seek.

Week #5
Wed, Feb 8 –
Tues, Feb 14

 

Advanced Excel.  Charts, Transpose, Macros. Attend Caritas and Veritas Symposium on Tuesday

Roth vs. Traditional IRA

Week #6
Wed, Feb 15–
Tues, Feb 21

 

Advanced Excel.  Charts, Transpose, Macros, If-then, sumif, macros, solver

 

Week #7
Wed., Feb 22–
Tues., Feb 28

 

Midterm. Break even and financial planning

Week #8
Wed., March 1–
Wed., March 14

 

Databases. SQL,R, SPSS, Watson
Mid Semester Break March 5-11

Week #9
Wed., March 15
Tues, March 21

 

Databases. SQL,R

Import a cvs file into Excel. Import data from a database of stocks located on Dominican SQL Server. Use solver for portfolio optimization

Solve another problem from book, Will use Pivot Table. Cover part 1 of 3 of DBMS concepts and examples this week.

Week #10
Wed.,March 22 –
Tues., March 28h

 

Databases. SQL,R, SPSS, Watson

Work on a big problem that uses SQL Server and Pivot Tables

Week #11
Wed, March 29–
Tues, April 4

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #12
Wed, April 5–
Tues, April 11

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #13
Wed, April 12 -

Saturday April 22

 

Read about cloud computing.  Build your own website (Weebly or Dreamweaver)

Easter Break

Week #14
Sun, April 23–
Fri., April 28

 

 Continue to Build web site and study cloud computing

Week #15
Sun April 30–
Sat May 6

 

No Final Exam

 

 

 

Please note that the course schedule and outline may change at the discretion of the instructors.

For your convenience, here is a copy of the Registrar's Academic Calendar.

Spring 2017

January 11 First day of classes - follow Monday schedule; Last day to apply to graduate Spring 2017
January 16 Martin Luther King, Jr. Day - No Classes
January 19 7:00PM deadline for adding/dropping undergraduate classes
January 26 7:00PM deadline for adding/dropping graduate classes
January 26 Last day to declare satisfactory/fail grade option for undergraduate classes
February 9 Last day to declare course intensification option for undergraduate classes
March 5-11 Mid semester vacation
March 30 Last day to withdraw from spring semester classes
April 13-16 Easter Vacation
April 28 Last day of undergraduate classes
April 29 Saturday and schedule conflict undergraduate final exams
May 1-May 4 Undergraduate Final exams
May 4 Last day of graduate classes
May 5 Final grades due at noon for graduating students
May 6-7, 2017 Commencement Weekend
May 9 Final grades due at noon