The Children's Storefront

Please scroll to the RIGHT assignment

---

Challenge Assigned Wed 1/16/08 to Grade 8 and Assigned Thursday 1/17/08 to Grade 7 (same assignment)

Using the 33 years from 2008 to 2040, create a six column spreadsheet with these attributes

• column 1 must be the 33 years from 2008 to 2040

  Use the black cross/white cross trick after you highlight the first two

• column 2 must show what happens when $100 is deposited in a bank at 3% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $103)

  Use a formula such as = 1.03*B1 perhaps

  Use the black cross/white cross trick after you highlight just the SECOND one

• column 3 must show what happens when $100 is deposited in a bank at 4% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $104)

  Use a formula such as = 1.04*C1 perhaps

• column 4 must show what happens when $100 is deposited in a bank at 6% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $106)
• column 5 must show what happens when $100 is deposited in a bank at 8% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $108)
• column 6 must show what happens when $100 is deposited in a bank at 9% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $109)
• after studying what happens over 33 years, please color the first cell in each column where the money has doubled, e.g. reached $200; if it ever reaches $400 to double again, please color that one also. By color, we mean change the FILL COLOR.

  Don't forget this step (every multiple of 200)

• Include your name using a font of your choice and the size that equals one inch tall which coincidentally is also 72.
• Please make sure it "fits the page" and prints on one piece of paper
• You must HAND ME the printout (please ask for and write the date on it with a pen or pencil

---

Challenge Assigned 1/15/08 (Tues) to Grade 5 and Grade 6 ... 100 if completed by end of Wed ... 95 if completed by end of Thurs ... 90 if by and so on ... MUST BE PRINTED and handed to me ... Mr. Bergen

• Let A = your current AGE
• Construct a times table that goes from A-9 to A in both a horizontal and vertical direction
• For example, if you are age 10, it would go from 1 to 10
• For example, if you are age 11, it would go from 2 to 11
• The columns must be SHRUNK so that they are "not so wide"
• Use font colors, borders and patterns
• Put your name in a font size that is 1/2 inch tall (you should know the number by now)

  72 points make an inch so 36 points make half of an inch

• Include the date you print it and make sure it is twisted to be at a 45 degree angle

  Don't forget to twist it

• Please PRINT out (reminder you need permission to print) and hand to me in person. It must fit on ONE page.
• Please write the date and time with a pen or pencil on the page
• Do not forget to give to me .. Mr. Bergen

Using the 33 years from 2008 to 2040, create a six column spreadsheet with these attributes

• column 1 must be the 33 years from 2008 to 2040
• column 2 must show what happens when $100 is deposited in a bank at 3% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $103)

  Use a formula such as = 1.03*B1 perhaps

• column 3 must show what happens when $100 is deposited in a bank at 4% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $104)

  Use a formula such as = 1.04*B1 perhaps

• column 4 must show what happens when $100 is deposited in a bank at 6% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $106)
• column 5 must show what happens when $100 is deposited in a bank at 8% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $108)
• column 6 must show what happens when $100 is deposited in a bank at 9% annual interest (the cell for year 2008 is $100 and the cell for 2009 is $109)
• after studying what happens over 33 years, please color the first cell in each column where the money has doubled, e.g. reached $200; if it ever reaches $400 to double again, please color that one also. By color, we mean change the FILL COLOR.
• Include your name using a font of your choice and the size that equals one inch tall which coincidentally is also 72.
• Please PRINT out and hand to me in person
• Please write the date and time with a pen or pencil on the page