Why are macros not used? A brief review and an approach for improving training

Macros are programming scripts that can be generated by recording users' actions. It appears that despite their potential for reducing monotonous work, they are under-used by non-programmers. The present paper reviews the literature on the use of macros. Included is an original study that examines the effect of adding the ''search and replace'' option as an alternative to using macros in a hypothetical task. It is concluded that the problem of not using macros is due, in part, to motivational biases. Motivational biases emerge even after macro training because simpler alternatives that ''compete'' with macros are more attractive to users. These biases can be addressed through the training process. Some training principles for a strategically competitive real-world environment are presented.

[1]  John M. Carroll,et al.  The Minimal Manual , 1987, Hum. Comput. Interact..

[2]  Aharon Tziner,et al.  Personal and situational characteristics influencing the effectiveness of transfer of training improvement strategies , 1991 .

[3]  Chuck Litecky.  Spreadsheet macro programming: A critique with emphasis on Lotus 1-2-3 , 1990, J. Syst. Softw..

[4]  Robert D. Marx,et al.  Relapse Prevention for Managerial Training: A Model for Maintenance of Behavior Change , 1982 .

[5]  C. Dennis Allen,et al.  User customization of a word processor , 1996, CHI.

[6]  Steven Roman,et al.  Writing Excel Macros with VBA , 2002 .

[7]  Daniel Gopher,et al.  Melioration and the Transition from Touch-Typing Training to Everyday Use , 2003, Hum. Factors.

[8]  John M. Carroll,et al.  The Minimal Manual , 1987, SGCH.

[9]  K. Denise Muth,et al.  Children's Comprehension of Text: Research into Practice. , 1989 .

[10]  Wendy E. Mackay,et al.  Patterns of sharing customizable software , 1990, CSCW '90.

[11]  Jerome R. Busemeyer,et al.  Resource allocation decision making in an uncertain environment , 1987 .

[12]  E Yechiam,et al.  On the potential value and limitations of emphasis change and other exploration-enhancing training methods. , 2001, Journal of experimental psychology. Applied.

[13]  I. Goldstein.  Training in Work Organizations , 1980 .

[14]  Dave Valliere.  Using CAD macros and languages for productivity on a Unigraphics system , 1986 .

[15]  Avi Parush,et al.  Easy first steps and their implication to the use of a mouse-based and a script-based strategy. , 2004, Journal of experimental psychology. Applied.

[16]  Janice E. J. Woodrow.  Macros for educational research , 1988 .

[17]  Reinhard Oppermann,et al.  Adaptive user support: ergonomic design of manually and automatically adaptable software , 1994 .

[18]  UlloaMiguel.  Teaching and learning computer programming , 1980 .

[19]  Owen L. Astrachan.  Concrete teaching: hooks and props as instructional technology , 1998, ITiCSE '98.

[20]  John M. Carroll,et al.  Blocking Learner Error States in a Training-Wheels System , 1984 .

[21]  William E. Cooper,et al.  Cognitive Aspects of Skilled Typewriting , 2011, Springer New York.

[22]  Walter Schneider,et al.  Training High-Performance Skills: Fallacies and Guidelines , 1985 .

[23]  Jeffrey E. Clark.  VBA for AutoCAD 2002: Writing AutoCAD Macros , 2001 .

[24]  Gavriel Salvendy,et al.  An approach to the design of a skill adaptive interface , 1995, Int. J. Hum. Comput. Interact..

[25]  Reinhard Oppermann,et al.  Adaptability: user-initiated individualization , 1994 .

[26]  Frederick M. Richardson.  Pseudo-programming (with macros) of accounting spreadsheets , 1990 .

[27]  Mary Beth Rosson,et al.  Effects of Experience on Learning, Using, and Evaluating a Text Editor , 1984 .

[28]  G. Pólya,et al.  How to Solve It. A New Aspect of Mathematical Method. , 1945 .

[29]  L. Dosier,et al.  Academy of Management Best Paper Proceedings , 1997 .

[31]  A. Baddeley.  Domains of recollection. , 1982 .

[32]  Janice E. J. Woodrow.  Macros for educational research: Part II , 1989 .

[33]  E. J. O'Brien,et al.  When comprehension difficulty improves memory for text. , 1985 .