Demonstrate knowledge of quantitative techniques for business data analysis.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Description of the assessment

Module Learning Outcomes

On successful completion of the module, students will be able to:

1. Demonstrate knowledge of quantitative techniques for business data analysis. 

2. Use relevant quantitative techniques within Excel, with real data to create a focused industry/business analysis.

Component 2: COURSEWORK

Summary of Assessment Method:  

Weighting:  60%

Assesses Learning Outcomes: 2

Individual written analysis (suitable for a web page) integrating applied quantitative analysis within Excel, real data and focused interpretation. (Maximum words 2,500 with additional evidence as reader notes, data and Excel analysis). 

This assessment is an individual client report. You must analyse the data, provided by the Client in the CW2 Excel file. The file contains a sample of companies from the UK food and tobacco manufacturing. You must write a report using your analysis of the data provided, that meet the requirements of the Client as set out below.  The data set for this assessment is in the CW2 Excel file in the CW2 folder, in the assessment section of Course Resources. You will also find some notes on the measurement of the variables used in a separate Word file. You are required to analyse the data provided using Excel only.  You should use the results of your Excel analysis to create fit for purpose tables and charts, which must be embedded in the body of the report to support your discussion and analysis for the client.

The deadline for submission is 17th January 2022 at 11.59pm. You can submit before the deadline. You should write the report in Word and submit it via the Turnitin link in the Assessment section of Course Resources. Do not submit an Excel file. You will receive individual feedback as comments, summary comments and rubric comments on your report in Turnitin within 3 weeks of the submission date.

You can submit your work before the deadline.  If you miss the deadlines your work will be deemed as late.  Penalties apply unless you have been granted additional time from  a Study Plan, or from a submission for  Exceptional Extenuating Circumstances (EEC) or Late Submission Request (LSR) all of which require evidence. The new undergraduate regulations on late submission penalties are available in section F6 at:  

https://www.derby.ac.uk/media/derbyacuk/assets/departments/the-registry/academic-regulations-2018-aug/Part-F-Asst-regs-for-UG-progs-2019-20-web-v1-updated-following-LSR-amendment-v1-LSR-amends.pdf

Assessment Content

Assessment Requirements

You must write an individual report analysing only the data provided. The data is real UK data from a specialist database.  There are more than 5,000 food and tobacco manufacturers registered in the UK, but consistent data on the variables in this data set is only available for the sample you have in the data set for the latest year available, 2020.  The data includes measurements of performance, size, and other variables. The overall aim of your analysis is to help the client understand the UK food and tobacco manufacturing sector.  The client is thinking about investing in this sector and wants you to analyse the available data provided in the Excel file.  You should use your analysis to provide the client with a better understanding of the performance potential of different groups of companies in the sector.  Your report must provide only the analysis that the client has requested, and your discussion must explain why the analysis might be relevant to the client as they think about investing in the sector.  Your job is not to decide whether the client should invest or not, or to do financial analysis for the client. Your job is to provide the analysis that the client requests, and provide recommendations drawn directly from the analysis. Only use the data provided.  Do not add new or additional data or information from other sources.  Only use the techniques we have covered in the lectures.  Do not use evidence or techniques that we have not covered in the lectures. You can only use EXCEL spreadsheet for your analysis that we have used in the lectures and/or computer labs.

Any evidence that students have colluded or copied each other or used the work of a source without reference and citation will be investigated and may result in a plagiarism investigation.  If you use techniques we have not covered in the lectures, it will be treated as a major failure to meet the requirements of the CW2 brief.

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme