I was thinking about the Tennessee proposal to put an armed officer in every school. The problem with this proposal is that it doesn't deal with boredom.
Most armed resource officers (AROs) would spend years doing not much more than "being there," with Glock on hip. Standing (or sitting) around is mind-rotting.
The ARO job needs to be rounded out to have routine but non-trivial duties that can be dropped at a moment's notice to go confront trouble. Ideally, the ARO would operate out of a centrally located office equipped with many TV screens tied to cameras looking at the school's entrance, halls, playgrounds, dining/multipurpose room, and parking lot.
A family friend monitors 30+ cameras like this for a county courthouse/jail complex. She radios onsite deputies if she sees something amiss. A school ARO might in some circumstances call for LEO backup but would be the first responder already onsite.
A more controversial suggestion adds a wide angle camera in each classroom with the signal blocked unless the teacher or principal turns it on. Teacher unions might otherwise fight classroom cameras, and may fight them regardless of safeguards.