Skip to main content

Skills My Students Value

In the last two weeks, several of my students have mentioned that employers expected them to know macro programming for Microsoft Office applications, including Word, Excel, and Access.

I've written many times that students should aim for at least intermediate knowledge of Word, including the concept of macros if not coding skills. However, the inclusion of Excel and Access was a little surprising. Maybe it shouldn't be, since what made Lotus 1-2-3 the "killer application" for PCs was its macro abilities. WordPerfect also had exceptional macros back in the DOS days, helping it become dominant for many years.

Note: I'm not sure I'd call the VBA code in Access "macro" coding, but it is Visual Basic and often the code used in workplaces exists in snippets. I won't post my gripes with most of what I've seen done in Access, but I have a long list of bad habits I've seen in workplaces. Still, employers use it for small projects and it isn't a bad system — more often a "badly used" system.

Student groups have asked if I might speak to their members about macros, since employers want these skills. That tells me that our schools should be teaching these skills, starting as early as possible.

Why don't we teach the real power behind Office? Because teachers (and most other users) have no idea what is possible with macros.

Over time more and more features once possible with macros have become integrated into applications. But, macros are still a great way to do more with applications.

I cannot imagine an engineer or draftsman not customizing AutoCAD with LISP scripts. Or a serious Web developer not automating pages with JavaScript. Learning macros opens the door to other forms of coding.

Comments

Popular posts from this blog

Slowly Rebooting in 286 Mode

The lumbar radiculopathy, which sounds too much like "ridiculously" for me, hasn't faded completely. My left leg still cramps, tingles, and hurts with sharp pains. My mind remains cloudy, too, even as I stop taking painkillers for the back pain and a recent surgery.

Efforts to reboot and get back on track intellectually, physically, and emotionally are off to a slow, grinding start. It reminds me of an old 80286 PC, the infamously confused Intel CPU that wasn't sure what it was meant to be. And this was before the "SX" fiascos, which wedded 32-bit CPU cores with 16-bit connections. The 80286 was supposed to be able to multitask, but design flaws resulted in a first-generation that was useless to operating system vendors.

My back, my knees, my ankles are each making noises like those old computers.

If I haven't already lost you as a reader, the basic problem is that my mind cannot focus on one task for long without exhaustion and multitasking seems…

MarsEdit and Blogging

MarsEdit (Photo credit: Wikipedia) Mailing posts to blogs, a practice I adopted in 2005, allows a blogger like me to store copies of draft posts within email. If Blogger, WordPress, or the blogging platform of the moment crashes or for some other reason eats my posts, at least I have the original drafts of most entries. I find having such a nicely organized archive convenient — much easier than remembering to archive posts from Blogger or WordPress to my computer.

With this post, I am testing MarsEdit from Red Sweater Software based on recent reviews, including an overview on 9to5Mac.

Composing posts an email offers a fast way to prepare draft blogs, but the email does not always work well if you want to include basic formatting, images, and links to online resources. Submitting to Blogger via Apple Mail often produced complex HTML with unnecessary font and paragraph formatting styles. Problems with rich text led me to convert blog entries to plaintext in Apple Mail and then format th…

Screenwriting Applications

Screenplay sample, showing dialogue and action descriptions. "O.S."=off screen. Written in Final Draft. (Photo credit: Wikipedia) A lot of students and aspiring writers ask me if you "must" use Final Draft or Screenwriter to write a screenplay. No. Absolutely not, unless you are working on a production. In which case, they own or your earn enough for Final Draft or Screenwriter and whatever budget/scheduling apps the production team uses.

I have to say, after trying WriterDuet I would use it in a heartbeat for a small production company and definitely for any non-profit, educational projects. No question. The only reason not to use it is that you must have the exclusive rights to a script... and I don't have those in my work.

WriterDuet is probably best free or low-cost option I have tested. It is very interesting. Blows away Celtx. The Pro version with off-line editing is cheaper than Final Draft or Screenwriter.

The Pro edition is a standalone, offline versio…