Applying BI Solutions to Enhance and Improve Business Operations, Exams of Programming for Engineers

Download Applying BI Solutions to Enhance and Improve Business Operations and more Exams Programming for Engineers in PDF only on Docsity!

Higher Nationals

Internal verification of assessment decisions – BTEC (RQF)

INTERNAL VERIFICATION – ASSESSMENT DECISIONS Program title HND in Computing Assessor Internal Verifier Unit(s) Unit 14: Business Intelligence Assignment title Applying BI solutions to enhance and improve business operations Student’s name List which assessment criteria Pass Merit Distinction the Assessor has awarded. INTERNAL VERIFIER CHECKLIST Do the assessment criteria awarded match those shown in the assignment brief? Y/N Is the Pass/Merit/Distinction grade awarded justified by the assessor’s comments on the Y/N student work? Has the work been assessed Y/N accurately? Is the feedback to the student: Give details:

• Constructive? Y/N
• Linked to relevant assessment criteria? Y/N
• Identifying opportunities for Y/N improved performance?
• Agreeing actions? Y/N Does the assessment decision need Y/N amending? Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date

Higher Nationals - Summative Assignment Feedback Form

Student Name/ID Unit Title Unit^ 14:^ Business^ Intelligence Assignment Number Assessor Submission Date Date Received 1st submission Re-submission Date Date Received 2nd submission Assessor Feedback: LO1 Discuss business processes and the mechanisms used to support business decision-making. Pass, Merit & Distinction Descripts P M D LO2 Compare the tools and technologies associated with business intelligence functionality. Pass, Merit & Distinction Descripts P M D LO3 Demonstrate the use of business intelligence tools and technologies Pass, Merit & Distinction Descripts P P M D LO4 Discuss the impact of business intelligence tools and technologies for effective decision-making purposes and the legal/regulatory context in which they are used. Pass, Merit & Distinction Descripts P P M D Grade: Assessor Signature: Date: Resubmission Feedback: Grade: Assessor Signature: Date:

Internal Verifier’s Comments: Signature & Date:

• Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have been agreed at the assessment board.

Pearson Higher Nationals in

Computing

Unit 14: Business

Intelligence Assignment 01

General Guidelines

1. A Cover page or title page – You should always attach a title page to your assignment. Use previous page as your cover sheet and make sure all the details are accurately filled.
2. Attach this brief as the first section of your assignment.
3. All the assignments should be prepared using a word processing software.
4. All the assignments should be printed on A4 sized papers. Use single side printing.
5. Allow 1” for top, bottom , right margins and 1.25” for the left margin of each page. Word Processing Rules
6. The font size should be 12 point, and should be in the style of Time New Roman.
7. Use 1.5 line spacing. Left justify all paragraphs.
8. Ensure that all the headings are consistent in terms of the font size and font style.
9. Use footer function in the word processor to insert Your Name, Subject, Assignment No, and Page Number on each pag e. This is useful if individual sheets become detached for any reason.
10. Use word processing application spell check and grammar check function to help editing your assignment. Important Points:
11. It is strictly prohibited to use textboxes to add texts in the assignments, except for the compulsory information. eg: Figures, tables of comparison etc. Adding text boxes in the body except for the before mentioned compulsory information will result in rejection of your work.
12. Avoid using page borders in your assignment body.
13. Carefully check the hand in date and the instructions given in the assignment. Late submissions will not be accepted.
14. Ensure that you give yourself enough time to complete the assignment by the due date.
15. Excuses of any nature will not be accepted for failure to hand in the work on time.
16. You must take responsibility for managing your own time effectively.
17. If you are unable to hand in your assignment on time and have valid reasons such as illness, you may apply (in writing) for an extension.
18. Failure to achieve at least PASS criteria will result in a REFERRAL grade.
19. Non-submission of work without valid reasons will lead to an automatic RE FERRAL. You will then be asked to complete an alternative assignment.
20. If you use other people’s work or ideas in your assignment, reference them properly using HARVARD referencing system to avoid plagiarism. You have to provide both in-text citation and a reference list.
21. If you are proven to be guilty of plagiarism or any academic misconduct, your grade could be reduced to A REFERRAL or at worst you could be expelled from the course.

