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

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 & MW after class

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 2013, Microsoft Access 2013, 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 29th –
Fri., Sept. 2nd

 

Introduction and Project Management

Week #2
Wed., Sept. 7th –
Fri., Sept. 9th

 

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

Week #3
Mon., Sept. 12th –
Fri., Sept. 16th

 

Complete Project Mangement Unit. Begin Excel and Personal Finance.

 

Week #4
Mon., Sept. 19th –
Fri., Sept. 23rd

 

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. 26th –
Fri., Sept. 30th

 

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

Roth vs. Traditional IRA

Week #6
Mon., Oct. 3rd –
Fri., Oct. 7th

 

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

 

Week #7
Mon., Oct. 10th –
Fri., Oct. 14th

 

Midterm. Break even and financial planning

Week #8
Mon., Oct. 17th –
Wed., Oct. 19th

 

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

Week #9
Mon., Oct. 24th –
Fri., Oct. 28th

 

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. 31st –
Fri., Nov. 4th

 

Databases. SQL,R, SPSS, Watson

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

Week #11
Mon., Nov. 7th –
Fri., Nov. 11th

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #12
Mon., Nov. 14th –
Fri., Nov. 18th

 

Databases. SQL,R, SPSS, Watson

Final Financial project - Retirement, Stocks, and Financials

Week #13
Mon., Nov. 21st

 

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

Week #14
Mon., Nov. 28th –
Fri., Dec. 2nd

 

 Continue to Build web site and study cloud computing

Week #15
Mon., Dec. 5th –
Fri., Dec. 9th

 

Cover special advanced topic and review for final.

Week of Dec. 12th

 

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.

August 29 First Day of Classes

September 5 Labor Day - No Classes

September 6 7:00PM deadline for adding/dropping fall semester classes

September 13 Last day to declare satisfactory/fail grade option

September 27 Caritas and Veritas Day (class schedule suspended)

September 27 Last day to declare course intensification option

October 21-23 Long Weekend (no classes)

November 9 Last day to withdraw from fall semester courses

November 23-27 Thanksgiving Vacation December 10 Last day of classes December 12-17 Final Examination Week

December 20 Final Grades due at noon