What If?, Excel

Let students play What If? using an Excel spreadsheet. Each student selects an item he/she would like to buy and finds out its cost, and then creates a spreadsheet to calculate how long it will take to be able to afford the item. Column A shows the cost of the item. Column B shows the amount of money earned each week, and Column C shows the percentage saved. A formula is entered in Column D to calculate the amount saved each week. A formula is also entered in Column E to calculate the total amount saved.

Students can go in and change any of the numbers in Column B or C and see how it affects the amounts shown in Column D and E. For example, in the next figure, the percentage of savings in cell 4C was changed from 5% to 20%.

 

GLEs - Math

Grade 4
Number and Number Relations
14. (N-9-E)

Grade 5
Data Analysis, Probability, and Discrete Math
30. (D-1-M)

Grade 6
Data Analysis, Probability, and Discrete Math
30. (D-2-M)