Spring 2026, Section 606
Online Section
|
Instructor: Dr. John F. Kros |
Phone: 328-6364 |
|
Office: 3205 Bate Building |
Email: krosj@ecu.edu |
|
Office Hours: MTW 10:45 am.-12:30 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. |
(NOTE: Joyner Library has copies available for student use on a reference and first come first served basis.) It is perfectly acceptable to buy a used copy of the text. However, used copies do not come with access to the Text Website. Access to the Online Text Materials can be purchased from Kendall/Hunt at the Text Website listed below.
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 text you will not have access to the Online Text Materials.
Software:
Risk Solver Platform (RSP) - a web based version can be found here (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 (Excel addin for Decision Trees) - included on the Text Website or at TreePlan.com
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 @ 5% |
20% |
|
Quizzes |
4 total @ 1% |
4% |
| Spreadsheet Tutorial Videos - contains 3 tutorials with 3 accompanying quizzes that all must be taken by 12 midnight January 19th to receive credit | 6% | 6% |
|
Exams: 2/20
Exam I- 3/27 Exam II - Exam
Posted by 3/27 and due before 12 midnight 3/28 4/27 Exam III Exam
Posted on 4/27 due before 12 midnight 4/28 |
1 @ 20%
1 @ 20%
1 @ 20%
|
60% |
|
Assessment Exam - Individual Timed Assignment |
. |
5% |
|
Final Exam - Individual Timed Assignment |
. |
5% |
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. Students are expected to complete the homework and post their finished work to Canvas by the due date. Late homework will not be accepted.
Spreadsheet video tutorials consist of short video lectures pertaining to spreadsheet operation, development, and modeling. Each videos must be watched first which is then followed by a short 5-10 question multiple choice quiz over the video tutorial material. The quizzes can be taken more than once but the videos must all be watched and the quizzes all must be taken to receive credit. There will be no partial credit given here. The purpose of the spreadsheet video tutorials is to prepare students for the spreadsheet modeling that will take place in the course. If you find these videos and quizzes difficult I suggest you obtain a spreadsheet help book (e.g., Spreadsheets for Dummies) and brush up your skills early on in the course (i.e., the first couple of days).
Quizzes will
consist of multiple choice and true/false questions. Quizzes
will be posted on Canvas and must be taken online. Each
quiz can be taken multiple times until all questions are
answered correctly (i.e., you score a 100%). The quizzes are for
the students own benefit and can be completed anytime before the
due date. Students are to complete the quizzes before 12
midnight of the due date. If you do not understand this
information regarding the quizzes please contact the instructor.
Missed quizzes can not be made up and will receive a zero
grade.
Exams will
cover material from the video lectures, quizzes, homework, and
my examples. The problems on the exams will be similar to the
homework problems. Missed exams 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 Slay 138 (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., 1/21 is bolded as it is the due date for Homework #1)
OMGT 3223 Tentative Course Outline
|
Week/Day Of: |
Topic |
Homework |
Topics: |
|
1/12 |
Introduction |
. |
Chapter 1 |
|
|
. |
Chapter 1 |
|
|
1/15 |
|
Chapter 3 Peruse Study Guide Problems: Chapter 1 - #2, #3, & #6 Chapter 3 - #1, #2, #3, & #4 Peruse Excel Templates: Chap 3_1 and Chap 3_2 |
|
| 1/19 |
Spreadsheet
Video Tutorials Must be Completed by 12 midnight
January 19th - 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 January 19th - Links are on Canvas in the assignment's folder. |
|
1/21 |
Probability and Statistics |
Homework #1 -due 12 midnight Homework
#1 Solutions-.xls file
Homework #1 - Problem #2 Cost-Volume B/E Graph Video Lecture |
Chapter 3 |
|
1/26 |
Probability and Statistics Quiz
#1 - Administered via Canvas Due 12 midnight |
Bayes' Rule/Stat. Example #2 - Solutions to Selected Quiz #1 Problems |
Chapters 1 and 3 |
|
1/28 |
Decision Analysis |
Chapter 2 - Attempt/follow along with any of the examples within the text of the chapter Peruse
Study Guide Problems: Chapter
2 - #1 & #2 Chapter 4 Peruse Study Guide Problems: Chapter 4 - #1, #2, #3, & #4 Peruse Excel Templates: Chap 4_1, Chap 4_2, Chap 4_3, Chap 4_4, Chap 4_5, and Chap 4_6 |
|
|
2/2 |
Decision Analysis |
Decision Analysis - Sensitivity Graph Tutorial Sensitivity Analysis Example Video Tutorial Homework
#2 - due 12 midnight Paired
Problem Solution Set - Problem A & B HOMEWORK #2 SOLUTIONS |
Ibanez
Produce - Read the case and develop a model
to help the company (Partial solutions will be
posted later). This is an assignment to
assist y'all in developing Decision Trees, nothing
is to be turned in. Click here for a SnapShot of Ibanez Model in Excel - Use this as a guide to build your own model in Excel using Treeplan. I will post a full solution on October 4th, but try it on your own first. |
| 2/5 |
Simulation |
Excel
Template for RSP Tutorial |
Chapter
5 Peruse Study Guide Problems: Chapter 5 - #1, #2, #3, & #6 Peruse Excel Templates: Chap5_1, Chap5_2, and Chap5_3 |
|
2/9 |
Simulation |
. |
Chapter
5 |
2/12 |
Simulation |
Review
Stochastic Sensitivity Graphs w/regard to
Dominance, Tradeoffs, and Risks |
Chapter 5 |
|
2/16 |
Decision Analysis and Simulation Quiz
#2 - Administered via Canvas Due 12 midnight |
. |
Chapter
4 and 5 |
2/17 |
Review for Exam - Stochastic Sensitivity Graphs |
Review Stochastic Sensitivity Graphs w/regard to Dominance, Tradeoffs, and Risks | Chapter 5 |
| 2/19 |
Review Sheet for Exam I |
Chapter
1, 2, 3, 4, and 5 |
|
| 2/20 |
Exam I Posted |
Exam I Video Narrative |
Writing Guidelines |
|
2/21 |
Exam I - due by 12
midnight |
Exam
I Partial Solutions |
Chapter
1, 2, 3, 4, and 5 |
| 2/26 |
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: Chapter 8- #2, #3, #4, #6, & #12 |
| 3/2 |
Optimization Models | Optimization
Tutorial Video Lecture - Shave Ice Problem to Accompany Shave Ice LP Example Video - .pdf file |
Chapter
8 Peruse Study Guide Problems: Chapter
8- #2, #3, #4, #6, & #12 |
|
3/5 |
. |
Chapter
8 Optimization problems, computer solutions, and sensitivity analysis |
|
|
3/9 |
Optimization Models - Networks |
Homework #3 - Due 12 midnight Case
Study - More
instructions to come |
Chapter
8 Transportation problems & Assignment problems Peruse Chapter 8 Pirate Logistics Example to Assist in the Case Study Model Formulation Case
1 Narrative Video Lecture |
| 3/11 |
Case Study Review |
HW#3 Solution Set |
. |
|
3/16 |
Quiz
#3 - Administered via Canvas |
. |
Chapter
8 |
|
3/27-28 |
Exam II Word .pdf Exam
II Video Narrative |
Exam II Review
Sheet - Video Narrative |
Chapter 8 |
|
3/30 |
|
Chapter
7 Naive
Forecasting Video Tutorial Forecasting - Moving Average Video Tutorial Peruse Study Guide Problems: Chapter 7 - #1, #3, #5, & #7 Peruse Excel Templates: Chap7_1, Chap7_2, and Chap7_3 |
|
|
4/6 |
Forecasting-Linear Regression |
Chapter
6 |
|
|
4/13 |
Forecasting-Linear Regression |
Homework #4 - Due 12 midnight |
Chapter
6 Peruse Study Guide Problems: Chapter 6- #3, #4, #5, & #6 Peruse Excel Templates: Chap6_1, Chap6_2 |
|
4/20 |
Quiz #4 - Due 12 midnight |
Chapter
6 and 7 |
|
|
4/27 |
Exam
III - .pdf |
Exam III Due Tuesday April 28th by 12 midnight |
Chapter 6 and 7 |
|
5/4 |
Final Exam and Assessment Exam - Due 12 midnight |
. |
Final
Exam |
