About Me

My photo
Welcome to my math blog! The purpose of this blog is to help you stay informed about our learning and experiences that have taken place during our math class. I have also included links your child (and you) may want to use in order to supplement math learning in 5th grade.

Wednesday, December 13, 2017

Personal Financial Literacy: Santa's Expenses (Variable)

Bell Ringer:

STAAR Benchmark Kahoot

Lesson Frame:



Lesson:

We continued working with Santa's budget today by adding variable expenses.  Our spreadsheet started out looking like this:


Today's spreadsheet was bare.  This was in order for me to teach a few things about formatting the spreadsheet.  (1) We went through the credit, debit, and balance columns and formatted each with "currency" so that dollar signs, decimal points, and the change would be evident.

After putting in the balance, we put in the first expense.  At this point, I taught them how to format a cell to subtract.  We repeated this a few times to make them a little more comfortable, then I showed them the "cheat" that began appearing when we typed an = sign.  I did not teach them how to format a column in one step... maybe next time.

The expenses we used were:



When we added in the final expense, we noticed that Santa had a negative balance.  We knew that meant that he did not have enough money for the month.  This lead into our "close".

Close:

I wanted them to type their response, so I introduced them to "create" within Google Classroom.  Since the spreadsheet had already been assigned, students could "create" a Google Doc to answer this question.  When finished they were to "turn in" these two items through Google Classroom.

Assignment:
  • Countdown to STAAR 5.1.6
  • Think Through Math







No comments:

Post a Comment