- Getting the data into excel
- Open the database from my blog. The link is
- https://docs.google.com/spreadsheet/pub?key=0AsLuz158vxFMdDlpWDliME9FcngwdERROGhmNlBHMGc&output=html
- COPY the url address above
- Open excel (Microsoft office folder in programs)
- Click on the data tab
- In the “get external data” section CLICK ON FROM WEB
- In the address bar that pops up PASTE the url address above
- Click IMPORT twice
- Click Okay
Questions for the database
Write the answers on your own paper. We'll go over them in class!
Write the answers on your own paper. We'll go over them in class!
Make sure you use the sort feature
- Which planet has the most satellites?
- Name the coolest satellite (in your opinion) from each of the planets and the dwarf planets category. Be sure to explain why you think the satellite is cool.
- How far from the sun is Saturn?
- Which dwarf planet is the farthest from the sun?
- Which satellite is the coldest? What is the temperature?
- Which satellite is the hottest? What is the temperature?
- Which satellite has the most mass? What is the mass?
- Which satellite has the least mass? What is the mass?
- Which satellite has the smallest radius? What is the radius? What planet does it orbit?
- Which satellite has the largest radius? What is the radius? What planet does it orbit?
- Which dwarf planet takes the longest to orbit the sun? How long does it take?
No start up for today.
Here is the links you'll need
Database form for entering data
Collected Data
No comments:
Post a Comment