ComputerScienceExpert
$18/per page/
can I get this done quick. I need this for class tomorrow.
To The Moon and Back!
An exploration of size, scale, units, and ratios
1. The website http://www.joshworth.com/dev/pixelspace/pixelspace_solarsystem.html lets you
explore the solar system with both planet sizes and distances to scale, with Earth’s moon as one
pixel. Starting from the sun, scroll right to the Earth by clicking the empty part of the scrollbar.
How many screen widths do you have to go?
2. Use a ruler and the website’s scale (can be found near the sun) to estimate the distance from the
Earth’s surface to the Moon’s surface. 3. Convert your result to miles. 4. The actual distance from the Earth’s surface to the Moon’s averages 233,815 miles. What was
the percentage error of your estimate? 5. To successfully escape a planet’s gravity, a spaceship must achieve escape velocity, which for
Earth is 11.2 km/s or 25,054 miles per hour. If a ship reaches this speed and maintains it, then
neglecting the need to slow down prior to landing, how long would it take the ship to reach the
moon? 6. Look up the minimum distance from Earth to everyone’s favorite dwarf planet, Pluto. At the
speed given in question 5, how long would it take to reach Pluto? Convert your answer to
meaningful units. 7. Space travel is expensive! For their trip to the Moon, the Apollo astronauts’ living quarters were
only 213 cubic feet (that’s smaller than a typical bathroom in a house). How many dollar bills
could fit in there? (You’ll need to look up the size of a dollar bill.) 8. Would a stack of dollar bills in the amount of the U.S. national debt reach from the Earth to the
Moon? Show your calculations to receive any credit! 9. Pluto has been hard to measure from Earth because of its atmosphere. In 2007 Young, Young,
and Buie measured Pluto as having a diameter of 2322 km. The New Horizons probe traveled to
Pluto and measured it up close and we now know the actual size is 2372 km. What was the
percent error of the 2007 measurement? 10. The dwarf planet Eris, which has no atmosphere and has been easier to measure, has a diameter
of 2326 (±12) km. In several complete sentences, discuss the relative sizes of Pluto and Eris and
how our understanding of their size relationship has changed. 11. Visit http://www.exploratorium.edu/ronh/weight/. If a person weighs 140 lbs on Earth, how
much would they weigh on the moon? How much on Pluto? Rolling to Linear and Exponential Functions Part A: Growth by Chance
1. Begin with four pennies on your plate. Roll your die and add the number of pennies to your plate
as indicated by the die. Count the number of pennies now on the plate and enter that number in the
table below. Continue in this manner for 15 rolls or until you run out of pennies, whichever comes
first.
Roll
Total #
of
Pennie
s 2. 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 4 Use Excel to complete the following:
a. Enter the data into Excel and make a scatter plot. Describe the trend of the data.
b. Using Excel, generate the linear trendline for the data. Write your regression equation and the
coefficient of determination below.
c. Using the linear model, how many pennies would you have at the end of 25 rolls?
d. What is the minimum number of rolls the linear model requires to have $10.00 or more? Part B: Exponential Growth
1. Begin with four dice in your shaking cup. Each roll consists of the following actions.
Shake up the dice in your cup and turn them out onto the plate. For each die that is showing an even
number, add a die to the plate from your supply cup. In the table below, record the total number of
dice (old and new) on the plate. Put all of the dice on the plate into your shaking cup. End of a roll.
Continue the rolls until run out of dice.
Roll
Total #
of Dice 0 1 2 3 4 5 6 7 4 2. a. Enter the data into Excel and make a scatter plot. Describe the trend of the data.
b. Using Excel, generate the linear trendline that best fits the data.
Write your regression equation and the coefficient of determination below.
c. Using Excel, generate the exponential trendline that best fits the data.
Write your regression equation and the coefficient of determination below. 8 9 d. Using the model that fits your data better, how many dice would you have at the end of 25 rolls?
e. What is the minimum number of rolls the better model requires to have 1,000 or more dice? Part C: Exponential Decay
Start with 40 dice in your cup. Put 40 in the first cell of the “Total Number of Dice” row. Each roll consists
of the following actions: Shake the dice in your cup and dump them out onto the plate. Remove each die that shows a 6 from the plate and put them back in the original container. Count the remaining dice on your plate and record that number in the next cell of the “Total
Number of Dice” row. Put the dice left on the plate into your shaking cup. Repeat
Continue until there is one die left or until you reach 9 rolls, whichever comes first. (Note: If the number
of dice reaches 0 record a 1 instead and quit collecting data.)
Roll
0
1
2
3
4
5
6
7
8
9
Total Number of
Dice
1. a. Create a scatter plot of the data (Roll and Total Number of Dice). Sketch the scatter plot. b. Use Excel to generate the linear trendline that best fits the data. Write your regression equation
and the coefficient of determination here. c. Use Excel to find an exponential trendline to model your data. Round the coefficient to two
decimal places and the exponent to four decimal places. Write your regression equation and the
coefficient of determination here.
2. a. Using the model that fits your data better, how many dice should you have at the end of 4 rolls?
b. How many rolls would your model require to have 6 dice? Buying a New Car: Financing Options Lab
For this project you will pretend to buy a car. We hope that someday when you do buy a car some of
what you learn while completing this lab will come in handy. Much of the information about financing
also applies to purchasing a house with a mortgage.
There are three parts to the car-buying process:
1. Research
2. Going to the Lot
3. Financing Research
Most of the time and effort of car buying should come before you go to the dealership. Working through
the questions below will help you get the vehicle you need at an affordable price. You will be copying
and pasting these questions and answers into the spreadsheet you submit for this lab.
Type of vehicle sought (sedan, motorcycle, SUV, pickup, etc.):
Prioritized list of features with most important listed first. Mark required features with a *:
Maximum monthly payment you can afford (make this up but try to be realistic):
Down payment saved up (make this up but try to be realistic):
Multiply your monthly payment by 55 and add the down payment to determine your approximate
maximum car price (this assumes you get a 5 year loan):
Go to www.edmunds.com and research available vehicles with the features you need that are in your
price range.
Vehicle chosen:
Features (from list above) that this vehicle has:
Current rebates and incentives for this vehicle according to Edmunds.com:
* Rebates to customers are ones that you will get directly. Rebates to the dealer are ones that they will
receive as extra profit from the sale, so they give you something extra to negotiate down the price. Going to the Dealership
We don't expect you to actually go to the dealership or test drive a car for this project. But there are
several things to keep in mind when the day comes that you are really buying a car. Salespeople and dealerships have daily, monthly, and annual quotas. Wait for a rainy day to test drive cars. Not only will you see how it handles in bad weather, but
you'll also find the dealership less crowded and the salesperson more willing to work with you for
the sale. At the end of the month and the end of the year you'll find salespeople with more pressure to
make a sale, even if there is less profit involved. You will have an easier time negotiating down
the price. Factory to dealer incentives usually appear for the last 10 days of the month and then disappear,
and they can give you much more to negotiate with.
Financing
You will generally have a few options for financing. For the sake of this project consider the following
loan terms:
1. Five year loan with $500 rebate and 6.75% APR.
2. Six year loan with no rebate and 6.95% APR.
Set up amortization tables for the options listed above in sheets 2 and 3 of your Excel file. Be sure to
subtract the down payment amount that you listed above, and all rebates (whether ones you found at
Edmunds.com or for the $500 dealer rebate option), from the purchase price to determine the loan
amount.
Once you've made your amortization tables, answer the following questions. You will be copying and
pasting your answers into the spreadsheet you submit for this lab.
1. Which option has the lower total cost?
2. How much less does it cost than the other option?
3. Which option has the lower monthly payment?
4. How much lower is this monthly payment than the other option?
5. How much interest would you pay on each of the loans?
6. Which option do you think makes the most sense for you, and why?
Turn in a single Excel file with the text of the research notes copied and pasted into a text box on the first
sheet. Below that, on the first sheet, answer the questions above in another text box. Put your two
amortization tables on sheets 2 and 3. Dean’s New Car
Directions: Working in groups of two or three, answer the following questions. Each student should
complete the handout, but only one will be collected from each group. At the end of the activity, pick
one paper to hand-in. All group members will sign to indicate they agree with all the answers. Do not
sign unless you are happy with the group product.
Dean is planning to purchase a car for $28,560. He has 12% to put down and can finance the remainder
for 5 years.
1. Go to www.bankrate.com and list the three lenders with the lowest rates for auto loans based on
your location and the list the rates they charge. Record the date of your search and the average of
these three or the average given by your instructor. 2. Using the same website, find the three lenders with the highest rates for money market account
(5 yr CD with minimum $1000 deposit) and record those lenders and rates here. Look for the “rates”
given near the APY values. These values may be the same or close to the same in this case. Record
the date of your search and the average of these three or the average given by your instructor. 3. What is the amount of Dean’s down payment? 4. What is the loan amount that Dean will be financing? 5. What will his monthly payments be on the car loan? Use the interest rate average calculated in
question 2. 6. What is the total amount Dean will pay for his car if he finances the purchase? 7. How much interest will Dean pay the creditor over the life of the loan? 8. Since Dean has the down payment amount already, if he puts that in a money market savings
account with the APR you found in question 2, what amount would he have to deposit each month to
have the full $28,560 cost of the car so he could pay cash for it in five years? 9. If Dean saves up to pay cash for his car (as calculated in question 8) instead of financing it what
will be the total that he has to deposit into the savings account to accumulate the cost of the car? 10. it? How much less will Dean pay for the car if he saves up to pay cash for his car instead of financing 11. If Dean puts the down payment amount in his savings account, and then he deposits the payment
amount from question #5 in the account each month, how long will it take for him to save up for the
car? 12. Discuss the advantages of both methods by explaining what reasons Dean would have for
choosing them.