ORSANCO - RiverWatchers' Data Entry

2006-2007 Calendar Year

Water Quality Index Form

Downloadable Water Quality Index Form (.pdf format) (.doc format)

Downloadable Q-Value Forms (.pdf format) (.xls format)

* Denotes Required Field

Site Information
School/Organization	*
Date of Sample	*
Time of Sample	*	Time form 24 hour HH:MM
Water Temp	*	°C
Air Temp	*	°C
Today's Weather	*
Yesterday's Weather	*

* You may perform as many of the following tests as you wish; however, at least 6 must be completed to obtain a Total Water Quality Index Value. Divide the total of the Calculation column by the total of the Weighting Factor column to obtain the Water Quality Index Rating. IF YOU DO NOT HAVE DATA FOR A TEST. PLEASE LEAVE THE FIELD BLANK.

** If you enter Data in the Test Results field, you must choose a value in Weighting Factor field or your data submission can become corrupt.

Test Results (Average)

Q-Value

Weighting Factor

Calculation

Dissolved Oxygen

% Saturation

E. Coli

colonies/100 mL

units

Biochemical Oxygen Demand (BOD 5)

mg/L

H2O Temperature Change

°C

Total Phosphate

mg/L

Nitrate (NO3)

mg/L

Turbidity

NTUs


	Water Quality Index

	90 - 100%	Excellent
	70 - 90%	Good
	50 - 70%	Medium
	25 - 50%	Bad
	0 - 25%	Very Bad

Guide for Water Quality Ranges


	Dissolved Oxygen (% Saturation)

	91 to 110	Excellent
	91 to 90 > 110	Good
	51 to 70	Fair
	<50	Poor


	Total Phosphate

	< .10	Excellent
	.11 to .16	Good
	.17 to .58	Fair
	.59 to 2.99	Poor
	> 3.0	Very Poor


	E. Coli (colonies per 100 mL)

	< 50	Excellent
	51 to 200	Good
	201 to 1000	Fair
	> 1000	Poor


	Nitrate (NO3) (mg/L)

	< 1.32	Excellent
	1.76 to 3.52	Good
	3.96 to 8.36	Fair
	> 8.8	Poor


	pH (pH units)

	6.5 to 7.5	Excellent
	6.0 to 6.4 7.6 to 8.0	Good
	5.5 to 5.9 8.1 to 8.5	Fair
	< 5.5 < 8.6	Poor


	Turbidity (JTU, NTU)

	1 to 10	Excellent
	10.1 to 40	Good
	40.1 to 150	Fair
	> 150	Poor


	Biochemical Oxygen Demand (mg/L)

	<2	Excellent
	2.0 to 4.0	Good
	4.1 to 10	Fair
	> 10	Poor


	Water Temperature Change (°C)

	0 to 2	Excellent
	2.2 to 5	Good
	5.1 to 9.9	Fair
	> 10	Poor