CS 101 · Year 1 · Semester 1 · 4 credits · Computer Science
Programming I (Python)
From first principles to reproducible actuarial pipelines: write clean, testable Python that prices risk.
The Meridian Migration: Building an Actuarial Engine in Python
When a catastrophic spreadsheet error threatens Meridian Mutual with regulatory sanctions, a newly hired junior actuarial analyst must rebuild the firm's core pricing and valuation pipeline in pure, tested Python before the state insurance commission audit.
At 7:42 AM on Maya's third day at Meridian Mutual, Chief Actuary Marcus Vance slams a 400-megabyte spreadsheet onto her screen. A nested IF formula across row 14,000 has misclassified tobacco users as preferred non-smokers, underpricing 12,000 term policies by 3.4 million dollars.
Transcript
At 7:42 AM on Maya's third day at Meridian Mutual, Chief Actuary Marcus Vance slams a 400-megabyte spreadsheet onto her screen. A nested IF formula across row 14,000 has misclassified tobacco users as preferred non-smokers, underpricing 12,000 term policies by 3.4 million dollars.
- Master Python core syntax, primitive types, and variable assignments for actuarial modeling
- Implement branching logic and iterative loops to process policyholder records
- Define modular, reusable functions with docstrings and type annotations to price insurance contracts
- Compute expected loss and pure premium programmatically across diverse risk profiles