Data & IT Assignment: Using Numeracy, Data and IT FP Contents - Task

This assignment focuses on numeracy, data analysis, and IT skills, encompassing mathematical proficiency, data interpretation, and spreadsheet application. Part 1 involves basic numerical operations, fractions, percentages, and problem-solving. Part 2 analyzes Olympic Games medal data, calculating ranges, modes, and comparisons between countries. It also discusses factors affecting a nation's performance. Part 3 demonstrates Microsoft Office skills, including creating and formatting tables and charts in Excel. The assignment includes tasks such as ranking countries by medal count and highlighting data, showcasing practical application of data analysis techniques. Desklib offers a wealth of similar assignments and study resources for students.

Using numeracy data
and IT FP

Contents
Contents...........................................................................................................................................2
INTRODUCTION...........................................................................................................................3
Part 1................................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................4
Question 3....................................................................................................................................4
Question 4....................................................................................................................................4
Question 5....................................................................................................................................5
Question 6....................................................................................................................................5
Question 7....................................................................................................................................6
Question 8....................................................................................................................................6
Question 9....................................................................................................................................6
Question 10..................................................................................................................................7
Part 2................................................................................................................................................7
Part 3..............................................................................................................................................10
Question 13................................................................................................................................12
Question 14................................................................................................................................13
Question 15................................................................................................................................14
Question 16..................................................................................................................................1
Olympic Games Medal Table..........................................................................................................2
Olympic Games Medal Tables........................................................................................................3
Conclusion.......................................................................................................................................4
References........................................................................................................................................5

INTRODUCTION
Math proficiency is defined as the capacity to think and implement precise mathematical
principles, and proficiency is characterized as the capacity to calculate and analyse the offered
mathematics and IT information (Al-Qirim, Tarhini and Rouibah, 2017). Understanding essential
mathematical processes like divisions, multiplying, adding, and subtracting is part of core
mathematical skills. Individuals need arithmetic to acquire rational thought and cognitive
abilities in their daily actions. For tasks such as eating, following directions, analyzing invoices,
and participating in sports, the notion of arithmetic is necessary continue providing solutions to
issues and also making knowledge of mathematics, trends, timing, and forms. It was discovered
that perhaps the notion of reading and mathematics allows people to learn the core abilities they
need to succeed in existence. There is a broad strategy to improving reading and mathematics
skills and also assisting learners in order to live a happy and gratifying existence and
participating as an engaged and well-informed citizen. This arithmetic repertoire is divided into
three primary activities, each of which would be completed one by one.
Part 1
Question 1
Math proficiency, as previously mentioned, is defined as the capacity to analyze and
applying the basic mathematical principles. Understanding essential numerical calculations such
as divisions, multiplying, adding, and subtracting is required for essential mathematical skills.
The numerator and denominator concepts would be covered further down-
Numerator: When quantities are given as fractions, the formula is a/b, in which a
represents the numerator and b represents the denominator (Antignac, Scandariato and
Schneider, 2016). For example, 4/5 is a proportion, and the couple of percent bars are the line
that separates the numerals 4 and 5. Therefore, the numerator is the value well above fraction
line, while the denominator is the integer underneath it. The numerator is depicted in the diagram
beneath-

Denominator: The denominator is the lowest integer in a proportion which represents the
quantity of equivalent pieces separated into a thing (Berg and Carlsson, 2019).
Question 2
Expressing 24/40 and 18/42 in their simplest forms
3 ∧18
24 = 5 = 3
40 42 7
Question 3
(a) , Expressing the fraction 2/3, ¾ and 5/6 as equivalent fractions with a denominator of 12.
2 = 8 , 3 = 9 5 = 10
3 12 4 12 6 12
(b) A library contains 60,000 books. 14,000 are about business, 22,000 are on healthcare and
12,000 on psychology and law. What percentage of the library’s books is on computing, if
computing books make up two-thirds of the remainder?
The total books in the library = 60,000 Business books = 14000
Healthcare books = 22000 Psychology and law = 12000
Remaining book = 60000 – (14000 + 22000 + 12000) = 12000
The computer books is 2/3 of the remainder = 2/3 x 12000 = 8000 Therefore, the percentage of
the library books on computing will be; 8000/60000 x 100 = 13.33%
Question 4
-Liz purchases two pairs of running shoes
- Liz gives three Crisp £50 notes = £50 x 3 = £150
-Liz received £10.50 change
What is the amount for each pair? (let this be referred to as x) Therefore, 2x + 10.50 = 150
2x + 10.50 = 150
From the equation above, the value of x can be calculated as shown below. 2x = 150-10.50
2x = 139.50 X = 139.50/2 X = 69.75
Therefore, each pair of the running shoes cost £69.75

