Armed guards are also problematic, just based on cost effectiveness. The thing to remember is that school shootings are incredibly rare. This is now dated, but the stats haven't changed appreciably since it was published:
http://www.prisonpolicy.org/scans/jpi/schoolhouse.pdf
The numbers change, from year to year, but the 40 killings that happened in school, in 1998, were the ballpark we're talking about -- 33 to 63 kids per year between 1992 and 2010. So, what would the cost/life saved be of putting paid armed guards in schools?
Answering that would require nailing down the details of what we're proposing. Are we talking about armed guards in all schools? Just in the high-risk schools? Would we put several guards per school, to get good coverage, or just one? Would they be well-trained, or just low-cost mall-cop types?
Just for a "back of the envelope" estimate, let's say we put an average of one armed guard per public school, at a fully-loaded (benefits included) cost of $50,000 each (about as cheap as you could expect to go if you want people who are more likely to stop shootings than to be involved in accidental shootings themselves), and that this results in cutting the school killing rate in half.... from, let's say, an average of 50 per year to an average of 25.
In that case, the cost-per-life saved would be $50,000*100,000(number of public schools)/25(lives saved). That works out to $200,000,000. Is $200 million a reasonable cost to save a life? No. There are COUNTLESS ways we could save far more lives for far less money.
For example, upgrading guard rails costs about $101,000 per life saved:
http://www.textfiles.com/survival/costja88
http://books.google.com/books?id=LsXmMHOT8VsC&pg=PA465&lpg=PA465&dq="cost per life saved" guard rails&source=bl&ots=uoTiSc3e33&sig=zpb3wIS7vXWe9ugfnspV_x-183A&hl=en&sa=X&ei=guK5UcevKY_k4APY6YC4Ag&ved=0CDYQ6AEwAQ#v=onepage&q="cost per life saved" guard rails&f=false
Building mobile ICUs in small towns isn't much more expensive than that. There are thousands of things we could spend money on that would be saving lives at a cost of $1 million per life or less. So, why would we blow vast amounts of money on armed school guards, when our kids would be vastly safer if we spent the same money fixing guardrail caps, reducing pollution, or any number of other interventions?
I get why the NRA would love this idea. It flows taxpayer dollars into the pockets of gun manufacturers who, in turn, flow money into the pockets of the NRA leadership. But why would any ordinary citizen think it was a good idea?