Overview
For this assignment, you will create a savings plan for a future purchase and then visualize your savings plan in a line graph using Excel. Along the way, you will be asked to identify and interpret various elements of linear equations, while analyzing the equations to determine if your savings goal will be met during your pre-determined time frame. This assignment is meant to be a practical way for you to analyze a savings plan in a real-world scenario that is personal to you. Additionally, you will learn valuable Excel graphing tools and apply logic to draw conclusions based on mathematical information within your savings plan.
Before starting on the worksheet, you will first review the Background for Module 3, which includes videos, reading materials and practice exercises to prepare you to finish the worksheet accurately and thoroughly.
The Background consists of the following topics:
- Slope
- Graph Equations and Inequalities
- Graphing Using X and Y Intercepts
- Slope-Intercept Form
- Writing Equations of Lines
- Solve a System of Equations
- Identify System Graphs and Solutions
- Graph a System of Equations and Inequalities on a Coordinate Plane
- Apply a System to a Real-World Situation
The worksheet given has boxes below the questions where you will provide your answers and calculations. You will need to show your work for all your answers.