Comprehensive Report: Using Numeracy, Data, and IT Effectively

This report showcases the application of numeracy, data analysis, and information technology in solving problems and interpreting data. It begins with basic numeracy concepts like fractions and simplification, then transitions into analyzing a provided dataset to derive meaningful insights such as identifying countries with the least medals, determining the mode of participated games, and calculating medal distribution. The report further demonstrates the use of IT tools, specifically spreadsheets, to organize and present data effectively, enhancing analytical capabilities and accuracy. It concludes by highlighting the importance of integrating these skills for comprehensive data interpretation and problem-solving.

Using Numeracy, Data
and IT

Table of Contents
INTRODUCTION ..........................................................................................................................3
PART-1............................................................................................................................................3
With the help of Numeracy.........................................................................................................3
PART-2............................................................................................................................................8
Through data given ....................................................................................................................8
PART-3..........................................................................................................................................10
With the application of IT.........................................................................................................10
CONCLUSION .............................................................................................................................16
REFERENCES..............................................................................................................................17

INTRODUCTION
Numeracy comprises of numbers, figures and amounts that requires to analysed by
converting this raw data into a well structured format. They comprises of various hidden values,
which when analysed presents a meaningful information. They makes use of mathematical and
statistical tools to bring some results out of them. Presentation of figures in table and graph
format has made the analytical work more easy. With the introduction of IT in this format, the
task has been became efficient. This has also reduced the manual which earlier took a lot of time
to get completed. Now, all the charts and diagrams can be made on a single click and whole data
can be analysed more quickly and accurately (Gee, Gonzalez and Cooper, 2020). This report is
divided into three parts. The first one comprises of some figures related to fractions,
simplification and other queries. Second part makes use of data to get some desired results. Third
section is about the usage of statistics and tools of information technology to present the data in
more smart and accurate manner.
PART-1
With the help of Numeracy
Question 1: Describe the following terms:
Numerator is the term which is represented in the top section of fraction. It shows the
number of parts it comprises of related to that data. Increase in this value tends to increase the
value of complete fraction. Presence of zero in this section does not make the figure irrelevant as
in case of denominator.
Denominator is the bottom number in the fraction. It depicts the complete thing rather
than showing a particular portion. It also depicts the number of parts in which a particular thing
is divided into. With the decrease ion its value, the complete matter tends to increase. There is a
fact that of the lower value is zero, the solution converts into infinity and makes it irrelevant
(Wang and et. al., 2021).
A fraction is written in the form of a/b.
Here, a = Numerator
b = Denominator

For example, a pizza has four slices out of which one has been eaten. Now the remaining
parts are 3. For this, the fraction of pieces left will be 3 / 4, where 3 is numerator and 4 is
denominator.
Question2: Depict the figures mentioned below in their simplest forms.
The following fractions has the potential to reduce itself to the shortest form without
losing its value. For this, at very first, there is a need to identify the highest common factor
which can divide both the terms above and below. After dividing it, the resultant value will be in
its simplest form.
1. 24 / 40 : In this case, the biggest common figure identified is 8. on dividing by 8, the
resulting figure will be 3 / 5. This is its simplest form (Pearce and et. al., 2018).
2. 18 / 42 : Here, HCF is 6. By eliminating the multiplication of 6 from both denominator
and numerator. The resulting value will be in shortest form. Resulting value for it is 3 / 7.
Question3:
(a)Convert the provided fractions as a denominator of 12.
At first, it is important to identify that on multiplying with what number, the resultant
figure will become 12. This can be calculated by dividing the denominator of given
figure with 12. Then, the resultant number is to be multiplied by both the digits above and
below, so that the actual figure does not change.
I. 2/3 = Here, it is required to multiply both the values up and down with 4 like this-
(2*4) / (3*4).
The outcome driven will be 8/12.
II. 3/4 = For solving this, the complete fraction is to be made 3 times of itself by
applying following format
(3*3) / (4*3)
The value received is 9/12.
III. 5/6 = In this case, the figure is required to be multiplied by 2 on both the sides.
(5*2) / (6*2)
The result gotten is 10/12.
(b) Ascertain the percentage of total computing books with that to the complete
holding provided.
Whole lot = 60000

