Dominican University – Brennan School of Business
FIN490/MGMT490 : Special Topics in Management & Finance
Fall 2017

Name:

James W Miller (Jim)

Anne Drougas

Phone:

847-530-0550 (cell)

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

Office:

 

Fine Arts 207

Fine Arts 219

Email:

jmiller@dom.edu

adrougas@dom.edu

Office hours:

By appointment

By appointment & M 3-4, W 5-6, F 12-1.

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 2013, and Adobe Dreamweaver, during this course. R and SPSS may 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 and this will be demonstrated in the first class. 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

20

 

A

93 -100

Online Discussions

30

 

A-

90-92.9

Homework and Quizzes (12 x 20)

240

 

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. Attendance in all classes (3 per week) is required with the following exceptions: You are allowed three unexcused absences. You can be excused if you send the instructor an email before the class starts. On each unexcused absence after three, your grade will be reduced by 5%.


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 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. Exception: A few assignments will be done in teams in class. You can work with members of your team on these assignments.

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 24 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 (A full course calendar is available online via CANVAS)

Date

 

Topic

Week #1
Mon., Aug 28th –
Fri., Sept. 1nd

 

Introduction and Project Management

Week #2
Wed., Sept. 6th –
Fri., Sept. 8th

 

Learn Project Management Concepts and use Microsoft Project
Monday: Sept. 5th: No Class LABOR DAY

Week #3
Mon., Sept. 11th –
Fri., Sept. 15th

 

Complete Project Mangement Unit. Begin Excel and Personal Finance.

 

Week #4
Mon., Sept. 18th –
Fri., Sept. 22rd

 

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

Week #5
Mon., Sept. 25th –
Fri., Sept. 29th

 

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

Roth vs. Traditional IRA

Week #6
Mon., Oct. 2rd –
Fri., Oct. 6th

 

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

 

Week #7
Mon., Oct. 9th –
Fri., Oct. 13th

 

Midterm. Break even and financial planning

Week #8
Mon., Oct. 16th –
Wed., Oct. 18th

 

Databases. SQL,R, SPSS, Watson
Friday: Oct. 21st: No Class – LONG WEEKEND

Week #9
Mon., Oct. 23th –
Fri., Oct. 27th

 

Databases. SQL,R, SPSS, Watson

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
Mon., Oct. 30st –
Fri., Nov. 3th

 

Databases. SQL,R, SPSS, Watson

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

Week #11
Mon., Nov. 6th –
Fri., Nov. 10th

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #12
Mon., Nov. 13th –
Fri., Nov. 17th

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #13
Mon., Nov. 201st

 

Read about cloud computing.  Build your own website (Weebly or Dreamweaver) Wed - Sunday: No Class – THANKSGIVING

Week #14
Mon., Nov. 27th –
Fri., Dec. 12nd

 

 Continue to Build web site and study cloud computing

Week #15
Mon., Dec. 4th –
Fri., Dec. 8th

 

Cover special advanced topic and review for final.

Week of Dec. 11th

 

FINAL EXAM WEEK

Please note that the course schedule and outline may change at the discretion of the instructor. Please attend class regularly to be updated on the status of lecture material. Also, please check the syllabus online for updates and links to datasets used for classroom simulations! Please allow me to make adjustments as circumstances arise.

 

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

2017 - 2018 Academic Calendar Fall 2017

August 28 First Day of Classes; Last day to apply to graduate Fall 2017

September 4 Labor Day - No Classes

September 5 7:00PM deadline for adding/dropping undergraduate classes

September 12 6:30PM deadline for adding/dropping graduate classes

September 12 Last day to declare satisfactory/fail grade option for undergraduate classes

September 26 Caritas and Veritas Day (class schedule suspended)

September 26 Last day to declare course intensification option for undergraduate classes

October 20-22 Long Weekend (no undergraduate classes)

November 8 Last day to withdraw from fall semester courses

November 22-26 Thanksgiving Vacation

December 9 Last day of undergraduate classes

December 11-16 Undergraduate Final Examinations

December 16 Last day of graduate classes

December 19 Final Grades due at noon for all classes