.IntroductionAssessment Title:Data Management The aim of this unit is to provide students with an understanding of how management information and decision-making are enhanced by the application of statistical methods. Students will learn about a range of statistical techniques and how they can inform management thinking. While studying the unit they will develop their numerical abilities and increase their confidence in handling data in order to create information and knowledge.Learning Outcomes (LO)By the end of this unit a student will be able to:LO1: Evaluate business and economic data/information obtained from published sources. LO2: Analyse and evaluate raw business data using a number of statistical methods.LO3: Apply statistical methods in business planning.LO4: Communicate findings using appropriate charts/tables. BTEC HND in Business/Unit31: Statistics for Management/April 2020Page 1
Written Report:LONDON CHURCHILL COLLEGE Submission FormatThe submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. The recommended word limit is 3,000–3,500 words, although you will not be penalised for exceeding the total word limit. Specification of AssessmentTask1 (LO1 & LO2):Scenario:You are working as a Business Data Analyst for a global organisation based in the UK. You have been tasked with providing a report on the value and importance of statistical management. The report should cover the following: An introduction to statistics, e.g. what they are, what are the key characteristics and what are the benefits of statistical data for meeting business objectives. The sources and types of data and information businesses can access. The value of employing statistical methods when meeting business objectives andachieving competitive advantage. An analysis of deductive and inductive approaches and what the implications are forbusiness intelligence. Provide examples of analysis of given sample sets of data that could be used by theorganisation. Evaluate the suitability of one type of data analysis vs another. BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 2
LONDON CHURCHILL COLLEGEIn the above scenario, following assessment criteria will be covered: Evaluate the nature and process of business and economic data/information from a range of different published sources. [Learner needs to introduce the concept of statistics, with characteristics and benefits of statistical data for meeting business objectives. Learner also needs to evaluate the statistical component and numerical measurement to process the business and economic data.] Evaluate data from a variety of sources using different methods of analysis. [Learner needs to evaluate data from a variety of sources using different methods of analysis, learner may describe the data analysis approach has undertaken to find out the appropriateness of different data analysis method (Define the deductive and inductive approach with example). Learner also needs to define the exploratory and confirmatory analysis. Learners should define, what statistical method use for exploratory and confirmatory analysis; such as descriptive statistics, inferential statistics.] Analyse and evaluate qualitative and quantitative raw business data from a range of examples using appropriate statistical methods. [Learner needs to define statistical methods that are used to analyse and evaluate data for example differences between qualitative and quantitative raw data analysis, measures of central tendency and variability (e.g. mean, median, range, standard deviation). Application to business data finding should include average earnings, measuring variability in business processes such as queuing times and customer arrival rates.]For above assessment criteria learners can use the following case 1 and case 2:Case 1:This is reported what business travelers pay for hotel rooms per night in major U.K. cities. The average hotel room rates for 20 cities are as follows: City London EdinburghManchester BirminghamAverage Rate (£)/night 245146167 177 BTEC HND in Business/Unit31: Statistics for Management/April 2020Page 3
LONDON CHURCHILL COLLEGE Glasgow LiverpoolBristol Glasgow Leeds Nottingham Newcastle Brighton Cardiff Sheffield Cambridge Southampton Belfast Leicester Yorka. What is the b. What is the c. What is the d. What is the e. What is the Case 2:166 126 125 123 120 144 173 192 160 139 134 167 162 145 155mean hotel room rate? median hotel room rate?mode?first quartile? third quartile? A manger wants to see if geographical region is associated with ownership of a Macintosh computer. The manager surveys 100 people and the data break down as follows:Mac No MacNorth East 12 14 South West 21 18 Midland 17 18 Column Total 50 50Row total26 39 35 100Run the chi-square test is used to determine whether an association (or relationship) between 2 categorical variables in the population.Task 02(LO3 & LO4): BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 4
LONDON CHURCHILL COLLEGEScenario:In your position as a Business Data Analyst for the organization (same organization from scenario 1) of your choice you are producing analysis of raw data and communicating findings appropriately. Evaluate the differences between descriptive and inferential data. Using sets of given data, you are to calculate a range of descriptive and inferential statistics.Applying and justifying the use of different methods, e.g. T-Test, ANOVA testing, chi–squaretesting. Present your findings in the appropriate format using a range of graphs and charts tocommunicate data analysis.You must add the relevant calculations with your submission.In the above scenario, the following assessment criteria is covered: Apply a range of statistical methods used in business planning for quality, inventory andcapacity management. [In this part learners need to explore and define the use of statistical process control and appropriate techniques in application to operations, e.g. inventory, flow time, quality, capacity. Learner should present the validity of statistical process control. Learner is also asked to produce a flow chart that plots the measures of variability and probability for the supply chain management of your organisation’s products/services.] Using appropriate charts/tables communicate findings for a number of given variables. [Present your findings in the appropriate format using a range of graphs and charts to communicate data analysis). You also can use the following case 1, 2 & 3 to produce appropriate charts to communicate findings appropriately. Discussdifferent variables: Choosing the most effective way of communicating the results of your analysis and variables. Nominal, ordinal and interval/ratio levels. BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 5
LONDON CHURCHILL COLLEGEDifferent types of charts/tables and diagrams: The use of frequency tables, simple tables, pie charts, histograms, frequency curves and normal curve. Advantages and disadvantages of different types of methods. Presentation of information using tables and charts. Software for producing charts/tables (e.g. Excel).]Case 3:Use the following sample data set to apply statistical method and state the final assessment:In plant one it takes each 2 hours a sample from a production process. Each sample consists of 3 measurement of pressure in psi (pounds per square inch). The results are reported in the table below.8.00 a.m. 10.00 a.m. 12.00 a.m. 2.00 p.m. 4.00 p.m. 6. 00 p.m. 8.00 p.m. 37 142 66 94 84 75 4033 144 61 96 88 70 4235 145 60 99 66 72 46Assessment Methods Assignment Title Assessment Method Criteria Covered Final Submission Dates Task 1: Data Analysis & Reporting (LO1 & LO2) Report LO1 & LO203.07.2020 Task 2: Data Insight (LO3 & LO4) Report LO3 & LO4 BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 6
LONDON CHURCHILL COLLEGE Learning Outcomes and Assessment Criteria BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 7
LONDON CHURCHILL COLLEGE Recommended ResourcesANDERSON, D. et al (2010). Statistics for Business and Economics. 2nd Ed. Cengage Learning. MORRIS, C. (2012) Quantitative Approaches in Business Studies. 8th Ed. Harlow: Pearson Prentice Hall.DAVIS, D. and PECAR, B. (2013) Business Statistics Using Excel. 2nd Ed. Oxford: Oxford University Press.SLACK, N. and BRANDON-JONES, A. (2008) Quantitative Analysis in Operations Management. Harlow: Pearson Prentice Hall.Assignment Submission InstructionsTo submit Assignment, please follow the instructions below -1. Go to the following website: http://www.turnitinuk.com/2. Start by clicking on the class name you would like to submit to after logging in to Turnitin3. You will see a two links, one for your Draft Submission and one for the Final Submission. Click on the Submit button to the right of the assignment you wish to submit. Please remember that you will only be able to submit to each folder once.4. Select single file upload from the Submit: pull down menu BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 8
LONDON CHURCHILL COLLEGE5. Enter a title for the submission6. Once the requirements for single file upload have been reviewed, students have a choice to upload a file from: the computer Dropbox or Google DriveClick one of the submission buttons and then select the file you would like to upload7. Click Upload to upload the file8. Review the preview panel. Click the Confirm button to upload the file to the assignmentIf you still have any questions or need any help, please contact with your Personal Tutor. BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 9
LONDON CHURCHILL COLLEGE Assignment Submission LimitLearners must submit their assignments via Turnitin. Turnitin is an originality checking and plagiarism prevention service that is used by the College to assess assignments.The College has a cap on the number of times that an assignment can be submitted through Turnitin. Students will now only be able to obtain one similarity report prior to their final submission.Students wishing to generate a similarity report before their final submission should submit their assignment in the Drafts Folder on Turnitin. Only one submission can be made to this folder and no submissions to this folder will be assessed.The Final assignment must be submitted in the Final Submission Folder or the Learner will be considered absent for the submission, even if they have submitted in the Drafts Folder.For the final submission, Learners must add the feedback front sheet to declare the authenticity of their assignment.Achievement of a pass gradeA pass grade is achieved by meeting all the requirements defined in the assessment criteria for each individual unit.Achievement of a merit or distinction gradeAll the assessment criteria and merit grade descriptors need to be completed within a unit to achieve a merit grade. All the assessment criteria, merit and distinction grade descriptors must be completed within a unit to achieve a distinction grade.Academic MisconductAcademic Misconduct is an act of gaining an unfair academic advantage in relation to formal or informal academic exercises. Examples of academic misconduct are- Cheating in an examination; Impersonation; Fabrication; Collusion; Plagiarism; Submission of work produced by someone else. The College consider all academic misconduct seriously. For reference, learners are recommended to read the following documents and to consult with their Personal Tutors - BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 10
LONDON CHURCHILL COLLEGE LCC Harvard Referencing Guide (Located in VLE) Academic Discipline Policy (Located in VLE)Mitigating CircumstancesMitigating circumstances can be defined as circumstances that are unexpected, significantly disruptive and beyond the control of the student, which could not be reasonably predicted or accommodated by the student and which affects student’s ability to meet assessment deadlines or impairs the performance of the student in assessment.If you wish to apply for mitigating circumstances, you can obtain the form from E-Learning, your personal tutor or reception. The completed form must be accompanied by evidence such as a medical certificate in the event of you being sick.Please note that the lecturers do not have the authority to extend the coursework deadlines and therefore do not ask them to award a coursework extension. For further information please consider reading the following policy- Mitigating Circumstances Policy (Located in E-learning) Referencing GuideHarvard Referencing SystemWe expect students to use the alphabetical or name-date method known as the HARVARD system. There are two parts in this system:1. Citation within text or body of the report:In this the author's surname and year of publication are cited in the text, e.g. (Bond, 2004).2. Reference List:A reference list (of these citations) is included at the end of the assignment, in alphabetical order by author. The reference list also includes additional details such as the title and publisher.A bibliography lists relevant items that you have used in the preparation of the assignment but not cited in your text. A bibliography should also be in the Harvard style and the inclusion of such a list shows that you have read widely beyond the items you have cited. BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 11
LONDON CHURCHILL COLLEGEExamples of citation within text or body of the report:1. Cormack (1994, p.32-33) states that................2............. This view has been supported in the work of Cormack (1994, p.32-33).3. Jones (1946) and Smith (1948) have both shown......4. Corporate Author: 1st citation: Royal College of Nursing (RCN), 2007 2nd citation: RCN, 2007Examples of listings in reference list:1. Books with one author:Redman, P., 2006. Good essay writing: a social sciences guide. 3rd ed. London: Open University in assoc. with Sage.2. Books with two, three or four authors:The required elements for a reference are: Authors, Initials, Year. Title of book. Edition. Place: PublisherKirk, J. & Munday, R.J., 1988.Narrative analysis. 3rd ed. Bloomington: Indiana University Press. Page 11 of 12 BTEC HND in Business/ Managing Human Resources/May 20133. Books with more than four authors:For books where there are more than four authors, use the first author only with surname and initials followed by ―et al‖. The required elements for a reference are:Author, Initials., Year. Title of book. Edition. (only include this if not the first edition) Place: PublisherGrace, B. et al., 1988. A history of the world. Princeton, NJ: Princeton University Press.4. E-booksFor e-books the required elements for a reference are:Author, Year, title of book. [type of medium] Place of publication: PublisherFishman, R., 2005.The rise and fall of suburbia. [e-book]. Chester: Castle Press.If available at website: Fishman, R., 2005. The rise and fall of suburbia. [e-book]. Chester: Castle Press.Available at: libweb.anglia.ac.uk / E-books [accessed 5 June 2005].5. Journal articles BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 12
LONDON CHURCHILL COLLEGEAuthor, Initials., Year. Title of article. Full Title of Journal, Volume number (Issue/Part number), Page numbers.Perry, C., 2001. What health care assistants know about clean hands. Nursing Times, 97(22), p.63- 64.6. Newspaper articlesAuthor, Initials., Year. Title of article. Full Title of Newspaper Day and month before page numbers of article.Slapper, G., 2005. Corporate manslaughter: new issues for lawyers. The Times, 3 Sep. p.4-5.7. Journal articles from an electronic sourceBoughton, J.M., 2002. The Bretton Woods proposal: an in-depth look. Political Science Quarterly, [online]. 42 (6), Available at: http://www.pol.upenn/articles (Blackwell Science Synergy) [accessed 12 June 2005].8. InternetNational electronic Library for Health. 2003. Can walking make you slimmer and healthier? (Hitting the headlines article) [Online]. (Updated 16 Jan 2005) Available at: http://www.nhs.uk.hth.walking [accessed 10 April 2005].The title of a web page is normally the main heading on the page.9. E-version of annual reportsMarks & Spencer, 2004.Annual report 2003-2004. [Online]. Available at: http://www-marks-and- spencer.co.uk/corporate/annual2003/ [accessed 4 June 2005]. BTEC HND in Business/Unit31: Statistics for Management/April 2020 Page 13