Scale models: Converting and Solar system I need help with homework talking about converting and solar system , here is the professor instruction , and the

Scale models: Converting and Solar system I need help with homework talking about converting and solar system , here is the professor instruction , and the rest you will find inside the excel. Be sure to use formulas in each of the orange cells (DO NOT USE THE “CONVERT” FUNCTION!). Don’t do your work on a calculator and type the answer into the orange cells. Thank you Scale Models
Making scale models can make really large objects and distances more tangible to our understanding. It is difficult to envision
a mile or more, and even more so for really large distances and sizes such as the size of a planet and its distance from the Sun
like to make a model of the solar system and place it on a university campus with the sun farthest east and the planets aligne
We will use a campus size of 4 km2 (2 km North-South by 2 km East-West).
PART 1
Step 1. We want our scale Sun to have an equatorial diameter of 2 m. Some yellow cells contain known values (km) found by
NASA information. You must find the additional values for each planet’s EQUATORIAL RADIUS to fill each cell in that column.
information.
Step 2. Orange cells require an Excel formula to perform a calculation. The math is the same as if you were using a calculato
you place the = sign first. The size of our scale Mercury is 0.0070 m. If your formula returns the value of 0.0070, then your ca
correct.
Calculation help for the scale planet size: What do we know?
We know the dimensions of three objects. So we can set up a problem to solve for the fourth object dimension (scale planet
our X (unknown)). In this case, we are solving for the scale planet diameter.
Step 3. Complete the calculations for the other planets in the same manner, then convert the scale sizes to cm and mm. The
in 1 meter, and 10 mm in 1 cm.
PART 2
Step 1. Using NASA information again, place known values in the yellow cells (scientific notation with two decimals). Mercur
from the sun (km) is shown.
Step 2. Type an Excel formula in each orange cell. The distance of Mercury from the Sun in our scale model is 83.2 m. If you
returns that value, then your calculation is correct.
Calculation help for the scale distance from the Sun: What do we know?
We know the planet’s equatorial RADIUS and distance from the Sun, and we now know the DIAMETER of each planet in our s
this case, we are solving for the scale planet distance from the Sun. Note that you must multiply the planet’s RADIUS by 2 (di
Equatorial
Radius
(km)
2 pts
Sun 695508
Mercury
2440
Venus
Earth
Moon
Mars
Jupiter
Saturn
Uranus
PART 1 (10 points)
Scale
Scale
Equatorial Equatorial
Diameter Diameter
(m)
(cm)
4 pts
2 pts
2
Scale
Equatorial
Diameter
(mm)
2 pts
Neptune
PART 3 (5 points)
Will the model solar system fit on campus? If not, which planet(s) will fit? What can we do to make our model a better fit if a
don’t fit? Type your answers in the gray box below.
PART 4 (1 points)
Cite the NASA sources ,in the gray box below, for the values you used in these calculations:
Extra credit (3 points)
If the solar system did not fit aligned East to West, would it fit if we placed the Sun in the southeast corner and aligned the pl
northwest? If not, which planets would fit? Type your answers in the gray box below and provide details of how you derived
ng. It is difficult to envision a distance of
d its distance from the Sun. We would
east and the planets aligned to the west.
nown values (km) found by researching
ll each cell in that column. Use NASA
you were using a calculator, but in Excel,
lue of 0.0070, then your calculation is
ct dimension (scale planet diameter is
e sizes to cm and mm. There are 100 cm
ith two decimals). Mercury’s distance
ale model is 83.2 m. If your formula
TER of each planet in our scale model. In
he planet’s RADIUS by 2 (diameter).
PART 2 (4 points)
Distance
from Sun
(km)
5.79E+07
1.08E+08
1.50E+08
2.28E+08
7.79E+08
1.43E+09
2.87E+09
Scale Distance
from Sun
(m)
4.50E+09
e our model a better fit if all the planets
t corner and aligned the planets to the
details of how you derived your answers.
Question 1 – 1 point
The distance from the Earth to the Sun is 149,600,000 km. Formulate this number in scientific notation. What is this distance in miles, meters, and feet?
(Use scientific notation)
Earth-Sun Distance
scientific notation
Earth-Sun Distance
Earth-Sun Distance
Earth-Sun Distance
149600000 km
miles
m
ft
Question 2 – 2 points
The Earth’s circumference is 40,008 km. While standing at the equator, how fast are you actually moving in miles/hour and miles/second due to the
Earth’s rotation? (HINT: How many hours does it take for the earth to spin one time?)
Earth circumference
rate
rate
40008 km
miles/hour
miles/sec
Question 3 – 2 points
Using a basketball (radius=120mm) to make a scale model of the Earth, how tall would you make Mt. Everest (elevation is 8,848 m)? (This is a scale
proplem.)
basketball radius
earth radius
Mt. Everest
Mt. Everest scale
120 mm
6370 km
8848 m
mm
Question 4 – 1 point
In the Atlantic Ocean, 4.5 million year old sea floor lies 45 km away from the Mid-Atlantic Ridge. How fast is the plate moving (cm/yr)? What is the
spreading rate of the ridge? (Spreading rate = 2 times the velocity)
distance from ridge
Atlantic sea floor age
velocity
spreading rate
45 km
4500000 years
cm/yr
cm/yr
Question 5 – 1 point
In the Pacific Ocean, 4.5 million year old sea floor lies 225 km away from the East Pacific Rise. How fast is the plate moving (cm/yr)? What is the
spreading rate of the Rise? (Spreading rate = 2 times the velocity)
distance from ridge
Pacific sea floor age
velocity
spreading rate
225 km
4500000 years
cm/yr
cm/yr
Question 6 – 1 point
If the temperature of a basaltic lava flow as it exits a volcanic vent is 1200?C, what is the temperature in degrees Fahrenheit?
Temperature
1200 ?C
Temperature
?F
Question 7 – 2 points
If the geothermal gradient is 15?C per km, what is the temperature at 10 km, 15 km and 35 km?
Geothermal gradient
15 ?C
Depth (km)
10
15
35
Temp (?C)
?C
?C
?C

Purchase answer to see full
attachment