Lied on Their Resume

One of my biggest pet peeves:  People who take jobs like “administrative assistant” or “teacher”, jobs which in the 21st century are incredibly computer-centric, and don’t know even basic PC functionality.  Of course, they’ll have said during their interview that they’re experts, but when you sit them in the chair, they don’t know the difference between and URL and an e-mail address, or between Word and Excel.

So then what?  Do you fire them for not being able to do the job they said they could do?  Fuck no, it becomes my problem.  I have to train them to do what they should have known to start with… and really, should be able to do for 99% of the jobs in this day and age.

One of my favorite problem children comes and asks me for help.  Apparently, she has two spreadsheets full of customer information, both in different formats.  She’s tasked with combining them into one, then sorting them six different ways based on the needs of who is asking for the report.

First I have to explain how to make new entries into the spreadsheet.  Then I have to explain the difference between storing a date as text like “January 3” compared to actually having a date format like “1/3”.  Then I have to explain how to use a Yes/No box.  Then I have to describe for her the process of copying and pasting the two spreadsheets together.

As for sorting them?  Well, I know you can sort a spreadsheet, but when you’re looking at doing it as many ways as she wanted, I felt compelled to tell her that a spreadsheet was far from ideal for the task.  So, I had to work with her on converting the Excel data into an Access Database (it was a relatively small amount of Data, no need to reach for anything more sophisticated).  All this over someone whose job requirement is to know MS Office in and out.

Finally, I get her to the point where the Database mirrors the Excel sheet in format, so all she has to do is enter in the new data she has behind the existing data.  I show her how, now that she’s done this, she can sort any which way she wants all day long.  She smiles and seems genuinely happy.  Then she asks “So, now how do I get it back to the way it was?”


GI Jerk

Posted once or twice in TSC…first time here.

Thanks for the space, Skip!


Manager in charge of my building…I’d give the official title but it doesn’t matter.  He oversees Day to day operations.

IT doesn’t report directly to him and he hates it.

Ive seen this job turn over 6 times in my 15+ years at my company.

No one was as big a jerk as this guy.

On a day when he’s not trying to make you feel like dirt on his shoe, he’ll drop a subtle hint that he was an Army ranger and that you weren’t.  I sometimes think he just goes home at night to do push ups and sit-ups under a bare lightbulb in his minimally decorated studio apartment….with just an American flag pinned to the wall.

No project is turned in too early.  No conversation ends includes a “please,” “thanks,” or “sorry.”

Nothing satisfies me more than telling this guy, “No” after he’s embarrassed someone in a team meeting or he’s announced that people that were forced to stay home with their kids in a snowstorm were “slackers ” and later “wusses.”

My boss and I laugh when he tries to go around the IT dept and get hardware from our budget without our input only to have our VP loop us in.  He’ll cite a bogus justification for thousands of dollars worth of equipment, and I’ll show him and my VP that we can accomplish the bogus task with existing resources at no cost.

I guess that’s it for now.  Thanks for the space to vent!