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
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)
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
At the bottom of the column or end of the row do you need a total?
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
- What is a database
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
- Using a database for customer records
Your Outlook address book is a database, Google contacts is to
- Diaries, appointments and reminders
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)
- Sync it with your Smart Phone
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.