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)
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:
Middle School Science Blog 