MS World Assignment Instructions

Referencing your completed MS Excel assignment, prepare a brief report in the form of a letter, to

be sent to ALL members of the Board of Directors. In the introductory part of the letter:

i$.$ Briefly inform these stakeholders of the benefits of automation on the current business

processes within the organization, specifically referencing the benefits of using a

spreadsheet solution and how easy it was to process data to derive the information

presented in the report.

ii$.$ Give a brief analysis of the data found in the chart created $($in your MS Excel

assignment$)$ and include the chart in your report.

THE UNIVERSITY OF THE WEST INDIES OPEN CAMPUS Page $4$ of $4$

iii. The report should be no more than $1500$ words.

Note that all employee internal contact information is located in the $$Employee Department

Contacts$$ MS Excel worksheet. Prepare the aforementioned by following the additional

instructions below.

a$.$ Prepare a professionally constructed letter using your name, job title, department,

telephone number, and email address as provided in the instructions and a resized graphic

of computer as part of the letterhead as relevant salutations.

In addition, ensure requirements at points i$.$ to iii. above are included. $[30]$

b$.$ All formatting stays at the default except for the following: $[10]$

i$.$ Left and right margins : $0\mathrm{.}5$

ii$.$ Page numbers $$ bottom left e$.$g$.3$ of $5$ where $3$ is the page number and $5$ is

the total number of pages. Page numbers should NOT be shown on first page

iii. The description $$Savings Analysis for $2022/2023$ in the right header. Header

information should NOT be shown on first page

iv$.$ Your Group ID in the left header. Header information should NOT be shown

on first page

v$.$First line indent$$ on each paragraph

Include, from your MS Excel assignment, a copy of the statement of income. In one

sentence briefly describe the figure copied in this letter $[10][20]$

c$.$ Complete the report as your main document all using the Mail Merge feature in MS

Word. Include and ensure that all necessary fields based on the requirements mentioned

above are visible in your main document. Save the main document as

groupid$\_$open$\_$s$3\_24\_$wd$1.$ For example Group$1\_$open$\_$s$3\_24$wd$1.[20]$

d$.$ Generate the required letters $($to the persons mentioned above only$)$ and save the

generated file as groupid$\_$open$\_$s$3\_24\_$wd$2.$ For example Group$1\_$open$\_$s$3\_24$wd$1.$

$[20$