|
The aim of this set of notes is to
provide some 'in-depth' guidance for those
wanting to upgrade their skills by learning about computers and the
tasks that can be carried out with them. The notes may be of value
of those who for whatever reason, need training in order to
re-enter the workforce.
Our aim is to teach the efficient use of
computers, with a particular focus on the use of computers in the
modern business environment.
If your
are contemplating using our services, we would like you to help us
by using these notes to
determine what software training you need prior to visiting our
training room.
(Design Cad Pty Ltd, University of Adelaide
Commerce and Research Precinct, 24 Stirling Street, Thebarton,
South Australia).
If you want to succeed in almost any
job or profession
in the 21st century, you will require some degree of computer
proficiency. Facility with computers will increasingly be required in the workplace
- it won't be an optional skill.
Among many other things, you might use your computer
to:
-
produce professional
looking letters,
free from embarrassing spelling errors;
-
automatically generate form letters from a list of
clients;
-
fax a purchase order to a company who sells a
particular product;
-
write reports. Those
reports might need to be quite detailed and contain tables of contents and a cross checked index;
-
manage lists in a spreadsheet - for example,
keeping records of stock held in a warehouse;
-
calculating selling prices of goods with
sufficient margins such that your company makes a profit;
-
keep accurate financial
records by using a spreadsheet with (say) financial applications.
Examples might be calculating the effect of increasing
mortgage repayments, tracking expenditure on a particular project, etc.;
-
produce a brochure or a
catalogue for your company;
-
correspond with
clients locally and overseas by
electronic mail (email);
-
prepare and delivering a presentation to a group of people
(e.g. a sales pitch),
-
build a web site so that your company can sell
its products on the Internet;
-
use special purpose accounting software (MYOB,
QuickBooks, Attache etc.);
-
use industry specific software (quotes for
crash repair industry, manage patients in a doctor's office);
-
book travel plans,
saving money in the process;
-
carry out banking at any time of the
day and reducing the fees that your bank charges the company etc.
Each of these tasks
requires you to use a different software tool. It is our job to teach
you how to use each tool. Think of a computer simply as a toolbox.
We hope that with our
help, you can see that computers can offer new, worthwhile and perhaps
even exciting experiences.
Let's survey some
computer applications.
The table below contains links to a wide range of
material. The list is in in rough order of the tools in most common usage; word processing
is placed first and some of the more esoteric topics towards
the end. In each category, we have provided links to some small movies
which explain how the software tool works. These can be played on your
computer by clicking on the link.
|
If a warning box similar to the one below appears
after you click on the link, click the ''Open" option and the movie
should start playing. |
|
 |
|
You do not have
to do anything while the movie plays; just watch the screen. There is no
need to move or operate your mouse while the movie plays. You can pause
and re-start the movie by pressing the space bar.
To close a movie
before it finishes, press the Esc key. After the movie plays, you will
automatically be returned to this point in the notes. |
The purpose of the list
below and the movies embedded in the page, is to show you that you have on your desk, a very powerful
tool - a modern computer with a considerable collection of very powerful
software, but there is every chance that you are unaware of its power.
[While very effort is
made to ensure that these files are free from viruses, please use your
own tools to check the files before running them. Some of the files are
quite large and will take time to download; only do this if you have
broadband access. Design Cad does take responsibility for the effects of
running the files.]
|
Word
processing |
What is a
word processor?
An
overview of word processing including some comments on
the use of word processing in a scientific setting. Using
styles. Setting up an automatic
table
of contents in a complex document. Building a
'container' or master document which calls sub-documents for
automatic updating. Using a document with embedded Excel
spreadsheets; linking and embedding. Developing an easily
updated Curriculum Vitae. Examining a document which uses
extensive footnoting. Automatically generating an index from
a Word file. Word files and the Internet. Using the
reviewing tool. Using Word to develop a project charter.
Using Adobe Acrobat to produce PDF files of varying levels
of size and complexity. Other word processors - Adobe
FrameMaker for books. Placing graphics in word processing
files. |
|
Spreadsheets |
What is a
spreadsheet?
Splitting a the Excel screen to enable convenient
editing. Using Excel to
add up some numbers. Setting up a
print zone in a
spreadsheet. Relative vs. absolute cell references.
Utilizing functions in a spreadsheet. Using the database
function - filtering. Using pivot tables. Creating graphs.
Scientific graphs. Decision making with spreadsheets -
internal rate of return, decision trees, real time data
capture. Importing and exporting data. From accounting
programs to Excel. Extracting data from CAD drawings. Using the statistical analysis package in Excel. |
|
Project
management |
What is
project management? Using Microsoft Project as a project
management tool. Working out a project plan. s Project just
a project scheduler? Adjusting
properties of
a Microsoft Project project. Inserting a
hyperlink into a
project. |
|
Email |
What is
an email client? Microsoft Outlook, Outlook Express,
Eudora Pro, using mail via the Internet- WebMail.
Sending an email with attachments.
Running virus checks. |
|
Databases |
What is a
database? A
contact
management database in Microsoft Access. Understanding
relationships in Access. The importance of planning your
database. Using Excel spreadsheets as database containers.
Databases in
FileMaker Pro. Sorting records in FileMaker. |
|
PowerPoint |
What is a
presentation tool? An
overview of
PowerPoint. |
|
Image editing |
What is
an image editor? Create a
new image
file.
Feathering an image in Adobe Photoshop. using the
magic wand tool
in Photoshop. Photoshop's
polygonal lasso
tool. Understanding colour spaces, creating images for the
web - Adobe ImageReady software. |
|
Web
sites |
What is a
web site? Using Microsoft
FrontPage. Data driven web sites. Using inForm to
collect trial data. creating web sites for special purposes
-
clinical update,
software support. |
|
Computer Aided Design |
What is CAD?
Placing a
symbol
(block). Place
circles
touching. Using the
SPLINE command.
Join
lines. Placing text. Applying dimensions. Working to a
company wide drafting standard. AS1100 specification.
Working in
3D.
Garden
design.
Rendering in 3D. |
|
Vector drawing |
What is
vector graphics? Vectors vs. bit mapped graphics. Adobe
Illustrator.
Placing an
orthogonal line in Illustrator. |
|
Desk Top Publishing |
What is
DTP? Creating a
poster. Adobe InDesign. Adobe PageMaker. Making
text flow to a new
column. Creating a
newsletter. Test
printing. Place
text and
graphics in Microsoft Publisher. |
From the above, you can
see that there is a huge range of uses for a computer. Your first step in determining a
suitable training program for
your needs should be to make sure that you understand what it is
that you want to achieve i.e. you need to define your aims at the
outset.
It is worth writing this
down. You might write something like this:
"I have been out
of the workforce for some time. When working previously, I worked as
a storeman in different organizations, most in the handling of fresh
fruit and vegetables. These positions all involved the use of manual
(paper) systems for record keeping - computerization had not yet
entered this industry.
I would like to
return to the industry. My contact with friends who have stayed in
the industry, tell me that they have to use email to contact
suppliers, fax orders from a computer to clients, enter daily
prices for fresh fruit into a spreadsheet and use a special
stock control computer program written for the industry. We
will call this application FreshVeg."
Based on the
requirements set out above, you would choose the following courses
in the order set out below:
An
Introduction to Business Computing (this gives an overview of
computing);
An
Introduction
to Excel (gain confidence with spreadsheet software);
An
Introduction to Outlook (learn to handle email & the internet);
Desktop Publishing.
Find someone to
teach the use of the special stock control program FreshVeg.
(Only after you have taken the other courses).
You now have confidence
to start applying for jobs. You may of course have to update other
skills - is your forklift driving licence current?
Can you see that it is
worth aligning your training program with the type of job that you
require?
Click
here for answers to questions
students often ask.
|
Contact: info@designcad.com.au
T/F +61 8 8354
2400
M 0418 414 932 Design
Cad Pty Ltd (ABN 38 007 890 146)
©1997- 2006. http://www.designcad.com.au
|
 |
|