School Resource Officers (SROs) are rarely, if ever, placed in elementary or middle schools. They are usually placed in high schools. In the system I work for, we had an armed gunman enter a high school and the SRO was successful in keeping the students and faculty safe. That being said, the middle school I work at does not have an SRO and the exterior doors cannot be locked during the day.
I have been thinking about what would happen if a similar situation was to occur at my school. There are 4 classrooms in one large room that are seperated by partitions without individual doors. In our lockdown drills, we have to chain the doors to this area. There is no way that I could get the hall doors chained fast enough if a gunman was to come to our area first, and we are located right next to an entrance.
The only thing that I could do is put myself between a gunman and my students.
I would like to be able to defend my students and myself without leaving my wife and children on their own in this world.