In this unit we will be using our computers like scientists and mathematicians.
We will be creating tables, spreadsheets, and graphs using data we have collected from the internet.
We will study and analyze this data using these tools to learn about the natural patterns that exist in the motions of the earth and the sun.
We will also learn the effects this has on the earth.
Find a credible source of Sunrise and Sunset times on the Internet and calculate the Hours of Daylight and Hours of Nighttime: Search for the sunrise and sunset times for today in Beloit, OH, 44609.
Making a table to collect data from the web: After you make and print your table, use the http://www.usno.navy.mil/ to find the rise and set data for the 1st – 15th of this month. Record this information in your table. (I highly recommend using pencil for data collection.)
Math Formulas: Let’s see if we can write formulas for the math we were doing over and over again in out table.
Making a Spreadsheet:Use the math formulas we have written to teach the computer to do the math for us.
After you make the spreadsheet use the USNO Website above to collect the 1st,10th, and 21st of the 3 months of the season we are in right now. Winter: Jan. – March, Spring: April – June, Summer: July –Sept., Autumn: October- December
Making graphs: Using the insert tab and the chart tools make graphs of the data you have collected and calculated in your spreadsheet.
Patterns and Predictions: After organizing your data and graphing it, what patterns do you notice? What predictions can you make about these patterns for the rest of the year?
Answering Natural Questions: Use the USNO website to search for the yearly sunrise and set table for Beloit, OH. Use the following website to help you answer questions 11 through 16, NASA link
Add sample data for the whole year to your spreadsheet: Copy the spread sheet you made onto another sheet in your book. Use the USNO website to add the data for the 1st, 10th, and 21st of the other 9 months of the year to your spread sheet so that you have a sampling of data for the whole year.
Making more graphs of your new data and calculations: Using the yearly data you have collected make the same 4 graphs you made earlier with the small set of data.
We can use our graphs to:
1. check our data for errors
2. and compare them to your predictions to see the rise, set, day and night patterns for the whole year.
Finding the Minimum, Maximum, and Average values in your data can be much easier using your graphs and special formulas in Excel.
Lets try graphing 2 sets of data on one graph. Use the direction to help you make a graph of rise and set times on one column graph and a graph of day and night times on one line graph.
The second graph you made is not very interesting looking is it? Let's use some formulas to fix the data so it will make a more interesting graph.
Printing and Labeling Legal Size Graphs: Remember to think before you print, these large full color graphs use a lot of paper and toner. We want to prevent as many mistakes as possible. Work with a partner.
Sun Earth Diagrams: Let's use the graphics tools in Microsoft Word to draw a diagram of the earth's position related to the sun during the solstices and equinoxes. Read the Enchanted Learning and the NOAA Website to understand the cause and effects the earth's position has.
When you finish your first diagram use File, Save As to quickly make 3 other copies of it.
1. Use PowerPoint to animate your sun earth diagrams.
2. What effect does Latitude have on the variation of the length of daylight?