One of the members of my gun club is a 3rd grade teacher. He has a permit, and he carries concealed at all times at the school he teaches at.
This guy has already given some thought to what he might do if faced with a Sandy Hook or VA Tech-type scenario. His plan is to have his students get under their desks while he crouches behind his and covers the door with his weapon. He carries an airweight. 38 snubnose revolver with a Crimson Trace laser sight on it, and to avoid the risk of overpenetration/stray bullets he loads it with +P Glaser Safety Slugs. These are thin-walled "cannisters" containing BB's that will penetrate a couple of inches at most into a solid object before detonating. If they hit drywall or sheetrock, they will fragment prior to exiting thus posing little risk to anyone on the other side. If they hit concrete they will break up rather than riccochet. If they hit a human body...they will go in a couple of inches and explode, making an absolultely devastating entrance wound but no exit wound. This guys desk is 8 feet from the door, and at that range...from a rest with the laser sight...head shots on a would-be assailant will be a piece of cake. Whatever else happens in that building, no way in hell will anybody be able to get in and hurt his kids.