Higher National Diploma in Business

Assignment Brief

Student Name /ID Number Unit Number and Title (^) Unit 14 : Business Intelligence Academic Year 2021/ Unit Tutor Assignment Title Business Process Support Mechanisms Issue Date Submission Date IV Name & Date Submission format The submission should be in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced. Follow Harvard referencing system for in-text citations, reference list and the bibliography.. The recommended word limit is 4,000–4,500 words, although you will not be penalised for exceeding the total word limit.

Unit Learning Outcomes: LO1 Discuss business processes and the mechanisms used to support business decision-making. LO2 Compare the tools and technologies associated with business intelligence functionality LO3 Demonstrate the use of business intelligence tools and technologies LO4 Discuss the impact of business intelligence tools and technologies for effective decision-making purposes and the legal/regulatory context in which they are used

comments/posts and all negative and positive online comments about organization and products. Upper management of company believe more you know about organization and the external environment you have better completive advantage. Have potential to control bigger market share and effectively become number 1 beer in Sri Lanka Task 1 Analyse the business processes and the supporting processes of the organization given in the scenario and differentiate between semi structured and unstructured data. Evaluate the benefits and drawbacks of using application software to handle the business processes in Yard of Ale. Task 2 Compare how strategic, tactical and operational decisions are supported within the organization for business decision making process. You have to furthermore compare and contrast how various information systems (TPS,MIS,DSS) could be utilized to enhance those decisions with related to key features of BI framework. Justify your answer with relevant to the functionalities of business intelligence. Task 3 Chief Engineer is the tactical manager of engineering department who oversees all repairs and maintenance of the total eight sectors of the factory that include water purification plant, Mill, Brewhouse, bottling plant, waste treatment plant, factory maintenance and repair/ fabrication shop. Each sector consists of two or more sub sectors and each subsector have 4- 10 of machines. Chief engineer requires to track the maintenance and repair all the machineries with minimal disruption to production and he must maintain healthy inventory of spare parts which consist of over 5000s items, track the progress of every jobs, Identify

problematic arias, Track engineers and mechanics work logs and efficiency and monitor system downtime. 3.1. Explain what business intelligence is and the tools and technologies associated with it by taking relevant examples to the organization given in the scenario. 3.2. Design a Managerial dash board for chief engineer using various data visualizations methodologies that includes 6-8 widgets to present required information. Apply appropriate customizations that can utilize to improve the managerial dashboard designed above. Critically evaluate how your Dashboard design and the suggested enhancement could optimize chief engineer’s performance by delivering accurate and reliable information to increase his effectiveness. Task 4 4.1. Discuss how organizational decision-making process can be improved by implementing business intelligence tools. Conduct a research to identify the organizations that have utilized new business intelligent innovations and trends to improve their performance and to extend BI systems to target audience, provide better competitive advantage within the market. 4.2. Sharing data within the organization through a BI tool can raise legal, ethical and professional concerns. Explore the legal issues that may result when using business intelligence tools (Eg: Data protection laws, Cyber security, etc.) and evaluate how the chosen organization and extend the target audience / gain a competitive advantage by securely exploiting Business Intelligence tools.

Grading Rubric Grading Criteria Achieved Feedback LO1 Discuss business processes and the mechanisms used to support business decision-making. P1 Examine, using examples, the terms ‘Business Process’ and ‘Supporting Processes’. M1 Differentiate between unstructured and semi- structured data within an organisation. D1 Evaluate the benefits and drawbacks of using application software as a mechanism for business processing. LO2 Compare the tools and technologies associated with business intelligence functionality P2 Compare the types of support available for business decision-making at varying levels within an organization. M2 Justify, with specific examples, the key features of

business intelligence functionality. D2 Compare and contrast a range of information systems and technologies that can be used to support organisations at operational, tactical and strategic levels. LO3 Demonstrate the use of business intelligence tools and technologies P3 Determine, with examples, what business intelligence is and the tools and techniques associated with it. P4 Design a business intelligence tool, application or interface that can perform a specific task to support problem-solving or decision-making at an advanced level. M3 Customise the design to ensure that it is user friendly and has a functional interface. D3 Provide a critical review of the design in terms of how it meetsa specific user or business requirement and identify