Notes
Slide Show
Outline
1
Sunspot Lab
  • Susan F. Smith Valentine
  • Tools Data Excel Project
  • Fall 2007
2
Target Audience
  • 8th Grade Students
  • Science Class
  • Regular Education
  • Special Education
3
Creating The Project
  • Why?
  • Alternative Lesson
  • Class Support
  • Data Research
  • Lab Activity
  • Learning Tool
  • Lesson Enhancement
  • Teaching Tool
4
General Overview
  • Lesson Background /
  • What Will Your Project Consist Of?
  • Analyze experimental data sets using measures of central tendency: mean, mode, median.
  • Construct and use a graph of experimental data to draw a line of best fit and identify a linear relationship between variables.
  • Express physical relationships in terms of mathematical equations derived from collected data.
  • Perform mathematical computations using labeled quantities and express answers in correctly derived units.
  • Represent and describe mathematical relationships among variables using: graphs, tables.
  • Use computer spreadsheets, graphing and database applications to assist in quantitative analysis of data.
  • Use quantities using appropriate number formats, such as decimals, percents, scientific notation.
5
Instructional Goals /
Standards
  • Mathematical Applications
  • (CCS 5.3)
  • Data Analysis And Probability
  • Geometry And Measurement
  • Numerical Operations
  • Patterns And Algebra
6
Graph
  • How?
    • Collect Sunspot Data From Research
    • Insert Data Into Template
    •    (Spreadsheet)
    • Create Graph Based On Data
      • Bar Graph
      • Line graph
      • Pie Graph
7
Data Template
8
 Spreadsheet Template
9
Bar Graph
10
Line Graph
11
Pie Graph
12
Analyzing The Data
  • Conclusions Drawn?
    • What Did You Learn?
  • How?
    • What Data Did You Use To Determine Which Graph To Use?
  • Plan?
    • What Did You Compare?
    • Where Did You Research?
13
Success /
Effectiveness Of Project
  • How To Measure?
    • Did The Students Create The Graph?
    • Did The Students Do The Research?
    • Were Their Results Accurate?
14
References
  • Microsoft
  • Excel 2003
  • Power Point