|
Sep 08, 2024
|
|
|
|
MA 1840 - Computer Applications in Applied Mathematics4 lecture hours 0 lab hours 4 credits Course Description This course introduces students to computer applications used for solving mathematical problems. Students are introduced to advanced functions in Microsoft Excel and to the Python programming language. Topics include problem formulation, data analysis, graphical solutions, as well as introduction to programing logic, conditional statements, looping techniques, and functions. Applications to actuarial science are discussed. The course material is presented as a combination of lecture and hands-on exercises. (prereq: open to Actuarial Science students only) 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
- Write macros in Microsoft Excel
- Implement conditional statements in Python
- Implement FOR and WHILE loops in Python
- Implement functions in Python
Prerequisites by Topic Course Topics
- Working with data and Excel tables
- Performing calculations on data
- Formatting
- Filters
- Formulas and functions in Excel
- Charts and graphics
- PivotTables and PivotCharts
- Macros
- Conditional statements
- FOR and WHILE loops
- Functions in Python
Coordinator Dr. Kseniya Fuhrman
Add to Portfolio (opens a new window)
|
|