I agree, with reservations.
Colleges and Universities should never be “Gun Free” zones. If you can qualify for a CCW permit, you should be able to carry.
Every public school should have desk space and a computer terminal for cops to do paperwork. Cop shows up at various times of the day and is on site from five minutes to an hour.
That is kinda like the old sign;
These Premises Are Guarded by an Armed Guard 3 Nights a Week. YOU Decide Which NIght. Public school teachers and school personnel that can qualify for CCW permit should be allowed to carry.
Same with school visitors.
Would this cure the problem? No, but it would be like a healthy dose of castor oil and sure as hell help.