The Curious Scientist

General Notes

While we generated a Compojure web application, this is primarily an Incanter project, as the Clojure aspect generates the data that the front-end web application downloads and consumes using the AlaSQL client database.

Web Interface

Each lesson will be available on a single HTML page.

Load either SQLite for JS or AlaSQL
Use either Ace Editor (web site) for the Cloud9 Interface

Should we do a standard page, and then have the individual stuff downloaded?

Development

Using Emacs with csv-mode

Lesson 1: Dolphins

The trick is that the query should search for dolphins fed earlier than the last 4 hours … not today, even though the text of the question will be today.

Each Dolphin record should have the following fields (created by Clojure):

ID: Some random number between 1000 and 5000
Name: String
Last Fed: Timestamp that alasql understands
Weight: Integer between 150 and 650 kg
Length: Float between 2 and 4 m
Age: Approximate … date arrived?
Sex: male or female (based on name?)

Dolphin Species (enumerated list)
- Bottlenose (common) 40%
- Common (uncommon) 20%
- Atlantic Spotted Dolphin (uncommon) 20%
- Striped dolphin 10%
- Clymene dolphin
- Spinner dolphin
- False killer whale (rare)
Stay (in days … purely random?)
Modify length/weight based on species (and maybe age)
Fix Date to be in YYYYMMDDHHMMSS format See http://stackoverflow.com/questions/31151589/how-do-you-create-a-time-field-in-alasql

Lesson 2: Arsenic and Old Moss

What is the highest level of airborne arsenic Maybe other chemicals What year were they lowest? When we’re they elevated?