|
1
|
- Susan F. Smith Valentine
- Tools Data Excel Project
- Fall 2007
|
|
2
|
- 8th Grade Students
- Science Class
- Regular Education
- Special Education
|
|
3
|
- Why?
- Alternative Lesson
- Class Support
- Data Research
- Lab Activity
- Learning Tool
- Lesson Enhancement
- Teaching Tool
|
|
4
|
- 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
|
- Mathematical Applications
- (CCS 5.3)
- Data Analysis And Probability
- Geometry And Measurement
- Numerical Operations
- Patterns And Algebra
|
|
6
|
- How?
- Collect Sunspot Data From Research
- Insert Data Into Template
- (Spreadsheet)
- Create Graph Based On Data
- Bar Graph
- Line graph
- Pie Graph
|
|
7
|
|
|
8
|
|
|
9
|
|
|
10
|
|
|
11
|
|
|
12
|
- Conclusions Drawn?
- How?
- What Data Did You Use To Determine Which Graph To Use?
- Plan?
- What Did You Compare?
- Where Did You Research?
|
|
13
|
- How To Measure?
- Did The Students Create The Graph?
- Did The Students Do The Research?
- Were Their Results Accurate?
|
|
14
|
- Microsoft
- Excel 2003
- Power Point
|