I have to disagree. Any 'model' that implies that water has some resonant frequency that microwaves are specifically designed for is misleading to the point of uselessness.
If microwave ovens were tuned perfectly for water, then the water near the surface of foods would absorb most of the oven's energy, and not let the center of the food warm up as efficiently... essentially causing the microwave oven to heat food more like a regular oven.
AFAIK, the frequency chosen for use by microwave ovens is a balance between
* A desire for the EM energy to penetrate deeper into the food (per my 2nd paragraph above)
* A desire for the EM energy to not interfere with licensed communications bands, in the event that the oven is "leaky".
Finally: it's not very hard to explain the concept of a dipole moment, and why molecules that have one will twist in the presence of EM radiation. In fact, if you do explain this, quite often the student will come to realize that this is also true of light, which is why (A) a vintage Easy Bake Oven toy could bake a brownie with just an incandescent lightbulb, and (B) will serve to demystify microwaves as being just sub-infrared light.