Oh MrsS, what a complete bummer. I have to say I am a bit
as to why these nutjobs remain in the employ of the establishment that you work for. "no interpersonal skills"?? What's she doing there, FFS? Good luck with HR, although it sounds like the whole lot of them need a gigantic kick up the arse.
When I lived in Germany, I once worked for a Boss From Hell who was a huge control freak and bully. It was his company, so he figured he could do what he liked. I was the most junior employee (all the others were engineers), but he swore at everyone and regularly threw things at people. He was convinced that he spoke and wrote perfect English and it took me some time to figure out that when he gave me things he had written to "proofread", I was not actually supposed to make any corrections, just to tell him that he was a linguistic genius as well as an IT hotshot. He had learnt his English from Americans and was convinced that "appropriate" was spelt "abbrobriate" (try saying it in a US accent) and got in a fearsome rage when I corrected this. He threw a phone at me when I tried to show him the dictionary. And that was an olden days desk phone.
I created a rude cartoon of Loony Boss on the Unix graphics editor (IT olden days) on my workstation and something unfortunate happened and it appeared in an endless scroll on all the workstations in the building. I got sacked. 
BTM, I wish I could offer you some words of wisdom re: your dd, as her attitude to her Spanish test sounds horribly familiar. However, the only thing that works for my dd under those circs is when she gets a decent result, which then buoys her up for a while. I keep going on and on that as long as you've done your best, that's all that counts.