- Home
- Free Samples
- Data Science
- DATA4200 In-Class Group Data Mining E...
DATA4200 In-Class Group Data Mining Exercise Assessment 1 Answer

Assessment 1 Information
Subject Code: | DATA4200 | ||
Subject Name: | Data Acquisition and Management | ||
Assessment Title: | In-Class Group Data Mining Exercise | ||
Assessment Type: | Data Analysis | ||
Word Count: | 500 | Words | (+/-10%) |
Weighting: | 20 % | ||
Total Marks: | 20 |
Your Task
- Face-to-Face Students: Complete this task in an online zoom webinar at your usual class time in Week 6. The zoom link will be provided to you a few weeks beforehand.
- Online Students: Complete this task in your usual online webinar in Week 6.
Assessment Description
- Business Problem: Suppose that you are a data analyst for the Police department in Boston, USA. You have been asked to start cleaning and analysing subgroups of crime statistics in your city.
- Data sets: Access the following excel files on the KBS portal: Boston_Crimes.csv
Offense_codes.xlsx
- Recall that we first saw this data set in Week 5.
- The group activity in Week 6 will consist of each group submitting a word document and excel file on MyKBS in 2.5 hours with:
- Part A: A quick review of theory from weeks 1-5 (200 words)
- Part B: Cleaning, interpreting and visualising data (using excel or SQL and/or Tableau) and writing up your interpretation as a group (250 words)
Assessment Instructions
- Form groups of 3-4 to complete the exercise before class
- All students will be given 2.5 hours in an online zoom session in Week 6 during your class time to complete this activity
- Face-to-face students will be sent a zoom link for the class in Week 4 (in week 6 they do not attend campus but come online)
- The activity is open book
- You will need access to excel or SQL and Tableau and a computer in class to complete this activity
- To prepare for this activity review lectures 1-5 and practice SQL and excel examples
- At the beginning of your online class your lecturer will email you Part A and B questions in a word document to complete as a group (in break out groups using screen share so the whole group can work on one document)
- Supporting excel data can be submitted via an excel file
- All students must be online, contribute and have their camera on
- Any visualisations can be pasted into the word document
- Once the group has completed the questions, and before 2.5 hours are up, one group member only needs to:
- Submit the word document into a Turnitin drop box on MyKBS (in assessment table)
- Submit their supporting excel file into an excel drop box on MyKBS (in assessment table).

Customer Testimonials
ABC Assignment Help for one reason became my favorite because they don’t have a very complex signing up process and it’s very simple so everybody can use it. I was able to sign in without any hassle as my Company Law Assignment was due and they did it for me in a very efficient manner and I am very delighted with their service and a heartiest thanks.
Emily, Sydney
I work part time to meet my expenses apart from college and I took this as a decision to not burden my parents. A while later I started feeling great amount of stress in balancing it all together and decided to seek help from ABC Assignment Help for my Commercial Law Assignment and they did my assignment for me and I am super satisfied with their work style. Thank you so much.
Lawrence, Tasmania
I had a harsh week as I was extremely debilitated and every one of my assignments were getting excessively and caused me an incredible mental breakdown. A companion of mine seeing my circumstance asked me to utilize ABC Assignment encourage, their quick and efficient administrations helped me complete my Contract Law Assignment with less stress
Rihana, New South Wales