develop an awareness of how the position of the rising and setting Sun changes over the course of the year and how these changes relate to the number of hours of daylight and the seasons.

art 2: Sunrise/Sunset

The objective of this part is to develop an awareness of how the position of the rising and setting Sun changes over the course of the year and how these changes relate to the number of hours of daylight and the seasons. Because regular observations difficult, you will find an Excel file of sunrise and sunset times on Canvas. You need to use these times to:

A. Produce a graph of the Hours of daylight vs. day (where day is a number between 1 and 365). This can easily be done in Excel by: – Highlight the Sunrise and Sunset columns and change for Format to Time 13:30. This will change the times from AM/PM to military time. – Make a new column whose value is Sunset minus Sunrise. Set the Format of this column to Number. This will make the answer a decimal representing the fraction of 24 hours that are daylight. – Multiple the decimal by 24 to get the number of hours of daylight. – Make a Scatter Plot with Day on the horizontal axis and Hours of Daylight on the vertical axis. Your graph must be made on the computer, not drawn by hand.

B. Answer the following questions:

Determine the approximate date of the longest day (most hours of daylight) of the year.

Determine the approximate date of the shortest day (least hours of daylight) of the year.

Determine the two days for which there are approximately 12 hours of daylight (equal length day and night).

The Sunrise and Sunset times make sudden jumps on 3/12 and 11/5. Why does the time suddenly jump almost an hour around those days?

Determine the date for which the Sun rises farthest to the North. *0o and 360o are straight north, 90o, 180o, and 270o are straight east, south, and west.

Determine the date for which the Sun sets farthest to the North.

Determine the date for which the Sun rises farthest to the South.

Determine the date for which the Sun sets farthest to the South.

Determine the date(s) for which the Sun rises directly East.

Determine the date(s) for which the Sun sets direction West.

Do you see any relationship between where the Sun rises and the number of hours of daylight? How about between the number of hours of daylight and the average temperature?