I don't think I have ever been drunk in school, don't see the point. Been drunk on a lot of field trips with class, though, but that's natural.
I've been stoned a few times in Junior High. Wasn't a good experience, but not in a psychological sense (Junior High was always weird and uncomforting somehow every day) but I rather felt physically sick and was glad when class was over so I was able to get some fresh air.