NELHA Biota Study Sidney Vermeulen January 2 nd - January 30 th - - PowerPoint PPT Presentation

▶
nelha biota study
SMART_READER_LITE
LIVE PREVIEW

NELHA Biota Study Sidney Vermeulen January 2 nd - January 30 th - - PowerPoint PPT Presentation

Dec 07, 2022 478 likes •710 views

NELHA Biota Study Sidney Vermeulen January 2 nd - January 30 th Graduate HPA 2017 Current MIT Sophomore About Me Major: Biological Engineering Minors: Computer Science, Statistics Dedon Lab: Cell culture Contracted reports

slide-1
SLIDE 1

NELHA Biota Study

Sidney Vermeulen January 2nd - January 30th

slide-2
SLIDE 2

About Me

 Graduate HPA 2017  Current MIT Sophomore

 Major: Biological Engineering  Minors: Computer Science, Statistics  Dedon Lab: Cell culture

slide-3
SLIDE 3

What is the biota data?

 Contracted reports  Anchialine ponds, marine coral, marine fish communities  Quarterly, then biannual, then annual  Monitor NELHA’s impact on the environment

slide-4
SLIDE 4

Project Goals

 4 Week Project  Digitize all Biota Studies since 1989 (~ 1 Week)  Analyze longitudinal data (~ 1 Week)  Create a webpage for the public to access data (~ 2 Weeks)

slide-5
SLIDE 5

Objective One: Digitize Data

slide-6
SLIDE 6

Digitizing Data

 Adobe Acrobat to transform image PDFs to editable text PDF  Tabula to extract tables  Four boxes of reports!

 Over 50 reports to digitize

 Blank and missing data

slide-7
SLIDE 7

Objective Two: Analyze Data

slide-8
SLIDE 8

Data Analysis

 Analyzing coral coverage and fish counts  Basic visualizations using excel  Statistical analysis using R

 Help from Professor John Burns from UH Hilo for statistical analysis

slide-9
SLIDE 9

 Large variance year to year  Diversity about the same  Individual species of coral and fish similar to the mean

Findings Findings

slide-10
SLIDE 10

 Analysis of decades  Coral coverage and fish count have an

  • pposite effect

 90s significantly less coral  10s significantly less fish

Findings Statistical Analysis

slide-11
SLIDE 11

Object Three: Presenting Data

slide-12
SLIDE 12

Presenting Data

  • Challenge: Presenting a large amount of data in a few digestible charts
  • Raw data
  • Decade averages
  • Add interactivity
  • Goal: Explore data as much or as little as you want
slide-13
SLIDE 13

Buttons and Dropdowns

  • Anchaline Ponds
  • Opae Ula density plotted with the presence or absence of mosquito

fish

  • 15 possible graphs
  • Coral Cover and Fish Counts
  • Site
  • Depth
  • 47 possible graphs
slide-14
SLIDE 14

 Toggle bars/lines using the legend  Zoom option  Can see the data at each point

Findings Chart Elements

slide-15
SLIDE 15

Database on Google Sheets

  • Raw data is self updating
  • Spreadsheet formulas
  • Ensures longevity of project
slide-16
SLIDE 16

Web Products

  • NELHA Website:

http://nelha.hawaii.gov/resources/library/nelha- lab-reports/sidney-biota/

  • Google Sheets:

https://docs.google.com/spreadsheets/d/1nv5Qf_ DEMTfXAVj1qcYPD0zzOYcJY6rST- A8zWYmqVQ/edit

slide-17
SLIDE 17

Takeaways and Next Steps

slide-18
SLIDE 18

Personal Takeaways

  • First computer science project
  • Web development
  • Coding in HTML, and Java Script
  • Working within Wordpress
  • Science opportunities in Hawaii
slide-19
SLIDE 19

Project Next Steps

  • Website organization
  • Create group of colors and patterns for the bar

and line graphs

  • Data analysis
  • Weather events (ie. Hurrican Iniki (1992) and coral

bleaching 2014

  • Comparative analysis to other sites monitored
slide-20
SLIDE 20

Questions? Suggestions?

slide-21
SLIDE 21

Thank You

  • Keith
  • Pam
  • Laurence
  • Everyone else at NELHA