Business = 14000
Healthcare = 22000
Psychology and law = 12000
Remaining books = complete sum – books of (Business + Healthcare +Psychology and
law)
= 60000 – (14000 + 22000 + 12000)
= 60000 – 48000
= 12000 books
Books of Computing = 2 / 3 * other ones
= 12000 * 2/3
= 8000
% of computing books in library = [ books of computing / Total books * 100]
= [8000 / 60000 * 100]
= 13.33 %
So, the desired result is 13.33%.
Question 4: Calculate the cost of single pair of shoes to Liz.
Number of pairs = 2
Cash given to shopkeeper = 3 * £50 = £150
Considering the amount paid be x.
Change given = £10.50
Price of 2 pair of shoes = [2 * cost of single pair ] + 10.5 = 150
2x + 10.50 = 150
2x = 139.50
x = £69.75
Therefore, the amount of singe pair of shoes comes out to be £69.75
Question 5:
(a) Present 240.50 * 19.54 in 2 decimals.
Whenever, a value is required to be presented in specific significant figures after point. Then, the
numbers present after that particular place are required to be eliminated and their impact is
shown on the immediate last value of the digit. If the number after the required place is 5 or more

than it, then the figure prior to it is increased by 1 otherwise not (Oslington, Mulligan and Van
Bergen, 2018).
240.50 * 19.54
= 4699.3700
The resulting figure is form of 4 decimals. For making it to 2 significant decimal, last 2
zeros have to be removed. Thus, the solution is 4699.37
(b) Show the value as a power of 10.
52100 = 521 * 102.
Question 6
(a) Ascertain the savings made by Patty an her two siblings.
Discount given = 30%
Total persons = 3
Total Amount paid = £210
30% discount means, they have to pay only 100- 30 = 70% amount of the total price.
Therefore,
= 210 / 70 * 30
= £ 90
So, savings of 3 persons jointly is £90.
(b) Determine the following.
Average savings per person =90 / 3
= £ 30
Question 7: Solve
(a) 3 / 4 – 7 / 9 + 2 / 3
With the help of Lowest Common Multiple of 4, 9, 3 which is 36.
(3 / 4 * 9 / 9) – (7 / 9 *4 / 4) + (2 / 3 * 12 / 12)
= (27 – 28 + 24) / 36
= 23 / 36
(b) Ascertain the biggest number
0.1, 0.02, 0.003, 0.0004, 0.00005
In the above situation, the largest number is 0.1. This is because in all other digits, the immediate
value after decimal is 0 which is smaller than 1.

Question 8: Work out the percentage of men said no.
Total number of men and women = 90+60 = 150
3/5 of total said yes which comes out to be 150 * 3 / 5
= 90
3/10 of women which is 60 * 3 / 10 = 18 said yes.
Thus, Men who said yes = 90 – 18
= 72
Men saying no = 90 – 72
= 18
% of men saying no =
= 18 / 90 * 100
= 20 %
Men who said no = 20 % men
Question 9: Calculate the time at which Annabelle must leave.
Time of meeting = 10:30 AM
Looking in reverse order, Annabelle will require 5 minutes to reach at hall from
Birmingham station. It means if it reaches at exact 10:30 AM, it will reach station at 10:25 AM.
It takes one hour and 10 minutes from Euston rail station to reach Birmingham. So, at Euston,
time must be 9:15 AM. Before this the train leaves at 9:05 AM. From the house, it takes one hour
to reach Euston. Then, the time must be 8 :15 AM.
So , it is recommended that Annabelle must leave the house from 8 to 8:10 AM. If there is
a delay of even 5 minutes after 8 :15 AM, then she would be late by 10 minutes because of fixed
schedule of train to Birmingham.
Question 10: Checkout the heavier box.
Shredded wheat box = 0.35 Kg
Weetabix box = 9 / 25 Kg = 0.36 Kg
on comprising the weights of two boxes,
35 / 100 = 36 / 100
35 is greater than 36
So, the Weetabix box with 9 / 25 weight is more heavy.

PART-2
Through data given
Question 11: Answer the questions
(a) Determine the country with least medals in total.
With the help of table, it can be said that lowest number if medals is 491, won by
Hungary. So, Hungary received minimum medals.
(b) Which countries participated in minimum number of games.
China and Soviet Union are identified as countries with least number of games they took part
in.
(c) Check out the mode of participated games.
Mode refers to the value that occurred maximum number of times in a data group. So, in
this case, maximum occurring frequency is 27 with a count of 3.
So, Mode = 27
(d) Calculate rang of specifically gold medals.
Range is the difference between the highest value and lowest value of that column or row.
In this situation, 1022 – 147 = 875
(e) Determine the count of countries who received more silver than bronze medals.
China, Great Britain, Soviet Union & United States are 4 countries that are identified
to fit in the required scenario.
(f) Keeping United states aside, select the countries who received all the medals
separately in more quantity as compared to Great Britain.
Germany and Soviet Union are the two countries other than united states who earned
more medals than Great Britain.
(g) According to the number of games, identify the countries who got maximum
number of medals.
It can be view from following table.
Category
Total games Total medalsCountries
France 28 713
Great Britain 28 847

