Notes
Slide Show
Outline
1
Analyzing Precipitation In Microsoft Excel
  • Tools and Concepts for Data Analysis
  • Jessica DeSclafani
2
About me
  • Where I teach:  Hackensack High School


  • What I teach:  Algebra 1, Pre-Calculus, HSPA 3


  • How long I have been teaching:  1 year


  • Schools:  Hasbrouck Heights High School
  •   Ramapo College of New Jersey
3
The Lesson
  • Lesson Title:  Weather Scatter Plot


  • Objective:  SWBAT understand how to create a scatter plot algebraically and compare using Microsoft Excel.


  • Standard:  NJCCS 4.3.B.1


  • Target Audience:  9th Grade Algebra 1


  • Time:  5 days
4
Timeline
  • Day 1:  Introduce project and directions
  • Brief introduction


  • Day 2:  Gather Information


  • Day 3:  Analyze 5 scatter plots algebraically


  • Day 4:  Create scatter plots in Excel and compare information


  • Day 5:  Test on Scatter Plots and Comparing Data
5
Gathering Information
  • Where to gather information


  • What to look for


  • Pick 5 cities


  • Find total precipitation for each month in one year.
6
Solving Algebraically

  • Plot information on a scatter plot.


  • Pick two points


  • Find the slope of the points


  • Put back into the equation y = mx+b


  • Solve for ‘b’.
7
Solving Using Excel
  • Sort information in Excel.


  • Create scatter plot


  • Find line of best fit.


  • Repeat for all cities.
8
Solving Using Excel cont…
9
Conclusion
  • Students will be graded out of 100 points on the project…
10
Resources
  • Websites:
  • http://www.srh.noaa.gov
  • Image Sites:
  • http://01gif.com
  • http:// www.Bestanimations.com
  • http:// www.Feebleminds.gif
  • http:// www.Grossweather.com
  • http://members.tripod.com/~star43
  • http:// www.Netcfpd.com
  • http://www.iecc.edu
  • http://stratford.gardencity.k12.ny.us
  • http://curvebank.calstatela.edu/
  • http://www.hamlin.k12.sd.us/