Numeracy, Data & IT Skills: Comprehensive Mathematical Solutions

This assignment solution focuses on numeracy, data, and IT skills, emphasizing mathematical competency. It covers fundamental concepts such as fraction simplification, percentage calculation, and statistical analysis. The solution includes detailed explanations and step-by-step calculations for various mathematical problems, including arithmetic operations, data interpretation, and the use of Excel functions for data analysis. The assignment also explores practical applications of these skills, such as calculating discounts, analyzing Olympic medal data, and determining travel times. The document provides a comprehensive guide to enhancing numeracy and IT skills, demonstrating the application of mathematical concepts in real-world scenarios. Desklib provides access to this and many other solved assignments.

Numeracy, data & IT

INTRODUCTION
Arithmetic expertise is described as the ability to think about and apply exact predictive
concepts, while IT competence is described as having the ability to compute and evaluate the
available arithmetic and IT data (Ascher, 2018.). Mastering in basic arithmetic, statistics,
probability, measurement is an important aspect of developing fundamental mathematical
abilities. Mathematics is required for logical cognition and mental skills in everyday routines.
The concept of numeracy is important for actions such as dining, completing tasks, assessing
invoicing, and playing sports. It also makes mathematical knowledge, patterns, scheduling, and
forms available. It was established that the concepts of language arts and mathematics may
enable them to build the basic skills that are require in day to day operation in life. There is a
significant strategies for increasing literacy and mathematical abilities, as well as helps the
learner in learning concepts that act in contributing as an active and well-informed person. This
mathematics repertory is split into 3 main exercises, each of which should be done individually.
Part 1
Question 1
As said before, mathematics competency is interpreted as the capability to analyse and
implement simple mathematical concepts. Basic quantitative abilities necessitate knowledge of
fundamental calculated values like summing, finding average, differences. Let know the meaning
of the following two types of fraction (Kilpatrick, 2020).
a) Numerator: numerator define as number which divide the total numbers in a part.
b) Denominator : It means the total part in a fraction.
When expressing numbers as percentages, the equation is x /y, where the upper part (x) denotes
the numerator and the lower part (y)stands for denominator. For example 4/5 is a fraction in
which 4 is the numerator and 5 is denominator. As a result, the numerator is the number just
above fraction line, and the denominator is the number below it. In the graphic below, the
numerator is shown-

Question 2
a) 24/40 in simplest form:
24 / 40 divide it by 8 then it will be 3 / 5
b) 18/42 in their simplest forms
by dividing it to 6 it will = 3 / 7.
Question 3
(a)Expressing the fraction 2/3, ¾ and 5/6 as equivalent fractions with a denominator of 12.
2 * 4 / 3* 4 = 8 / 12
3* 3 / 4 *3 = 9 / 12
5 *2 / 6 * 2 = 10 / 12
(b)total books 60,000 .
14,000 are business books,
22,000 healthcare books and
12,000 on psychology and law.
Remaining book = 60000 – (14000 + 22000 + 12000) = 12000
The computer books is 2/3 of the remainder = 2/3 x 12000 = 8000
the percentage of computing out of total books in the library are 8000/60000 x 100 = 13.33%
Question 4
-Liza buys 2 pairs of shoes.
- Liza provides three £50 notes = £50 x 3 = £150
change money get = £10.50
Total amount for shoes= 150- 10.50
= £139.50
single shoe amount = £139.50 / 2
Therefore, each pair of the running shoes cost £69.75
Question 5
(a). 240.50 x 19.54 in two significant number

for two numbers there will be 4 decimal place after the value 240.50 x 19.54 = 4699.3700
= 4699.37 (2 decimal places)
after two decimal the number will be 4700
(b) 52100 in the power of 10
5.21 x 104
Question 6
(a). A new gym offers 30% discount in registration in initial month
there are 3 people who register
together three pay £210
Let the total discount be y Therefore
discount amount is 210* 30%
= £ 63
(b) The total savings made was £63 There are 3 person
Therefore, the average savings per person is
£63 / 3 = £27
Question 7
(a) 3 / 4 + 7 / 9 + 2 / 3
Use BODMASS
(27-28+24)/36 = 23 / 36
(b) largest numbers 0.1, 0.02, 0.003, 0.0004, 0.00005 out of them will be 0.1 because if the
whole number is divided by 100 then out of the among 0.1 will be equal to 10 and
another values will be small.
Question 8
-total 90 men and 60 women were asked that whether they watched the movie or not

