|
Warren
Township High School |
| Excel Project Page > Excel Project |
|
EXCEL PROJECT |
|
DIRECTIONS:
You are to work with a partner for this project. You are to answer each of the following problems using an excel spreadsheet. You are to use Excel only! (No calculators!) You must use formulas, functions and cell references for all your solutions. Your spreadsheet must be formatted attractively. Along with figuring out each problem you will need to write up and print a detailed explanation of how you solved the problemWord. Print a copy of the spreadsheet with and without formulas, and provide a graph for each problem.
You will be assigned one problem to present to the class your solution using PowerPoint. When creating the presentation, assume no one in the class has seen the problem before. Include a 1) title slide 2) introduction 3) text description of solution 4) spreadsheet 5) spreadsheet--formula view 6) chart 7) conclusion.
Print your PowerPoint presentation 6 slides per page. Place the PowerPoint printout last in your binder!
Printouts for each job should contain: 1)-Word Solution, 2)-Spreadsheet, 3)-Spreadsheet Formulas, and 4)-chart.
Place all documents in a bound folder. (Title Page, Table of Contents.....)
|
|
PROBLEM 1--Cookies
A baker has two kinds of cookies one costs .75 per pound and the other costs .50 per pound. Create a spreadsheet that shows how many pounds of each should be used to make a mixture of 60 total pounds costing .55 per pound. |
|
PROBLEM 2--Cashier Countdown
At the end of the day, the manager at Golf World has the cashiers add up the money in their cash drawers. They usually make mistakes in counting the total amount of money. Create a spreadsheet that will allow employees to enter the number of each and every kind of coin and bill in the drawer and find a total. |
|
PROBLEM 3--Carpet Cost Calculation
Mr. Jones is trying to decide how much money it will cost to install carpeting in his home. Create a spreadsheet that shows: length and width for each room, square feet, square yards, cost per room and total cost of carpet. The carpet to be purchased costs $12.50 per square yard. The house has these dimensions:
LR 12 x 14 BR1 18 x 22 BR2 10 x 11 BR3 13 x 12 Den 8 x 10 Game room 25 x 16 Hallway 3 x 26 |
|
PROBLEM 4--Veterinarian Drug Calculator
Dr. Voorhees, a veterinarian, must determine appropriate dosages for certain animals. Most medicines are given according to body weight in kilograms. The vet gives the animals 0.4 ccs per 2 kg of body weight. Create a spreadsheet to find the dosage for the following animals: Horse 500 kg Collie 35 kg Cat 14 lbs. Doberman 85 lbs. |
|
PROBLEM 5--Tennis Tourney
A tennis tournament has been scheduled at WTHS for next weekend. You are in charge of ordering the scorecards. 106 people are entered. The tournament is single elimination and one scorecard is needed for each match. You do not need a scorecard for a BYE. A) How many score cards are needed if all the players show up for the tournament? B) If you make the tournament double elimination (you must lose twice before you are out), how many score cards do you need? |
|
PROBLEM 6--Mortgage Calculator You want to buy a new house. To buy the house you want, you need a loan for $100,000. Youve been shopping for loans and found one offering an interest rate of 9.5% with a 15 year term, 8.5% with a 20-year term, 7.5% with a 25-year term, and 7% with a 20-year term. Use a *data table(s) to calculate your monthly payments for each interest rate, and what your total interest would be for each loan. *use help! |
|
PROBLEM 7--Car Loan Calculator
You want to buy a car for $18,500. The car dealer has offered to finance your purchase at 8.5% for 48 months. You can afford to make payments of $250.00 per month.
A) Use A) **Goal Seek to find the maximum amount you can borrow at this interest rate.
**use help! |