Scenario
A restaurant chain planned to open its second restaurant in London. To ensure this is a viable move, the shareholders are keen to understand the market. Therefore you are asked to carry out a planned data collection and data analysis to help the board of directors in understanding the customer preferences.
Task 1(LO 1: 1.1, 1.2, 1.3 and LO 2:2.1, 2.2, 2.3) (M1,D1,D2)

Report on Data Collection and Analysis, In this report;

 Create a plan for primary and secondary data collection with presenting the survey methodology & sampling frame used
 Design a questionnaire to collect data and provide a justification for its design
 Collect data and summarise the collected data using representative values
 Analyse the collected data using measures of dispersion. You must be able to use the analysis to inform and support decision making.
 Carry out suitable calculations to draw useful and realistic conclusions and provide valid recommendations your calculations must include quartile, percentiles and the correlation coefficient. Explain how these calculations helped you to draw useful conclusions.
To achieve M1, have effective judgements and approach in using variety of sources for the collection of data and range of techniques to analyse data effectively
To achieve D1, justify conclusions through synthesis of ideas and propose realistic improvements for the collection of data and range of techniques to analyse data effectively
To achieve D2, properly manage activities in using variety of sources for the collection of data and range of techniques to analyse data effectively

Task 2 (LO 3: 3.1, 3.2, 3.3, 3.4 and LO 4: 4.1, 4.2, 4.3)(M2,M3,D3)

Prepare a Business Presentation and a formal Business Report to disseminate information effectively which include;

 the findings which should be used to draw valid conclusions (You must use spreadsheet software for all calculations and incorporate graphs and charts to clearly effectively present the findings)
 trend lines in graphs to assist in forecasting for specified business information. For example, this may include people’s eating behaviours overtime and preferences against seasonal changes.
 a plan for the project identifying the Critical Success Factors and the Critical path to implement a business process and the recommendations you are suggesting from your findings. For example, a business process to serve customers
 different financial tools such as discounted cash flow and IRR functions to evaluate the financial viability if the proposed recommendations

To achieve M2, apply and justify learning methods/techniques, synthesise and process complex information to produce information in appropriate formats in decision making and in using software-generated information
To achieve M3, you need to use range of methods of presentation, have accurate technical language and appropriate communication to produce information in appropriate formats in decision making and in using software-generated information.
To achieve D3, incorporate your previous knowledge to produce information in appropriate formats in decision making and in using software-generated information.

Evidence checklist Summary of evidence required by student Evidence presented
Task 1 A report that demonstrates the ability to use a variety of sources for the collection of data, both primary and secondary and range of techniques to analyse data effectively for business purposes The report must be written in professional manner and properly referenced. You may use tables and diagrams to support your report to illustrate the text. The report should comply with the word count of 1500 with +/- 10% margin.
Task 2 Produce a pack which includes presentation slides, spreadsheet and a business report.

The report must be written in professional manner and properly referenced. The report should comply with the word count of 1000 with +/- 10% margin. You may use tables and diagrams to support your report to illustrate the text. Word count excludes the index, headings, information contained in tables, references and bibliography.

Presentation slides and spreadsheets must be also submitted as a printed copy.You may use tables and diagrams.