Explain the value of the information for any one of the mentioned organisations

Assessment Brief

Part 1 – Individual 250-word Report using MS Word (50%)

You will be given a case study. The case study will be posted on ULEARN

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

Note that   the four paragraphs of 60 words each contribute to 240 words, which is within the 250 word counts limit. The remaining 10 words are for your ID, Name, headings etc…

When answering this Part 1, you are mainly to focus on the following four points:

• Value of Information
• Handling of Information
• Matching Information System to User Requirements
• Ideas for an IT Policy

Read the given information on the webpage and answer the following. For every answer, you must give specific example(s) from the webpage

https://www.mygreatlearning.com/blog/ai-bigdata-case-study/

For Value of Information, you must answer the following two statement

• Explain the value of the information for any one* of the mentioned organisations
• Identify how the information was used and shared effectively for the same organisation

Note  the difference between “Explain” and “Identify”

For Handling of Information, answer the following statement, after appreciating how information is handled by each organisation

Pick any one* of the mentioned organisations, appraise how the information is handled

Note  that you might want to know what “appraise” is

For Matching Information System to User Requirements, answer the following statement, after understanding what the user requirements for any information system

Pick any one* of the mentioned organisations, identify the key factors used to match Information System to User Requirements

Note: Information system consists of data, process, people, software and hardware

For Ideas for an IT Policy, answer the following statement, based on the whole document* 

• Explain the value of the information for any one* of the mentioned organisations

• Formulate ideas which could contribute towards generating a policy regarding IT issues, after reflecting what the IT issued discussed in the document
• Recognise the need for on-going evaluation

Note  that you might want to know what “formulate” and “recognise” are.

IMPORTANT:

For MS Word, to PASS, you MUST at least prove that the submitted document is 

• STRICTLY no more than 250 words. Your name, ID, All headings, word counts, references etc. MUST BE counted. The **ONLY** words that are not counted is when they are in the table and images.
• STRICTLY 4 paragraphs exactly
• STRICTLY no more than 1 page (side) of A4. (single sided)
• Completed in MS Word
• Uploaded in MS Word format (that is .docx NOT pdf) and onto the CORRECT MS Word folder (based on the day of your lesson)

Only after achieving the above, you then work to further improve on the "design" (layout, formatting etc) of the MS Word document. Please ensure nobody has the same design as yours. The design itself is 25%.

Part 2 – Individual 10-page Presentation using MS Power Point (50%)

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

When you copy and paste the MS Excel into MS PowerPoint, you must use the “show formulas” feature in MS Excel to show your formulas.

Your PowerPoint slides must be no more than 10 slides and no more than 30 minutes (depending on instructions) containing

• 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

Then you capture those data present them into MS Power Point. You only need to submit the MS Power Point. There is no need to submit to submit the MS Excel.

IMPORTANT

For MS PowerPoint, to PASS, you MUST at least prove that the submitted PowerPoint slides

• are STRICTLY no more than 10 slides, including your ID and name, answering all the 15 Qs.
• MUST SHOW the formulae (formula view)
• MUST SHOW the "figures" (data view)
• is Completed in MS PowerPoint
• is Uploaded in MS PowerPoint format (that is .pptx NOT pdf) and onto the CORRECT MS PowerPoint folder (based on the day of your lesson)

Only after achieving the above, you then work to improve on the "design" (layout, formatting etc) of the MS Power Point and explanation/evaluation of your formulae. Please ensure nobody has the same design as yours. 

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

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. 

• Explain the value of the information for any one* of the mentioned organisations

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.

IMPORTANT:

For MS Excel, to PASS, you MUST at least prove that you are 

• able to do Q1 - Q10 of any of the given dataset (one of the two dataset, other than the one you did for your PowerPoint)
• MUST upload the MS Excel onto TurnItIn before the link closes. You only have 30 minutes. (including the copy of the Excel)
• Completed in MS Excel
• Uploaded in MS Excel format (that is .xlsx NOT pdf) and onto the CORRECT MS Excel folder (based on the day of your lesson)

Then, you can PLEASE further improve by completing Q11 to Q15 which carry the MOST marks of the MS Excel.

Additional Notes     (these apply to all the above and will cause marks to be given or deducted if not adhered to):

• All submitted works MUST be in their respective MS Word, MS Power Point and MS Excel format.
• Spreadsheet must be produced using required formulas/features and formulae must be evidenced
• Spreadsheet must be well designed with required formulas/features and formulae must be evidenced
• Labels of the columns and rows of Excel spreadsheet(s), if used, must be clearly shown on the screen capture(s)
• Table(s) must be professionally displayed
• Chart(s) must be clearly labelled with correct headings and legend.
• Any commentary or analysis must be specific
• Word, time, and page limits must be adhered to
• Instructions must be followed correctly