![[Compututor Logo]](pict0.gif)
Computer assistance for businesses and home users in the St. Louis area
Professional teacher--over 35 years classroom experience
Adjunct Professor, Computer Applications, Webster University
Instructor, St. Louis Graphic Arts Institute
My specialty is people. I speak English, not
"computerese."
E-mail:
[email protected]
Phone: (314) 821-0924
-What's on this page (click each heading for details):
-What I do (click
here for more detailed explanation of the categories below)
Articles I have written, published in St. Louis Computing newspaper, covering computer training, problem solving, writing macros.
Notes on classes for my students -- log of what was done in class each day
My name is Roy W. Johnson. I am a former high school teacher with 31 years of classroom experience, teaching all levels, beginning to advanced. I did not teach computer courses--I taught World Cultures and led summer study trips to Europe and Asia. In 1983, I began to develop my computer expertise. When our school set up a computer lab in 1984, the administration asked me to help develop classes to train my colleagues. Then I began teaching evenings and weekends in the St. Louis Community College system. I became familiar with Apple, IBM, and Commodore Amiga technology and programs.
In 1991 I decided to "retire" from high school teaching and become a full time computer consultant/trainer. I applied and was accepted as an Adjunct Professor in the Math/Computer Department at Webster University, where I currently teach Introduction to Microcomputers, Electronic Spreadsheets, and Database Software. I am also on the staff at the St. Louis Graphic Arts Institute, the training center for the local printing industry, where I teach desktop publishing. In addition, I have taught in the University of Missouri-St. Louis and the Maryville University continuing education computer programs. My part time teaching schedule allows me to operate my home business in private consulting and training.
I have a varied background, which includes entertaining, public speaking, radio and TV, and a year of training as a Hungarian linguist for the Army Security Agency, followed by 18 months Bavaria (Germany) as a radio intercept operator/translator. These experiences broaden my background and help me relate to a variety of people.
Click here to go back to "What's On This Page"
-My Philosophy
Have you noticed anything unusual about this
page?
It doesn't try to dazzle you with dramatic but slow-loading and sometimes confusing graphics.
It is simple, straightforward, and organized.
It is user-friendly- you can move around easily and find what you want.
It's easy to read--
I believe clear, effective communication, not razzle-dazzle, is the essence of the value of the internet--and the essence of good computer training and consulting. I believe in presenting ideas in the language of the student or client. My purpose is to find your needs and fill them.
Teaching, training, consulting: My teaching
background gives me good communicating skills. I can help an individual
learn about a computer or set up a training session for a business staff.
Although I can teach more advanced programs, I am especially good at
"basic training" for computer novices. Click here
to go directly to a list of the programs I am familiar with. I have written
articles for St. Louis Computing on different aspects of computer
training. Click here to go directly to those
articles.
Preparation of professional learning materials: At
my high school, the teachers were extensively involved in creating learning
materials. These materials had to be clear and simple to be understood
by all students. The skills I developed aided me in writing manuals
for beginning, intermediate, and advanced Lotus 1-2-3 in the Maryville University
Continuing Education Program. I can create customized learning materials
for specific needs of an individual or staff.
Designing spreadsheets or databases: I am familiar
with Lotus, Excel, Quattro Pro, Access. I can set up a spreadsheet or database
for you in these programs.
Page layout: I have experience creating pamphlets
and newsletters in Pagemaker, Quark Xpress, Microsoft Word,
WordPerfect
Automating repetitive tasks with macros. To
some people, macros sound mysterious and difficult. To others, they
are a way of saving time by recording a few keystrokes. Few people
realize that the programming of macros can be as complex as any other
programming--or that macros can be programmed to perform some amazingly complex
tasks, saving many hours of precious time. I wrote a series of articles
for St. Louis Computing newspaper on macros. Click
here to go directly to those articles to see examples of what macros
can do.
I am experienced with the following - IBM or Macintosh:
Introduction to Computers - what's inside and how they work
DOS and IBM system -- Macintosh system
Windows 3.1, Windows 9x, most Windows programs
Microsoft Office (Word, Excel, Access, Powerpoint)
WordPerfect - Microsoft Works
Lotus 1-2-3 -- Quattro Pro -- Framework -- Quicken
Pagemaker -- Quark Xpress -- Aldus Freehand
Internet -- Netscape Navigator -- Internet
Explorer
America Online -- FrontPage Express -- Outlook Express --Home Page
design
Problem solving: Spreadsheets and "low nickel rounding" --how to get a spreadsheet to round down to the next lowest nickel, and, more importantly, how to think in a way that will help you solve problems like this.
How macros can make your work easier and speed you up -- how to create macros for yourself, and when you need a professional.
I operate two interactive genealogy web pages, which you can view to see samples of my work. You can use the BACK feature of your browser to come back here.
Pace
Network - the Internet Center for Pace Surname Research:
Professional genealogist Bruce Howard, a Pace family researcher, says
this is the most effective and user-friendly genealogy page he has seen.
It is interactive like a newsgroup in that submitters send queries
and I post them. It is international in scope, with queries from England,
Canada, Australia, Korea (a U.S. soldier), and all over the U.S. The
page averages over 30 hits a day - a large number for a one-surname genealogy
page.
SchnakeNet
- for Schnake surname research, my wife's family. Much smaller,
but contains some interesting old German marriage contracts and history.
Worth checking if you have German ancestry.