Evidence-Based Problem Solving
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
COMM1110 Evidence-Based Problem Solving
Assessment 4: Case project part 2
Guideline and Marking Rubric
Due date: Week 11: 11:59 AM (midday), Wednesday 24th April
Project Overview
In Assessment 3, you worked as a consultant, and your client, GreenMart, a retail
supermarket chain, needed assistance with a notable rise in food waste, especially in the
fresh food section. You employed techniques like the 2W and logic tree to organize
information and develop logical problem-solving strategies. Additionally, you conducted
basic Excel data analysis and initiated an ethical analysis of the dilemma.
Now, in Assessment 4, we'll conduct a more in-depth analysis to address the increased
food waste issue at GreenMart. This assessment mirrors the case project we encounter
daily as managers in the workplace. Therefore, we'll apply all the knowledge we've gained
in our course to help you develop statistical, ethics, and analytical skills necessary to solve
the problem.
You will use the same personal Excel data you downloaded from Assessment 3, and
we will continue to conduct data analysis based on that. If you need assistance, you
can refer to page 6 in the Assessment 3 Guideline document for instructions on how
to download your personal Excel data.
• Word Limit: 2,000 words with a 10% buffer, allowing for a maximum of 2,200 words without
penalty. There's no minimum word requirement, so any word count below 2,200 is acceptable.
• The word count rule is straightforward – everything in your report, such as headings,
subheadings, and in-text citations, contribute to the word count, except for the reference list
(bibliography), and any inserted screenshots or images. Use your Word document's built-in
word count feature to check your word count accurately.
• Structure and Format: No need to have cover page, introduction, or executive summary. Simply
begin your report directly with section 1. Write in a business report style (e.g., using an essay
format, formal language, headings, and subheadings to make your report easy to read).
• Referencing Style: While referencing is optional, if you choose to cite external information,
adhere to the Harvard referencing style for any sources cited in your report. (see the guideline
link - How to Cite Different Sources with Harvard Referencing | UNSW Australia)
2
Section 1 – Further Statistical Excel Data Analysis (40%):
This section is approximately 700 words (guide only, not a word limit).
Apply all statistical data analysis skills you learned in our course to conduct a deeper analysis
of the food waste issue, using the same personal data file from Assessment 3.
1) Formulating Hypotheses on Variable Relationships:
Let's review your personal Excel dataset and the analysis you conducted on Food waste in your