total audience are = 90+ 60 = 150
- The fraction of people that said yes = 3/5 (150 * 3 /5) = 90
-Portion of women who watched are = 3/10
Portion Fraction of men also watched the movie = 3/5 – 3/10 = 3/10
-Fraction of men that didn't watch= 1 – 3/10 = 7/10
total of men who did not watch are= 7 / 10 * 90 = 63
percentage who did not watched among men are = 63 / 90 * 100
= 70%
Question 9
-Annabelle resides at Bermondsey in London.
-She will deliver her speech in Birmingham at 10:30 am
time taken by her from her residence to Euston Station will be an hour (1 hr), from she will
gets the train to Birmingham
-Train journey from Euston Station to Birmingham is an hour and 10 minutes (7/6 hrs)
- The meeting destination is a 5-minute (1/6hr) walk from the platform.
Therefore, total time it will taken by Annabelle's journey from her home to the venue is = 1 hrs
+ 7/6 hrs + 1/12 hr = 27/12 hrs = 2 hours 15 minutes
the total time taken by her to reach at the destination at the scheduled time
=(10hrs 30minutes) – (2hrs 15 minutes) = 8hr 15minutes
the train that runs from Euston to Birmingham is are for different time at 5 minutes past the
hour, 25 minutes past the hour and 45 minutes past the hour.
Hence the earliest time that Annabelle can left from her house is at 8 : 15am
Question 10
Shredded Wheat weight is = 0.35
Weetabix box weight is = 9/25 that is 0.36 kg
Now we need to convert them into numbers (0.35,0.36)/100
so from the above calculation the value of the Shredded Wheat is 35, and that of the Weetabox
is 36 ,

so it is clear that Weeta box is heavier in weight by 1 kg or 0.1.
Part 2
Question 11
Below is the table of summer Olympic medals and total game play by the 10 countries:
(a) By looking at the table, country who won least number of total medals from other ten
countries is Hungary. It won only 491 medal out of 8741 medals.
(b)The team that didn't competed in games are Soviet Union and China. The countries have
mainly competed in only 10 games.
(c)IN the above table, mode is 27 in total game column. It is repeating three time, the team
name are Sweden, United State and Italy.
(d)The of gold medal awarded is the difference between 1022- 147 = 875. ( highest – lowest)
(e) From the total team, 4 team has received bronze medal: Soviet union, Great Britain, US and
China.
(f) Apart from the United States, there are two countries winning more silver, gold and
bronze medal . Germany and Soviet Union are the countries who got more.
(g) highest number of medals won for each game should be computed in order to evaluate
whichever country did best. Similarly, given the infomation from the database above, it has
been calculated that by dividing the total number medals earned by total sum of games every
country has participate
TEAM MEDAL GAME PERCENTAGE
Australia 497 23 19.12
china 543 10 54.3
France 713 28 25.46
Germany 937 24 39.04
Great Britain 847 28 30.25

Hungary 491 26 18.88
Italy 577 27 21.37
Soviet union 1122 10 112.2
Sweden 494 27 18.3
US 2520 27 93.33
Based on above table, the Soviet Union is the nation which performs the good as they have the
most medals per game (112.2 medals per game).
(h)Jamacia has a number of reasons for not getting position in top country . Jamaica, which is
known for its athletics, does not place in the top ten. The main reason for their lack of
involvement in many competitions might be due to its small population in contrast to other
countries. The more populous a country is, the more probable it is to compete in more games
and, as a consequence,they can be placed in the top participating team. Moreover, if
comparison is made with other disciplines such as team athletics, in which people rarely
participate, the athletic tasks performed in Olympic events are small
(i) As per the table, the Soviet Union is the closest competitor to the United States, hence
each medal category of the United States is been compared by the soviet union category.
Country Gold medal Silver medal Bronze medal
US 1022 794 704
Soviet union 440 357 325
difference 582 437 379
By seeing the calculation of the above table it is been noted that in gold category the US has
soviet union has performed outstanding. Therefore in gold category the are the closet competitor.
(j) In order to find out 3 countries with the to the highest degree evenly apportioned number of
gold, silver and bronze medals, nations with the least small range will be identified
Team Gold medal Silver medal Bronze medal Range difference
Australia 147 163 187 187 – 147 = 40
China 227 165 151 227– 151 = 74
France 212 241 260 260 – 212 = 48

Germany 275 313 349 349 – 275 = 74
Great Britain 263 295 289 295 – 263 = 32
Hungary 175 147 169 175-147 = 28
Italy 206 178 193 206 – 178 = 28
Soviet Union 440 357 325 440 – 325 = 23
US 1022 794 704 1022 – 704 = 318
From the above table it is been calculated that out of 10 countries three has equally distributed
their gold medal. they are soviet union, Hungary and Italy.
Part 3
Based on the information in database, additional instructions are given to hoe the function
can be used in MS OFFICE TAHT Could help to make calculation easy.
As shown, a well-designed comparative graph would be created using Excel Soft from the
previous tabular data (Hodge and Cobb, 2019). The table shown above was built in Excel and
may be seen in the picture below-

To emphasise the region shown in the provided information, the highlighted choice would have
been clink and the appropriate column is been highlighted, as seen following image.
The following table is been complete with all of the vital elements are been showned and is
discussed below:

Question 13
(a). Depending on the preceding statistics, the procedures ands activities to be undertaken in
addition to assessing the country's total awards from 1st to 10th are outlined below-
(b) The procedure was to insert the formula “=rank(G3,G3:G12), and the result is depicted in the
figure below-

(c) The stacked bar diagram is the type of diagram that would suffice or be suitable for
displaying solely gold medals.
(d) The parts "Team" and "Total" are the components that should be copied.
(e) The overall number of awards won can be calculated using Excel's "SUM(G3:G12)" function,
as illustrated in the picture below-
Question 14
(a) As shown in the image below, the total number of awards for Germany and the United
Kingdom could be calculated using Excel's "Sum (G6 and G7)" formula.
(b) The method shown in the figure below could also be applied to calculate the total average
number of silver medals won by all European countries (Lam, 2018).