Office for Apprentices

As a followup to my last post I thought I would start off with where the students need to go with regard computing skills.

Basic Word Processing

Letter witting & General Correspondence mock resume

Quotes and orders via fax and email

BRICKSAW OPERATIONAL PROCEDURE

Emails

Students need to be exposed to basic business letters and other documents that come across the desk of an employer.

The WorkCover, Bank Statement type documents

General letters on letterhead, a.b.n., a.c.n., builder’s license numbers, full details and address.

Quotes for works and materials for purchase

Emails and email etiquette

Adding an image to a word document (company logo)

Spreadsheet Fundamentals

Setting up & entering basic data

Page set up, column, headings and lines, adding data directly into cells on the spreadsheet

Columns and Rows

What information do you need to record?

What headings do you need

How does it need to be viewed?

Sub Totals & Totals

AutoSum

At the bottom of the column or end of the row do you need a total?

Ready to total cells

What do you want to do with the total?

Add A column This adds Cells A1 down to A9 together =SUM(A1:A9)

The “∑”symbol is at the top righthand corner of the Excel spreadsheet and clicking on it will start the process of adding cells totals, then you need to highlight the cells you want totalled and click OK and it will do it for you.

Electronic Diaries & Basic Database use
It is basically just a Spreadsheet with information stored in cells which you can access when you need that information. E.g. Outlook Dairies, Access Databases etc
Your Outlook address book is a database, Google contacts is to
A diary is just a book if you don’t use it correctly

Make your appointments by entering the date, time, location, phone contact details, address and email details, also add details of the meeting/appointment, what you need to bring or do prior etc

Add a reminder at least an hour before to give you time to get there or get ready etc

In a separate diary entry add a reminder that the meeting is coming up tomorrow or later

Finally after the meeting add another entry/appointment with details of any follow-up that needs to be done and then enter any further appointment that you may have organised with reminder.

This method while it at first seems a lot of work will remind you of appointments and what if anything has to be taken or done at that meeting the address, location and time of the appointment and full details of who is prest and the nature of the appoint. (Quote, payment, site meeting etc)
This allows you to have your diary with you always and be able to look up any conflicting appointments when scheduling work or meetings

You can add appointments on the spot and it helps you keep organised and on time.