In this coursework, you need to evidence your knowledge of all your learning outcomes in the module booklet: LO1, LO2, LO4 and LO5 are directly embedded to the coursework, LO3 needs to be embedded by the students (hint: either by using different tools/methods OR comparing the tool/method they have used with other available tools/methods). Required files in Coursework Submission: An academic report named as CC6057_StudentID , student ID being your numerical London Met ID. Part 1 [40 marks total] This task will test your ability to find relevant data, cleanse & transform the data and build dimensional database or any other Data Mining techniques to analyse data. Using what you have learned in this module, apply the Data Analysis Lifecycle steps to complete the tasks below. It is expected that students use the software taught in this module, but it is optional. If students decide to use other tools, then they need to prepare a Walkthrough or Readme to explain how the solution works. Old cities like London, have narrow streets; while they are not even enough to tackle cars, busses and pedestrians, the usage of scooters, bicycles etc. has increased. The purpose of this coursework is to find if this is affecting the road safety. Make sure to section your coursework methodology according to Data Analysis Lifecycle. 1. Find data relevant to Road Safety and describe it. Hint: search for Road Safety Data from data.gov.uk and download casualties, vehicles and accidents [5 marks] 2. Import the data to your preferred environment and complete the below: A. Apply data profiling, check for errors, inconsistencies and correct them accordingly. [15 marks] B. Design a model to answer the questions in part 2 [20 marks] CC5067Main sit Coursework 22-23 Academic Year pg. 2 Part 2 [20 Marks total] Answer the below questions using one of the methods learned in this module: 1. Which accident severity type occurs the most? Do we know what it is labelled as? [5 marks] 2. Is accident severity affected by vehicle type? If yes, which vehicle type? If no, why is this your decision? [5 marks] 3. Which gender is involved more in accidents? What is the top 5 most used vehicle type by that gender? Is the most used vehicles the same for the other genders? [5 marks] 4. List 5 more questions to answer and write down the answer. [5 marks] Part 3 [35 Marks total] Add below to your report with captions to explanation where they belong in Part 2. 1. Share all the visualisations created/code written to answer the questions in Part 2. [10 marks] 2. Download the embedded csv files from here( Weather.csv , Vehicle_Type.csv , Accident_Severity.csv ) and answer the these questions: a. If you had these in Part 1 and Part 2, would you change your design in Part 1 B.? b. Would you answer any questions from Part 2 differently? Why? [10 marks] 3. Given these 2015 datasets( Accidents_2015.xlsx , 2015_Make_Model.cs v ),prove or disprove White-Van Man (https://en.wikipedia.org/wiki/White_van_man) stereotype? [15 marks] CC5067Main sit Coursework 22-23 Academic Year pg. 3 Report Structure [10 Marks total] You are required to write academic report, make sure you follow the below structure: Cover Page Table of Contents Introduction Methodology and Design Findings (Answers to Part 2 and 3) Conclusion