Question 5
(a). 240.50 x 19.54 (2 significant)
From the above expression, there is a total of four decimal places from the two numbers 24050
x 1954 = 46993700
240.50 x 19.54 = 4699. 3700
= 4699.37 (2 decimal places)
(b) Rewriting 52100 to the power of 10
5.21 x 104
Question 6
(a). A new gym offers 30% discount to individuals who sign up in the first month
-Patty and 2 siblings (which is 3 individuals in total)
-The 3 people paid a total amount of £210
-Let the total amount without the 30% discount be p
-Let the total discount be y Therefore
30/100 x P = y---------Eqn 1
P – y = 210...........Eqn 2
To solve for P, we substitute the value of y in equation 2
P – (30/100 x P) = 210 P – (30P/100) = 210
100P – 30P = 21000
70P = 21000 P = 21000/70 P = 300
We can now substitute the value of P in equation 2 to find y 300 – y = 210
y = 300- 210 = 90
Therefore, the total savings made was £90
(b) The total savings made was £90 There are 3 individuals involved
Therefore, the average savings per person can be calculated as
£90/3 = £30

Question 7
(a). ¾ - 7/9 + 2/3
(27-28+24)/36 = 23/36
(b) Which is the largest of the following numbers? 0.1, 0.02, 0.003, 0.0004, 0.00005
From the above, numbers the largest number is 0.1 because the position of the significant
number one is at tenth which is the largest position after the decimal place (Boyles, 2019).
Question 8
-90 men and 60 women were asked whether they had watched the latest ‘Expendables’ movie.
- The fraction of people that said yes = 3/5
-Fraction of women that said yes = 3/10
-Fraction of men that said yes = 3/5 – 3/10 = 3/10
-Fraction of men that said no = 1 – 3/10 = 7/10
-Number of men that said no = 7/10 x 90 = 63
-Percentage of men that said no = 63/90 x 100 = 70%
Question 9
-Annabelle lives at Bermondsey in London.
-She is required to speak in Birmingham at 10:30 am
-It will take her an hour (1 hr) to get to from her house to Euston Station, where she gets the
train to Birmingham
-The train journey from Euston Station to Birmingham is an hour and 10 minutes (7/6 hrs)
- The meeting venue In Birmingham is a 5-minute (1/6hr) walk from the station.
Therefore, total time it will take Annabelle to journey from her house to the meeting venue is =
1 hrs + 7/6 hrs + 1/12 hr = 27/12 hrs = 2 hours 15 minutes
In order to calculate the time, the total time needed to get the meeting venue from the
scheduled time
=(10hrs 30minutes) – (2hrs 15 minutes) = 8hr 15minutes
Even though the train that runs from Euston to Birmingham comes at 5 minutes past the hour,
25 minutes past the hour and 45 minutes past the hour.

Therefore, the latest time that Annabelle can leave the house is at 8 : 15am
Question 10
The weight of Shredded Wheat = 0.35 = 35/100 The weight of Weetabix box = 9/25
Now we need to convert them into numbers (35,36)/100
From the above, the value of the Shredded Wheat is 35, while that of the Weetabix is 36
Therefore, the Weetabix is heavier
Part 2
The Medals Table for Summer Olympic Games has been provided in the table shown below.
(a) From the provided data, the country that has the lowest number of overall medals among the
10 countries is Hungary with 491 medals.
(b) The country/countries that competed in the least number of games are China and Soviet
Union with 10 games (Chinn, 2020).
(c) The mode in the number of games countries participated in is 28 (France and Great Britain)
(d) The range between the gold medals awarded to the 10 countries is = 1022 – 147 = 875
(e) There are 4 countries that got more silver medals than bronze medal and they are China,
Great Britain, Soviet Union, and United States.
(f) Apart from the United States, Germany and Soviet Union has more gold metals, ,more silver
medals and more bronze than Great Britain
(g) In order to decide which nation performed better, the maximum quantity of trophies earned
each match must be determined. Alternatively, using the information in the above table, this
may be computed by splitting the overall quantity of trophies won by the number of matches
played by each nation (Cohrssen and Niklas, 2019).
Australia :
497/26 = 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.30 United States:
2520/27 = 93.33
From the above calculations, it is clear that Soviet Union is the country that
perform the best since they have the highest number of medals per game (112.2
medals per game).
(h) There could be various factors why a nation like Jamaica, which excels in
athletes, doesn't really place in the top ten awards. The primary cause for their lack
of participation in numerous tournaments could be due to their relatively tiny
demographic in comparison to other nations. The larger the populace, the more
likely they are to participate in more tournaments and, as a result, to be among the
top ten medalist nations. Furthermore, contrasted to other sports such as group
sports, where individuals seldom engage in, the athletic activities engaged in
Olympic events are rather minor (Fatima and Linnes, 2019).
(i). The nearest competition to the United States, according to the chart, is the
Soviet Union, therefore each award class of the United States will indeed be
contrasted to that of the Soviet Union.
Gold medal US = 1022
Soviet Union = 440
The difference = 1022 – 440 = 582
Silver medal US = 794
Soviet Union = 357
The difference = 794 – 357 = 437

