Data Analysis: Spreadsheets & Graphing
(1) Analyzing experimental data
- Import, format, graph, and analyze class data on reaction time
- Analyze class experimental data for a study such as this one on mitosis. (see movie for (1) statistics; (2) graph)
- What makes things float? Do the inquiry lesson for density and bouyancy.
- Dihybrid Cross - AP Biology genetics lab (corn)
(2) Solving problems with spreadsheets
Solve real-life problems by analyzing the following spreadsheet files.
- Determine the energy of reaction of the combustion of methane (CH4) or other molecule.
- Express the measurements of a scale model of the solar system designed to fill your classroom or the football field.
- Express the relative sizes or distances of the planets in graphic form
(3) Spreadsheets & Graphing - Complete these exercises - download chapter | ss-file A| ss-file B |
- eps graphics (use Safari, or Firefox and open with Preview) OR entire graphics file -(pwd 646)
- Calculations and computer modeling
- Walking through Graphs
- Graphing Stories
- Constructing Graphs from Real-World Descriptions
- Scatter and line graphs
- Column and bar graphs
- Pie and area graphs
- High-low / combination / log plots
- Statistics
(4) Spreadsheet development
- Develop a spreadsheet file to teach a specific science or math lesson. Include lesson plans for using the spreadsheet. This spreadsheet must include a variety of calculations. Include a copy of the spreadsheet (showing calculations).
- Post your excel file on the web.