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. iii. The report should be no more than 1000 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 : 1” 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 2020/2021” in the left header. Header information should NOT be shown on first page iv. Your student id in the right 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] d. 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 studentid_open_s2_22_wd1. For example 411012456_open_s2_22wd1. [20] e. Generate the required letters (to the persons mentioned above only) and save the generated file as studentid_open_s2_22_wd2. For example 411012456_open_s2_22wd1.
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.
iii. The report should be no more than 1000 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 : 1”
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 2020/2021” in the left header. Header
information should NOT be shown on first page
iv. Your student id in the right 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] d. 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
studentid_open_s2_22_wd1. For example 411012456_open_s2_22wd1. [20]
e. Generate the required letters (to the persons mentioned above only) and save the
generated file as studentid_open_s2_22_wd2. For example 411012456_open_s2_22wd1.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
