Butler County, Ohio, sheriff Richard Jones has proposed commissioning people as peace officers and stationing them in schools.
I'm not convinced it would be that expensive. You could get five people for each school, with one day's service per week. Choose retirees who have time. My gun club alone could probably cover my city.
Of course a simpler solution would be to allow teachers, and in colleges, students, who have CCW licenses, to carry, for free. But the sheriff's proposal would at least deal with those who have no problem with allowing sworn law enforcement officers to carry, yet tremble at the thought of anyone else doing so. I knew a fellow at Interior who transferred from legal to law enforcement, got his badge, and defused a dangerous situation where law enforcement was frankly getting out of control (a vehicle chase with gunshots gets the adrenalin flowing, and the perp who crashed the car was a bank robber). He was the type of guy who kept his head in a nasty situation (as in pointing out that it's a bad idea to be shouting about killing the SOB in front of witnesses, no matter how bad he is or how worked up you are). But then he was the same before he got the badge.