Discovering The Solar System Through A Database

 

Mr. Conant - Memorial Middle School - Beverly Public Schools - Beverly, MA

Student's Page

Essential Questions:

Overview: A database is a collection of data that is organized especially to be used by a computer.  Databases are designed to get you the information that you specifically desire, and hides the files you don’t need.  Some databases that you may have used include an Ask Eric (an online catalog for articles) and your libraries card catalog. Today’s activity is an introduction to databases.  To view the database you must have Microsoft Excel on your computer.  Read each question, follow the steps, and enjoy.  To get a copy of this worksheet click on this link.  

Part 1:

  1. Identify all of the planets that have a diameter greater than 4,200 miles.

To accomplish this task using a database, you should follow these steps:

After you have recorded your answers on the provided lines, select the “data” menu click on “filter” and select “show all”.  This will reset the database so you can move on to query 2.

 

2.  Identify all of the planets that have a rotation less than 1 Earth day.  (Hint:  Follow the directions for example 1 except click on the rotation.  Also, when completing step number 3, you must click on “less than

3.  Identify the planets that have “less than or equal to” 150 million kilometers away from the sun.

     4.  Identify the planets that are “greater than or equal to” 438 million miles away from the sun.

5.  Identify the planets that have an average revolutionary period “greater than” 12 Earth years

 

Part 2:

Now that you have mastered the concept of a “simple” query, you are ready to move on to two-step queries.

  To retrieve answers to two-step queries read and follow these instructions.

After you finish a query, select the “Data” menu.  Click on “Filter” and select “View All”.

6.  Identify the planets that have a density greater than 5.25 or a density less than 1.33. View.

7.  Name the planets that are either less than or equal to 6,794 kilometers in diameter or greater than 51,200 kilometers in diameter.

8.  Identify the planets that have zero moons or have greater than 21 moons.  

9.     Identify the planets that are less than or equal to 36 million miles away from the sun or greater than or equal to 3,680,000,000 miles from the sun.

10.  Now it is your turn!  Based on this database, write two queries.  You may choose a “simple” or a two-step query.  Remember to record your answer.

 

{Activity}    {Database}    {Evaluation}    {Teacher's}    {Back To Mr. Conant's Home Page}

© 2004 T. Conant