|
Instructor: Dr. John F. Kros |
Phone: 328-6364 |
|
Office: 3205 Bate Building |
Email: krosj@ecu.edu |
|
Office Hours: MTW 12 noon.-2:00 p.m. or by appt. |
Click below to listen to Dr. Kros discuss the syllabus - Then follow along on the web page
Click here for the Narration of the Syllabus
Text:
|
Spreadsheet Modeling for Business Decisions, Kros, 5th Edition, Kendall/Hunt Order the eBook of the text directly from KendallHunt: http://www.kendallhunt.com/kros/ or
obtain from ECU Bookstore, UBE, etc. |
Text Website: Website for Spreadsheet Modeling for Business Decisions. Contains Excel Templates, STUDY GUIDE, interactive models, etc. You need to use the code that accompanies the textbook to access the site. If you procure a used hard copy text you will not have access to the Online Text Materials.
Software:
Solver for Excel will be used in this course - it is a free program that is included with all legal versions or Excel. Below are links to a set of tutorials on how to install Solver on your PC or Apple (these links can also be found later in the syllabus on the June 4th date.
Video Tutorial for Adding in Solver to Excel for PC's
Video Tutorial for Adding in Solver to Excel for Apple Computers
Risk Solver Platform: RSP (OPTIONAL advanced version of Solver) - a web based version can be found here if you are interested in an advanced version of basic Solver (this is the best way to access and only way Mac users can use the software) Google Sheets Risk Solver Add-on - if wanted a full term download included with text is at http://www.solver.com/risk-solver-platform
Treeplan (OPTIONAL Excel add-in for Decision Trees) - included on the Text Website or at TreePlan.com
This course engages diverse opinions & scholarly perspectives to develop critical thinking, analysis, & discussion as well as these tenets:
Assignments and Grading: Assignments are summarized later in this syllabus. Grading will be calculated roughly along the following guidelines and weights with student to student and student to faculty interaction via ongoing, moderated discussion board/chats (e.g. Homework):
|
Homework - Including Discussion Board
Posts |
4 @ 10% |
40% |
|
Quizzes |
4 total @ 1% |
4% |
| Spreadsheet Tutorial Videos - contains 3 tutorials with 3 accompanying quizzes that all must be taken by 12 midnight May 20th to receive credit | 3% | 3% |
|
Exam I |
43%
|
43% |
|
Final Exam - Individual Timed
Assignment, Posted 6/22 and due by 12 midnight 6/23 |
. |
10% |
PLEASE USE THE FOLLOWING NAMING CONVENTION
WHEN SAVING AND SUBMITTING COMPLETED ASSIGNMENT FILES:
lastnamefirstinitialassignment.suffix
For example, for myself I would name my
first homework assignment file:
krosjhomework#1.doc
Be forewarned, I will either send your assignments back to you ungraded or downgrade your work if you do not follow this naming convention.
Homework will be assigned according to the tentative schedule presented. Please attempt every problem and feel free to ask me or your fellow students for assistance. However, all homework turned in must be your own work and missed assignments will receive a zero grade. Late homework will not be accepted.
Quizzes will cover material from the previous classes and the problems will be straightforward. They are multiple choise & are completed via Canvas. YOU CAN TAKE EACH QUIZ MULTIPLE TIMES AND TO RECEIVE FULL CREDIT YOU MUST COMPLETE EACH QUIZ WITH A 100% GRADE. Missed quizzes can not be made up and will receive a zero grade.
The exam will cover material from the text and my lectures. The problems on the exam will be similar to the quiz and homework problems. A missed exam will receive a zero grade. Please make prior arrangements if the exam will be missed.
Final grades
will be assigned by letter and will be derived approximately
from the grading percentages shown above roughly following the
standard +/- scale. I will assign grades on individual
assignments according to the ECU +/- scale (A = 4.0, A-=3.7,
B+=3.3, B = 3.0, B-=2.7, C+=2.3, C = 2.0, C-=1.7, D+ = 1.3, D =
1.0, D- = 0.7, F = 0.0).
Roughly the following grade cut-offs will be used: above 3.7 = A, above 3.3 through 3.7 = A-, above 3.0 through 3.3 = B+, above 2.8 through 3.0 = B, above 2.5 through 2.8 = B-, above 2.2 through 2.5 = C+, above 1.9 through 2.2 = C, above 1.6 through 1.9 = C-, above 1.3 through 1.6 = D+, above 1.0 through 1.3 = D, above 0.8 through 1.0 = D-, below 0.8 = F. Percentage scores will not be assigned.
Attendance: Timely attendance is the responsibility of the student. There is no penalty for missed lectures.
COB PROCTOR POLICY
I will not be requiring proctors for this class. However,
many of the online courses you enroll in may require a
proctor. A proctor is someone who is approved to
administer examinations or other course material on behalf of
the course instructor. The purpose of the proctor is to
assure the integrity of the examination process. The
university academic integrity policy may be reviewed at
http://www.ecu.edu/studenthandbook/III.htm.
HOWEVER, YOU ARE ON YOUR HONOR
TO COMPLETE ANY EXAMS WITHOUT OUTSIDE ASSISTANCE FROM ANYONE
WITHIN THE COURSE OR ANY OUTSIDE PERSON/ENTITY. DO NOT
COLLABORATE OR COLLUDE ON ANY EXAM. PLEASE EMAIL OR CALL
OR STOP BY IF YOU DO NOT UNDERSTAND THIS POLICY.
Attendance: Timely attendance is the responsibility of the student. There is no penalty for missed lectures.
| Good
Academic Standing |
End of
Semester 2 |
End
of Semester 3 |
| GPA = 2.0+ |
GPA < 2.0 |
GPA <
2.0 |
| Good
Standing |
Probation |
1 Semester
Suspension |
East Carolina University seeks to comply fully with the Americans with Disabilities Act (ADA). Students requesting accommodations based on a disability must be registered with the Department for Disability Support Services located in Mendenhall Suite 109, (252) 737-1016 (Voice/TTY).
Continuity of Instruction: In the event that face-to-face campus classes are suspended for some undetermined length of time due to a pandemic or other catastrophic event, I will strive to continue instruction for our online course through Canvas and via email soon after the event occurrence. Students must understand that it may be necessary to make adjustments to instruction modes and/or assignments. It is the responsibility of the student to logon each day and to comply with any needed changes.TAKE NOTE: Bold Items Indicate Dates When Assignments are Posted or When they are DUE
(e.g., 5/21 is bolded as it is the due date for Homework #1)
OMGT 3223 Tentative Course Outline
|
Week/Day Of: |
Topic |
Homework |
Topics: |
|
5/18 |
Introduction |
. |
Chapter 1 |
|
5/19 |
|
Chapter 3 Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 1 - #2, #3, & #6 Chapter 3 - #1, #2, #3, & #4 |
|
| 5/20 |
Spreadsheet
Video Tutorials Must be Completed by 12 midnight
May 20th - Links are on Canvas in the assignment's
folder. |
. | Tutorials
posted on Canvas under Assignments tab. Spreadsheet Video Tutorials Must be Completed by 12 midnight May 20th - Links are on Canvas in the assignment's folder. |
|
5/21 |
Probability and Statistics |
Homework #1 -due 12
midnight |
Chapter 3 |
|
5/22 |
Probability and Statistics Quiz
#1 - Administered via Canvas Due 12 midnight |
Bayes' Rule/Stat. Examples Like Quiz #1 Problems |
Chapters 1 and 3 |
|
5/26 |
Decision
Analysis Decision Analysis - Decision Criterion Excel Template (HINT: Good to use for HW#2) |
Decision Analysis Lecture
w/.ppt Decision Analysis
Tutorial - Building a Decision Criterion Excel
Template |
Chapter 2 - Attempt/follow along with any of the examples within the text of the chapter Peruse Study Guide Problems (these
problems are only for practice & DO NOT need
to be submitted): Chapter 2 - #1 & #2 Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 4 - #1, #2, #3, & #4 |
|
5/27 |
Decision Analysis |
Homework #2 - due 12
midnight Paired
Problem Solution Set - Problem A & B |
Ibanez Produce - This
is an example to assist y'all in developing
Decision Trees, nothing is to be turned in. |
| 5/28 |
Video Lecture for Simulation .ppts |
Chapter 5 Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 5 - #1, #2, #3, & #6 |
|
5/29 |
Simulation |
Review
Stochastic Sensitivity Graphs w/regard to
Dominance, Tradeoffs, and Risks |
Chapter 5 |
|
6/1 |
Decision Analysis and Simulation Quiz
#2 - Administered via Canvas Due 12 midnight |
. |
Chapter 4 and 5 |
| 6/2 |
Begin Optimization Models | LP Example Setup Video - EXCEL Portion LP Example Video - Solution by Hand |
Chapter 8 Transportation problems & Assignment problems Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 8- #2, #3, #4, #6, & #12 |
| 6/3 |
Optimization Models | Optimization
Tutorial Video Lecture - Shave Ice Problem to Accompany Shave Ice LP Example Video - .pdf file |
Chapter 8 Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 8- #2, #3, #4, #6, & #12 |
|
6/4 |
Video
Tutorial for Adding in Solver to Excel for PC's Video Tutorial for Adding in Solver to Excel for Apple Computers |
Chapter 8 Optimization problems, computer solutions, and sensitivity analysis |
|
|
6/5 |
Optimization Models -
Networks |
Homework #3 - Due 12 midnight Pirate Logistics Transportation LP - Video Tutorial on LP Setup |
Chapter 8 Transportation problems & Assignment problems Peruse Chapter 8 Pirate Logistics Example to Assist in the Case Study Model Formulation |
|
6/8 |
Quiz #3 - Administered via Canvas |
. |
Chapter 8
|
6/9-10 |
Exam I Word .pdf - Exam I Posted |
Exam I Video Narrative Exam Partial Solutions - Posted after the Exam Due Date |
Chapter 8 Writing Guidelines |
6/10 |
Exam I Due 12 midnight |
Partial Exam Solutions |
. |
|
6/15 |
|
Chapter 7 Naive Forecasting Video
Tutorial Forecasting - Moving Average Video Tutorial Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 7 - #1, #3, #5, & #7 |
|
|
6/16 |
Forecasting-Linear Regression |
Chapter 6 |
|
|
6/17 |
Forecasting-Linear Regression |
|
Chapter 6 Peruse Study Guide Problems (these problems are only for practice & DO NOT need to be submitted): Chapter 6- #3, #4, #5, & #6 |
6/19 |
Quiz
#4 Administered via Canvas |
Final Exam Review Sheet |
Chapter 6 and 7 |
|
6/22-23 |
Final Exam Posted to Canvas
on 6/22, Due 12 midnight on 6/23 |
. |
Final Exam |