Ethan White

@ethanwhite
1 Followers
210 Following
279 Posts
Associate Prof in Environmental Data Science. Research + software + education. @weecology & Data Carpentry co-founder. #datadon #DataScience #ecology #rstats #python #OpenScience #OpenData #OpenSource
Websitehttps://www.weecology.org
Pronounshe/him
GitHubhttps://github.com/ethanwhite/
ORCIDhttps://orcid.org/0000-0001-6728-7745
Show threadEthan WhiteDec 6, 2022
@powersoffour 😂 I had to look up "ouroboros"
Ethan WhiteDec 6, 2022

Teaching SQL today so breaking out my favorite nemonic for the order of SQL clauses:

Select - So
From - Few
Where - Workers
Group by - Go
Having - Home
Order by - On time

Which I got from https://twitter.com/statsnam/status/1149431249511075840

Students definitely identify with it at the end of the semester.

Nam Nguyen on Twitter

“@beeonaposy Mnemonic that i used when i was learning SQL years ago lol. Thought you'd enjoy: So -Select Few -From Workers -Where Go -Group by Home -Having On TIme -Order by”

Twitter
Show threadEthan WhiteDec 6, 2022
@1ore Thanks! (and apologies for the new obsession). Happy to answer questions if you start building something out with one of your labs.
Show threadEthan WhiteDec 6, 2022
@hye @powersoffour I think that's a great way of thinking about it!
Ethan WhiteDec 6, 2022
Show threadHao YeDec 6, 2022
@ethanwhite @powersoffour
I think perhaps “now that you’ve worked through that can you add it to the wiki” is similar to "progress isn't permanent unless it's been committed". It's an additional step to learn, but important for record-keeping!
Show threadEthan WhiteDec 6, 2022

@echoechoR Yes, absolutely!

We did write about it, but a very long time ago here: https://jabberwocky.weecology.org/2008/12/14/the-benefits-of-having-a-lab-wiki/

Thanks for the links!

The benefits of having a lab wiki

Jabberwocky Ecology
Show threadEthan WhiteDec 6, 2022
@andrewlhipp Thanks! Project focused wikis can definitely be useful if the projects are big enough!
Show threadEthan WhiteDec 5, 2022
@cscott58 institutional memory - so key and yet so hard to maintain. I wish you all the luck with your 🐋
Show threadEthan WhiteDec 5, 2022
@rmflight @powersoffour 💯
Ethan WhiteDec 5, 2022
Show threadDr. Robert M FlightDec 5, 2022

@ethanwhite @powersoffour so, be consistent, model the behavior, and reiterate again and again the *why* we do it this way.

If you want the students to use it, then you need to use it too. It is a great way to capture all those little pieces of knowledge about navigating university bureaucracy, experimental designs, and if you analyze other people's data, their designs too. 😉