Activity 01
Spreadsheet Duel: Simple vs Compound
Pairs open a pre-made spreadsheet with input fields for principal, rate, and time. They calculate and graph simple interest against compound interest over 5 years, then adjust rates to see impacts on a $5000 loan. Pairs present one key finding to the class.
Explain the difference between simple and compound interest calculations.
Facilitation TipDuring Spreadsheet Duel, circulate and ask pairs to show you where the interest formula changes between simple and compound tabs before they graph results.
What to look forPresent students with a scenario: 'You borrow $1000 at 5% simple interest for 3 years.' Ask them to calculate the total interest paid and the final amount owed. Repeat with a compound interest scenario for comparison.