WHAT'S OUR WATER REALLY LIKE?


ESTIMATED TIME TO COMPLETE: 90 minutes

MODULE OBJECTIVES: Students will gain an understanding of the biotic index including how to compute it and what it tells us about the quality of the water by manipulating algebraic and statistical concepts through Excel spreadsheets and the Internet.

CONCEPT(S) LEARNED IN THIS MODULE:

STANDARDS ADDRESSED BY UNIT MODULES:

TECHNOLOGY - ENHANCED INSTRUCTIONAL STRATEGIES UTILIZED IN THIS MODULE:

Technology enriched learning and real world problem investigations,
guided discovery learning with immediate feedback and computer based estimation skills.


Component

Brief Description of Module Activities

Student Grouping

Materials/Technology

Engagement

Students will search for an article concerning water pollution the night before. In class, they will be given an article to read concerning the pollution of a nearby river, stream or body of water. The article will motivate students to think about analyzing the health of a body of water and how the rate of pollution is determined. Introduce the idea of biotic index.

Whole class and individual

Article found independently and hand out article

Exploration

Study a sample of water for different organisms.- Students will study their samples for the organisms that can be found. Using a chart provided, students will tally the number of organisms they find in their sample of water.

Small groups

Bucket of sample water for each group, informational chart of aquatic insects, fine netting to sift out organisms

Explanation

Explain what the biotic index is and how it helps us determine the purity of a body of water. Give students a simple example of a water environment in order to practice finding the biotic index. (Teacher will guide students through this process). Once students have completed finding the biotic index for the sample environment, they will then go on to determine the biotic index for their jar of water. Students will use Excel to input data and determine the biotic index.

Whole class and individual

Water environment example, informational chart of aquatic insects, spreadsheet software, tally from group buckets

Extension

Students will be given a real-life problem that will provide the biotic index goal and other specifications for a water environment they are to create. Using Excel, they will find a combination of organisms to satisfy the biotic index range.

Whole class and individual

Real-life problem, spreadsheet software, chart of aquatic insects

Evaluation

The teacher will use a rubric to score the studentsí work.

Individual

Copies of rubric for each student

EXPECTED MODULE OUTCOMES:

Students will be able to:

PERFORMANCE BASED ASSESSMENT OF MODULE OUTCOMES:

Students will provide answers to the Reflection questions and submit an Excel spreadsheet containing final biotic index.

SCORING RUBRIC:


Analysis

Displays

2
  • Thorough explanation of the process of determining the biotic index
  • No errors in calculations

  • Spreadsheet organized well
  • Answer clearly labeled
  • Uses 12 pt font, Times New Roman
  • No spelling errors or grammar errors

1
  • Minor errors in calculations
  • Some steps missing in finding the biotic index
  • N/A

0
  • No explanation of finding the biotic index
  • Major errors in calculations
  • Not in the correct format
  • Spreadsheet is not understandable

TEACHER NOTES:


Unit Description
Module 1 2 3 4