Bronze medal
US = 704
Soviet Union = 325
The difference = 704 – 325 = 379
From the above calculation, the medal category in which the United States far outperformed
its closest competitor Soviet Union is the Gold medal category
(j) In order to determine 3 countries with the most evenly distributed number of golds, solve
and bronze metals, countries with the least small range will be identified
Australia
Gold Silver Bronze
147 163 187 Range = 187 – 147 = 40
Chin
a
Gold
Silver Bronze
227 165 151 Range = 227– 151 = 74
France
Gold Silver Bronze
212 241 260 Range = 260 – 212 = 48
Germany
Gold Silver Bronze
275 313 349 Range = 349 – 275 = 74
Great Britain
Gold Silver Bronze
263 295 289 Range = 295 – 263 = 32

Hungary
Gold Silver Bronze
175
Italy
Gold
147
Silve
r
169
Bronze
Range = 175 –
147 = 28
206 178 193 Range = 206 –
178
= 28
Soviet Union
Gold Silver Bronze
440 357 325 Range = 440 –
325
= 115
Sweden
Gold Silver Bronze
147 170 179 Range = 179 – 147 = 23
United States
Gold Silve
r
Bronze
1022 794 704 Range = 1022 – 704 =
318
From the above analysis, the 3 countries with evenly distributed medals are Sweden, Hungary,
and Italy
Part 3
Some directions on how to execute certain tasks on Microsoft Office will indeed be given
depending on the statistics in the database.

A well-designed comparable chart will indeed be made utilizing Excel Soft from the preceding
tabular draught, as illustrated (Fernández-Manzano, Neira and Clares-Gavilán, 2016). The
above-mentioned table was created in Excel and is depicted in the image following-
The highlighting option would've been pressed and the relevant field chosen as illustrated in the
accompanying illustration to emphasize the area presented in the supplied database.
The finished table with all of its essential components is then presented and described in the
diagram beneath-

Question 13
(a). The processes or tasks to conduct in addition to determining the nation’s overall medals from
1st to 10th are described following, based on the preceding tables.
(b) The operation was to enter the expression “=rank(G3,G3:G12), and the outcome is shown in
the diagram beneath-

(c) Stacked bar chart is the style of graph which will be adequate or acceptable in portraying just
gold medals.
(d) The "Team" and "Total" sections are the ones which should be reproduced.
(e) The total number of medals received could be determined utilizing the calculation
“SUM(G3:G12)” in Excel, as shown in the image beneath-
Question 14
(a) The entire quantity of medals for Germany and the United Kingdom can indeed be computed
utilizing Excel's "Sum (G6 and G7)" calculation, as illustrated in the picture beneath-
(b) The technique provided in the image beneath can also be used to compute the overall
average quantity of silver medals for all European nations.

(c) The methodology shown in the image beneath is used to compute the overall gold medals
for nations that have competed in less than 20 tournaments.
(d) The searching and Find operations would be used in the newly constructed Excel Spread
Sheet to locate Italy and its associated medals tally. The procedure should be used, though, is
"=Find(A9:G9)." The explanation is depicted in the diagram beneath-
Question 15
(a) > The technique would have been used to calculate the median quantity of medals for every
medal category, and the findings are shown in the diagram beneath
The median for a gold medal is calculated using the formula “=median (D3:D12),” as shown in
the diagram below.

The median for the Silver medal is calculated using the formula “=median
(E3:E12),” as shown in the diagram beneath.
The median for a Bronze medal is calculated using the formula “=median
(F3:F12)”, as shown in the diagram following.
(b) The equation would have been used to calculate the average number of trophies
for every medal category, and the findings are shown in the diagram underneath.
The equation “=Average (D3:D12)” is used to calculate the mean for the Gold
medal, and the outcome is shown in the diagram beneath.

