Congratulations!! You have been selected as the winner of a $1000 shopping spree at the store of your choice from those listed below. WAIT, there's a catch. You knew there would be didn't you?
You can only take home your choices if your total bill is between $995 & $1000 including tax. (ahem, you do realize you can't really take these home, right?)
All of your shopping has to be in only one of the stores listed below.
You can not buy more than 3 of any one item
You can not spend more than 1/2 of your money on a single item
You can not buy gift cards
You can not start shopping until your spreadsheet is set up to correctly calculate your totals!
No problem, right? You know how to use a spreadsheet to keep track of your purchases and calculate the tax and total for you!! All you have to do is create a spreadsheet that looks like this:
Shopping Spree Spreadsheet
Shopping Spree Spreadsheet
Formulas Your Spreadsheet Should Have:
Each cell in Column D should be a formula that multiplies the Cost per Item by the Quantity Purchased for each item you buy. Hint #1: To multiply something you need to use the asterisk (shift 8)Hint #2: Formulas ALWAYS start with an equal sign (=) and since you will be doing basic math functions they will always start with =SUM(
The Sub-Total should be a formula which calculates the total of all of the items in column D Hint #3: Try using the Auto Sum feature
excel-autosum.jpg
The current tax rate is 9.75% (the example shows 8.25% but you need to use the current rate which has increased) so the Tax total should be a formula which multiples your Sub-Total by the tax rate.
Your Grand Total should be a formula that adds your Sub-Total plus the Tax amount - Remember this needs to be between $995 & $1000! Can you reach exactly $1000? The person coming the closest to $1000 (between $995 & $1000) will win a prize!
Where You Can Shop:Remember you have to pick ONE store and you can not start shopping until your spreadsheet set up is complete!!
ask Cards
Task Card Video
Movement, Looping (repeat/forever) and Bouncing on Edge
Change effects (color, etc), Press key and Wait __ sec.
Importing New Sprites and Speaking/Thinking
Create Your Own Animation Using Costumes
X&Y Coordinates and Pen Down Effect
Sensing Feature/Hide and Show
Broadcasting and Receiving
Variables and Keeping Score
Putting It All Together
Editing Sprites
Scratch Basics
click on the lessons to download instructions.Video Game Graph
video gamesUse the above link to complete your bar graphs of the Top 10 videogames.
Remember a good graph:
Title
Axis
Labels
Key
Scale
Line Graph
Create a line graph using information for the Play Station 2 (PS2) from 2000-2010.
Line Graph
You must set up a table, this time copy and paste will not be an option!! Here is an example.
Your graph should show the years and the number of PS2s sold over time.
Format your graph ( font, font color, line color, title).
Excel Review
Excel Review.xlsx
- Details
- Download
- 29 KB
All About Me
Evaluating Websites
WolvesWild Ones
Hinter Land
Fake or Real
Compare and contrast these two website with the information you know about evaluating references.
Dog Island
Dogs and More Dogs
Fraction Games
Fraction ManorTriplets
Bridge Builders
Decention (decimals, percents and fractions)
CyberSense
Click the link to play the game.
Martin Luther King Jr.
Watch short biography of his life. Here
Take a look at some photos. Here
Watch No Socks Only
Shopping Spree
Congratulations!! You have been selected as the winner of a $1000 shopping spree at the store of your choice from those listed below. WAIT, there's a catch. You knew there would be didn't you?
- You can only take home your choices if your total bill is between $995 & $1000 including tax. (ahem, you do realize you can't really take these home, right?)
- All of your shopping has to be in only one of the stores listed below.
- You can not buy more than 3 of any one item
- You can not spend more than 1/2 of your money on a single item
- You can not buy gift cards
- You can not start shopping until your spreadsheet is set up to correctly calculate your totals!
No problem, right? You know how to use a spreadsheet to keep track of your purchases and calculate the tax and total for you!! All you have to do is create a spreadsheet that looks like this:Formulas Your Spreadsheet Should Have:
Hint #1: To multiply something you need to use the asterisk (shift 8) Hint #2: Formulas ALWAYS start with an equal sign (=) and since you will be doing basic math functions they will always start with =SUM(
Hint #3: Try using the Auto Sum feature
Where You Can Shop: Remember you have to pick ONE store and you can not start shopping until your spreadsheet set up is complete!!
- Amazon
- Toys R Us
- Target
- Best Buy
You can only buy things appropriate for your age! No movies or games rated above your age, no music with warning labels, nothing inappropriate!!Your spreadsheet should be named: Shopping Spree and saved in your folder