Excel Daylight Assessment

15 pts.  You found the sunrise and sunset for your city and entered it into a chart in Excel.

5 pts. Your chart has BORDERS around it. 

5 pts. You formatted the titles in row 4 to WRAP.  You centered the titles horizontally and vertically.

10 pts. You CORRECTLY calculated the amount of daylight on the 21st of each month.  The amount of daylight should be recorded in column E.

 

You made a line graph of the amount of daylight of your city.  Your line graph should have:

5 pts. A title - “Amount of Daylight for …your city…”

5 pts.  Series 1 should be named “Amount of Daylight”.

5 pts. X axis should be labeled “Months” and have the months listed below each mark.

5 pts. Y axis should be labeled “Hours” and should have the times listed next to each mark.

20 pts. Your chart is made correctly.

 

10 pts.  You calculated the AVERAGE amount of daylight for your city for the year.  The answer should be recorded in cell 17E.

5 pts.  You handed in TWO copies of your Excel project – one showing the formulas and one showing the answers.  Each copy is printed on ONE page.

15 pts. Behavior met classroom expectations.

 

105 pts. TOTAL