Study Aids
Interactive notes and tools I made while studying health care analytics at Carnegie Mellon, drawing on my travel-medicine clinic work. Each one sets Thailand beside other countries, cites its sources, and shows where those sources disagree. For built systems and case studies, see the Project Archive.
From the 1790s to today in photos: insurance, payment and policy set against politics, the economy and society, with Thailand’s schemes alongside and a running count of who is covered.
From the first microscopes and germ theory to RNA vaccines: discoveries, outbreaks and wars, with Thailand’s programme, reigns and governments alongside. 108 stories, each with its sources.
Enter vaccines and labs, copy to EMR, import or export records, review historical guideline milestones and print an A4 or Letter record.
Draw ER diagrams in the class's Chen notation, normalize tables stage by stage and run relational algebra as a query tree, with every (min, max), key, dependency and normal form checked as you go. Opens draw.io files.
Type Oracle SQL and watch what the database does with it, clause by clause: FROM, joins, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, beside an ERD whose keys light up as each step uses them.
A 3Blue1Brown-style Manim video on pooled testing, its recursive re-splitting idea, and Dorfman's 1943 origins.