MTH 1840 - Computer Applications in Actuarial Science

3 lecture hours 0 lab hours 3 credits

Course Description
This course introduces students to computer applications used for actuarial science. Students are introduced to advanced functions in Microsoft Excel and to the R programming language. Topics include problem formulation, data analysis, graphical solutions, as well as an introduction to R data structures. Applications to actuarial science are discussed. The course material is presented as a combination of lectures and hands-on exercises. This course meets the following Raider Core CLO requirement: Integrate Learning. (prereq: Actuarial Science major or Actuarial Science program director consent)

Course Learning Outcomes
Upon successful completion of this course, the student will be able to:

Analyze and present data
Use computer applications to create professional presentations of solutions
Work with advanced formulas and functions in Microsoft Excel
Construct Pivot Tables and Pivot Charts in Microsoft Excel
Understand data types, data structures and indexing in R
Apply basic functions in R
Construct appropriate plots for the data type

Prerequisites by Topic

Basic algebra

Course Topics

Working with data and Excel tables
Performing calculations on data
Formatting
Filters
Formulas and functions in Excel
Charts and graphics
Pivot Tables and Pivot Charts
R objects: vectors, matrices, arrays, lists, and data frames
Data aggregation and manipulations
Data visualization

Coordinator
Dr. Won Chul Song

Announcement

The Raider Return

Milwaukee School of Engineering

Connect With MSOE

MTH 1840 - Computer Applications in Actuarial Science