Information and communication technology Skills

Information and communication technology Skills –
Final Assessment – Individual Assignment

The assignment consists of two parts: PART A (an essay written in Microsoft Word and PART B (a Microsoft Excel file containing charts and data related to your essay).

Software to be used for this assignment:
– Part A must be completed using Microsoft 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: the assignment must be submitted no later than 1pm on MONDAY THE 27TH of March 2017.
Submission format: Both files (part A and B – MS Word and MS Excel) should be zipped up and submit via Turnitin AND a printed copy must be handed in to the CRIC office on or before the submission date. 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.

i) Write minimum of 1000 words – maximum 1500 words (excluding references) on the following topic
– Give the example of a specific organisation (e.g. a bank, school, government department) and describe a problem they have attempted to solve using ICT. The problem could be related to growth, security, scaling or anything else). 10 Marks
– Explain how ICT has helped the company to overcome the problem. 10 Marks
– Use 3 or more citations in your work using the citations tool in MS Word and the Harvard Anglia standard. 10 Marks

ii) Provide a table of data showing statistical or numerical data relevant to your discussion (e.g. growth, sales, users). 10 Marks

iii) Include at least 2 images and add captions (labels) to them using the Insert Caption function. 4 Marks (1 mark per image and 1 mark per caption)

iv) Automatically generate a table of figures. 6 Marks

v) Use heading styles where appropriate and automatically generate a table of contents 8 marks

vi) The style of the document should include the following:
• A header on every page of the document 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)

vii) 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 axis 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 axis, 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 for providing the chart, 4.5 marks each for the title, and a legend)