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

More Than a Typewriter: The Power of Word

Visalia Direct: Virtual Valley March 3, 2014 Deadline April 2014 Issue More Than a Typewriter: The Power of Word Typewriters still amaze me, especially the antique mechanical models. There’s something wonderful about the feel of levers, gears, springs and rollers working together to transmit thoughts into words. Typewriters possess a romance computer keyboards and touch screens lack. But, please, stop using your word processor like a typewriter. Word processor abuse mars many otherwise good documents. Bad habits people develop over time lead to documents that are ugly and difficult to edit and revise. The numerous excuses for improper word processing deserve dismissal. It does not take days or even hours to learn to use tabs effectively. Paragraph styles take minutes to understand and appreciate. Even a complex looking table of contents takes only a few mouse clicks to create if you construct a document properly. When you know more about your software tools, you also kno...

Word Macro for Word Abusers

I overuse some words and phrases in my writing. Most writers have some problem words. It isn't that the words should never be used, or that we use them incorrectly. We simply use them too frequently. The following Microsoft Word VBA macro marks words I should check for overuse. Also included are words and phrases I should avoid. Feel free to copy and modify this macro. I encourage my students to try this macro, too. Once you have the macro in Word, you can alter the word list to reflect your preferences and habits. Sub macWordsToAvoid() Dim vFindText As Variant Dim txtWord As Variant 'list the exceptions to look for in an array vFindText = Array("about", "all", "almost", "a lot", "already", "always", "along with", _ "anxiously", "absolutely", "as well", "believe", "certainly", "clearly", "definitely", _ "eagerly",...

eCheating: Students using high-tech tricks – USATODAY.com

This fall, I resorted to using "anti-plagairism" tools for the first time in at least six years. One reason for this is that what I had been teaching at the University of Minnesota didn't lend itself to plagiarism. My technical writing students had to design a new toy or board game, create a prototype, and develop a product pitch. It's hard to steal another person's LEGO project that uses randomly selected bricks. However, teaching a literature class I found that students either had problems with understanding citation norms or they simply assumed an instructor wouldn't check to determine if a passage was a copy-paste effort. I learned this is a great reason to have two mandatory drafts before a final paper, too. My department head and other colleagues were supportive and I'm now working on a reusable lesson module that will address citations. Student don't quite grasp that simply because you can copy-paste doesn't mean it is acceptable. ...