Exercise 3

Data management

Over the summer, interns at the HISC main office created checklists from the original occurrence data that were collected and augmented from the online form. Taking the role of the HSC Project Leader, you must now carry out final quality checks prior to publication.

  1. Download UC2-IS-3-ForCleaning.xlsx. (156 KB)

  2. Evaluate the dataset and identify which types of errors are present.

  3. Identify possible ways to correct those issues and perform those corrections for as many of the errors as you can.

  4. Use the exercise sheet to provide your answers and submit the spreadsheet.