DATA ANALYSIS

---

(1) Databases - Complete these exercises - download chapter | db-file

Note to PC-users. you will need to turn on the autofilter feature to view these sheets as databases. Select the category headers, the use Data/Filter/Autofilter. Arrows should appear in the catergory headers. If they do not, repeate the procedure until they do.

• Chemistry
• Biology
• Health
• Astronomy and Earth Science
• Physics

(2) Spreadsheets & Graphing - Complete these exercises - download chapter | ss-file A| ss-file B | graphics

• 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

(3) Biological Databases Anatomy | Genetics | Botany | Zoology

(a) Research 3 biological databases of your choice to find specific information (graphics and/or text) relevant to a lesson you might teach in a secondary school biology class. Include links to the data, and describe how it would be used.

(b) Give a specific example of how you could use online biological databases to enhance your instruction in a biology or physiology classroom.

(c) Write a higher-order question that would require students to analyze data from one of the databases.

(d) Use Inspiration (sample files) to develop a visual taxonomic scheme for the materials (photo) presented in class. Include a link to your file.

(4) Chemical Databases

(a) Discuss three specific advantages of an interactive periodic table compared to a traditional periodic table.

(b) Write a question that could be answered more effectively using an interactive periodic table than with a traditional periodic table.

• Periodic Tables
• Chemical and Mineral Information

(5) Nutrition Analysis Using Online nutrition databases

(a) Attach a printout of the analysis of your daily diet.

(b) Use the computerized analysis to prepare a written summary of your diet and recommendations for improvement if necessary.

(6) 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)

(7) 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

(8) Solving problems by graphing (Note: completed in #2 above - no need to repeat)

• Differentiate and identify periodic and non-periodic properties of the elements by graphing.
• Compare and contrast the radioactive decay for two isotopes by graphing
• Analyze and discuss yearly climatic data for evidence of global warming.

(9) Statistical analysis (Note: completed in #2 above - no need to repeat)

• Determine the relationships between the length, mass and periods of a pendulum using trendlines
• Use regression analysis (trendline) to investigate and explain the relationship between independent and dependent variables in the distribution of plants or animals in a transect.

(10) 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.

(11) GPS / Mapping