News for hackers. Stuff that matters.
Re:President Obama calls on every American to learn code by memset on Tuesday December 10, 2013 @12:11AM (#6879076)
Let's assume you're paying a developer $100k per year - not atypical in this day and age. As a business, I want that developer, who is likely making more than anyone else in the organization, to be working on "the most important thing" in our business at a given time. This might mean a new checkout flow, making sure the online shopping cart works, or scaling a website to accomodate 1000 users at once.

There are many tasks which engineers can easily do, and which most non-technically people are loathe to perform, but are not the most important thing that an engineer ought to be doing in a business. The easiest example is reporting.

A given marketing department will want sales information. They'll want charts and graphs describing conversion rates, customer acquisition costs, etc. There are far more ways that the marketing department will want to slice-and-dice data for analysis than a team of developers can possibly produce.

Engineers don't want to be relegated to creating reports. And anyway, the report you just asked your engineer to create may have just cost you $1000.

So if we were able to bring these marketing people to a level of proficiency where they could use SQL to generate reports, Excel to manipulate that data, and VBA to do analysis (which I believe could be accomplished with 80 hours of training - a drop in the bucket over the course of one's career), then we can let the engineers do the things they are good at ("make sure passwords are secure") and the marketing folks have the minimum proficiency they require to do their jobs.

This is common in companies like Amazon; "the engineers wouldn't help me run reports, so I had to learn myself."

Nowadays, business decisions are based on numerical analysis of behavior. (Click-through rates of advertisements. Conversion rates from campaigns. Number of lawns per high school student per summer.) This trend is unlikely to go away.

In practice, "numerical analysis" means "schlepping data into Excel and running the numbers." And that skill of "running the numbers" without having to ask an engineer (who is both expensive and uninterested) seems, to me, of great practical value.

Obviously I have cornered one specific example that I consistently deal with. But it is not too difficult to imagine that these tools of analysis can help automate any number of tasks, in many disciplines. It is not uncommon for linguistics (graduate) students to learn programming to better analyze the meter of poetry. Optimistically, I hope that "non-technical" will be able to use the tools of our trade in new and interesting ways that we never imagined - the same way a carpenter might use everyday materials in ways that are very innovative to laymen.

Re:President Obama calls on every American to learn code by collyw on Tuesday December 10, 2013 @09:05AM (#6880739)
As a counter argument to that, many of the non-technical users in my organization like Excel. We have wasted countless hours by sticking to excel as a data input / manipulation tool, as it is incredibly error prone. Non technical users don't see the difference between a 2 and "2" and a " 2". It looks right to them, and much of the time they seem incapable of reading a sensible error message and fixing it the problem themselves.
Re:President Obama calls on every American to learn code by hatu on Tuesday December 10, 2013 @09:55AM (#6881011)
I've also noticed this countless of times. If you leave data sets to be designed by a non-engineer - it will cost you hours and hours of parsing and changing the format constantly depending on who slapped the excel sheet together. Literally one of the worst experiences on a job was dealing with a big corporations excel sheets and trying to convert them into usable data.
Re:President Obama calls on every American to learn code by memset on Tuesday December 10, 2013 @10:15AM (#6881121)
Doesn't this imply that, with stronger engineering education, the problems you describe (which arise from poor engineering) would be eliminated?
Re:President Obama calls on every American to learn code by collyw on Wednesday December 11, 2013 @04:52AM (#6886791)
I suppose so. Experienced developers already have that education. An introduction to programming class is not likely to provide that. I look back at technical decisions I made ten years ago, when I started coding, and I see how much cleaner and more elegant my solutions current solutions are likely to be (when a clean solution is possible).
Re:President Obama calls on every American to learn code by analog31 on Tuesday December 10, 2013 @08:33AM (#6880573)
Perhaps a side effect of "everybody" learning to program will be the demand for more programming tools that are easy to use. Excel and VBA both developed due to use demand.

I've seen lots of people, from engineers to workers on the loading dock, use Excel to create convenient tools for their own use.

Re:President Obama calls on every American to learn code by easy_rider on Tuesday December 10, 2013 @09:20AM (#6880825)
My client, he doesn't know what "FTP" is, and does not know how to upload his revised version of the current Excel calculation sheet which he designed, and is core-business, and coupled to an application form. He knows the ins and outs about Excel, from formulas to shortcuts, and i'm a total novice when he's explaining stuff to me.

I'm interfacing with his Excel sheet through PHP, and he does not have to change the way he works, and I don't. I don't need to know all the ins-and outs, I just need to know which cell needs what data, and the cells that are calculated and need to extract data from.

I'm now building a management backend for him in Rails, and it will work the same way. Maybe later those Excel calculations will be ported to the database, but for now there is no reason to bother my client with learning a new interface and changing the way he works.