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:
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 reallife 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 
Reallife 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 









TEACHER NOTES: