Georgia schools have the right idea.
Via Fox 10:
It is common for schools in Georgia to have uniformed gun-toting officers patrolling the hallways and grounds. It would be a radical step to allow general school personnel to have weapons during the school day.
School board members in Fannin County faced that vote on whether or not faculty members could start carrying weapons during the school day. The board voted in favor of the measure, but stipulated they need to be in the hands of trained teachers and staff.
Read more here.