PART B: STRUCTURED QUESTIONS Answer ALL questions. Each question carries 30 marks. QUESTION 1 (a) Describe Mintzberg's FOUR (4) decisional roles of a manager. (8 marks) 6) Models can represent systems or problems and can be differentiated based on their degree of abstraction Classify and describe with an example each for the FOUR (1) different types of models. (8 marks) c) Based on the below Excel worksheet, read and answer the following questions. E F G H TOTAL GRADE GPA REMARKS B ASSIGNMENT MIDTERM 15 10 23 18 20 12 26 15 22 10 10 7 D FINAL 27 40 35 38 30 28 A 1 NAME 2 ROSLY 3 3 JENNY 4 JACKY 5 OLIVIA 6 CHONG 7 RUEBEN 8 9 10 MARKS 75 AND 11 ABOVE 12 60-74 13 50-59 14 BELOW 50 REFERENCE TABLE GRADE GPA REMARKS A 4 EXCELLENT B F 3 2 0 GOOD AVERAGE FAIL 1) Write a formula to calculate the TOTAL marks for OLIVIA (2 marks) ii) Write a formula using nested conditional logic to determine that GRADE for RUEBEN. The GRADE is based on the TOTAL mark obtained by the student (refer to the worksheet's reference table). (2 marks) 111) Use the lookup function to display the GPA for JENNY based on the Grade obtained (refer to the worksheet's reference table). An absolute cell reference is to be used where appropriate (2 marks) iv) Use the lookup function to display either EXCELLENT, GOOD, AVERAGE or FAIL in the REMARKS column for ROSLY (refer to the worksheet's reference table). An absolute cell reference is to be used where appropriate. (2 marks) v) Write a formula to calculate the AVERAGE MARK obtained by each student. (2 marks) (d) Data mining is placed at the intersection of various disciplines such as statistics, artificial intelligence, machine leaming, management science, information systems and databases. Describe FOUR (4) main characteristics or objectives data mining, (4 marks) (Total: 30 marks) QUESTION 2 (a) Models play a key role in DSS. Why? Explain how models exist in spreadsheet packages like Excel. (8 marks) 6) Explain FIVE (5) potential benefits of wikis to a director of marketing. (10 marks) (c) The UniTrusty Insurance is considering whether to open an investigation of a reported case of negligence at a slimming center. The company is using an expert system that has 500 rules which is developed by IntelTech Software. Discuss the following questions: 1 Should the patient involved in the negligence case be informed that a computer program is deciding the future of an investigation? Justify your answer (7 marks) (11) Discuss FIVE (5) are some of the potential legal implications of Part B. Question 2(c)(i)? (5 marks) (Total: 30 marks)