Explain your findings in detail next to each bar/graph in a format of a report. Formulate to find the total for each item to fill in column “Total”.

Task requirements:

The assignment should be submitted as a single Word document, 2000 words in total, including all the 3 parts and the cover page. Make sure to proofread your work before submission to avoid any spelling or grammar mistakes. Make sure appropriate referencing is done while accessing online resources, including eBooks, images, and credible sources of secondary data for all the parts

Part 1

You should write 700-800 words describing the use and impact of information system and Cloud Computing for the company of your choice, which can be selected from the given list. Ensure the task’s requirements are met and explained well, considering the logical order and interconnections. Format your text following the guidelines below. This part can be written in text format. However, you can include your findings in the format of charts, graphs, etc. (Mark 30%)

Part 2  

You should create an informative poster, equivalent to 500-600 words, about IT security for the audience at GBS, including possible future students, current students, teachers, and management staff. You can use MS Word to create the poster. The poster needs to be added underneath Part 1 on the same file.

When designing the poster, consider what information you can best express visually and what needs a text explanation. Figures, tables, and photographs are all appropriate for a poster. Text may be included in short paragraphs or in bulleted lists, where appropriate. Use headings to create structure and support your ability to draw your audience to specific points on your poster.

Guidelines for creating your poster:

  1. Aim for a maximum of 500-600 words of text (including titles for figures etc.)
  2. Write short, bulleted phrases, rather than groups of paragraphs.
  3. Use Arial font style and appropriate font sizes:
    • Main title – 72 point
    • Subtitles – 60 point
    • Supporting materials – 32 point
    • Minimum – 18 point
  1. Clearly label all visuals
  2. Use colour sparingly to unify your poster.

You must demonstrate evidence of wider research and reading of core textbooks and academic scholarly work through referencing. Your assignment should be submitted as a poster following by references on a the same word document. (Mark 30%)

Part 3

You should write 500-600 words report describing your findings of the given sample data in written text and visual demonstration, including relevant graphs and charts that can be copy and paste from your Excel file. Make sure the requirements of the task are explained well, considering the logical order and interconnections. You can access the Week 4 teaching material uploaded on Moodle to have a better understanding of the report format. Follow the given guidelines below to format your report. (Mark 40%)

Part 1- Case Study (Cloud Computing)  

Many well-known fast-growing businesses have a significant investment in improving their ability to be more successful by using information technology linked to cloud computing. Choose a company from the list below and discuss how it works collaboratively using IT. Note any changes, achievements, challenges, and outcomes.

  • McDonald’s
  • Tesco
  • Google
  • Microsoft
  • British Airways
  • Global Banking School (GBS)

Remember:

It is required to include the followings:

  • A brief introduction to the organisation.
  • Explanation of technology and cloud computing used within the organisation.
  • Impacts of the use of cloud computing:
    • Within the organisation;
    • Between the organisation and other stakeholders, including customers and other businesses; and
    • Impacts on the environment (such as pollution, wider use of resources etc.).

Part 2 – Word Processing

Design an informative poster on MS Word or PowerPoint. Your poster should fit on a single-side of an A4-size paper. You can include information about GDPR (General Data Protection Regulation) or risks for users and the best set of practices to protect their data and privacy.

Remember:

It is required to include the followings:

  • Make your titles stand out.
  • Use different font sizes for the titles and text.
  • Change your page colour.
  • Insert some relevant pictures.
  • You can underline, bold, or highlight the words if necessary.
  • Ensure all references are listed underneath the poster on the same MS Word file.

Part 3 – Data presentation

A set of sample data is given below. Use Excel to record data and use relevant charts and graphs to Analyse and compare your data in various aspects. Explain your findings in detail.

Order Date Region Item Units Unit Cost Total
9/1/14 Central Desk 2 125.00  
6/17/15 Central Desk 5 125.00  
9/10/15 Central Pencil 7 1.29  
11/17/15 Central Binder 11 4.99  
10/31/15 Central Pencil 14 1.29  
2/26/14 Central Pen 27 19.99  
2/9/14 Central Pencil 36 4.99  
8/7/15 Central Pen Set 42 23.95  
1/15/15 Central Binder 46 8.99  
1/23/14 Central Binder 50 19.99  
3/24/15 Central Pen Set 50 4.99  
5/14/15 Central Pencil 53 1.29  
12/12/14 Central Pencil 67 1.29  
5/31/15 Central Binder 80 8.99  
2/1/15 Central Binder 87 15.00  
5/5/14 Central Pencil 90 4.99  
6/25/14 Central Pencil 90 4.99  
12/4/15 Central Binder 94 19.99  
11/25/14 Central Pen Set 96 4.99  
2/18/15 East Binder 4 4.99  
11/8/14 East Pen 15 19.99  
9/18/14 East Pen Set 16 15.99  
7/12/14 East Binder 29 1.99  
12/29/14 East Pen Set 74 15.99  
7/29/14 East Binder 81 19.99  
4/27/15 East Pen 96 4.99  
8/24/15 West Desk 3 275.00  
3/7/15 West Binder 7 19.99  
5/22/14 West Pencil 32 1.99  
3/15/14 West Pencil 56 2.99  
10/14/15 West Binder 57 19.99  
9/27/15 West Pen 76 1.99  

Remember:

  • Save your data in an Excel sheet.
  • Formulate to find the total for each item to fill in column “Total”.
  • Use Auto Sum to find the Grand Total Sales of all regions together.
  • Use a bar chart to compare the sales in different regions.
  • Use a pie chart to find the percentage of each item’s value in total sales. (Find the total value of each item first.)
  • Use the appropriate graph to compare the number of units of items sold in each region.
  • Explain your findings in detail next to each bar/graph in a format of a report.
  • Include a screenshot of your Excel sheet that clearly shows the formula you create to find the total at the end of your report separately. (You can click on one of the cells underneath the “Total” and this will help the formula to appear on formula bar and then take the screenshot.
  • This report for part 3, needs to be on the same MS file following part 1 and 2.