Tuesday, February 12, 2008

EXCEL SHEET

Brody has three months to save $1200. Here is his plan. Will he make it?

March:
Must pay $200 to his mom
Must pay $300 for rent
Must pay $100 for his car
He will earn $200 from lawn mowing
He will earn $75 for babysitting
He will earn $775 for selling items on Ebay

April:
Must pay $50 in rent
Must pay $100 for his car
He will earn $300 from mowing lawns

May:
Must pay $60 for tickets to go to a concert
He will earn $20 from babysitting
Must pay $100 for rent

TASK
You must compose a spread sheet with all of the information above. Think about how you would design the spreadsheet. By month? By items he needs to pay for vs. money he owes? Be neat and organized! Make smart choices so your audience will understand it. In addition to including all of the information above, you must also provide the Total for he will have (either positive or negative) for each month and then provide a grand total at the end of how much he will have (it may be a positive or negative number). You will have to generate formulas for these.

Use different easy-to-read fonts and sizes, appropriate column headings, and again, make sure your information is organized in a smart way so if you were to present it, your audience would understand it. You may include only one piece of clip art.

When you are finished, print preview and make sure it is in landscape. In addition, add a footer with your name/date/hour.

Tuesday, January 22, 2008

Monday Jan 22

Today I collected your Eulogy paper and your Big Wave assignment from the weekend.

Next we discussed the next unit of grammar: compound and complex sentences. You had time to read, take notes, and attempt a few problems beginning on page 556.

Class/Homework:
Take notes on pages 556/557 & 559
Do problems:
Page 557 #1-10, #11-20, answers only
Page 560 #1-5 write out the sentences
#11-15 write out the sentences

Friday, January 18, 2008

A Bit of Fun

You have been working hard lately and should be rewarded. You may go to one of the following sites below after you finish your flyer:

Monday, December 3, 2007

Christmas Wish List

Today and tomorrow you are going to shop for 15 goodies you would like for Christmas. (I know it is early, but it is never to early to shop for good deals!)

In an excel sheet, create a spreadsheet that will have a good design, at least two small graphics, a list of 15 items you would like for Christmas, and how much it costs for each of them. At the end, give a total cost of all the items by setting a formula to have the computer do the math for you.

In addition, create a 3-D Pie chart so that your parents can easily see what item they are spending the most money on.

Finally, in a word document, type a numbered list of all the websites you visited to find your items. See the example below:

Mrs. Ehle's Christmas List
1. An Ipod Nano--www.target.com
2. A Nikon D60 Digital Camera---www.ritzcamera.com

***************
TURN IN:
When you hand in the assignment, you should turn in:
(PRINT PREVIEW YOUR WORK BEFORE YOU PRINT IT OUT!!)
1. he Excel Spreadsheet and the chart together in one document. It should be printed in landscape format. Please print the answers only (No Formulas).
2. A Word document with your items and places you shopped on the internet.

EXCEL--Can you do it?

Aaron has monthly expenditures. He only has $1000 in his budget. Your job is to create a spreadsheet for him.



Here is what he spends his money on:

HOUSE: $450

PHONE: $60

CABLE/COMPUTER: $60

ENTERTAINMENT: $50

GAS: $30

GROCERIES: $150




  1. Make the title of your spreadsheet A1: Aaron's Monthly Expenses.

  2. Then merge cells A1-C1 for the title.

  3. Input column headings for the information above. A2 should say EXPENSES and B2 should say COST. Widen columns as needed

  4. In A3-A8, enter the things he spends his money on and in B3-B8, put the amounts he spends on each of them.

  5. In A9 should say GRAND TOTAL, in B9 use a formula to total up how much he spent for the month.
  6. In A10 should say Money Left Over, in B10 use a formula to show close he is to spending $1000.
  7. Insert a graphic of a smiley face if he has money left over, and insert a graphic of a sad face if he went over his budget of $1000.
  8. When you are finished, please print out one copy LANDSCAPE, with the formulas only. Make sure to add a footer with your name/date/hour on it.