Month: June 2013

Hello, my name is Bob Green and I am a data geek! Oh and in addition to being a data geek, I am a spreadsheet formula junkie. Ask me to do math on pen and paper I will fail but ask me to do the same problem in a formula in Excel and you will have an answer. I don’t understand it but programming it with Excel works for me.
Example of data geek: One summer I tracked the number of times I rode each roller coaster at Cedar Point. I created a spreadsheet that listed each coaster at that time along with their track length and course time. I then plugged it into a spreadsheet to calulcate the total feet travelled during the operating season and time spent on the rides. I don’t remember the time spent but I do remember I rode over 121 miles of track that summer (okay…I am a roller coaster junkie as well).
Data is all around us in various forms each day. I think it is safe to say that as humans if it can be quantified we have tracked it at one time or another. Does this data provide us with any information we didn’t have previously? Does this data help us to change our behavior (positiive or negatitive)? Once we have the data what do we do with it?
Case #1: Weight
Those who know me in real life, know that I am not the skinniest person alive nor am I the heaviest but I carry an above adequate level of weight. While I am active in playing hockey 2 – 3 times a week along with officating games in the Winter that is about the extent of my exercise outside of walking at an amusement park. Until recently I was also a frequent shopper at many fast food establishments. At a doctor’s office visit in December 2012, I weighed in at the heaviest I had ever been. The motiviation was there at that point to drop the weight.
I was at a hockey game (sensing a pattern here between hockey and roller coasters?) with a friend who showed me his Fitbit One. At a price point of $99 it was an easy choice and I bought one the next day. The Fitbit One tracks steps taken, floors climbed, distance travelled and calories burned. The website offers more indepth graphs and charts along with other features such as tracking food consumption and sleep. After using it for a week I had a baseline of my behvaiors and then set out to change them. I also ended up purchasing the Aria One scale found on the site that tracks weight, body fat and BMI.
Gone were the mornings of eating a fried egg, bacon and pepper jack sandwich every day with a drink from Starbucks (it still happens but less frequently), gone were the days of eating lunch out (again still happens but less frequently) and gone were the days of eating dinner out (same as the other two). Lunch became turkey/cheese sandwich with fruit and dinner often times was grilled chicken and pergoeies. Two things were quickly noticed, I had more money in my bank account and the weight was dropping.
Since that December doctor visit I have dropped 25 lbs (3.2% body fat and went down 1.5 pts on the BMI scale since March 2013) through trying to walk 5 miles a day, eating less food that is better from a nutrition standpoint and partaking in more activites as much as possible. My best day walking was a 17 mile trek around Cedar Point. I have set my goals to be 10 lb incriments so that I can see progress faster than setting a larger goal. I have hit my first goal of 240 lbs and am now setting my sights on 230 lbs.
Case #2: Driving
The second case is a bit more exciting as it was my first new car purchase in almost 4 years. My previous car was a 2006 Hyundai Elantra that had 135,000 miles on it. I was content with the car minus the poor gas mileage it achieved in the city but push came to shove when I was going to need about $1,000 in repairs for a car that had a trade in value of $1,900. I ended up purchasing a 2012 Chevy Cruze and currently plan to run it until it dies.
The majority of my driving in and around Columbus can be considered city driving. I was averaging 23-25 miles per gallon. If I was doing stricitly long range highway miles I was pulling down 28 – 30 miles per gallon. It wasn’t bad but it wasn’t great either. Combined I was getting probably around 26-27 miles per gallon. The Chevy Cruze though is much better in this regard. When I am doing strictly city driving I am averaging 32 miles per gallon and when highway driving is involved I am averaging 38 miles per gallon. My highest highway miles per gallon is currently at 38.9 miles per gallon.
The challenge I faced though was quantifying and the data over a long term than just that one tank of gas. I have created a spreadsheet that tracks miles drove for the month, average MPG and the average speed. This is data that is collected via the car’s computer system. Other data collected for this spreadsheets includes an average gas price (the price of gas on each Friday during the month in Ohio divided by 4), the average cost of fuel for the month, the average cost of fuel for the day, average miles drove per day, average number of gallons consumed in the day, average number of gallons for the month and how many total fill ups.
This is a treasure trove of data that I am able to now use to calculate and analyze to my heart’s content. I know that I drive on average 1,890 miles a month since March at an average MPG of 33.4 at an average speed of 35.07 MPH. Since I bought the car in March 2013 I have seen that the average price of gas has increased .20 cents per gallon and I am spending just under $200 per month on fuel. An average day I will consume $6.46 worth of fuel driving 61.5 miles per day using 1.84 gallons of fuel and fill my tank from empty roughly 3.62 times during the month.
What will I do with this data? I am not 100% sure. I think that one way I could use the data would be to notice any trends in MPG performance. If the MPG is decreasing that could be a sign of a mechanical issue with the car possibly. It could also be a sign of my average speed increasing. I am sure there is other tasks I could do with this data but I have only 3 months worth at this time so I am still working to figure it out.
Data is all around us and it can beneficial to our every day lives. It is how we use that data in our lives which determines it’s value. Data collection is huge in education at every level but people have different views on it’s effectiveness in the classroom. I am in favor of collecting data to help determine which standards a student is struggling with so we can create instruction that fits the need of that student. As a student in school I would have loved to be able to answer my dad with the data when he asked me “What is it that you don’t get about X?” X being what ever the math topic was that day in school. I always answered I don’t know…because I didn’t know what it was I didn’t understand about the topic but had nothing to back it up with.
I am NOT in favor of using a single test to collect a snapshot of a student’s growth on a given day and then use that data to determine a teacher’s pay or effectiveness. There are external variables influencing that student that are beyond the teacher’s control that can impact their ability to score well on a test to demonstrate growth. In addition to these external variables, we know that students all learn at different paces and have different struggles with the material.
What is my solution? I don’t know. I am tired though of seeing educators taken to task and being labeled as ineffective by people (media, public and legislators just to name a few) who have no idea of the reality in the classroom or the challenges faced. We have a system that is far from perfect but it is a system that is hopefully open for debate and tweaking after hearing input from all parties involved. I just hope that a dialogue can be established that includes all voices at the table.

