If I may interrput the schoolyard taunting for a brief moment...
Tiger, here's the thing that people have eluded to, but I don't think anyone has explained yet. When you tried the rods in class, I'm sure they worked very well. But the reason they moved isn't because they "detected" water; it's because you expected them to move, and therefore you moved them without realizing you were moving them. Yes, really.
I know, I know you swear you didn't move them. But you did. This is called the "idiometer response." Here's another way to demonstrate it. Take a ring or a key or any other small-ish object with a hole in it. Thread a string about two feet long through it, and hold the ends of the string together so the ring dangles freely. Rest your elbow on the table and hold the ends of the string between your index finger and thumb. With your other hand, stop the ring from swinging so it's perfectly still. Now be as still as you possibly can, but just imagine the ring swinging back and forth, away from you and back toward you. Pretty soon the ring will actually start to move that way, even though you think you're being still. The longer you think about it, the further it will swing. Now change direction and think about it swinging side to side, and soon the ring will follow suit. Ditto with swinging in a circle, both clockwise and counter-clockwise. It works because when you think about the motion, your body produces an involuntary movement that's too small for you to feel, but big enough to start the ring swinging. It's the same thing that makes Ouija boards work... and dowsing rods.
So back to the test you did. If you don't believe me that it was just the ideometer effect, here's how to tell whether it was or not. If it was really the rods finding the water, then they should be able to find it whether you know where it is or not, right? So try this: get ten paper cups and ten paper bags. Put one cup in each bag, but leave the tops of the bags open so you can see into them. Spread them around the room. Put water in five of the cups. Check your dowsing rods to make sure "they" work, which they very probably will as long as you know which cups have water in them. Then try this: leave the room, and have a friend go in and mix the bags up and close up the tops, so that when you walk back in, all you'll see is ten closed bags and you won't know which ones contain water. Have your friend leave the room. Then see how well the dowsing rods work with the bags closed. "Dowse" all ten bags, and make a record of which ones you think have water in them before you look inside any of them. Once you've made your choices, then open them up and see how accurate the rods were. Then see if you still think there's anything to it.
Oh, and yes, people have been using this "technique" to allegedly find water and all sorts of other things for years. The thing is, they've all been mistaken. Yes, all of them, every single time, for all those years. And if you think that many people couldn't possibly be that wrong that consistently for that long, then stick around and prepare to have your eyes opened.