The Actuary s Toolkit

This course is designed to equip students in the Columbia Actuarial Program with the technical software skills essential for modern actuarial work, with a special focus on Casualty Actuarial Science. Through this course, students will gain proficiency in Excel and R—two foundational tools used in data analysis, reserving, ratemaking, and simulation modeling. Excel will be explored as a powerful and accessible tool for structuring actuarial models, performing sensitivity analysis, and managing large data sets. R will be taught as a robust statistical programming language that supports reproducible actuarial analysis, including the use of GLMs, bootstrapping methods, and data visualization. The course will also include an introductory segment on Python, highlighting its growing relevance in automating workflows, handling large-scale data, and integrating with machine learning frameworks that may be increasingly relevant in pricing and predictive modeling.

The broader aim of this course is to bridge the gap between theoretical actuarial concepts and practical implementation through programming. By learning these software tools, students will be able to operationalize core actuarial principles—such as risk modeling, claim development, and stochastic analysis—within real-world business contexts. The course aligns with the Actuarial Program’s mission to produce industry-ready professionals who can not only understand the mathematical underpinnings of risk but also communicate and deliver insights through modern analytics platforms. It supports the development of computational thinking, data fluency, and technical agility, which are increasingly critical in actuarial practice as the industry becomes more data-driven and technologically complex.

This is an elective course available exclusively to students enrolled in the Columbia Actuarial Program. No prior experience with Excel, R, or Python is required, making it an ideal entry point for students new to programming or applied analytics. The course will be conducted fully online over the course of a full academic semester, providing flexibility while maintaining rigorous engagement through weekly assignments, project-based learning, and applied actuarial case studies. Whether students aim to pursue traditional actuarial roles or explore emerging areas like InsurTech, this course will provide the software toolkit needed to succeed in a modern actuarial environment.