MATH1146 Mathematics of Data Analytics 2020/21
Coursework 1 – Data Project
Student identifier: 1119216 Mark: 69%
Feedback
Feedback and Feedforward for next assignment
What you did well in this assignment:
Excellent Excel and VBA skills
What you could improve in this assignment:
Think more about the context in which the systems are used in answering the analytical
questions
Add more validation to your user form
What you can take forward to your next assignment:
A very good mark for a demanding assignment
Marker: TM
Moderator (where relevant):
Comment:
Page 1
, Question Mark Comments
1 19/30 (a) 7/10 Good use of formulas but I am confused that you present
two lists for each category, and these two lists are different. Which
one is correct?
(b) 12/20 Good technical comments but you could say more about
the circumstances in which each approach is most appropriate.
2 20/20 Excellent code
3 19/30 (a) (1) 2/5 You should separate the personal info and the
geographical info into separate tables as these are logically distinct
(2) 1/1
(3) 1/1
(4) 3/3
(b) 12 /20 Good overview – you could say more about the data
integrity, data security and multi-user access capabilities
4 11 /20 Nicely-designed form. Basic requirements met, but you allow the user
to type a new value into the category box. For a higher mark, provide
more data validation (check phone number is numeric, email address
contains “@”, etc)
TOTAL 69%
Page 2
Coursework 1 – Data Project
Student identifier: 1119216 Mark: 69%
Feedback
Feedback and Feedforward for next assignment
What you did well in this assignment:
Excellent Excel and VBA skills
What you could improve in this assignment:
Think more about the context in which the systems are used in answering the analytical
questions
Add more validation to your user form
What you can take forward to your next assignment:
A very good mark for a demanding assignment
Marker: TM
Moderator (where relevant):
Comment:
Page 1
, Question Mark Comments
1 19/30 (a) 7/10 Good use of formulas but I am confused that you present
two lists for each category, and these two lists are different. Which
one is correct?
(b) 12/20 Good technical comments but you could say more about
the circumstances in which each approach is most appropriate.
2 20/20 Excellent code
3 19/30 (a) (1) 2/5 You should separate the personal info and the
geographical info into separate tables as these are logically distinct
(2) 1/1
(3) 1/1
(4) 3/3
(b) 12 /20 Good overview – you could say more about the data
integrity, data security and multi-user access capabilities
4 11 /20 Nicely-designed form. Basic requirements met, but you allow the user
to type a new value into the category box. For a higher mark, provide
more data validation (check phone number is numeric, email address
contains “@”, etc)
TOTAL 69%
Page 2
