MATH1146 (2020/21) Mathematics of Data Analytics Contribution: 60% of module
Course Leader: Tony Mann MATH1146 Data Project Assignment Deadline: Thursday 26/11/2020
This coursework will be marked anonymously
YOU MUST NOT PUT ANY INDICATION OF YOUR IDENTITY IN YOUR SUBMISSION
This coursework should take an average student up-to-date with tutorial work about 30 hours ‘
Feedback and grades are normally available within 15 working days of the coursework deadline
Learning Outcomes:
1 Critically evaluate the differences between a variety of mathematical methods and software for
storing data and make appropriate choices for different applications.
3 Create macros to perform a variety of functions used by practitioners in mathematical data
analysis.
6 Be familiar with the advanced techniques for data manipulation in spreadsheets such as the use of
Pivot Tables and Lookup functions.
Plagiarism is presenting somebody else's work as your own. It includes: copying information
directly from the Web or books without referencing the material; submitting joint coursework as
an individual effort; copying another student's coursework; stealing coursework from another
student and submitting it as your own work. Suspected plagiarism will be investigated according
to the procedures set down by the University. Please see your student handbook for further
details of what is / isn't plagiarism.
All material copied or amended from any source (e.g. internet, books) must be referenced correctly
according to the Harvard reference style.
Your work will be submitted for plagiarism checking. Any attempt to bypass our plagiarism
detection systems may be treated as a severe Assessment Offence.
Coursework Submission Requirements
An electronic copy of your work for this coursework must be fully uploaded on the
Deadline Date of Thursday 26/11/2020 using the link on the coursework Moodle
page for MATH1146.
You must submit a ZIP file containing a single PDF document with supporting Excel
files.
There are limits on the file size (see the relevant course Moodle page).
Make sure that any files you upload are virus-free and not protected by a password
or corrupted otherwise they will be treated as null submissions.
You must NOT submit a paper copy of this coursework.
All courseworks must be submitted as above. Under no circumstances can they be
accepted by academic staff
The University website has details of the current Coursework Regulations, including details of
penalties for late submission, procedures for Extenuating Circumstances, and penalties for
Assessment Offences. See http://www2.gre.ac.uk/current-students/regs
Page 1
, Mathematics of Data Analytics - Coursework 1 (Data Project Assignment)
Deliverables and Data:
You should attempt all four questions. Where appropriate you are expected to research
beyond lecture material and reference your sources using the Harvard referencing system.
In submitting your answers you should upload a ZIP file containing the PDF with your
written answers and your Excel spreadsheets (.xlsx and .xlsm files). Make sure you give
the files appropriate names so that it is clear where the answer to each question is to be
found.
The data for questions 1, 2, and 3 is available on the Moodle page for this course. You will
need to click on the data spreadsheet and input your Banner number to generate your data.
(Do not worry if it takes a little time to generate the data.) You will then need to save the
resulting Excel file. The data is specific to your Banner number so do make sure you enter
your number correctly so that you use the correct data which is unique to you. Failure to
use the correct data may result in you losing marks.
Marking:
For questions which involve writing code you must follow good professional practice by
commenting your code fully to explain its workings, and you should lay out the code
appropriately in line with good professional practice to make the structure clear. Failure to
do this will result in marks being deducted.
Page 2
Course Leader: Tony Mann MATH1146 Data Project Assignment Deadline: Thursday 26/11/2020
This coursework will be marked anonymously
YOU MUST NOT PUT ANY INDICATION OF YOUR IDENTITY IN YOUR SUBMISSION
This coursework should take an average student up-to-date with tutorial work about 30 hours ‘
Feedback and grades are normally available within 15 working days of the coursework deadline
Learning Outcomes:
1 Critically evaluate the differences between a variety of mathematical methods and software for
storing data and make appropriate choices for different applications.
3 Create macros to perform a variety of functions used by practitioners in mathematical data
analysis.
6 Be familiar with the advanced techniques for data manipulation in spreadsheets such as the use of
Pivot Tables and Lookup functions.
Plagiarism is presenting somebody else's work as your own. It includes: copying information
directly from the Web or books without referencing the material; submitting joint coursework as
an individual effort; copying another student's coursework; stealing coursework from another
student and submitting it as your own work. Suspected plagiarism will be investigated according
to the procedures set down by the University. Please see your student handbook for further
details of what is / isn't plagiarism.
All material copied or amended from any source (e.g. internet, books) must be referenced correctly
according to the Harvard reference style.
Your work will be submitted for plagiarism checking. Any attempt to bypass our plagiarism
detection systems may be treated as a severe Assessment Offence.
Coursework Submission Requirements
An electronic copy of your work for this coursework must be fully uploaded on the
Deadline Date of Thursday 26/11/2020 using the link on the coursework Moodle
page for MATH1146.
You must submit a ZIP file containing a single PDF document with supporting Excel
files.
There are limits on the file size (see the relevant course Moodle page).
Make sure that any files you upload are virus-free and not protected by a password
or corrupted otherwise they will be treated as null submissions.
You must NOT submit a paper copy of this coursework.
All courseworks must be submitted as above. Under no circumstances can they be
accepted by academic staff
The University website has details of the current Coursework Regulations, including details of
penalties for late submission, procedures for Extenuating Circumstances, and penalties for
Assessment Offences. See http://www2.gre.ac.uk/current-students/regs
Page 1
, Mathematics of Data Analytics - Coursework 1 (Data Project Assignment)
Deliverables and Data:
You should attempt all four questions. Where appropriate you are expected to research
beyond lecture material and reference your sources using the Harvard referencing system.
In submitting your answers you should upload a ZIP file containing the PDF with your
written answers and your Excel spreadsheets (.xlsx and .xlsm files). Make sure you give
the files appropriate names so that it is clear where the answer to each question is to be
found.
The data for questions 1, 2, and 3 is available on the Moodle page for this course. You will
need to click on the data spreadsheet and input your Banner number to generate your data.
(Do not worry if it takes a little time to generate the data.) You will then need to save the
resulting Excel file. The data is specific to your Banner number so do make sure you enter
your number correctly so that you use the correct data which is unique to you. Failure to
use the correct data may result in you losing marks.
Marking:
For questions which involve writing code you must follow good professional practice by
commenting your code fully to explain its workings, and you should lay out the code
appropriately in line with good professional practice to make the structure clear. Failure to
do this will result in marks being deducted.
Page 2