One of my favorite features over on Lifehacker is a recurring feature titled “Insert Name, and This Is How I Work”. The feature takes a look at how people such as authors, programmers, web site founders and others work. They look at the devices, software, processes and any thing else they might think of and put it together in an article. You can see a complete list of the features here: This Is How I Work

Current Gig: IT Coordinator
Location: Columbus, OH
Current Mobile Device: iPhone 5
Current Computer: Work: 15 inch MacBook Pro Late 2011 Home: 11 inch Mac Book Air Mid 2011, Acer C7 Chrome Book and a random Dell laptop that if I screw it up…no harm no foul.
One Word That Describes How I Work: Sproadically Focused (Okay…it’s two words but it describes me)
When I am focused on something or a deadline is at hand it has all my attention. If I have multiple things on my plate with no deadline approaching, I will work on something for a few hours and then work on something else. I find that it helps me think about the first task with a clear mind.
What Apps/Software/Tools Can’t You Live Without?
Evernote. Evernote is at the top of my list because it is on all of my devices, always up to date and the search function I feel functions like my brain. I can remember bits and pieces of something and if I can remember a keyword or tag I can usually find it in Evernote. I recently purchased an external USB battery that is 10200 mAh that I feel will become a great resource at conferences and on the road. Google Maps and GPS. When I visit a school, Google Maps and GPS save me from getting lost and ensure I can get back to the office at the end of the day. Pandora or some type of music. Silence is nice at times but for the most part I need music to keep me focused. Random cables in my bag because you never know when you will need a cable to connect or test a device. Scrap paper. Umbrella.
What’s your workspace like?
Office: Cubeical with two custom built windows (we removed the panels) and a missing wall. There are three of us in cubicals and we often collaborate on various items. One day the inability to see the other persons face got us mad so we took the panels out, the wall down and never looked back. My cubeical has various roller coaster pictures I have taken, little sayings and other stuff hanging on the remaining walls. It is not very organized to the untrained eye but I know where stuff is and my stack of scrap paper is never ending. I will some times use an external monitor but for the most part just use the laptop.
Mobile Office: I have a Timbuk2 custom messenger bag that I carry my laptop, umbrella, cables, Grid-It System and any other materials I need. Timbuk2 is another product I found out via Lifehacker and am glad I made the purchase. The quality of the material is great and it is held up to the weather and the abuse I put it through amazingly well.
Home: I either work on the couch in my bed. I knwo that neither of these are idea and I am working on developing a home office setup but haven’t found a desk that I like at this point and is affordable.
What do you listen to while at work?
98% of the time I will have Pandora on and a mix of custom stations playing. The music ranges form The Beetles to Jimmy Buffett to Bob Seger to Kid Rock to Brad Paisley. It is all over the place and some times I will mix it up and add a new station to the mix. The other 2% of the time may be a pdocast or Wait Wait Don’t Tell Me.
What is your best time-saving trick?
I don’t know if it is a time saving trick but I tend to get in the office between 8:00 – 8:15 AM which usually gives me 45-60 minutes before the office comes alive for the day and allows me to get focused on what ever the task may be for that day.
What’s Your Favorite To-Do List Manager?
I go back and forth but for the sake of this I would have to say paper and pen. It sits right next to my office phone and I can see what needs to be done, make notes etc.
Besides Your Phone and Computer, what gadget can’t you live without?
This is a tough call but I would have to say my Fitbit which tracks my steps, stairs climbed and miles walked. It has been a great benefit to me over the last few months since I bought it and helped me track and see visually as I work on goals.
What everyday thing are you better at than anyone else?
I don’t know. If I had to pick something it I guess it would be not hitting the snooze button on the alarm and getting out of bed as soon as the alarm sounds.
What’s Your Sleep Routine Like?
I try to be in bed by 11:30 PM and awake at 6:30 AM. Depending on the day though the bed time usually falls between 12:00 – 12:30 AM and awake at 6:30 AM. On the weekend unless I have to do something I usually aim to wake up between 8:00 – 9:00 AM.
Fill in the blank. I’d like to see ____ answer these same questions.
Chris Osgood or Steve Yzerman. Going from playing hockey to front office roles, I think it would be interesting to see how they developed their work routines and what they use and how they were guided.
What’s the best advice you’ve ever received?
Don’t skate with your head down. Actually the best advice any one ever gave me was work hard and focus on what you can control. Hard work pays off in the end, it may not be immediate but in the end working hard pays off you may just have to wait for it to show it’s self.
Anything else?
I get bored easily with products and don’t think I have ever kept a cell phone for a full two years before replacing it with something else. As a tech person, I want exposure to as many products as possible and know how they function and work in real life.
I am roller coaster addict. Just ask any one who knows me. I also am a hockey addict. If I am not playing hockey, I am watching hockey.