ABCDEFGHIJKLMNO
1
2
EcoSpark's Data Analysis Calculator
Please fill in the "Yellow-Highlighted" cells below.
3
4
5
6
Study Status: Valid
7
8
Index Calculations and Ratings
9
Site CodeCRE-NOR-02Note: If <100 BMI's are found the study is Invalid.
10
SchoolSt. Joseph Secondary SchoolIndexValueRatingIndex Criteria Rating
11
Teacher/OrganizerE.Mota-Kenney% Worm (Oligochatea, Nematoda and Tubellaria)2%UnimpairedIndexImpairedPotentially ImpairedUnimpaired
12
WatershedCredit River% Midge (Chironomidae)10%Unimpaired% Worm> 30%10% to 30%< 10%
13
SubwatershedNorval to Port Credit% Aquatic Sowbug (Isopoda)0%Unimpaired% Midge> 40%10% to 40%< 10%
14
Stream/RiverCredit River% Snails (Gastropoda)0%Potentially Impaired% Aquatic Sowbug> 5%1% to 5%< 1%
15
Nearest IntersectionRiverwood Conservancy at Burhamthorpe BridgeNumber of Taxonomic Groups13Unimpaired% Snails-----< 1% or > 10%1% to 10%
16
Coordinates (Lat/Long)43.56111, -79.67223% Dominant Taxon36%Unimpaired# of Taxonomic Groups< 11------≥ 11
17
Monitoring Date9/21/2018% EPT (Ephemeroptera, Plecoptera, Trichoptera)59%Unimpaired% Dominant Taxon> 45%40% to 45%< 40
18
% Diptera (Diptera, Chironomidae, Culicidae, Simuliidae, Tabanidae, Tipulidae)11%Impaired% EPT< 5%5% to 10%> 10%
19
BMI Tally% Insects (All Diptera, Anisoptera, Coleoptera, Ephemeroptera, Hemiptera, Megaloptera, Plecoptera, Tricoptera, Zygoptera)92%Impaired% Diptera< 15% or > 50%
15% to 20%, or 45% to 50%
20% to 45%
20
TaxaCommon NameToleranceCountHilsenhoff Biotic Index (HBI)4.81Unimpaired% Insects< 40% or > 90%
40% to 50%, or 80% to 90%
50% to 80%
21
CoelenterateHydras80Benthic Aggregate Assessment (BAA) Overall ResultUnimpairedHBI> 76 to 7< 6
22
TurbellariaFlatworms80
23
NematodaRoundworms80Physical Data Collected
24
OligochaetaAquatic Earth Worms82ParameterResultRiparian, Substrate and Canopy Cover Types
25
HirudineaLeeches80Site Length (m)Riparian VegetationSubstrateOverhead Forest Cover
26
IsopodaSow Bugs80Number of Transects1-None1-Sand/Silt <2mm1-None
27
PelecypodaClams, Mussels60Minimum Wetted Width (m)2-Cultivated2- Pebbled 2-8mm2-1-25%
28
AmiphipodaScuds61Maximum Stream Depth (mm)3-Meadow3- Gravel 8-64mm3-26-50%
29
DecapodaCrayfish51Maximum Hydraulic Head (mm)4-Scrubland4- Cobble 64-256mm4-50-75%
30
HydracarinaWater Mites67Riparian Vegetation Left Bank (1.5-10m)5-Forest, Mostly Coniferous5- Boulder >256mm5->75%
31
EphemeropteraMayflies547Riparian Vegetation Left Bank (10-30m)6- Forest, Mostly Deciduous
32
AnisopteraDragonflies50Riparian Vegetation Left Bank (30-100m)
33
ZygopteraDamselflies71Riparian Vegetation Right Bank (1.5-10m)
34
PlecopteraStoneflies13Riparian Vegetation Right Bank (10-30m)
35
HemipteraTrue Bugs50Riparian Vegetation Right Bank (30-100m)
36
MegalopteraFishlies, Alderflies45Dominate Substrate (1st Dominate)
37
TrichopteraCaddisflies428Dominate Substrate (2nd Dominate)
38
LepidopteraAquatic Moths50Overhead Canopy/Forest Cover
39
ColeopteraBeetles422
40
GastropodaSnails, Limpets80Chemical Data CollectedChemistry Conversion Chart
41
ChironomidaeMidges713ParameterResultsRatingUnitsConversion
42
TabanidaeHorse and Deer Flies50Temperature (°C)18.0PoorPPT to PPM
Multiply result by 1000
43
CulicidaeMosquitos51pH (Drops)N/APPM to PPTDivide result by 1000
44
CeratopogonidaeNo-See-Ums60pH (Probe)8.42Fairµꓢ/cm to mS/cmDivide result by 1000
45
TipulidaeCrane Flies30Dissolved Oxygen (Tablets|ppm)N/AmS/cm to µꓢ/cm
Multiply result by 1000
46
SimulidaeBlack Flies60Dissolved Oxygen (Probe|mg/L)N/A
47
Misc. DipteraMisc. True FliesN/A1Conductivity (Probe| µꓢ/cm)869Fair
48
UnknownUnknownN/A0Turbidity (Cup|JTU/NTU)N/A
49
Total BMIs (excl. Unknown)132Turbidity (Tube|cm)N/A
50
Total BMIs132Total Dissolved Solids (ppm)618Fair
51
Salinity (ppt)0.40Excellent
52
Ammonia (ppm)N/A
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100