Assignment Instructions: Information in Organizations

Learning outcomes to be assessed
By the end of this module you will be able to:
LO1 Explain the value of the role of information within an organisation and identify how it be shared and used effectively
LO2 Appraise the handling of information in a business context, and identify key factors in matching information systems to user requirements.
LO3 Formulate ideas which could contribute towards generating a policy regarding IT issues and recognise the need for on-going evaluation.
LO4 Communicate effectively in a business environment, selecting appropriate software for specific tasks and completing tasks to an acceptable business standard.
LO5 Improve office automation applications skills, using Microsoft Office.

Part 1 – Individual 250-word Report using MS Word (50%)
You will be given a case study. The case study will be posted on BlackBoard. For this part of the assignment, you need to demonstrate the proficiency of using MS Word to produce a strictly no-more than 250-word 4-paragraph 1-page professional report.

Based on the given/chosen case study, perform basic research to meet the following criteria below, linking it
specifically to the chosen organisation of the case study. The main purpose of this Part 1 assignment is to demonstrate students’ capability in using various features of MS Words

Assessment Criteria:

• Introduction
Explain the value of the role of information specifically for the chosen organisation and identify how it can be shared and used effectively [first paragraph – suggested word counts: 60]

• Body
Appraise the handling of information in the chosen business context, and [second paragraph – suggested word counts: 60]
identify key factors in matching information systems to user requirements [third paragraph – suggested word counts: 60]

• Conclusions
Formulate ideas which could contribute towards generating a policy regarding IT issues and recognise the need for on-going evaluation. [fourth paragraph – suggested word counts: 60]

Part 2 – Individual 10-page Presentation using MS Power Point (20%)
For this part of the assignment, you need to (1) demonstrate the proficiency of using MS Excel by converting the source data into relevant information and (2) then convert such information in the presentation format using MS Power Point. You may not necessary required to do a stand-up presentation.
Using the case studies given, which contain data, you must work on all of three of the case studies by answering
all the questions using MS Excel to manipulate the data.

Using MS Excel, you need to demonstrate the following:
? data manipulation using various Excel functions (for examples, but not limited to Sum, Average, Count, Max, Min and conditional If statements)
? display of information in various chart formats Once you have completed all case studies, pick one of your best out of the three, create screen shots of all your output of the Excel tasks of ONLY one case study as per your choice. Copy and paste all output into the MS PowerPoint so that your slides contain all the output produced with MS Excel. 

Part 3 – 30-minutes On-line Individual Demonstration/Viva using MS Excel (30%)

Final step (3) is to demonstrate the proficiency in using MS Excel by doing demonstration/viva during
presentation. With your completed MS Excel activities on the given case studies for the Part 2 MS Power Point task, you will be given randomly by the online system for a similar case study for you to perform your Excel manipulation within 30 minutes.

You now have to demonstrate your proficiency skills in MS Excel by implementing the what you have done for the Power Point using MS Excel during the demonstration on-line, remotely, as evidence.
Again, using MS Excel, you need to demonstrate the following:
? data manipulation using various Excel functions (for examples, but not limited to Sum, Average, Count, Max, Min and conditional If statements)
? display of information in various chart formats
Once you have completed all Excel tasks, submit online within the time limit. There is no need for you to copy the outcome onto MS Power Point. This is only for MS Excel submission.