Geographic Data and Google Sheets

This video tutorial guides students through a daylight duration project using Google Sheets. It covers data entry for Catskill, NY, using timeanddate.com for data collection, entering sunrise and sunset data, graphing data, and customizing graphs. The tutorial emphasizes the use of military time for accuracy and demonstrates how data auto-populates in the spreadsheet. The video concludes with encouragement to explore and learn by doing.

What is the latitude and longitude of Catskill, New York, as mentioned in the video?

• 42.2° N, 73.7° W

• 40.7° N, 74.0° W

• 43.0° N, 75.0° W

• 41.5° N, 74.0° W

Which website is recommended for finding sunrise and sunset data?

• Sunrise-sunset.org

• Google.com

• Timeanddate.com

• Weather.com

What is the correct way to enter sunset time to ensure it shows PM in Google Sheets?

• Enter the time as AM and manually change it to PM

• Use a 24-hour clock format

• Enter the time and hope it auto-corrects

• Type 'PM' after the time

What is the daylight duration for December 21st, 2020, in Catskill, New York?

• 7 hours and 30 minutes

• 10 hours and 15 minutes

• 9 hours and 5 minutes

• 8 hours and 45 minutes

What colors represent the data lines for Russia, Ecuador, and Antarctica on the graph?

• Yellow, Green, Blue

• Orange, Red, Blue

• Blue, Red, Yellow-Orange

• Red, Blue, Green

What is the purpose of adding more lines to the graph?

• To practice using Google Sheets

• To compare daylight durations of different locations

• To fill up the graph space

• To make the graph look more colorful

How can you change the color of a data line on the graph?

• By using a color picker tool

• By changing the color in the data table

• By editing the chart and customizing the series

• By clicking on the line and selecting a new color

What should you do if you want to add a new data series to the graph?

• Edit the chart and use 'Add Series'

• Create a new graph

• Click on the graph and select 'Add Data'

• Manually draw the line on the graph

What is the benefit of exploring Google Sheets features as mentioned in the video?

• It is a requirement for the project

• It allows for better understanding and learning

• It helps in breaking the spreadsheet

• It makes the spreadsheet look more professional

What happens when you add more data to the upper portion of the spreadsheet?

• The data needs to be manually added to the graph

• The graph remains unchanged

• The data auto-populates and updates the graph

• The spreadsheet crashes