The following data set and questions are to be prepared prior to the exam. Process the information in EXCEL and then you can bring 2 A4 double sided pages from your EXCEL workbook into the exam.
This will be assessed as part of the Exam.
Question 9 : Using EXCEL
There are eight students who participate in tests for nine subjects. Each of the subjects has been marked from 0 to 100. The studentsÂ’ performances in each subject that have been tested are shown in the following table:
Database
69
70
84
78
79
80
90
60
Java
64
74
58
83
55
72
67
59
C++
70
68
87
68
91
64
76
88
Physics
57
76
78
72
71
45
51
90
Mathematics
80
71
67
90
34
66
45
76
English
34
56
67
48
26
76
59
34
Chemistry
45
56
43
23
76
45
33
43
Networks
56
45
34
23
67
56
64
72
Security
96
30
56
46
75
54
34
45
Students
A
B
C
D
E
F
G
H
Examine the scores in the nine subjects taken by the eight students to a target audience. The target audience is of your choice: i.e. a lecturer, a student or their parents etc a. Frame the problem you are solving (this may require 1 or 2 questions) and nominate the target audience (1 mark) b. Interrogate your data in EXCEL. (2 marks) c. Produce 3 charts that best represent a data visualisation for your problem. (3 marks) (This is to be completed before exam and printed EXCEL spreadsheets brought into the exam)
Leave a Reply