Effective use of computers & software tools

 

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).

Overview

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.

What can you use a computer for?

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.

Survey software applications

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.]

Broad field

Demonstration movies

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.

Determining your training needs

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."

Develop a personalized training program

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