BAN 6001 - Course Outline - Fall B 2023.docx656184335c5ef26384

docx

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

Report
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