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) |
|
Office: |
|
Fine Arts 207 |
Fine Arts 219 |
Email: |
|||
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 |
|
Introduction and Project Management |
Week #2 |
|
Learn Project Management Concepts and use Microsoft Project |
Week #3 |
|
Complete Project Mangement Unit. Begin Excel and Personal Finance.
|
Week #4 |
|
Excel Personal Finance. Use PMT function for car payments. Project net worth at age 65. Use absolute addressing and goal seek. |
Week #5 |
|
Advanced Excel. Charts, Transpose, Macros. Attend Caritas and Veritas Symposium on Tuesday Roth vs. Traditional IRA |
Week #6 |
|
Advanced Excel. Charts, Transpose, Macros, If-then, sumif, macros, solver
|
Week #7 |
|
Midterm. Break even and financial planning |
Week #8 |
|
Databases. SQL,R, SPSS, Watson |
Week #9 |
|
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 |
|
Databases. SQL,R, SPSS, Watson Work on a big problem that uses SQL Server and Pivot Tables |
Week #11 |
|
Databases. SQL,R, SPSS, Watson Final Financial project - Retirement, Stocks, and Financials |
Week #12 |
|
Databases. SQL,R, SPSS, Watson Final Financial project - Retirement, Stocks, and Financials |
Week #13 |
|
Read about cloud computing. Build your own website (Weebly or Dreamweaver) Wed - Sunday: No Class – THANKSGIVING |
Week #14 |
|
Continue to Build web site and study cloud computing |
Week #15 |
|
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