Activity 01
Spreadsheet Challenge: My Future Wealth
Students enter personal data like age, monthly savings, and interest rates into a shared spreadsheet template. They generate line graphs comparing compound vs. simple interest over 20-40 years. Pairs then swap and critique each other's projections for realism.
Analyze the incentives driving behavior in long-term savers.
Facilitation TipIn the Spreadsheet Challenge, circulate to ensure students adjust the interest rate and compounding frequency cells correctly, as these are common entry points for calculation errors.
What to look forProvide students with a scenario: 'Sarah invests $1000 at 5% annual interest, compounded annually. John invests $1000 at 5% annual interest, compounded monthly. Calculate how much each will have after 1 year and after 5 years. Which method yields more and why?'