Graphing Sunrise, Sunset, and Moonrise Data

image (10)

In this activity, students collected data from different cities around the world and entered the sunrise, sunset, and moonrise times into an excel spreadsheet. I have the spreadsheet set up to automatically graph the data as it is entered into excel for 7 consecutive weeks. (I printed out and photocopied the 4th tab of the spreadsheet to make it easier for the students to collect their data and then enter into the spreadsheet)

image (11)

For my classes, I gave everyone the information for the New Jersey data (it is in the spreadsheet as an example, but you can easily delete it and modify as needed). This gave everyone a foundation to make their comparisons. Each student was randomly assigned their first city, and when done, were able to choose any city from the list for their 3rd choice.

Files needed for the lesson:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s