Respect for Nature

post has two assignments

Business Environment

Task 1 (5 Marks)
Insert the following table into a new word document, Calculate the average marks for each student using function feature of MS Word.

Name Science Maths English Average
Tom Hopkins 50 30 50
Fred Mandel 30 12 59
Theo Savalas 30 17 39
Colin Jeffries 40 9 59
Mike Anderson 70 23 84

Task 2 (5 Marks)
Create a Fax Form Template, in which user must be able to customise the letter as per letter requirement. A sample is given below:

20 Fox St, Sydney
Phone: 33333333 Fax: 4444444

To: (“Who is this fax from?”)
Company: (“Company Name?”)
Fax No: (“Fax Number?”)

From: (“Who is this fax from?”)
Date: (Automatic Date) (Note: Contains today’s date and current time)
Subject: (“Subject of fax”)
No of Pages: (“No of pages”)
Message: (“Sender’s Message”) Note: The words in italics refer to the input fields.

Task 3 (12 Marks)
Type the following letter

To,
<<FIRSTNAME>><<LASTNAME>>
<<ADDRESS>>
<<SUBURB>> <<POSTCODE>>

Dear <<FIRSTNAME>>,

Thank you for your letter dated 5th of May concerning payment of your account.
You will appreciate that, under the terms of the contract, arrears in excess of 30 days are due and payable forthwith.
Accordingly, while we appreciate your current disposition, we must ask that you remit the full amount of arrears $<<AMOUNT>> within seven days or legal proceedings will be instigated.
You have purchased the following items: –
? Photocopier
? Scanner
? Keyboard
? Mouse
? Mouse pad

Yours sincerely,
Allen James
Credit Manager

Your tasks are as follows:

1. Create a table as given below in your spreadsheet software, Name the worksheet as “List.xlsx”

Title First Name Last Name Address Suburb State Postcode Amount
Mr King Jones 23 James Ruse Rd Sydney NSW 2000 $3000
Miss Daisy Smith 78 smart street Smithfield NSW 2164 $2500
Miss Georgina Dunn 23 Main Street Armidale NSW 2350 $1500
Mr Peter Trigg 90 High Street Mackay QLD 4157 $ 2000
Mr Rob Jung 2 Minton Street Wagga Wagga NSW 2650 $ 3500
Mr Kerry Sergeant 4 River Street Geelong VIC 3175 $ 1200

2. Mail merge the letter with the table from worksheet ” List.xlsx”
3. Submit the Letter_template.docx, Merge_Letter.docx, and List.xlsx along with the screenshots for all the steps in a folder:” Assessment 1_Task 3”.

Task 4 (6 Marks)
Record the following macro called letter using the following

When you finish create a new button and assign it to the macro that you have created name it createLetter, choose default style and select the following button. Add this button to the Quick Access Toolbar.

• Take screen shots of the process you followed to create the above macro button and how you added it to the QuickAccess toolbar.

• Save the letter as Assessment 1_Task 4.docx.

• Discuss and request feedback from other student or your trainer about your solutions. (2 Mark)

• Save Task 1 and task 2 solution in a new document:
Assessment 1_Task 1_Task 2.docx

• Submit the following files:
1. Assessment 1_Task 1.docx
2. Assessment 1_Task 2.dotx
3. A folder : Assessment 1_Task 3
4. Assessment 1_Task 4.docx.

• Print the documents portrait orientation double sided.

2:Paul Taylor, Respect for Nature

Read the Primary reading: Paul Taylor, Respect for Nature, Chapter 3: The Biocentric Outlook on Nature (69page).
Write about 200 words of philosophical reflection on the reading, from one or more aspect – reason, emotion, or physical activity.

business environment