Using Numeracy, Data & IT
Portfolio of Tasks
Date for Submission: Please refer to the timetable on ilearn
(The submission portal on ilearn will close at 14:00 UK time
on the date of submission)
Page 1 of 16
[2514]
Assignment Brief
As part of the formal assessment for the programme you are required to submit a
Using Numeracy, Data and IT assignment. Please refer to your Student Handbook
for full details of the programme assessment scheme and general information on
preparing and submitting assignments.
Learning Outcomes:
After completing the module, you should be able to:
1. Use basic numerical operations with whole numbers, integers, fractions and
decimals
2. Calculate ratios and proportions, percentages, averages
3. Construct and use appropriate graphical techniques to present simple data
4. Construct and use a spreadsheet application to record numerical data and
use simple formula
Maximum word count: 3000 words HARVARD REFRENCING
Please note the following:
Students are required to indicate the exact word count on the title page of the
assessment.

The word count includes everything in the main body of the assessment (including in
text citations and references). The word count excludes numerical data in tables,
figures, diagrams, footnotes, reference list and appendices. ALL other printed
words ARE included in the word count.
Please note that exceeding the word count by over 10% will result in a
10percentage point deduction.
Assessment Weighting: Part 1 (20%), Part 2 (80%)
Important note about Part 2 of this paper:
Assignment Task
USING NUMERACY, DATA & IT – PART 1 [60 MARKS]
This part covers Learning Outcomes 1 and 2 of the
module.
Question 1
a) Define the concept of a percentage
[4 marks
]
b) Define the concept of a ratio.
[4 marks
]
[Total Marks for Question 1 = 8]
Question 2
a) Express in its simplest form.
[2 marks]
b) Express 36 ∶ 72 in its simplest form.
[2
marks]
4 3
c) Express the fractions , and as equivalent fractions with a denominator of
10 4
20.
[3
marks]
7 3
d) Work out + −
9 4
[3 marks]
e) Find the mean of the following dataset:
301, 285, 20, 351, 35, 205, 311, 25, 45, 310, 301, 305
Round your answer to two decimal places.
[3
marks]
[Total Marks for Question 2 = 13]
Question 3
a) A software organisation employs 80,000 staff members. 16,000 employees are
in the sales team, 24,000 are in the customer support team and 14,000 are in
the software development and HR departments. What percentage of the
organisation’s employees are a part of the finance team, if the size of the
finance team makes up two-fifths of the remainder?
[5 marks]
b) One of the members of staff from the software organisation travels to
Birmingham on a business trip. She pays for her ticket with three crisp £25 notes
at the ticket office and is given £10.50 in change. Assuming that she bought a
return ticket and that each leg of the journey cost the same amount, how much
was one leg of the journey?
[5 marks]
c) The member of staff lives in Bermondsey in London.
She has to speak at a conference in Birmingham at 10:45am.
It will take her an hour from her home to get to Euston Rail Station, from where
she will get a train to Birmingham.
The train journey from Euston to Birmingham is an hour and 10 minutes.
Trains to Birmingham run at the following times: 5 minutes past the hour, 25
minutes past the hour and 45 minutes past the hour.
The meeting venue in Birmingham is a 5-minute walk from the station.
What is the latest time that the member of staff can leave home, if she is to
make it on time for the meeting in Birmingham? Show your working.
[7 marks]
d) Market research was undertaken to determine whether an ad campaign was
successful for the software company.
15 men and 75 women were asked if they had seen the company’s latest TV
advertisement.
Altogether, of the people said Yes.
of the men said Yes.
What percentage of women said ‘no’ out of the total survey population? (Show your
working).
[7 marks]
[Total Marks for Question 3 = 24]
Question 4
[3
marks]
b) The paralegal splits her earnings between utilities and savings in a ratio of 2 ∶ 3.
How much money will be allocated to her savings? (3 marks)
[3
marks]
[Total Marks for Question 4 = 6]
Question 5
a) In a hospital, 30% of the beds are vacant. There are 210 patients in beds at the
hospital currently. How many beds are there at the hospital?
[4
marks]
b) The hospital plans to increase its bed capacity by 15% over the next year. What
is the planned bed capacity at the hospital?
[3
marks]
c) The pharmacist is trying to determine which box has the greatest weight. A box
of Paracetamol weighs 0.55 kilograms and a box of Ibuprofen weighs
kilograms. Which box is heavier? Show your working.
[2
marks]
[Total Marks for Question 5 = 9]
[TOTAL MARKS FOR PART 1 = 60]
(LOs: 1 & 2)
Given below is the revenue that Tesco recorded by location over the last five years:
Question 6
a) Which year had the lowest total generated revenue in the last recorded five
years?
[1 mark]
b) In which year did Tesco have the least number of stores?
[1 mark]
c) What is the mode revenue for Tesco’s Central Europe division?
[2
marks]
d) What is the range between the revenues generated by Tesco’s UK & ROI division
over the last recorded five years?
[3
marks]
e) In which years did Tesco’s Central Europe division generate five times more
revenue than its Bank division?
[3
marks]
f) When comparing the total revenue generated by Tesco and the total number of
stores, which year had the greatest amount of revenue per store? Show your
working to justify your answer.
[4
marks]
g) Give TWO likely reasons to justify the behaviour of the ‘Total Stores’ dataset over
the last recorded five years.
[4
marks]
h) Which 3 years had the most evenly distributed generated revenue between the
three divisions? Show your working.
[3 marks]
[Total Marks for Question 6 = 21]
Question 7
a) Create the spreadsheet below using Excel. Include the rows and columns
identifiers, text formatting and column highlighting as shown.
[10 marks]
b) What actions or steps in Excel can you take to order the revenue generated by
the Tesco Bank division in ascending order.
[4 marks]
c) State the specific actions or steps in Excel that will produce a list/display of
those years where Tesco’s Central Europe division generates less than
£4,000,000,000 in revenue?
[4 marks]
d) Which type of graph will be suitable for representing the number of Tesco stores
that are open each year?
[1 mark]
e) In which column might replication have been used?
[1 mark]
f) How much revenue has Tesco generated overall over the last recorded five
years? Write the formula you have used alongside the correct numerical answer.
[3 marks]
[Total Marks for Question 7 = 23]
Question 8
a) What type of graph is suitable to show the correlation between the revenue
generated by Tesco’s UK & ROI division and the revenue generated by Tesco’s
Central Europe division over the last recorded five years?
[1 mark]
b) Create an appropriate graph to show the correlation between the total revenue
generated by Tesco and the number of its stores over the last recorded five
years?
[5 marks]
c) What type of correlation is present between the total revenue generated by
Tesco and the number of its stores over the last recorded five years?
[1 mark]
[Total Marks for Question 8 = 7]
Question 9
a) Calculate the median generated revenue for each division of Tesco, stating the
formula you would use for determining the median revenue for its Bank division.
[5 marks]
b) Calculate the average generated revenue for each division of Tesco, stating the
formula you would use for determining the average for its UK & ROI division.
[5 marks]
c) Calculate the standard deviation of the total revenue dataset (Column F) using
Excel. Use the standard deviation range function, STDEV.P, to check your
answer.
[7 marks]
d) Provide a definition for the standard deviation of any dataset. You must cite any
sources used.
[10 marks]
[Total Marks for Question 9 = 27]
Question 10
a) Write the Excel function that gives the total number of stores for the years in
which the number of stores is less than 5,000.
[4
marks]
b) Write the Excel function that gives the average total generated revenue for the
years in which Tesco’s Central Europe division generated more than
£4,000,000,000 in revenue.
[4
marks]
c) Write the Excel function that finds the sum of the generated revenue by Tesco’s
Bank division for the years where the total number of stores is greater than 5,000.
[4
marks]
d) Write the Excel function that searches the spreadsheet to find ‘2021’ and also the
corresponding Total Revenue for that year.
[6
marks]
[Total Marks for Question 10 = 18]
Question 11
a) Produce an appropriate fully labelled chart to compare each division’s generated
revenue over the last five recorded years.
[10 marks]
b) Interpret the chart produced in 11a). Discuss TWO probable justifications for the
behaviour of the data.
[4
marks]
c) Produce a suitable and fully labelled chart to reflect each division’s proportion of
the total amount of revenue generated in 2019.
[10 marks]
[Total Marks for Question 11 = 24]
[TOTAL MARKS FOR PART 2 = 120]
(LOs: 3 & 4)
Assessment Criteria (Learning objectives covered – all)
Level 0 prepares students to function effectively at Level 4. Criteria for assessment at Level 0 reflect the preparatory naturdemonstrate the acquisition of generic learning skills appropriate for self-managed learning in an HE context. Students arethe underpinning discipline-specific skills, knowledge and understanding necessary to undertake a programme of higher edGrade Mark Bands Generic Assessment Criteria
First
(1)
80%+ Outstanding performance which demonstrates an outstanding knowledge base, supporteanalyse the subject area. The work draws widely on relevant theory and shows awarenework shows an excellent level of competence and confidence in managing appropriate sacademic writing skills and professional skills (where appropriate). The work is accurate70-79% Excellent performance which demonstrates an excellent knowledge base the ability to berelevant theory whilst showing some awareness of any relevant ethical considerations.
The work shows a high level of competence in managing sources and materials, initiativeprofessional skills (where appropriate). The work is consistently referenced throughout. Upper
second (2:1)
60-69% Very good performance which demonstrates a sound understanding of the content and sto theory. The work shows a good level of competence in managing sources and materiare good and expression remains accurate overall. Good professional skills (where appLower
second
(2:2)
50-59% A satisfactory to good performance which shows a decent understanding of the content ashows a sound level of competence in managing basic sources and materials. Academiremains accurate overall although the piece may lack structure. Satisfactory professionaattempt to reference the work.
Third
(3)
40-49% A basic level of understanding in which there are some gaps in knowledge of the subjectconsiderations. The work shows a basic use of sources and materials. Academic writingexpression and the work may lack structure overall. There are some difficulties in develoMarginal Fail 30-39% A limited level of knowledge in which there are clear omissions in understanding the subjconsiderations. The work shows a limited use of sources and materials. Academic writiexpression and the work may lack structure overall. There are difficulties in developing p29% and
below
A poor performance in which there are substantial gaps in knowledge and understandingappropriate sources and materials. Academic writing skills are very weak and there are structure overall. Professional skills (where appropriate) are not developed The work is