Science

ademola

Assignment_9_instructions.docx

Home >Geology homework help >Science

ASSIGNMENT 9

PSC121 Weather and Astronomy Analysis (November 1 – November 28),

Due Nov 30th, 2020 24 points

You need to fill in two tables and answer 9 questions.

Table 1 is the Weather vs. Climate Excel Spreadsheet and Table 2 is the Weather/Astronomy Log. The Excel Spreadsheet is on Blackboard and instructions are given in Section A below. Questions based upon the Spreadsheet are in Section B. Section C below covers the Weather/Astronomy Log which is handed out in class.

A. Weather vs. Climate Excel Spreadsheet: INSTRUCTIONS FOR FILLING OUT and ANALYSIS

1. You will compare daily temperature high and low with climate averages constructed from the 30 year period 1981-2010 First, on your spread sheet, notice on the right where it says “plot the data” and 4 colored buttons below. Check the boxes next to all 4 buttons (by clicking on them). You should immediately see 2 curves, one blue (upper) and one gray (lower). DCA Average means the average temperature for DCA (DC Airport, i.e. Reagan National) These are the climate averages for each day from November 1-28.

a. You should immediately calculate the average high and low temperatures for DCA by typing in box C34: average(C5:32) and in box E34: average(E5:E32)

(don’t forget to hit “enter” after you type the formulas- a common excel mistake)

2. Next, you will tabulate 28 days of high and low temperatures in your spread sheet in the yellow columns (D and F). To get the observed high and low temperature for any day for the DC area, go to the following National Weather Service website: http://www.weather.gov/lwx/, then on the middle right, see “climate and past weather” with a pull down menu below it. Click on “past observed weather”. You should get the following page:

Weather vs. Climate Excel Spreadsheet: INSTRUCTIONS continued

Make sure that “Daily Climate Report (CLI)” is selected, that “National” is highlighted and “most recent” is selected. Click on the yellow “Go” button. You should then get a page which says

“CLIMATE REPORT

NATIONAL WEATHER SERVICE BALTIMORE MD/WASHINGTON DC”

Followed by

“THE WASHINGTON NATIONAL DC CLIMATE SUMMARY FOR NOVEMBER XX 2019...”

Look about 10 lines down for “OBSERVED VALUE” with Maximum and Minimum values.

The Maximum value for each day goes in the yellow column D under Actual High on your spread sheet. The Minimum value for each day goes in the yellow column F under Actual Low on your spread sheet. As you enter the tabulated values, assuming you have checks in the brown and yellow plotting boxes, you should see the graph building up (brown and yellow curves).

3. Calculate the monthly averages At the end of the 4 week period, enter the following formulas (EXACTLY) in your spread sheet:

For box D34, type “=AVERAGE(D5:D32)” and

for box F34, type “=AVERAGE(F5:F32)

PSC121 Weather and Astronomy Analysis Name

ALONG WITH THE TABLES HAND IN THE FOLLOWING. DUE Dec 2nd, 8 pm

B. Weather and Climate Spread Sheet: Analysis: ANSWER THE FOLLOWING QUESTIONS

1. Describe the blue and gray curves. Are they increasing or decreasing? How much is the change in temperature from the beginning to end of the 4 week period as predicted by these curves?

2. How do the blue and gray curves differ visually from the orange and yellow curves?

3. Based upon the visual comparison of the 4 curves, as well as a comparison of the averages in boxes C34, D34, E34, and F34, would you conclude that this month was warmer or colder than the expected long term average? Why?

4. Based upon the graph as well as the tabulated numbers, which days had the greatest difference from the long average? After doing instructions 5 and 6 below from your descriptive weather log, what was the weather like on those days?

PSC121 Weather and Astronomy Analysis

Name __________________________

C. Weather and Astronomy log: Fill out as instructed below and answer the following

5. Column 2: Give a 2 or 3 word description of the weather on each day. Nothing fancy, for example, “partly cloudy, breezy” or “mostly clear skies” or “overcast, raw, drizzly”

