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 AverageTom 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 JamesCredit 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 AmountMr King Jones 23 James Ruse Rd Sydney NSW 2000 $3000Miss Daisy Smith 78 smart street Smithfield NSW 2164 $2500Miss Georgina Dunn 23 Main Street Armidale NSW 2350 $1500Mr Peter Trigg 90 High Street Mackay QLD 4157 $ 2000Mr Rob Jung 2 Minton Street Wagga Wagga NSW 2650 $ 3500Mr 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 letter:Dear Jeff,
Congratulations on a fine effort of sales and for exceeding your target for the 1st January 2005.Please find enclosed a cheque for $ 200.50 being commission for this month
Yours sincerely,THE BOSS

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.

 

You must submit: • 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.docx2. Assessment 1_Task 2.dotx3. A folder : Assessment 1_Task 3 4. Assessment 1_Task 4.docx.
• Print the documents portrait orientation double sided.