BAN 6001 - Course Outline - Fall B 2023.docx656184335c5ef26384
docx
keyboard_arrow_up
School
Mount Kenya University *
*We aren’t endorsed by this school
Course
4401
Subject
Management
Date
Nov 24, 2024
Type
docx
Pages
13
Uploaded by mmakau2016
as of 10/29/2023
Department of Management and Information Technology
Fall B 2023
October 30, 2023 – December 17, 2023
COURSE
DESCRIPTION:
This course will cover the application of quantitative techniques to business problems.
Topics will include business applications of probability and statistics, forecasting
techniques, and decision theory.
Prerequisites: Co-requisite: Computer literacy; familiarity with Microsoft Excel.
REQUIRED
TEXTS:
Evans, James R. (2020). Business Analytics: Methods, Models and Decisions, 3
nd ed.
Boston: Pearson. ISBN 978-0-321-99782-1
Excel
Resources:
Microsoft Excel Help Center: https://support.office.com/en-us/excel
ADDITIONAL
READING
(SUGGESTED):
Albright, S. C. & W. L. Winston (2017). Business Analytics: Data Analysis and Decision Making, 5
th edition. Boston: Cengage. ISBN 978-1-305-94754-2
Camm, J.D., et al (2021
). Business Analytics
, 4
nd edition. Boston: Cengage. ISBN 978-0-
357-13179-4
BAN 6001
Fall B 2023
Page 2 of 15
Vriens, M., S. Chen & C. Vidden (2019). From Data to Decision: A Handbook for the
Modern Business Analyst. Solana Beach, CA: Cognella Academic Publishing.
ISBN 978-1-5165-2063-3
Additional readings posted on course-Canvas site.
SOFTWARE:
Microsoft Excel 2016 – Windows version.
Lectures and demonstrations will be based on the Windows version of Excel 2016
. If
you choose to use a different operating system (i.e., MacOS) and/or a different
version of Excel (Excel 2013 or earlier), it is your responsibility to make the
necessary
adjustment, if possible, and complete the assignments correctly
.
Please note that not all features and functions of Excel are available in all versions.
Please choose carefully.
you may download Microsoft Office including Excel for your personal and school use.
Link to download the software is on the home page of the student portal.
MS
in
MGT
Program
Learning
Outcomes
(PLOs)
for
BAN
6001:
PLO 1: Apply core management terms, concepts, and processes. Explain how
management concentration integrates functional areas of business organizationally and
creates value for customers while adding competitive advantage for organizations.
PLO 2: Examine professional ethics in light of legal, organizational, and societal
responsibilities. Integrate ethical thinking into all aspects of decision making.
COURSE
OBJECTIVES:
Students will explore how managers can use quantitative data and information for
planning, evaluation, and decision making. Students will learn about model building,
descriptive and predictive analytics including forecasting, prescriptive analytics utilizing
linear optimization and. decision analysis.
STUDENT
LEARNING
OUTCOME
(SLOs):
After successful completion of the course the student should be able:
To choose and apply appropriate statistical and management science tools to solve
business problems.
Know how to develop appropriate management science models.
Interpret and report the results in the context of business problem-solving and
decision making.
Demonstrate a mastery of the above objectives, including knowledge of a logical
approach to problem solving and decision making through the use of business-
analytic tools.
Demonstrate ethical awareness, the ability to do ethical reflection, and the ability
to apply ethical
principles in decision-making.
METHODS
OF
ACHIEVING
THE
OBJECTIVES:
This course will present students with statistical and management science tools as
applied to business problems as well as with an awareness of the ethical and social
implications of the use of these methodologies.
Assignments and quizzes will cover the materials presented and discussed in class and
in assigned readings.
The course will require the use of Microsoft Excel 2016 and the Internet as problem
solving tools. Assignments are chosen to stimulate independent thinking and problem
solving.
LEARNING
FORMAT:
Business Analysis for Managers will use a variety of approaches to insure active
participation of all students. Students will also be required to demonstrate personal
knowledge and communication skills. Emphasis will be put on analytical skills, oral and
written communication of quantitative and analytical decision processes.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
METHODS
OF
EVALUATING
STUDENTS:
Students are required to read all assigned chapters and be prepared to participate in
discussions. Your final course grade will be based on participation (via discussion
boards), assignments, quizzes, and a final (cumulative) case study analysis and
presentation
.
ACADEMIC
INTEGRITY:
The College policy that defines academic integrity includes procedures for dealing with
violations of that policy. Matters of academic integrity are distinct from the rubric of
student misbehavior. Violations of academic integrity include cheating, counterfeit work,
falsification of academic records, falsification of data or creation of false data,
plagiarism, theft (of information), and unauthorized reuse of work. Since a violation of
academic integrity takes place whenever anyone undermines the academic integrity of
the College or attempts to take unfair advantage of others, the above list cannot be
exhaustive. For further information, including the complete policy, procedures, and
sanctions, please refer to The Cord
. (See section on Academic Integrity St. Francis
College)
HOMEWORKS
and
ASSIGNMENTS
:
Homework problems are assigned for practice and are chosen to reinforce the topics
covered in each module. It is expected that students will complete these homeworks as
assigned. Assignment questions are selected from among these homework problems.
All
problem
solving
(homeworks
and
assignments)
be completed
using
Excel.
Homeworks are graded for efforts as follows: 5 points for complete submission; 2 or 3
points for partial submission; 0 point (no credit) for incorrect (non-Excel work), no
submission OR plagiarized submission.
For submission: 1) Complete all analysis in Excel: 2) Place answers to all problems in
ONE WORKBOOK
labeling each sheet reflective of its content ; 3) Be sure to show and
label all your answers
; 4) Post your workbook in the drop box on Canvas by its due
date/time.
Discussion
Board
for
homeworks:
Each assigned homework problem set has an associated graded discussion board
posted on Canvas. You are to post a question, reflect on what/how you learned
from the homework, and/or provide substantive response to a posted question
.
Do
NOT
post
solutions
!! Only assist each other with how to work through the problem
and/or issue … I monitor the discussion board and respond/post only as necessary.
This discussion board is graded for helpfulness
– i.e., the quality of the question(s), reflections, and/or responses even if the response is not totally correct – the effort is rewarded. The discussions are to be courteous and respectful. Social niceties like “thank you” and “I agree” are expected but do not get any credit for the posting.
This
is
a
LEARNING
COMMUNITY:
Active
participation
is
REQUIRED!
QUIZZES:
Quizzes will be comprised of multiple choice and short answer questions.
No makeups will be given for missed quizzes. Missed quizzes receive a grade of zero (0).
FINAL
CASE
ANALYSIS
AND
PRESENTATION
:
The course will bring together the material for students to apply the analytical tools learned to a business case, working through a business problem and the ways in which data analysis could help inform business decisions. (The analysis and presentation are to be completed during the in-person meeting of the course.)
The final course grade will be computed as follows:
Quizzes
20%
Assignments
20%
Class Participation and Discussions 20%
Final
Case
Analysis
and
Presentation
40%
Total
100%
The following grading system will be used:
Grade
Numerical
Range
A
93 -100
A-
90-92
B+
87-89
B
83-86
B-
80-82
C+
77-79
C
73-76
F
Below 73
GRADING RUBRICS for Assignments with Excel
Category
Rudimentary
2 Points
Developing
4 Points
Satisfactory
6 Points
Accomplished
8 Points
Exemplary 10 Points
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Data Entry
Several errors.
Some required
data may be missing.
Some data
required is
missing.
All data required
data is entered correctly.
Most data required is
entered with
100% accuracy.
All data
required is
entered with
100%
accuracy.
Computations
& Formulas
No
formulas
are used.
Several errors
in formula calculations
Minor errors in correct formulas
used.
Most formulas used are correct
applicable
formulas as
required
100% use of
correct
applicable formulas as
required.
Graphs
There were
graphs
present, but
graphs or data
were
incorrect.
There are
graphs present
but only most elements were
missing.
The graphs
required for the
project were correct. Some
elements were
depicted.
The graphs
required for the
project were correct. Most
elements were
depicted.
The graphs required for the project were correct.
All elements were depicted.
Category
Rudimentary
2 Points
Developing 4
Points
Satisfactory 6
Points
Accomplished
8 Points
Exemplary 10 Points
Organization/
Formatting
Information is
poorly
organized. Appropriate
formatting such as appropriate labels & column/row
widths &
heights are
not used.
Some
Information is organized, using standard
formatting tools. Some
labels or other
important formatting tools are
missing.
Information is
mostly organized,
using appropriate
standard
formatting tools, such as labels and
bolding.
Information is
organized by using appropriate formatting,
including
shading,
alignment tools,
borders, special fonts, appropriate
labels, appropriate column/row height & width
Information is
very well organized by using appropriate advanced formatting,
including shading, alignment tools, borders,
special fonts, appropriate
labels, appropriate column/row
height &
width
Visual Appearance &
Output
Spreadsheet is
VERY difficult to read and
locate
information.
Major
information
has been omitted.
Spreadsheet is
somewhat
difficult to read. A few
pieces of
important
information are
omitted.
Spreadsheet is
clear & easy to
read. Minor
information has been cut of when
printed.
Spreadsheet is
visually
esthetic, mostly
easy to read & most of the
required
information was
printed (nothing
is cut of).
Spreadsheet
is attractive,
easy to read &
all required
information
printed
(nothing is cut
of).
Followed Directions
None of the
directions
were followed.
Most of the
directions were
followed accurately.
Most of the
directions were
followed somewhat accurately.
Some of the
directions were
followed.
All directions were followed
accurately and
completely.
WHAT
IS
A
SCHOLARLY
POST?
Scholarly posts should have:
•
Quality of Thinking
: Develop, support, and convey clear, focused, and substantive ideas in ways appropriate to topic, context, audience, and purpose.
•
Organization and Coherence: Organize writing in clear, coherent sequences, making connections and transitions among ideas, paragraphs, and sentences.
•
Sentence Structure and Word Choice
: Use and vary sentence structures and
word choices to achieve clear and fluent writing.
•
Editing
: Edit for correct spelling, grammar, punctuation, capitalization, paragraph
structure, sentence construction, formatting, and, when appropriate, citations.
•
Use of Researched Information: Use, integrate, and cite researched information and evidence.
•
Reflection
: If appropriate, evaluate and articulate one's own point of view supported by research and logic.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
BAN 6001
Fall B 2023
Page 10 of 15
GRADING RUBRICS for ONLINE Discussions
Criteria
Exceptional
Good
Marginal
Unacceptable
Response to
discussion questions
Demonstrated
understanding
of the
topics/issues Accurate Detailed Relevant Unique ideas that promoted
discussion
Well-reasoned
2 points
Demonstrated understanding of
the
topics/issues Accurate Relevant Small degree
of original
thought or not
detailed
1 point
Brief response that was either
only marginally
applicable or very superficial
0.5 point
Response is illogical, incomplete or
incoherent
No points
Followed directions
Posted as
directed
0.5 point
One error in
following directions
0.25 point
Two or more
errors in
following directions No points
Three
or
more
errors
in following
directions No points
Composition
Writing is clear and understandable
Writing is always accurate for spelling, punctuation, grammar,
sentence
structure
0.5 point
Writing is clear and understandable
Minor errors in spelling, punctuation, grammar,
sentence
structure
0.25 point
Writing difficult
to
follow at times
OR
Numerous errors in grammar and
spelling but able to follow
No points
Writing is disjointed/rambling.
OR
Grammar and
spelling errors
interfere with message
No points
TENTATIVE
SCHEDULE:
The following is a tentative schedule of topics and lectures. Changes may occur as the
semester progresses. These changes will be announced and posted on Canvas. In
addition to the assigned readings, students are responsible for any other handouts
distributed in class and/or posted on Canvas.
Topic
Readings
Posted on Canvas:
1
Oct 30 –
Nov 6
Online
via
Canvas
Introduction
Introduction to Business Analytics
Basic Excel Skill
Database Analytics
Chapter 1 Appendix 1A
Chapter 2
Homework
Discussions
Quiz
2
Nov 6 –
Nov 13
Online
Via Canvas
Data Visualization Descriptive Statistics
Chapter 3
Chapter 4
Homework
Discussions
Quiz
3
Nov 13 –
Nov 20
Online
Via Canvas
Sampling and Estimation
Statistical Inference
Chapter 6
Chapter 7
Homework Assignment
Discussions
Quiz
4
Nov 20 –
Nov 27
Online
Via Canvas
Trendlines and Regression
Analysis
Forecasting Techniques
Spreadsheet Modeling and
Analysis
Chapter 8
Chapter 9
Chapter 11
Homework
Discussions
Quiz
Topic
Readings
Posted on Canvas:
5
Nov 27 –
Dec 4
Online
Via Canvas
Linear Optimization
Optimization Analytics
Chapter 13
Chapter 15
Homework Assignment
Discussions
Quiz
6
Dec 4 –
Dec 11
Online
Via Canvas
Decision Analysis
Course Summary And Review
Chapter 16
Homework
Discussions
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7
Dec 11 –
Dec 17
Dec 15 -
Dec 16:
Inperson
@Wheeler
Final (Cumulative) Case Analysis and Presentation