Any teacher who wants to carry should be allowed to after proper training. Maybe they could be deputized for in-school purposes.
Why should we expect a middle-aged social studies teacher to confront the shooter if a trained and experienced police officer would not?