The mean for the Silver medal is calculated utilizing the equation “=Average
(E3:E12),” as shown in the diagram follows.
The method “=Average (F3:F12)” is used to calculate the mean for the Bronze medal, as shown
in the image beneath.
(c) The mean of the available dataset would be determined initially, as seen below, in addition
to determine the standard deviation of the information given.
Mean = Total outcome/ number of outcome (N) Total outcome = 8741
Number of outcome (N) = 10
Mean = 8741/10 = 874.1 (the let mean be presented as u and the total medal for each country
will be represented x and we can determine (x-u) and (x-u)^2 as shown in the table below
From the provided data table, the following parameters can be deduced (x-u)^2 = 3432426.9

√
N = 10
Now, we can apply the provided standard deviation formula as illustrated below.
x
−
u
¿
2
¿
¿
∑
¿
¿
σ
=
√
¿
σ = 3432426.9 =585 .8710
σ =585.87

In accordance to the data given, the “STDEVP” function in Excel would have been utilized to
validate and cross-check the computed standard deviation of total medals for every nation, with
the findings seen in the image beneath-
The standard deviation derived from the preceding data is 585.8691748, while the estimated
standard deviation was assumed to 585.87, indicating that the simulation value is precise and true
(Jain, 2017).
(d) In light of the presented spreadsheet, it could be deduced that the estimated standard
deviation is critical in interpreting the statistical model. The standard deviation measures how
far a particular outcome deviates from the mean on average. Therefore, a low standard
deviation indicates that the presented findings are close to the mean, whereas a big standard
deviation indicates that the data are more dispersed. The standard deviation of 585.87 in regard
to the presented figures suggest that nations with greater totals are on average 585.87 away
from the distribution's mean. The standard deviation in this database can be used to identify
how far various nations' total medals differ from the mean overall medal, such as the United
States, the Soviet Union, and Australia (Kumar, 2018).
Question 16
(a) > Appropriate fully-labelled chart to compare the gold, silver, and bronze
medals total of the 10 countries (Russo, 2019).

Olympic Games Medal Table
1200
1000
800
600
400
200
0
Australia China France Germany Great Britain Hungary Italy Soviet Union Sweden United
States
Counrties participated in the Olympics
Total Games Gold Silver Bronze
(b) A suitable and fully-labelled chart to reflect the contribution of each country to the overall
medal is illustrated in the figure or chat below (Sultan, 2020).
Number of
medal

Olympic Games Medal Tables
10000
9000
8000
7000
6000
5000
4000
3000
2000
1000
0
1
Contribution of each country to the total medals
Australia China France Germany Great Britain
Hungary Italy Soviet Union Sweden United States
Number of
Medals

Conclusion
Math proficiency is defined as the capacity to analyze and implement precise mathematical
principles, and this study offered the computation and evaluation of the supplied arithmetic and
IT information. Understanding essential mathematical calculations including divisions,
multiplying, adding, and subtracting is required for essential mathematical skills. Humans need
arithmetic to acquire rational thinking and cognitive techniques in their daily actions. For tasks
including eating, writing directions, analyzing invoices, and playing, the notion of arithmetic is
necessary continue providing solutions to issues and also create knowledge of mathematics,
rhythms, periods, and forms. Humans can learn the core skills they need to succeed in life
through the concept of reading and mathematics. There is a broad method for improving
mathematics and communication skills, and also assisting learners in lead a good and gratifying
life and participating as an engaged and well-informed citizen. This arithmetic repertoire is
categorised into 3 activities, each of which would be completed one by one.

References
Books and journals
Al-Qirim, N., Tarhini, A. and Rouibah, K., 2017, August. Determinants of big data adoption and
success. In Proceedings of the International Conference on Algorithms, Computing and
Systems (pp. 88-92).
Antignac, T., Scandariato, R. and Schneider, G., 2016, October. A privacy-aware conceptual
model for handling personal data. In International Symposium on Leveraging
Applications of Formal Methods (pp. 942-957). Springer, Cham.
Berg, H. and Carlsson, H., 2019. Hur business intelligence system integrerar med
ekonomistyrningen i ett företag.
Boyles, M., 2019. The Affect and Limitations of Business Intelligence in the Fast-Food
Restaurant Industry (Doctoral dissertation, Capella University).
Chinn, S., 2020. The trouble with maths: A practical guide to helping learners with numeracy
difficulties. Routledge.
Cohrssen, C. and Niklas, F., 2019. Using mathematics games in preschool settings to support the
development of children’s numeracy skills. International Journal of Early Years
Education, 27(3), pp.322-339.
Fatima, A. and Linnes, C., 2019. The Current Status of Business Intelligence: A Systematic
Literature Review.
Fernández-Manzano, E. P., Neira, E. and Clares-Gavilán, J., 2016. Data management in
audiovisual business: Netflix as a case study. El profesional de la información (EPI).
25(4). pp.568-576.
Jain, V. K., 2017. Big Data and Hadoop. Khanna Publishing.
Kumar, A., 2018. Implementation core Business Intelligence System using modern IT
Development Practices (Agile & DevOps). International Journal of Management, IT
and Engineering. 8(9). pp.444-464.
Russo, J.A., 2019. The Impact of a Short Test-Wiseness Intervention on Standardised Numeracy
Assessment Scores: A Cautionary Tale about Using NAPLAN Growth Data to Evaluate
Primary Schools. Networks: An Online Journal for Teacher Research, 21(2), p.5.
Sultan, J.B., 2020. Characteristics of remedial students in learning numeracy and programs that
enhance the achievement.