Abiotic and Biotic Factors Worksheet - Excel

Document Sample
Abiotic and Biotic Factors Worksheet - Excel Powered By Docstoc
					                                                     2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls



                WATERSHED ECOLOGY CURRICULUM OUTLINE: ABIOTIC FACTORS


Unit                  Lesson                                                 Supporting Documents
Introduction          Aquatic Ecosystems Overview
Introduction          Water Cycle Overview


Watersheds            What is a Watershed?                                   What is a Watershed Worksheet_6th
Watersheds            Topographic Maps: Identifying Features                 Topographic Maps_ Identifying Features Worksheet_6-8
Watersheds            Build a contour model
Watersheds            Topographic Maps: Defining Watersheds                  Topographic Maps_ Defining Watersheds Worksheet_7th
Watersheds            Draw a cross section from a topographic map
Watersheds            Aerial photo interpretation
Watersheds            Geocaching: navigating using GPS
Watersheds            Wetlands within Watersheds                             Riparian Area Reading


Soils                 Soil Texture                                           Soil Texture Worksheet_7th
Soils                 Particle Structure and Characteristics
Soils                 Soil Infiltration Experiment and Analysis              Soil Infiltration Worksheet
Soils                 Soil Excel Lesson                                      Soil Excel worksheet 7-8
Soils                 Texturing and Infiltration in the Field


Water Quality         Water Quality Parameters Introduction                  Measuring Water Quality Worksheet_6th
Water Quality         Water Quality Testing and Analysis                     Water Quality Data Sheet (field)
Water Quality         Water Quality Parameters Across Space and Time         Water Quality Parameters Across Space and Time Worksheet
Water Quality         Water quality brochure                                 Water Quality Brochure Final 2007


Hydrology             Groundwater Flow Model                                 Groundwater Movement Questions
                                                       2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls

Hydrology                 Field Streamflow Measurement
Hydrology                 Streamflow Calculation                                Streamflow Calculation Worksheet
Hydrology                 Stream table
Hydrology                 Hydrograph intro and graphing                         MT_gaging_stations
Hydrology                 Flow-watershed size comparisons




Note: Lessons highlighted in blue were dentified by Levia and Doug as strengthening the curriculum
in future years, but are not yet fully developed




                 WATERSHED ECOLOGY CURRICULUM OUTLINE: BIOTIC FACTORS


Unit                      Lesson
                                                                                Seed and Plant Experiments Presentation                 Bean
                                                                                Life Cycle Worksheet                             Seed
Plants                    Seed Germination Experiment                           Germination Research Planning Worksheet_6th

                                                                                Seed and Plant Experiments Presentation                 Plant
Plants                    Plant Growth Experiment                               Growth Research Planning Worksheet_6th
Plants                    Plants in the Water Cycle: Transpiration              Plant Transpiration Paths Worksheet
                                                                                Photosynthesis Presentation                    Photosynthesis
                          Photosynthesis and Respiration Introduction and       Questions_pre_HOMEWORK                    Photo-Resp Modeling
Plants                    Modeling                                              Labels
                                                                                Water Movement and Photosynthesis Worksheet
Plants                    Plant Water Transport and Associated Tissues          Water Movement and Photosynthesis_KEY
Plants                    Plant Reproduction
Plants                    Cottonwood Field Ecology and Analysis                 Cottonwood Size Comparison
Plants                    Plant Adaptations to Water
Plants                    Cottonwood Biology and Ecology                        Merigliano Cottonwood Research Article and Q's
                                                          2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls



Macroinvertebrates        Field Collection and Analysis
Macroinvertebrates        Biology, Life Cycles and Tolerance Levels               Macroinvertebrate Life Cycle Presentation
Macroinvertebrates        Poster project: taxonomy, life cycle, ecology


Fish                      Fish adaptations intro (Project WET "Fashion a Fish")
Fish                      Trout Habitat Art Project                               Trout Habitat Presentation
Fish                      Fish adaptations (advanced)
Fish                      Fish taxonomy
Fish                      Fish field sampling (electroshocking demonstration)


8th Research Project      Field Research Project Teacher Outline
8th Research Project      Field Research Project Intro and Planning               Field Research Student Handout
8th Research Project      Field Research Data Collection
8th Research Project      Data Analysis, Results, Conclusion and Presentation     Field Research Project Presentation Guidelines




Note: Lessons highlighted in blue were dentified by Levia and Doug as strengthening the curriculum
in future years, but are not yet fully developed
                                       2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls




Supporting Documents                  # Pds C or F 6th 7th 8th
                                        1    C/F    1   1   1
                                        1     C     1   1   1


                                        1     C     1   0   0
