Balanace Sheet Math
Balanace Sheet Math
Embedded Files
Students discover how to create a balance sheet similar to what you would see in a bank statement. Fictional debit and credit transactions are typed in and students create a custom math function to calculate a running bank balance.
Learning Objectives
Learning Objectives
By the end of this activity, students will be able to:
- Create a custom function that calculates a running balance
- Ensure valid user input with drop down lists and date pickers
- Create a pie chart to display money spent by category
- Create a line chart to display bank balance trends over time
Lesson Materials
Lesson Materials
Finish the following to complete the assignment:
- Open the "starter" Google Sheet
- Open instructions to slide 11
- Skip "Formatting" slides 21 - 28
- Check the answer key once done
Page updated
Report abuse