covering for my cover letter

My first true exposure to the philosophy of teaching was in a graduate seminar at Simmons College. Within the safe boundaries of that classroom, the other students and I were able to dream up writing exercises, practice critiquing student assignments and philosophize about teaching, education and the world. There was very little admonishment, no matter how far-fetched the idea.

Since taking that course in 2004, I have had several opportunities to test my altruistic classroom theories against
real-world situations. From teaching literature to English teachers to introducing basic computer skills to adult ESL students, I have learned that it isn’t as much about my intentions as it is my willingness to adapt—both to the specific learning environment and to individual student needs. The goal becomes finding the balance between all of these needs with what needs to be taught.

Still, I believe that class to be a crucial step in my own journey towards teaching. I may have found that some things about the classroom are not permeable, but I have held on to my affinity for finding possibilities within restrictions. Barriers (of any sort) may mean more time spent examining individual lessons or revisiting particular instructions. But what’s so bad about slowing down, if it helps us learn from one another?

I wrote this is a cover letter, but my reviewer (who i agree with) thinks its a little too vague and writerly for anyone other than myself or likeminded english-y people to understand. Like I said, I agree with him. But I don't know what else to write... I don't have a list of "accomplishments" in the classroom to detail for anyone, and--in fact--don't even know For Sure if I want to be in a classroom full time. I'm only trying to do my best to apply for jobs I think I'm capable of doing.

I know the cover letter is only meant to get me the interview, but it's still the first view these people are getting of me AND my writing. I guess that's why I don't want to send a standard "You should hire me because of this..." letter. If it's written well, shouldn't they interview me and then decide I'm actually not qualified...?

typing assessment

I found this website called TypeOnline. You can practice basic typing skills or take assessment for typing words, numbers or words & numbers. My wpm is VERY HIGH, as i knew it would be--104 with only 1 mistake. However, my wpm when it's just numbers or when it's words and numbers is quite low. It sucks that they include "symbols" when it's just the numbers test, because I'd like to know how fast I actually type when it's just numbers on the number pad. I bet it's like 2000 wpm.


more change is a'comin...

how to feel...
liberated?
relieved?
scared?
regretful?

i don't know. (squeak)

update on the work cafe:

it's bad enough when i find one hair in my buffalo chicken wrap. but when i find TWO hairs? i wonder if there might be a larger problem...

ugh

i hate being on the same bathroom schedule as other female co-workers. it's awkward.

i've gone to the left

because the carpal tunnel has taken over any usefulness that once existed in my right hand, i've moved my computer mouse to the left side of the keyboard. i can't see why they call the left "liberal" because it's actually quite hard to use a mouse left-handed. however, i think i'm getting pretty good at it. it's kind of like going from a mac to a PC or a shifter to an automatic. once you get used to it, it's not so bad... (however, it's MUCH easier than going from non-profit to non-work, i mean the Corporate World).

if my boss ever reads this, she will probably spank me

but--hey--she is also the same person that once told me "we all do what we have to to survive."

anyway, my new way of getting through the day? ONLINE TV. previously, i've thought to myself: why would anyone watch TV online??? the screen is too small, the quality isn't that good, and if you want to watch TV, you should just buy a damn TV already! but last week, i discovered that watching TV online is, for cubicle-residents such as myself, almost better than discovering the fountain of youth or getting 2 weeks of paid leave for good behavior. *i said ALMOST*

unfortunately, Fox On Demand is really the only player i can get to work with my laptop. in other words, the other networks' players suck my ass. and there are very few shows on Fox that i would be caught watching. House is always a good one, but i'm all caught up on that. and i watched all 8 episodes of Amsterdam which i absolutely love (past lives + detective work = happy lee lee). so, yesterday, i decided to bite the bullet and join NETFLIX (gasp!). why i have resisted this for so long we will never know... it's $7.99 for one movie at a time, but as many as you want a month PLUS free online shows, movies, and other craptastic goodies. i am in heaven, well--at least while i'm at work.

currently, i'm catching up on Weeds, a show i never would've been able to watch since i don't now nor will i ever have Showtime. the show isn't that great. but you know what it IS better than? silence. or even worse, the thoughts in my head. or, the worse-est of them all...my cubicle neighbor's harp music. Go Weeds! Go Online TV!

no agenda needed!

i was just thinking how i used to have to print out an agenda for meetings with my boss and write down every single thing she said and keep it until i did everything she said and still keep it after that but just file it away in case i ever needed to reference anything she said or had asked me to do and how A) that didn't do me any good anyway when $hit the fan, and B) i'll NEVER have to do that again...as long as i stay at THP with MVP. like the good book says, Count Your Blessings.

life/work balance?

i wish life were as easy to manipulate as data in excel...

• don't like that person's personality? change the color!
• want to stop being someone's friend? delete that row!
• falling in love? make it BOLD!

but...it ain't. alas.

have i no morals anymore???

oops. i forgot that i am adamantly opposed to people eating fish for lunch at work, and i just ate some. it was damn good. but now i'm "that" girl, whose cube smells like fish. gross. at least hundreds of people are sharing in my shame, as i got it from the long-lined cafe station downstairs...

on another note, what would be a good, strong verb for the phrase "adamantly opposed"? using adverbs is almost as bad as eating fish at work (i said almost!).

always learning

thanks to a colleague asking me a question about doing an access query to get rid of duplicate records, i have learned 2 new-ish tricks. well, okay. only one. but i figured out a new use for a pivot table (PIVOT!) and that counts as a trick in my book. suffice it to say, i'm still and even-more smarter than JMM.

after searching for "unique" query access, and seeing the instructions were 1000 pages long, i quickly decided this must be doable in excel. guess what? i was right. you can delete duplicate records in excel much faster. and--since his original records are in excel to begin with, who needs access???

trick #1 - select all the columns and rows in your data range, go to your data menu and use the Advanced Filter to only copy Unique Records (shows up as a checkbox on the Advanced Filter window). now, these instructions are easily downloadable from many excel-help websites and i read them over and over again...apparently, i am the only geeky excel user who DIDN'T know how to do this. (but, then again, i have never had a reason to do this). however...i kept doing them over and over and wasn't getting any results so i started to think that a) they didn't work (because, of course, i'm Not Stupid) and b) anyone who read the instructions and thought they worked was stupid. well, i was wrong on both counts. the reason it wasn't working for me is because you have to have an exact duplicate, like the entire row has to match another entire row. whereas, my data was only duplicated in specific columns, namely the first 3. so...to make a long point even more boring, what i did was shortened my data range--you have to do this manually because even if you only select a few columns in your data range, excel changes it to all the columns because excel thinks i'm stupid, too--and THEN used the advanced filter to get rid of duplicates. this gave me a count of the rows in which there were duplicates in the first 3 columns.

okay, trick #2. create a pivot table with only the columns you need, like Member #, Date, & Diagnosis Code and change your sum function to a count function; that requires excel to group any duplicate member #s and give you a count of how many dates and diagnosis they have. you can easily "count" the number of members by seeing how many rows it takes up on your new pivot-table-tab. this is actually much quicker (i think) and a lot more fun!! i love pivot tables!!! i want to be buried with a pivot table. is that possible???

sweaty pits and i can't even drink about it

you know it's gonna be a bad day when you get to work, walk up the 5 flights of stairs that still aren't getting any easier, and realize you forgot to put on deodorant this morning. unfortunately, the only kind i have at my desk is the "natural" deodorant, which i should have just thrown away when i realized it didn't work...

if that isn't bad enough, i recently discovered that my work has a "no tolerance" policy for alcohol on the premises. great! what am i going to do with the flask and mini martini shaker i've been keeping at my desk???

not quite a tempered radical, but close.

despite the signs posted everywhere saying you can't leave your food in the microwave and then walk away to do something else, i just put my food in the microwave, walked away and went to the bathroom, then walked back and it was still there and nothing had blown up. i feel very "i've been her long enough to disregard that rule" right now.

and, yes, i'm eating at 11 AM. i can't help it. i'm starving.

new and improved

i like how my work addressed the problem of only having one bathroom for every 1500* or so people by painting the front doors a nice shade of olive green. it's like a home improvement bandaid: "there, there, that's better."











*this is not a scientific statistic. i have no idea how many people work in this building, or, even on my floor.

settling in

i figure you're settling in nicely at work when someone who's going on vacation asks you to take care of their plants while they're gone. either that, or, you're seen as that weird girl who sits in the corner and doesn't talk to anyone which means--naturally--you're good at taking care of plants...

the logic behind graphing

since a large part of my job has to do with the presentation of data (i.e. making boring stuff look pretty), i'm always searching for new ways to make my powerpoints look more spiffy. i like the look and feel of graphs because A) they take a lot of data and compress it into a very small setting and B) they incorporate COLOR (even if it's just the random colors excel chooses for me...). i'm pretty good at determining whether a graph looks good after the fact, just like i can tell you if a sentence is correct after you've written it or paint colors go together well after they're up on the wall. but unlike these 2 comparisons, i really never had an idea why a certain graph would look better than others. i kind of just close my eyes and click on one...

until TODAY, that is. i decided to do some research on why certain graphs are better than others and came across this tutorial. i think it's for high schoolers, or maybe even kids in junior high. but i found its very basic instructions refreshing and easy to grasp. i also feel like i've probably learned this before at some point in my life. oh, well! it's never too late to learn it again!

lackluster

why am i not motivated to do my work today????????????? I SUCK.

becoming even more excel-proficient (read: geeky)

have i mentioned that i love excel???? well, i do. that is aside, but i thought i'd just say it.

i spent some time today learning keyboard shortcuts for excel tasks i do all the time. i figure since my job entails me using excel about 90% of the time, these are worth knowing. also, my keyboard & mouse setup is not all that great, so using a mouse is annoying. but i have always hated using a mouse.

here are some of my faves:

shift+space: highlight entire row
alt + = : autosum function
ctrl + +: enter a new row

supposedly, ctrl+alt+V will open your paste special menu box. however, you then have to revert to the old keyboard trick of Alt + the applicable underlined letter, use your arrow keys, or transfer back to the mouse...so, still not the greatest shortcut key. anyway, i have a pretty custom menu bar for my paste special tasks. yes, i have to use the mouse...but customized menus are worth the pain!

i guess i will never know as much about excel as some of the bigger geeks out there; but, i can keep learning!

Ye Old Pivot Table vs. Crosstab Query

*Warning* This is a very geeky blog entry...!

subtitled: Who needs Excel anyway?

Today, I discovered the Crosstab query in Access. (I also discovered the Make Table query, but that discussion is for another time & place!) How did I discover this, you might ask... Well, it's all due to the fact that Excel will only let you import 65K records, because that's the maximum lines in a spreadsheet. Now, there are tons of "workarounds" on the web, if you're a programmer, data nerd, or techy geek (or all of the above)...but I'm just a wee little data enthusiast, definitely NOT tech savvy enough to read the numerous workarounds posted for this problem. In fact, I can't even read the questions posted regarding this problem, because they too include one of these scary "languages" called Code.

Anyway, instead of throwing my hands up in the air--which, really, I should've done given the amount of sleep I got last night--I began to think...think...think...think... You know, like Winnie-the Pooh does when encountered with a problem. I thought, there must be a way to do this in Access. (And by this, I mean a "pivot table" because that was my ultimate reason for wanting the 65,000+ records in Excel in the first place.) Guess what?? THERE IS!

Yes! I hearken back to the Access class where my teacher was like, basically anything you find yourself doing with data in Excel on a daily basis, you should be doing in Access instead. I LOVE HER FOR SAYING THAT. On the surface, Access does present intself as hard-to-understand and it's not really all that user intuitive. But, let me tell you...it is a lot easier to do difficult stuff in, as long as you're able to find a tutorial that you can understand. I mean, most of what I learned in Excel, I learned on the fly. Or, someone showed me once and I "got it." But for Access, the classes definitely help; the books help; the online tutorials help; even Microsoft's help center helps. In other words, you will need help if you are going to use this program.

Hey--that's probably the main reason why laymen AND tech savvy peeps neither one like it: they don't want to admit they need help! But me? No problemo. I love learning stuff, which--they have told me--usually involves trusting other people to teach it to you. (At first glance, it would seem this is incongruent with my stubborn, know-it-all personality. Au Contraire... Because once I have learned something, I can then pass it off as something I have known all along...)

Anyway.

What is the moral of this story? Let me recap for you:

• Excel has a silly limitation of 65,000 records in a spreadsheet and no inherent workaround when importing data that exceeds that limitation
• Access doesn't need your stinkin' Excel spreadsheet anyway...
• I still like Excel for formatting and makin' her pretty.
• ...but TODAY, my heart belongs to Access. LOVES.
  

this is how cool my job is

it allows for time (in fact, requires it!) for me to learn new things about my favorite program: EXCEL. (yes, i'm a microsoft whore, too...)

here is what i learned today: the formula to calculate someone's age when you have their date of birth.

=INT((TODAY()-A1)/365.25)
(taken from http://www.fontstuff.com/excel/exltut01.htm)


i tested it out and it works! i'm 31!