Watershed Topography Worksheet_8th      2     C     1   1   1
                                        2     C     1   0   0
                                       1-2    C     0   1   0
                                        1     C     0   0   1
                                        2     C     0   0   0
                                        1     F     0   0   1
                                        2     C     0   1   0


Soil Triangle and Flow Chart Slides     2     C     0   1   0
                                        1     C     0   1   0
                                       2-3    C     0   1   0
Soil Excel lab                         1-2    C     0   1   0
                                        1     F     0   1   0


                                        2     C     1   0   0
                                        3     F     1   1   1
                                        2     C     0   1   1
                                        4     C     0   0   1


                                       1-2    C     1   0   0
                                                   2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls

                                                    1      F      1   1   1
                                                    2      C      0   0   1
                                                    2      C      0   0   1
                                                    2      C      0   0   1
                                                    2      C      0   0   1




                                                  # Pds C or F 6th 7th 8th


Seed Germination Experiment Data Sheet
Seed Germination Analysis Worksheet                5+      C      1   0   0

Plant Growth Experiment Data Sheet        Plant
Growth Analysis Worksheet                          5+      C      1   0   0
                                                   1-2     C      0   1   0

Photosynthesis and Respiration Worksheet
Photosynthesis and Respiration Worksheet_KEY        2      C      0   1   0

Plant Water Transport Tissues Worksheet             3      C      0   1   0
                                                    2      C      0   1   0
                                                    1      F      0   1   0
                                                    1    C or F   0   0   1
                                                   1-2     C      0   0   1
                                    2a38b3ce-3cd2-4571-a4e9-5e2405e1fc17.xls



                                    3      F     1   1   1
                                    2      C     0   1   0
                                    5      C     0   1   0


                                    2      C     1   0   0
                                    3      C     0   1   0
                                    2      C     0   0   1
                                    2      C     0   0   1
                                    1      F     0   0   1




Field Research Planning Worksheet   3     C/F    0   0   1
                                    2-4   C/F    0   0   1
                                    5-7    C     0   0   1
                                WATERSHED ECOLOGY CURRICULUM OUTLINE BY GRADE: ABIOTIC FACTORS


Unit                             6th                                     7th                                           8th
Introduction    Aquatic Ecosystems Overview          Aquatic Ecosystems Overview                 Aquatic Ecosystems Overview
                Water Cycle Overview                 Water Cycle Overview                        Water Cycle Overview

Watersheds      What is a Watershed?                 Topographic Maps: Identifying Features      Topographic Maps: Identifying Features
                Topographic Maps: Identifying
                Features                             Topographic Maps: Defining Watersheds       Draw a cross section from a topographic map
                Build a contour model                Wetlands within Watersheds                  Aerial photo interpretation
                                                                                                 Geocaching: navigating using GPS

Soils                                                Soil Texture
                                                     Particle Structure and Characteristics
                                                     Soil Infiltration Experiment and Analysis
                                                     Soil Excel Lesson
                                                     Texturing and Infiltration in the Field


Water Quality   Water Quality Parameters Introduction Water Quality Testing and Analysis         Water Quality Testing and Analysis
                                                      Water Quality Parameters Across Space      Water Quality Parameters Across Space and
                Water Quality Testing and Analysis    and Time                                   Time
                                                                                                 Water quality brochure

Hydrology       Groundwater Flow Model               Field Streamflow Measurement                Field Streamflow Measurement
                Field Streamflow Measurement                                                     Streamflow Calculation
                                                                                                 Stream table
                                                                                                 Hydrograph intro and graphing
                                                                                                 Flow-watershed size comparisons
                                        WATERSHED ECOLOGY CURRICULUM OUTLINE BY GRADE: BIOTIC FACTORS


Unit                                    6th                                      7th                                              8th
Plants                Seed Germination Experiment             Plants in the Water Cycle: Transpiration      Plant Adaptations to Water
                                                              Photosynthesis and Respiration
                      Plant Growth Experiment                 Introduction and Modeling                     Cottonwood Biology and Ecology
                                                              Plant Water Transport and Associated
                                                              Tissues
                                                              Plant Reproduction
                                                              Cottonwood Field Ecology and Analysis

Macroinvertebrates    Field Collection and Analysis           Field Collection and Analysis                 Field Collection and Analysis
                                                              Biology, Life Cycles and Tolerance
                                                              Levels
                                                              Poster project: taxonomy, life cycle,
                                                              ecology

                      Fish adaptations intro (Project WET
Fish                  "Fashion a Fish")                       Trout Habitat Art Project                     Fish adaptations (advanced)
                                                                                                            Fish taxonomy
                                                                                                            Fish field sampling (electroshocking
                                                                                                            demonstration)

