using technology.
Language Obj:SWBAT use content vocabulary correctly
This week we will work on three assignments: Zippy Zoo, Huskie Jo's Budget, and Carpet Squares. Today we will review the Excel vocabulary, there will be a quiz on Wednesday, and most of you will complete the assignment, Zippy Zoo. When you finish the assignment attach the file, named Zippy Zoo, to edmodo.
Zippy Zoo Spreadsheet
1. In cell A6 type Animal, in B6 type Number, in C6 type Weight, in D6 type Total.
2. Highlight the words in row six and Change the alignment to center and make bold.
3. Enter the following animal names beginning in cell A8 and ending in A13: Gorilla, Elephant, Rhino, Tiger, Llama and Lion.
4. Type Total Weight in cell A15, and # of Trucks Needed in cell A16. Make both titles bold.
5. Type the following numbers in cells B8 to B13: 2, 5, 2, 5, 2, 6.
6. Type the following numbers in cells C8 to C13: 700, 2500, 4000, 425, 475, 175.
7. Now add a simple formula to calculate the weight of each animal times the number of each animal. So in cell D8 type the formula, =B8*C8. Then hit enter.
8. Then copy cell D8 by right clicking and choosing copy. Then highlight D9-D13 and right click and paste. You should notice that even thought the formula was copied from cell D8 the program has automatically adjusted to the new cell addresses and the formulas are correct.
9. Use speed sum button ( Egyptian looking E ) to add the total of each column. Highlight B8-B15 and click the speed sum button. You sill notice the answer appears in the bottom blank cell. Now do the other two columns at the same time.
10. Now we need to add a formula to see how full the trucks are. Click in cell B16. Enter a formula in this cell which will take the total weight of all the animals and divide it by the weight each truck can hold which is 4500 lbs. You should get 5.783333.
11. We want to fill five trucks exactly. In order to do this, you will need to experiment with the numbers of animals. If you have used the cell addresses for your formulas the answers will automatically update as you change the weight and the number of trucks. When you get five trucks, save you spreadsheet as Zippy Zoo and send it to me on edmodo.