I'm not sure about the elementary schools, but my local middle schools and high school all have one or two armed policemen. Their job is primarily to keep kids from misbehaving/causing harm to each other, rather than protecting schools from the outside world, but their presence is pretty unobtrusive and everyone generally likes and respects them. I was actually surprised that more schools don't have at least one resident officer - I thought it was fairly commonplace.