Project Title
Medical Insurance
Author
David Graser, Yavapai College, Prescott, AZ (David_Graser@yc.edu)
Abstract
In this project, students compare two health insurance plans of their choosing to find piecewise linear functions corresponding to the plan rules. Students will calculate the amount of medical charges the would need to have in one year for the plans to cost the same in that year.
Project Content
Scaffolding Resources
Definitions: DOC | PDF - This handout contains definitions of various terms you might find in a health insurance plan.
Technology Assignment : Collect and Organize Data DOC | PDF - In this tech assignment, students learn how to format an Excel worksheet while collecting data about two health insurance plans..
Technology Assignment: Calculate the Total Annual Cost DOC | PDF - In this tech assignment, students modify the Excel worksheet from the technology assignment above to create a table for each health plan. Upon completion, they will have a table containing several values for total medical charges and the corresponding total annual medical costs.
Technology Assignment: Graph the Total Annual Cost DOC | PDF - Students use the worksheet above to make graphs the total annual medical costs as a function of the total medical charges for each plan.
Technology Assignment: Find Piecewise Linear Models DOC | PDF - This tech assignment helps students to combine the graphs for each health plan onto a single graph. In addition, it demonstrates how to find the piecewise linear formulas for each health plan.
Notes
- The website eHealthInsurance offers the ability to find and compare health insurance plans in all US states.
- Students have had trouble understanding what the entries in the handout for the Technology Assignment: Calculate the Total Annual Cost mean. I wrote a separate handout on Deconstructing the Premier Plan (DOC | PDF) to help students see where each entry comes from.
- I produced a video to help students fill out the table in Technology Assignment: Calculate the Total Annual Cost.
- If you would like to see a sample technical memo produced by a student for this project, you will need to email me for a password. This file is password protected to insure students do not access this file. Make sure you email me from your professional email account so I can verify your identity.
- I gave a presentation on this project at the Fall 2011 ArizMATYC Conference at Estella Mountain Community College. I made it into a Flash video you can view.