6. Column 3: Rate the weather for each day- just give your opinion (1-10). A 10 is for a truly gorgeous day and a 1 is for a truly lousy day. (A good exercise to conduct in an elementary school classroom!). What were the 2 highest and 2 lowest rated days? Why did you rate them as such?

7. Column 4: Sketch the phase of the moon as you saw it (just draw the part you see, no fancy coloring or shading needed) and the time of day you saw it. If you did not see the moon, explain why.

8. How often did you see the moon? (How many days). For the days when you did not, explain why (there are probably two or three reasons. Use the back if you need more room).

9. What dates would you have expected a spring tide at DCA? What about a neap tide? Why? (again, use the back if you need more room)

ASSIGNMENT 9

PSC121

Weather and Astronomy

Analysis

(

November

–

November

)

Due

Nov 30

, 2020

24 points

You need to

fill in two tables

and answer 9 questions

Table 1

is the

Weather vs. Climate Excel Spreads

heet and

Table 2

is the

Weather/Astronomy

Log.

The Excel Spreadsheet is on Blackboard and instructions are given in Section A below.

Questions based upon the Spreadsheet are in Section B. Section C below covers the

Weather/Astronomy Log

which is handed out in class

Weather vs. Climate Excel Spreadsheet

INSTRUCTIONS FOR FILLING OUT

and ANALYSIS

You will compare daily temperature high and low with climate averages constructed from the

30 year period 1981

2010 First, on your spread sheet,

notice

on the right where it

says “plot the

data” and 4

colored buttons below. Check the boxes next to all 4 buttons (by clicking on them).

You should immediately see 2 curves, one blue (upper) and one gray (lower).

DCA Average

means the average temperature for DCA (DC Airport, i.e. R

eagan National)

These are the

climate averages for each day

from

November

You should immediately calculate the average high and low temperatures for DCA by

typing in box C34: average(C5:32) and in box E34: average(E5:E32)

(don’t forget to hit “enter

” after you type the formulas

a common excel mistake)

Next, y

ou will tabulate 28 days of high and low temperatures in your spread sheet

in the yellow

columns (D and F)

. To get the observed high and low temperature for any day for the DC area,

go to the following National Weather Service website:

http://www.weather.gov/lwx/

, then on

the middle right, see

“climate and past weat

her”

with a pull down menu below it. Click on

“past observed weather”.

You should get the following

page

ASSIGNMENT 9

PSC121 Weather and Astronomy Analysis (November 1 – November 28),

Due Nov 30

, 2020 24 points

You need to fill in two tables and answer 9 questions.

Table 1 is the Weather vs. Climate Excel Spreadsheet and Table 2 is the Weather/Astronomy

Log. The Excel Spreadsheet is on Blackboard and instructions are given in Section A below.

Questions based upon the Spreadsheet are in Section B. Section C below covers the

Weather/Astronomy Log which is handed out in class.

A. Weather vs. Climate Excel Spreadsheet: INSTRUCTIONS FOR FILLING OUT and ANALYSIS

1. You will compare daily temperature high and low with climate averages constructed from the

30 year period 1981-2010 First, on your spread sheet, notice on the right where it says “plot the

data” and 4 colored buttons below. Check the boxes next to all 4 buttons (by clicking on them).

You should immediately see 2 curves, one blue (upper) and one gray (lower). DCA Average

means the average temperature for DCA (DC Airport, i.e. Reagan National) These are the

climate averages for each day from November 1-28.

a. You should immediately calculate the average high and low temperatures for DCA by

typing in box C34: average(C5:32) and in box E34: average(E5:E32)

(don’t forget to hit “enter” after you type the formulas- a common excel mistake)

2. Next, you will tabulate 28 days of high and low temperatures in your spread sheet in the yellow

columns (D and F). To get the observed high and low temperature for any day for the DC area,

go to the following National Weather Service website: http://www.weather.gov/lwx/, then on

the middle right, see “climate and past weather” with a pull down menu below it. Click on

“past observed weather”. You should get the following page: