the should-i-should-i-not-get-Facebook poll is drawing to a close, with one day left to vote. as of this writing, Yes has a commanding 7-1 lead over No. nay-sayers should get on their horses and fight the good, but pointless fight. otherwise, y'all can just look forward to stalking me by the end of the week.
---
and for those that are oddly interested in this sort of thing:
i started my internship this week at the elementary school i volunteered at last May, working with a grade 6 class, primarily to help them prepare for the upcoming EQAO testing.
today, i spent most of the day in the library coding an Excel spreadsheet to analyze the marks from a standardized reading test that was done earlier in the school year for the grade 7/8 class. it took a long time because a) i'm not a programmer; b) i've forgotten most of Excel; c) i'm way too ambitious about spreadsheets sometimes.
the analysis called for counting the number of students in each level per question by gender. i thought a handy COUNTIF function would suffice as i use it all the time for counting things in columns that fit a certain criteria. unfortunately, the AND function does not work in conjunction with COUNTIFs. after devising a crude workaround (sorting by gender and COUNTIFfing for those specific ranges) i happened upon a new function: SUMPRODUCT.
this function operates with arrays, which allows me to basically do a count with multiple criteria. here's the tutorial i found just after i printed out the poorly coded version. so i spent about half an hour editing everything with SUMPRODUCT formulas instead of COUNTIFs.
ex. =SUMPRODUCT((B2:B50="M")*(C2:C50=3))to count the number of male students who scored a Level 3 on the first part of the first question.
my other accomplishments today: the teacher i am working with discovered that her sunglasses had fallen apart while sitting in the staff room during recess. one of the 'legs' fell off. after about 2 minutes of staring at the ground looking for the screw, we gave up and conceded defeat. i looked on the table and found the screw. while she went back to class to corral the students, i set about screwing the 'leg' back on with limited tools. i checked the knife drawer for something to turn the flathead screw with -- too unwieldly. i checked my wallet for a thin card -- nothing thin and strong enough. on a whim, i went to the photocopy room and rooted around the little container of miscellaneous items (staples, clips, scrap paper) and found a box-cutting razor -- success. i am king of random problem solving.
last year, i defeated the industrial stapler which had been jammed for months and neglected. prior to grade 8 graduation, i was called upon to add a student's grad photo to the framed copy in which he had been mistakenly exempted from. this required me to emulate the name font, scan a copy of the photo, crop and adjust it to the right size, learn how to disassemble a fairly complex frame and glue it down with elementary school supplies. it's still on the wall today.
tomorrow, i will try to solve the busted three-hole puncher.
i still haven't visited my babies yet, but i've seen half a dozen of them at various times in the halls. they still recognize me =D