Produce simple word-processed documents
You are working for Freedom Travel Pty Ltd, and you have been asked to carry out the following tasks. The company has the following policy and procedures which must be adhered to for all documentation and correspondence as follows.
The company's policy is to
use white A4 paper only
set out letters in fully blocked, open punctuation style
use a sans serif font, size 11
use the spell check and grammar check function
carefully proofread before submitting work to author for signature
Activity 1
You have been asked to create a new letterhead template for the company. Include a suitable graphic and use the following contact details.
Address - 55 City Road, Annandale 2038
Phone - 9319 1234
Fax - 9319 1235
Email - freedom_travel@ozenet.com.au
Save a copy as Freedom Travel letterhead to a suitable location.
ANSWER :
Freedom Travel 55 City Road, Annandale NSW 2038 Telephone 9319 1234 Facsimile 9319 1235 freedom_travel@ozenet.com.au
Activity 2
The Tours and Travel manager, Jane Hobbs, has provided you with the following handwritten draft and has asked you to word process the letter, in response to a customer enquiry. Ensure that you adhere to the company policy and procedures for document creation.
Today
Mrs J Bluntman
29 Umber Street
Maroubra NSW 2035
Dear Mrs Bluntman
Thanks for your enquiry about travel to Egypt later this year. It's a wonderfull destination and offers a variety of experiences for the visitor.
I recommend a flight to Singapore (with the possibility of a stopover) and then onto Cairo . A four star hotel in Dokkia - a leafy suburb in Cairo that allows easy access to the Pyramids, is reasonably priced. Three or four days in Cairo would be sufficent to see the main attractions. Other must sees in Egypt include
Luxor and the Valley of the Kings
Aswan and the opportunity to sail the Nile on a a felucca
Red Sea snorkeling
Australian visitors require a visa, which Freedom Travel can arrange on your behalf and it is advisable to take $US cash and travelers cheques.
Freedom Travel will happily organise your international and local Egyptian travel and arrange accommodation. If you would like to join an organised tour, we can make recomendations and take a booking on your behalf.
We look forward to asisting you with your travel plans.
Jane Hobbs
ANSWER :
Freedom Travel 55 City Road, Annandale NSW 2038 Telephone 9319 1234 Facsimile 9319 1235 freedom_travel@ozenet.com.au
October 31, 2007
Mrs. J Bluntman 29 Umber Street MAROUBRA NSW 2035
Dear Mrs. Bluntman
Thank you for your enquiry about travel to Egypt later this year. It is a wonderful destination and offers a variety of experiences for the visitor.
I recommend a flight to Singapore (with the possibility of a stopover) and then onto Cairo. A four star hotel in Dokkia, a leafy suburb in Cairo that allows easy access to the Pyramids, is reasonably priced. Three or four days in Cairo would be sufficient to see the main attractions. Other must sees in Egypt include
· Luxor and the Valley of the Kings
· Aswan and the opportunity to sail the Nile on a felucca
· Red Sea snorkeling
Australian visitors require a visa, which Freedom Travel can arrange on your behalf and it is advisable to take $US cash and travelers cheques.
Freedom Travel will happily organize your international and local Egyptian travel and arrange accommodation. If you would like to join an organized tour, we can make recommendations and take a booking on your behalf.
We look forward to assisting you with your travel plans.
Yours sincerely
Jane Hobbs
Jane Hobbs Tours and Travel Manager
Activity 3
Freedom Travel is planning a New Zealand holiday advertising campaign. You have been asked you to create the following advertising flyer. Be sure to
use a selection of
font styles and sizes
different alignments
bullets and tables
centre the document vertically on the page
insert graphics appropriate to the topic where indicated.
Freedom Travel
New Zealand Holiday Specials
Queenstown flying Air New Zealand from $866
Insert a suitable graphic here
New Zealand's adventure capital is fuelled by adrenalin. Visitors flock to Queenstown to ski, bungee-jump, skydive, go jet boating and white-water rafting. But if you're happy just to sit and watch, you won't be disappointed.
Inclusions
-Airfares are return per person
-Airport taxes and levies specified are based on the most direct flight route
Departure
Destination
Departure Period
Fare From
Tax
Australia
-Sydney
New Zealand
-Queenstown
1st July 04 -
31st July 04
AUD 766
AUD 100
Australia
-Brisbane
-Melbourne
New Zealand
-Queenstown
1st July 04 -
31st July 04
AUD 836
AUD 100
Activity 4
A memorandum is to be sent to all employees, with a copy to the manager, Kim Leigh. The memo is to inform staff of training sessions relating to the New Zealand Holidays holiday specials.
There will be two training sessions held, one for Travel consultants at 10 am and the other for Administrative staff at 1 pm, both on 15 March 2004. Morning or afternoon tea will be provided, as appropriate to the session time.
Jane Hobbs has provided you with a copy of a draft memo, which needs editing. Retrieve the document Training memo .
Make the necessary corrections as indicated by the proofing marks shown below. You can download and print a copy of some common Proofreading symbols to help you. ANSWER :
FREEDOM TRAVEL
INTERNAL MEMORANDUM
To: «First_name_» «Last_name_»
CC: Kim Leigh, Manager
From: Jane Hobbs, Travel and Tours Manager
Date: 30 October 2007
Subject: New Zealand Holiday Training Sessions
To prepare for the expected increase in bookings to New Zealand due to the planned New Zealand Holiday Special promotion, training sessions have been arranged for all staff.
There will be two training sessions, one for travel consultant and the other for administrative staff. Please attend the appropriate sessions at «Time» on 20 November 2007.
Each sessions is expected to approximately two and a half hours long, and «Tea_» tea will be provided.
Convert the edited memo into a mail merge document, so that it can be distributed to the staff with relevant session details.
Jane Hobbs, Ervien Lee, Bob Jankowski, Andrea Epinidis, Julie Singh Travel consultants
Sebastian Tran, Ingrid Johns, Your name here Administrative Staff
ANSWER :
First_name
Last_name
Position
Tea
Time
Andrea
Epinidis
Consultant
Morning
10 am
Bob
Jankowski
Consultant
Morning
10 am
Ingrid
Johns
Administration
Afternoon
1 pm
Ervien
Lee
Consultant
Morning
10 am
Julie
Singh
Consultant
Morning
10 am
Sebastian
Tran
Administration
Afternoon
1 pm
Hendra
Dinata
Administration
Afternoon
1 pm
Merge the document ready for distribution.
How many merged documents will you have?
I have six document, because Jane will not receive a merged copy.
Should you save this document?
No, usually a merged document is printed but not saved in the merged format.
Who will the first memo be addressed to?
The first memo should be addressed to Andrea Epinidis, who would appear first if the data is correctly sorted.
The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.
Sunday, November 18, 2007
Tuesday, November 13, 2007
Create and use simple spreadsheets
Business Services
Home > Business Services > Business Services (120/240 hours) > Create and use simple spreadsheets > Create and use simple spreadsheets
Activities
As an administrative assistant for Freedom Travel Pty Ltd, one of your duties is to maintain financial data using spreadsheet software.
Activity 1
The manager, Kim Leigh, has asked you to create a spreadsheet to record monthly stationery expenses.
Part A – creating a spreadsheet
- Create a new spreadsheet and enter the data as shown below. Save the spreadsheet with the filename STATIONERY, to an appropriate location
| Stationery | Jan | Feb | Mar | Apr | May | Jun | Totals |
| Highlighters | 20 | 40 | 0 | 60 | 0 | 10 | |
| Whiteboard markers | 20 | 0 | 0 | 0 | 0 | 0 | |
| Notepads | 30 | 60 | 20 | 0 | 20 | 30 | |
| Pencils | 30 | 10 | 0 | 0 | 10 | 0 | |
| Pens | 60 | 20 | 40 | 10 | 0 | 20 | |
| A4 Envelopes | 300 | 20 | 150 | 0 | 200 | 50 | |
| Post-it Notes | 300 | 0 | 50 | 30 | 50 | 0 | |
| Miscellaneous | 500 | 300 | 800 | 1000 | 600 | 500 | |
| A4 Paper (reams) | 2500 | 800 | 1200 | 600 | 1000 | 300 | |
| Monthly Totals | | | | | | | |
| | | | | | | | |
| Average Monthly Total | | | | | | | |
| Highest Monthly Total | | | | | | | |
| Lowest Monthly Total | | | | | | | |
- Enter the formula required to calculate the total expenditure for the month of January. Copy this formula for the other months
- Enter the formula required to calculate the total expenditure for Highlighters. Copy this formula for all other stationery items
- Enter the formulae to obtain Average of Monthly Totals, Highest Monthly Total and Lowest Monthly Total. Format these results to no decimal places
- Sort the spreadsheet into alphabetical order by Stationery
- Format the data so that figures are displayed as currency
- rmat the spreadsheet so that it is displayed appropriately (bold, shading, borders, centred vertically and horizontally, landscape, fit to one page etc)
- Insert a footer which shows the Filename, Task 1, Your Name
9. Print two copies of the spreadsheet, one showing the formulae and one showing the results
| Stationery | Jan | Feb | Mar | Apr | May | Jun | Totals |
| A4 Envelopes | $300 | $20 | $150 | $0 | $200 | $50 | $720 |
| A4 Paper (reams) | $2,500 | $800 | $1,200 | $600 | $1,000 | $300 | $6,400 |
| Highlighters | $20 | $40 | $0 | $60 | $0 | $10 | $130 |
| Miscellaneous | $500 | $300 | $800 | $1,000 | $600 | $500 | $3,700 |
| Notepads | $30 | $60 | $20 | $0 | $20 | $30 | $160 |
| Pencils | $30 | $10 | $0 | $0 | $10 | $0 | $50 |
| Pens | $60 | $20 | $40 | $10 | $0 | $20 | $150 |
| Post-it Notes | $300 | $0 | $50 | $30 | $50 | $0 | $430 |
| Whiteboard markers | $20 | $0 | $0 | $0 | $0 | $0 | $20 |
| Monthly Totals | $3,760 | $1,250 | $2,260 | $1,700 | $1,880 | $910 | $11,760 |
| Average Monthly Total | $1,960 | | | | | | |
| Highest Monthly Total | $3,760 | | | | | | |
| Lowest Monthly Total | $910 | | | | | | |
| | | | | | | | |
| | | | | | | | |
| | | | | | | | |
| SPREADSHEET TASK 1 HARRY HA | | | | | | | |
| Stationery | Jan | Feb | Mar | Apr | May | Jun | Totals |
| A4 Envelopes | 300 | 20 | 150 | 0 | 200 | 50 | 720 |
| A4 Paper (reams) | 2500 | 800 | 1200 | 600 | 1000 | 300 | 6400 |
| Highlighters | 20 | 40 | 0 | 60 | 0 | 10 | 130 |
| Miscellaneous | 500 | 300 | 800 | 1000 | 600 | 500 | 3700 |
| Notepads | 30 | 60 | 20 | 0 | 20 | 30 | 160 |
| Pencils | 30 | 10 | 0 | 0 | 10 | 0 | 50 |
| Post-it Notes | 300 | 0 | 50 | 30 | 50 | 0 | 430 |
| Whiteboard markers | 20 | 0 | 0 | 0 | 0 | 0 | 20 |
| Monthly Totals | 3700 | 1230 | 2220 | 1690 | 1880 | 890 | 11610 |
| Average Monthly Total | 1935 | | | | | | |
| Highest Monthly Total | 3700 | | | | | | |
| Lowest Monthly Total | 890 | | | | | | |
Part B – editing a spreadsheet
- Kim has asked you to amend the spreadsheet as follows
- Insert two rows at the top of the spreadsheet then key in the heading,
Freedom Travel Pty Ltd on one line, Stationery Expenses below
- Some supplies have been omitted. Add two rows and enter the following data
| | Jan | Feb | Mar | Apr | May | Jun |
| A3 Coloured paper | 500 | 100 | 200 | 50 | 150 | 80 |
| A4 Lever arch files | 1400 | 700 | 1000 | 400 | 200 | 150 |
- The company no longer uses Whiteboard markers. Delete that row
- Sort the spreadsheet so that the Total column is in descending order
- Print two copies of the amended spreadsheet, one showing the formulae and one showing the results
| Freedom Travel Pty Ltd | | | | | | | | | | |
| Stationery Expenses | | | | | | | | | | |
| Stationery | Jan | Feb | Mar | Apr | May | Jun | Totals | | | |
| A4 ENVELOPES | $300 | $20 | $150 | $0 | $200 | $50 | $720 | | | |
| A3 COLOURED PAPER | $500 | $100 | $200 | $50 | $150 | $80 | $1,080 | | | |
| A4 LEVER ARCH FILES | $1,400 | $700 | $1,000 | $400 | $200 | $150 | $3,850 | | | |
| A4 Paper (reams) | $2,500 | $800 | $1,200 | $600 | $1,000 | $300 | $6,400 | | | |
| Highlighters | $20 | $40 | $0 | $60 | $0 | $10 | $130 | | | |
| Miscellaneous | $500 | $300 | $800 | $1,000 | $600 | $500 | $3,700 | | | |
| Notepads | $30 | $60 | $20 | $0 | $20 | $30 | $160 | | | |
| Pencils | $30 | $10 | $0 | $0 | $10 | $0 | $50 | | | |
| Pens | $60 | $20 | $40 | $10 | $0 | $20 | $150 | | | |
| Post-it Notes | $300 | $0 | $50 | $30 | $50 | $0 | $430 | | | |
| Monthly Totals | $5,640 | $2,050 | $3,460 | $2,150 | $2,230 | $1,140 | $16,670 | | | |
| Average Monthly Total | $2,778 | | | | | | | | | |
| Highest Monthly Total | $5,640 | | | | | | | | | |
| Lowest Monthly Total | $1,140 | | | | | | | | | |
| | | | | | | | | | | |
| | | | | | | | | | | |
| SPREADSHEET | TASK 2 | HARRY | HA | | | | | | | |
- Kim needs to present half yearly expenses to the board of directors and has requested a chart that compares stationery expenses for the six months. Create an exploded pie chart as an object on the worksheet
- Print a final copy showing the results
| Freedom Travel Pty Ltd | | | | | | | | | | ||
| Stationery Expenses | | | | | | | | | | ||
| Stationery | Jan | Feb | Mar | Apr | May | Jun | Totals | | | | |
| A4 ENVELOPES | $300 | $20 | $150 | $0 | $200 | $50 | $720 | | | | |
| A3 COLOURED PAPER | $500 | $100 | $200 | $50 | $150 | $80 | $1,080 | | | | |
| A4 LEVER ARCH FILES | $1,400 | $700 | $1,000 | $400 | $200 | $150 | $3,850 | | | | |
| A4 Paper (reams) | $2,500 | $800 | $1,200 | $600 | $1,000 | $300 | $6,400 | | | | |
| Highlighters | $20 | $40 | $0 | $60 | $0 | $10 | $130 | | | | |
| Miscellaneous | $500 | $300 | $800 | $1,000 | $600 | $500 | $3,700 | | | | |
| Notepads | $30 | $60 | $20 | $0 | $20 | $30 | $160 | | | | |
| Pencils | $30 | $10 | $0 | $0 | $10 | $0 | $50 | | | | |
| Pens | $60 | $20 | $40 | $10 | $0 | $20 | $150 | | | | |
| Post-it Notes | $300 | $0 | $50 | $30 | $50 | $0 | $430 | | | | |
| Monthly Totals | $5,640 | $2,050 | $3,460 | $2,150 | $2,230 | $1,140 | $16,670 | | | | |
| Average Monthly Total | $2,778 | | | | | | | | | | |
| Highest Monthly Total | $5,640 | | | | | | | | | | |
| Lowest Monthly Total | $1,140 | | | | | | | | | | |
| | | | | | | | | | | | |
|
| TASK 3 | HARRY | HA | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
Activity 2
Kim has asked you to create a spreadsheet that that will track superannuation contributions. There are two types of contribution payable
- Employer contribution, currently 9% of gross wages
- Employee voluntary contribution, which varies for each employee according to wages, commission and percentage of wages contributed
1. Design a spreadsheet for the month of November 2003, based on the following data. You will need to calculate
a. Total monthly wages, which includes commission for travel consultants
b. Employer superannuation contribution (be sure to use an absolute reference)
c. Voluntary superannuation contribution
d. Total superannuation contributed
| First_name | Last_name | Weekly Wages | Weekly Commission | Voluntary Payment |
| Andrea | Epinidis | $450.00 | $ 81.25 | 5% |
| Jane | | $600.00 | $137.50 | 10% |
| Bob | Jankowski | $450.00 | $62.50 | 0% |
| Ingrid | Johns | $450.00 | $25.00 | 5% |
| Ervien | Lee | $450.00 | $80.00 | 7.5% |
| Julie | Singh | $450.00 | - | 5% |
| Sebastian | Tran | $450.00 | - | 9% |
| Your name | Your name | $400.00 | - | 3% |
2. Save the document as Superannuation to an appropriate location
3. Add a total row to calculate the totals for appropriate columns
4. Kim has asked you to calculate the highest, lowest and average employer superannuation contributions. Calculate these figures in a summary area below the total row
5. To compare the Employer and Employee contributions, create a suitable chart on a separate sheet
6. You have been asked to print a copy of the spreadsheet for a staff meeting. Ensure that the spreadsheet is displayed appropriately, including a title, landscape orientation, “fit to one page”, centred vertically and horizontally, header/footer etc
7. Print two copies, one showing the results and the other showing the formulae, including row and column headings for the formula copy only
The NSW HSC Online© site is bound by the responsibilities outlined in the disclaimer.
Subscribe to:
Posts (Atom)