Revision 3 as of 2009-09-21 12:53:17

Clear message

We are beginning to envision a website and class which would aim to show business users how to use a little bit of Python, focused entirely on helping them with their regular workaday duties.

For now, what we have is a gathering of notes and ideas.

About the idea

Original blog post on the idea

The idea is a website and a class designed to show businesspeople a little bit of programming that they can use in the computer tasks they already have. Not to make them into real programmers (at least, not yet), but to show how they can automate some of the tasks that work makes them do anyway.

(If a few of them end up becoming passionate hobby programmers, or even switching careers, and joining the ranks of contributing Python programmers... well, OK, that hope is the ulterior motive from our point of view.)

There are lots of beginning programming guides out there, but as far as I know, they are all aimed either at students, or at people who already know that they want to get deeper into programming; people who want to program for programming's sake. I'd like something for people with a totally different goal. It would differ from regular beginners' classes in that it:

Hopefully, the website will be a great reference, too. At the moment, information about how to do these basic business tasks can be pretty scattered, hidden, and non-beginner-oriented.

Title

I like the title "Computer Programming for Secretaries (and other businesspeople)", even though not many people are literally called "secretaries" anymore, because it's a very unpretentious title - it would emphasize that it's aimed at people who don't feel like they could survive a serious programming course.

Topics to cover

  • Accessing data in typical business apps (MS Excel, Access, etc.)
  • Screen scraping
  • ResolverOne
  • Blaze

Common automation tasks

Some common tasks that are probably worth mentioning

  • Importing CSV files (using csv)
  • Extracting data from XML (using etree)
  • Controlling the browser (using webbrowser)
  • Simple SQL access via sqlite

Writing OpenOffice macros in Python would probably be good.

Also Django is quite approachable for setting up a data entry system.

Please link to good tutorials on these subjects!

Unable to edit the page? See the FrontPage for instructions.