When I am stoned I am a lot less motivated to do anything and a lot less likely to study or whatever. It depends on the person I suppose.
A friend of mine ALWAYS gets stoned whenever there are university exams. Not during the day but in the evening before important exams. He says it chills him out and improves his performance. This guy is pretty much a straight-A student.