Activity Overview
This App provides the capabilities of a spreadsheet. Students enter data and text in cells, create cell formulas, and use built-in functions in cells.
Before the Activity
See the attached PDF file for detailed instructions for this activity
During the Activity
Follow the Activity procedures:
Use the CellSheet App and find simple compound interest
Enter the principal amount and the interest rate in cells A1 and A2
Create a column to list years up to 10 and a column to display the balance amount
Use absolute reference and enter the formula to calculate the balance after 1 year
Copy the formula to other cells
View the balance amounts after each time period
Change the principal amount and interest rate and view the updated balance
After the Activity
As a class, discuss difficult concepts