Tag Archives: economy

Excel, Used

When I teach Excel, I always highlight what I consider the two most important features that make Excel useful: formulas and charts. Formulas are important because they allow us to analyze, manipulate, twist and turn numbers so that we can learn new things about them. And charts allow us to visualize numbers so that we can understand them in an instant. (If a picture is worth a thousand words, then a chart is worth a thousand numbers.)

But, when we start creating our own charts, and formatting them, I always point out how charts can be used to manipulate the data. The easiest way to point this out is to change the vertical axis so that it doesn’t start at zero. This amplifies any changes in the vertical axis, making the chart more dramatic. Here is an excellent article by Eric Portelance that further discusses this manipulation, as well as several other manipulations — either on purpose in order to mislead an audience, or by mistake by someone who doesn’t know how to present data accurately. First Chart: inaccurate

The chart Portelance discusses is from a (late 2013) article by Mark Gimein, “Companies and Markets editor at Bloomberg.com, and lead writer for the Market Now blog and newsletter.” Bloomberg is, of course, the huge financial services conglomerate. These guys DO data. They should know better. In fact, I find it extremely hard to believe that they would create a chart that mistakenly mis-represented the data. The only other conclusion, then? That Bloomberg purposefully mis-represented the data.

The question then becomes, why? What do they hope to gain by publishing an article with the title, “For U.S. Men, 40 Years of Falling Income,” and then backing it up with purposefully mis-represented data?

Gimein’s concluding paragraph states, “To TMN it seems that the focus of the economic debate belongs less on rising incomes at the top than on falling incomes in the middle. The concern of Americans on the middle of the economic ladder is not really that their neighbors behind some high hedge are doing too well. It’s that they themselves are not earning anything like the incomes they expected. Judging by the data, that concern is well-founded.”

“Well-founded?” Look at the data in Portelance’s corrected chart:Second chart: corrected

The real question with this chart is, “what happened in 1972 that caused the steady progression of income growth to immediately level off?” Portelance, admitting he is not an economist, takes a shot in the dark anyway: “Bretton Woods and the end of the Gold Standard?” Maybe so. I’m not an economist either, and a cursory glance at Wikipedia’s “Nixon Shock” article only provided me more anxiety.

However, I do have my own guesses as to Bloomberg’s motives for publishing this purposefully-inaccurate article: Is Bloomberg trying to deflect attention away from income inequality (aka “Class Warfare”)? Are the richest 1% trying to “divide and conquer” the 99%?

Let’s look at a chart that looks at income by class: Third chart: income by class

The income of the bottom four-fifths — the middle  and lower classes — has remained steady since the mid 1960s. However, the top 20% and especially the top 5% have grown steadily since the mid 60s. This means that all the growth in income is going to the people who are already rich.

Is Bloomberg afraid that the proletariat will realized the rich have rigged the system? That the rich run things? That the rich make the rules, which of course favor the rich?

Teaching and Training

First week of Fall quarter classes done. The first week of each quarter is nice, because I don’t have any homework to grade, and my classes are pretty much set up– syllabi are done, the quarter’s assignment schedule is done, each class’ Canvas site is done… So, the first weekend is pretty slow. A chance to exhale.

So, I’ve been thinking a bit… Because “the economy” is “better” (whatever the heck that means), enrollment is down for all of my department’s classes. BTS enrollments are all down this quarter compared to Fall 2013. And that’s not good for me, nor for my BTS teacher counterparts, because we are making less money. And, as it is, it’s pretty tough for adjuncts here at BC to make ends meet here in Seattle, where the cost of living is among the highest in the country. Now, of course I’m not complaining, because it could be much worse, and of course I’m grateful that I have a job in the first place, and of course I didn’t go into teaching for the money, blah-blah-blah.

But many people here at BC may not know that, in addition to teaching BTS computer classes here in the IBIT division, I also work part time for Information Resources as a trainer, with Sukirti Ranade in the Technology Learning and Connections Center in A109. If you go to the TLCC website and look under “Peer-to-Peer Faculty Support Hours,” that’s ME! I’m the “peer” for teachers here at BC. As of this quarter, actually, that is only me, whereas for the last couple of years, it was me and Jim Dicus, English adjunct. But Jim is really busy this quarter and didn’t have time for the TLCC, so now I’m the only peer.

I really enjoy working at the TLCC and helping my fellow faculty with their technology needs. During those “support hours,” I just hang out in A109 and wait for the phone to ring or for faculty to walk in. But I also lead several training workshops for both faculty and staff each quarter. Look on the Training Calendar for all the workshops. This quarter, I’m offering Word Accessibility and WordPress trainings. Both of these sessions are great. We’ve been getting positive feedback about the Word Accessibility sessions, as the general consciousness about accessibility grows on campus.

But I’m especially excited about the WordPress sessions, because — well, this blog  is on WordPress, and in fact, ALL BC websites are now powered by WordPress… So, if you are in charge of your department’s website, or if you hope to some day administer an official BC website, or shoot, if you’d just like to use your own personal BC blog, then you may want to attend one of these sessions. And, speaking of accessibility, we will be talking about how to make your WordPress sites accessible too.

And while I’m talking about accessibility, I must tip my hat to BC’s new eLearning Manager, Ekatrina Stoopes. She has really spearheaded the college’s current efforts to “accessify” all documents and web sites. Since Ekaterina has been here, I have learned more about accessibility than in the entire rest of my life. So, thanks, Ekaterina.