Students Name: Evaluator: Date:
LO 6. Students will evaluate and apply selected analytics techniques to help enhance organizational competitiveness. (Assess in OPRE 605)
A key learning objective of this course is for youto be able to apply what you learn to solvenovel problems that youencounter in your professional setting. As such, the final exam for thiscourse is an individual project that integrates and applies the techniques covered in the course in a unique problem.
The project deadline is Friday, May 20, 2022.
You will have 5 minutes to briefly present your project in class on Thursday, May 12th.
Think about a domain you are very interested and/or experienced in and then think about aspects of it that are economic issues of supply and demand, cost and profit, inventory management, appreciation/depreciation of value, entrepreneurial strategy, etc. What problems do you see in that domain that could benefit from an analytic model? Think outside the box and don’t hesitate to contact me if you need help or if you want feedback from me at any time.
Below is an outline of what material I expect to see in you final project report.
As a reminder, these are INDIVIDUAL projects, and I will be expecting a unique submission from each student.
Write your report in Word using double line spacing.
Save your data, model and analysis in an Excel file. Use label and sheet names to clearly organize your Excel file.
Paste any relevant table and chart in your report including labels and references in the text.
Use font Arial size 10 (or similar if not available in your system).
By midnight on the due date, upload your Word file and Excel data file in Sakai under Assignments. (10% of the points will be deducted for each day or fraction of day that work is submitted after the due date.)
Youshould plan to write a brief report(3-5 pages) that has the following sections:
Introduction- describe the problem you are trying to solve (e.g., What/when should I buy and sell shares in Stock X based on historical data? When should inventory be put on sale?), with some description of the topic domain (e.g., venture capitalism, clothing retail, restaurant management). Your problem should be rich enough to require a spreadsheet model and simulation or linear optimization.
Analytic Strategy- verbally describe your model/s of the problem, but also include an influence diagram and mathematical model, the assumptions your model/s make/s about the problem and the variables that are involved; also describe what data you will be using and how you will acquire it.
Findings and Implications- provide a visual model of the data and/or the model output/analytic results and a verbal explanation for what they mean to a decision maker faced with the problem you analyzed. If you had been hired by someone to consult on this problem, how you would advise them to act based on your findings.
References- provide verifiable citations for any published studies or documents that informed your project, as well as any external data set/s that you used to complete it.
(accurate, relevant, multiplistic, logical, coherent)
(correct, appropriate, dualistic, reasonable, consistent)
(inaccurate, inappropriate, singular, illogical, fragmented)
Ability to interpret and frame a business scenario as an analytics problem
Presents information (data, ideas, or concepts) accurately and appropriately in familiar contexts
Reports information (data, ideas, or concepts) in familiar contexts with minor inaccuracies, irrelevancies, or omissions
Copies information (data, ideas, or concepts) often inaccurately, incompletely, or omits relevant information
Ability to apply a business analytics technique to a new context
Applies formulas, procedures, principles, or themes accurately and appropriately in familiar contexts
Uses appropriate formulas, procedures, principles, or themes in familiar contexts with only minor inaccuracies
Labels formulas, procedures, principles, or themes inaccurately, inappropriately, or omits them
Ability to interpret and evaluate (validate) solutions. Understanding of assumptions
Describes solutions, positions, or perspectives accurately. Identify some model limitations in general terms
Identifies simple solutions, over-simplified positions, or perspectives with only minor inaccuracies. Assumption nor limitation are considered
Names a single solution, position, or perspective, often inaccurately, or fails to present a solution, position, or perspective
Ability to explain the results within the context of the problem
Organizes a conclusion or solution that is complete, logical, and consistent with evidence presented
Connects ideas or develops solutions in a clear and coherent order
Offers an abbreviated conclusion or simple solution that is mostly consistent with the evidence presented, with minor inconsistencies or omissions
Arranges ideas or solutions into a simple pattern
Attempts a conclusion or solution that is inconsistent with evidence presented, that is illogical, or omits a conclusion or solution altogether
Lists ideas or expresses solutions in a fragmentary manner, without a clear or coherent order