Sweden 27 494
Italy 27 577
United States 27 2520
Soviet Union 10 1122
It is very much clear from the above table that United States and Soviet Union are the
two counties won a much number of games as compared to they participated in as compared to
other countries.
(h) Give two reasons behind Jamaica not counted ion top 10 countries.
Reasons due to which Jamaica could not turned up in top 10.
 Jamaica participated in single game, which is Athletics and won number of medals. But
taking part in only single game is not enough. There were 28 or more games, in which is
could have took part. Taking part in one game only reduced its chances to be top 10.
 Also, Jamaica is a small country with less population. So, it had little chance to earn
much medals. So, it did not turned up to top 10 (Haider-Markel and Joslyn, 2018).
(i) who is the closed competitor of united states. Tell on the basis of data provided.
Following are the countries who were immediately next to United states. Though they are niot
very close.
Country Gold Silver Bronze
United States 1022 794 704
Soviet Union 440 357 -
Germany - - 349
(j) Work out 3 countries in which all the medals are equally distributed..
Countries Medals Gold Silver Bronze
France 212 241 260
Sweden 147 170 179
Hungary 175 147 169

So, France, Sweden and Hungary are the three countries in which the medals are
distributed evenly within themselves.
PART-3
With the application of IT.
Question 12: Construct a spreadsheet with the help of Excel.

Olympic Games Medals Table (Top 10)
Team Total Games Gold Silver Bronze Total
Australia 26 147 163 187 497
China 10 227 165 151 543
France 28 212 241 260 713
Germany 24 275 313 349 937
Great Britain 28 263 295 289 847
Hungary 26 175 147 169 491
Italy 27 206 178 193 577
Soviet Union 10 440 357 325 1122
Sweden 27 147 170 179 496
United States 27 1022 794 704 2520
Total Number of Medals Awarded 8743
Average Number of Medals 874.3
Question13
(a) Write the steps of excel to create rank from 1 to 10.
To solve the purpose, following steps must be followed.
a. Select an empty cell and type the function RANK((F3, $F$3:$F$12)
b. Now, drag the cursor till the last country.
c. The countries will be ranked from top to bottom.
(b) Mention the steps required to display the countries who won more than 800 medals.
Following steps must be followed to do so.
 Select the complete column of total.
 Apply filter from the data tab (Cheung, and McBride, 2017).
 Select number filter from drop down list and apply filter greater than 800.
The resulting value is shown in following table. It shows all the countries with more than
800 medals in total.
Olympic Games Medals Table (Top 10)
Germany 24 275 313 349 937
Great Britain 28 263 295 289 847

Soviet Union 10 440 357 325 1122
United States 27 1022 794 704 2520
(c) Make a best suited graph of only gold medals.
(d) Detect the columns which might be replicated.
Replication simply means copy and pasting the data from one file to another or column to
column. This is basically done to solve the issue of any kind of any kind of problem is writing
the big and complex data. In this table of medals, replication might have been used in total
medals and teams column (O’Connor and et. al., 2019).
(e) Provide the formula to calculate the total of all the medals won.
For the purpose of getting the desired result, following formula is used.
[=SUM (F3:F12)]
The resulting figure will be 8743.
Question 14: Provide the formulas of Excel.
(a) Determine the total medals of Germany and Great Britain jointly.
For calculating the total number of medals following formula is applied.
=SUM (F6:F7)
The resulting value will be 937 + 847 = 1784.
(b) Ascertain the average number of silver medals won by European country.
European countries who participated in Olympics are- Italy, France, Sweden, Germany,
Hungary.
Formula used in Excel - =AVERAGE(D5;D6;D8;D9;D11)
The result in last would be 209.8.
(c) Find out the total count of gold medals won by countries who got involved in less
than 20 games.
There are only 2 countries who took part in less than 20 games. These are China and
Soviet Union who took part in 10 games.
Formula: [=SUMIF (B3:B12, “<20”, C3:C12)]
So, the total is 667.