8th Research                                                                                                Field Research Project Intro and Planning
                                                                                                            Field Research Data Collection
                                                                                                            Data Analysis, Results, Conclusion and
                                                                                                            Presentation


Note: Lessons highlighted in blue were dentified by Levia and Doug as strengthening the curriculum in future years, but are not yet fully developed
                                                     CONNECTIONS TO 2006 MONTANA SCIENCE STANDARDS

                                                                     Standard 1        Standard 2          Standard 3    Standard 4         Standard 5
Unit                   Lesson                                    1    2 3 4 5           1 2 3          2    3 4 5         3 4          1    2   3   4
Introduction           Aquatic Ecosystems Overview                                                             X                            X
Introduction           Water Cycle Overview                                                     X                             X

Watersheds             What is a Watershed?                                                     X                             X

Watersheds             Topographic Maps: Identifying Features                    X
Watersheds             Build a contour model                                     X
                       Topographic Maps: Defining
Watersheds             Watersheds                                                X                                            X
                       Draw a cross section from a
Watersheds             topographic map                                           X
Watersheds             Aerial photo interpretation                               X
Watersheds             Geocaching: navigating using GPS              X
Watersheds             Wetlands within Watersheds                                                                             X        X         X

Soils                  Soil Texture                                                     X   X
Soils                  Particle Structure and Characteristics                           X

Soils                  Soil Infiltration Experiment and Analysis X               X
Soils                  Soil Excel Lesson                         X
Soils                  Texturing and Infiltration in the Field   X           X

Water Quality          Water Quality Parameters Introduction                            X
Water Quality          Water Quality Testing and Analysis        X                      X
                       Water Quality Parameters Across
Water Quality          Space and Time                            X   X                  X
Water Quality          Water quality brochure                    X                      X                                              X    X    X    X

Hydrology              Groundwater Flow Model                                    X                                            X
Hydrology              Field Streamflow Measurement                  X                                                        X
Hydrology              Streamflow Calculation                    X               X
Hydrology              Stream table                                              X                                            X
Hydrology              Hydrograph intro and graphing             X           X                                                X
Hydrology              Flow-watershed size comparisons           X           X



        Note: Lessons highlighted in blue were dentified by Levia and Doug as strengthening the curriculum in future years, but are not yet fully developed
                                                   CONNECTIONS TO 2006 MONTANA SCIENCE STANDARDS

                                                                       Standard 1       Standard 2          Standard 3    Standard 4         Standard 5
Unit                    Lesson                                     1    2 3 4 5          1 2 3          2    3 4 5         3 4          1    2   3   4
Plants                  Seed Germination Experiment                X   X   X                            X
Plants                  Plant Growth Experiment                    X   X   X                            X

Plants                  Plants in the Water Cycle: Transpiration                   X                             X             X
                        Photosynthesis and Respiration
Plants                  Introduction and Modeling                                  X         X          X
                        Plant Water Transport and Associated
Plants                  Tissues                                                    X                             X
Plants                  Plant Reproduction                                                                   X

Plants                  Cottonwood Field Ecology and Analysis X                X                                 X
Plants                  Plant Adaptations to Water                                                      X        X
Plants                  Cottonwood Biology and Ecology                                                           X                      X    X    X    X

Macroinvertebrates      Field Collection and Analysis              X   X   X                                     X
                        Biology, Life Cycles and Tolerance
Macroinvertebrates      Levels                                                                                   X X
                        Poster project: taxonomy, life cycle,
Macroinvertebrates      ecology                                                                                  X X

                        Fish adaptations intro (Project WET
Fish                    "Fashion a Fish")                                                                        X
Fish                    Trout Habitat Art Project                                                                X                           X
Fish                    Fish adaptations (advanced)                                                              X
Fish                    Fish taxonomy                                                                                X
                        Fish field sampling (electroshocking
Fish                    demonstration)                             X   X

                     Field Research Project Intro and
8th Research Project Planning                                      X                                                                         X
8th Research Project Field Research Data Collection                X   X                                             X                       X         X
                     Data Analysis, Results, Conclusion and
8th Research Project Presentation                                  X       X X     X                             X                           X    X    X




         Note: Lessons highlighted in blue were dentified by Levia and Doug as strengthening the curriculum in future years, but are not yet fully developed

				
DOCUMENT INFO
Description: Abiotic and Biotic Factors Worksheet document sample