Hermiones Dilemma

1
Hermiones Dilemma

• Hermione baby-sat all summer long for Johnny.
  She earned 125 for her efforts. With the start
  of the school year, she wants to go shopping for
  some new school clothes. After spending some
  time at Old Shnavy Magic Clothing Store she
  narrows down her items to the following

2
Hermiones Dilemma

• A super cute pair of boot cut jeans 35.00
• A pair of flip flops 6.50
• A printed t-shirt 12.99
• A blue purse 15.99
• A yellow sundress 28.50
• A necklace 5.99
• A canvas jacket 32.00
• 1. Can she buy all of these things (show your
  work)?

3
Hermiones Dilemma

• 2. What if she had a coupon for 10.99 off of
  her entire purchase. Could she buy all of them
  now? Why or why not?
• 3. Oh wait! Hermione just saw the fine print
  on the coupon. The coupon could be used for 10.99
  off the entire purchase along with half off the
  lowest price item. Could she buy all of them
  now?

4
Hermiones Dilemma

• A super cute pair of boot cut jeans 35.00
• A pair of flip flops 6.50
• A printed t-shirt 12.99
• A blue purse 15.99
• A yellow sundress 28.50
• A necklace 5.99
• A canvas jacket 32.00
• Coupon for 10.99
• Oh yeah 1/2 off of the lowest priced item plus
  the 10.99 off.
• Use this spreadsheet to show how this cost is
  different from that with just the coupon.
• Hermione_shopping_trip.xls

5
Ron is so full of tricks!

• Pick a number
• Add 4 to your number
• Multiply your new number by 2
• Subtract 4 from your number
• Divide your new number by 2
• Subtract your original number for the number your
  just got!
• Bet your number is 2!

6
Show Ron the Algebra!

• Pick a number
• Add 4 to your number
• Multiply your new number by 2
• Subtract 4 from your number
• Divide your new number by 2
• Subtract your original number for the number your
  just got!
• Bet your number is 2!
• 2(N4) - 4 - N
• 2
• 2

7
And now work with this spreadsheet

• Rons_trick.xls

8
Ron has some new tricks for you TO DESIGN
DYNAMICALLY!

• First you have to find them!
• From Format, select Sheet and then Unhide.
• Problem 1 allows you to explore the trick
  DYNAMICALLY - What kinds of numbers can you
  use?
• Create new DYNAMICAL tricks - 2 and 3

9
HarrysTurn

• See that wand in his hand?
• Well, he somehow cast a spell that caused the
  wand to recreate itself over and over and over
• Professor Trelawney is challenging Harry to
  explore some patterns that he could create with
  the wands!

10
Oh my, the wands are piling up. What pattern can
you make with them?

• Make squares that build on each other this way!
• Your first task is to show Harry how to figure
  out how many wands are needed to create 1,000,000
  squares this way!

11
Oh my, the wands are piling up. What pattern can
you make with them?

• Harry would appreciate it if you would tell him
  using this spreadsheet!
• wands.xls

12
Oh my, the wands are piling up. What pattern can
you make with them?

• Harry thought of a new pattern for the wands!
  Can you find its pattern?
• It is shown in the sheet called Pattern2 in the
  wands.xls
• wands.xls

13
Oh my, the wands are piling up. What pattern can
you make with them?

• Goodness that is a lot of wands. If Harry were
  to sell the wands he used to make the 1,000,000
  squares for 1 each for either pattern, would he
  be able to pay off the national debt?
• Check with the national debt right now!
• http//www.brillig.com/debt_clock/

Pattern1
Pattern2