Individual Assignment MAC107 2018 Essays - Software, Free Essays

Individual Assignment MAC107 2018 Essays - Software, Free Essays Alex Mann Principles of ICT - MAC107 TERM - 2018 0 1 Final Assessment - I ndividual A ssignment The assignment consists of two parts: P ART A (an essay written in Microsoft Word and PART B (a Micr os o ft Excel file containing charts and data related to your essay ) . Software to be used for this assignment: Part A must be completed using M icrosoft Word and saved as a .doc or . docx file Part B must be completed using Microsoft Excel and saved as a . xls or . xlsx file. Submission time/date : no later than 1pm on Thursday 12 TH of April 2018 . Submission format: B oth files (part A ( MS Word ) and and B ( MS Excel ) should be zipped up and submit via Turnitin . Work submitted late will receive a mark of 0%. Part A - MS Word (worth 70 %) A minimum of 1000 words - maximum 1500 words (excluding references) are required for this discussion. Write minimum of 1000 words - maximum 1500 words (excluding references) on the following topic: explain how a specific company or organisation has used ICT to improve their business . Include a t able of contents, introduction, relevant sections/subsections and conclusion etc Describing a specific company or organisation . 10 marks Clearly explain how ICT is being used to improve their business . 10 marks Use 3 or more citations in your work using the citations tool found in MS Word 10 Marks Provide a table of data showing statistical or numerical data relevant to your discussion (e.g. growth, sales, users) . 10 Marks Include at least 2 images and add captions (labels) to them using the Insert Caption function . 4 M arks (1 mark per image and 1 mark per caption) Automatically generate a table of figures using the table of contents tool in MS Word . 6 Marks Use heading styles where appropriate and automatically generate a table of contents 8 marks The style of the document should include the following: A header on every page of the d ocument stating your name ( centred ) A footer on every page of the document stating the page number ( centred ) Border line separating the contents of the page from a header and a footer Heading (sub-Heading) and body Page setup - left 2.0cm, right 2.0, top 2.0, bottom 1.9 Font - heading Verdana 14, body Courier New 11 Line spacing 1.5 7 Marks (1 mark for each step above) Generate a bibliography using the tool built into MS Word. 5 Marks Part B - MS Excel (30 %) Using the data you provided in part A section ii, produce the following charts include a title, label for both horizontal and vertical axis (where possible), and a legend for all charts . Show the following in the charts: a) Column chart - title, label the axi s and legend - 10 marks (1 mark for providing the chart, 3 marks each for the title, labelling the axis and a legend) b) Line chart - title, label the axi s, values and legend - 10 marks (1 mark for providing the chart, 3 marks each for the title, labelling the axis and a legend) c) Pie chart - title, values, and legend - 10 marks (1 mark f or providing the chart, 4.5 marks each f or the title, and a legend)