I'm only 26 and I've only had one supervisor, but from what I understand this isn't how to do things....
I work for a government agency and I won't say what department, but I'll tell you what's NOT good in a supervisor, because unfortunately, mine has/does all of these:
1. Micromanaging - let us do our jobs. You can harp when we're not, but when we're closing 30-50 cases per person in an office with only 10 when we should have closer to 14, chill.
2. Know your job and more importantly, know how to do ours - In my agency my supervisor used to be one of 'us' lowly field personnel who did all the grunt work of the agency, but since coming out of the field 20 years ago, she's lost touch with what's required to do our job, how to enforce what we enforce, and doesn't know how to do her job as a supervisor. Passing off your duties as a supervisor to the acting supervisor when you're out of town does not constitute good managing. Leaving all the difficult and convoluted reports to your 'stand-ins' and only reviewing reports that are quick and easy, commonly only taking 15 minutes to read and review is irresponsible, cowardly, and unfair. Do your job.
3. Not being assertive and make decisions - Be decisive. Don't be afraid to make a decision and have to check every little thing with your boss because you're afraid of your own shadow. You're paid to make the tough calls for a reason.
4. Lack of spine - We as your employees come in, do the work, assignments and paperwork, and we're expected to produce. We go to bat for you. Conversely you should do the same for us.
5. Lack of standards across the board - Don't tell one person one thing and when someone else asks the same question, give a different answer. Be consist. When it comes to annual evaluations, don't just tell me what I'm doing right and wrong, tell me what I need to do in order to improve my rating. Cite specific examples and be open to suggestions from me and other employees regarding your performance. Listen to us when several people tell you something you're doing is wrong or completely out of left field. It shouldn't go in one ear and out the other.
Wow, if you haven't figured out, most of this was venting, but it's valid to the discussion. I've worked one 'office' job so far in my career, hopefully only one, but I've learned real quick what a supervisor is NOT and everything I mentioned above, my boss has done/not done or said/not said.