Using Numeracy Data & IT Portfolio of Tasks

Using Numeracy, Data
and IT Portfolio of
Task

Contents
Contents...........................................................................................................................................2
INTRODUCTION...........................................................................................................................6
TASK 1............................................................................................................................................6
Define the terms:..........................................................................................................................6
TASK 2............................................................................................................................................6
Express 24/40 and 18/42 in its lowest forms...............................................................................6
TASK 3............................................................................................................................................7
a) Solve the fractions 2/3, 3/4 and 5/6 with a denominator of 12................................................7
b) If computing books are two-thirds of the remainder. What is the percentage of the
computing books in library?........................................................................................................8
TASK 4............................................................................................................................................8
Calculate the price of each pair of running shoes with full working...........................................8
TASK 5............................................................................................................................................9
a) Define 240.50 x 19.54 in 2 significant figures after decimal..................................................9
b) Compose the figure 52100 as a power of 10...........................................................................9
TASK 6............................................................................................................................................9
a) Compute total savings made by 3 siblings and show working of the answer.........................9
b) Calculate average savings per sibling.....................................................................................9
TASK 7............................................................................................................................................9
a) Elaborate 3/4 - 7/9 + 2/3..........................................................................................................9
b) Find the largest of the following numbers- 0.1, 0.02, 0.003, 0.0004, 0.00005?......................9
TASK 8..........................................................................................................................................10
What was the percentage of men who said No with working?..................................................10
TASK 9..........................................................................................................................................10
If Annabelle has to reach on time for the meeting in Birmingham, what is the latest time that
she can leave home, Show your working..................................................................................10
TASK 10........................................................................................................................................11
A box of Weetabix weighs 9/25 kg and a box of Shredded Wheat weighs 0.35 kg and? Which
one of the box is heavier?..........................................................................................................11
TASK 11.........................................................................................................................................11
a) Which country has the lowest number of medals among the ten countries?.........................11
b) Which countries competed in the minimum number of total games?...................................11

c) Calculate the mode from the number of games countries took part in?................................11
d)What is the range between the gold medals awarded to the 10 countries?............................11
e) Determine the number of countries who got more silver medals than bronze medals?........11
f) Other than United States, which country got more silver medals, more gold medals and
more bronze medals than Great Britain?...................................................................................11
g) Which country did the received highest number of medals per game? Justify the answer.. .12
h) Give two reasons why a country like Jamaica does not feature in the top 10 medals after
doing very well in athletics........................................................................................................12
i) Ascertain each medal category in which the United States outperformed its closest
competitor, using the given information....................................................................................13
j) Which 3 countries have the most equally distributed gold, silver and bronze medals in the
smallest range............................................................................................................................13
TASK 12........................................................................................................................................14
Create the worksheet using Excel which includes the text formatting, columns and rows
headings and column highlighting as shown.............................................................................14
TASK 13........................................................................................................................................14
a) What steps in Excel will be taken to rank the countries from 1st to 10th.............................14
b) State the specific steps in Excel that will make a list of those countries with 800 or more
medals in total?..........................................................................................................................14
c) Which type of graph will be suitable for representing only gold medals information?........15
d) In which columns might reproduction have been used?.......................................................15
e) Which formula will be used in Excel to compute the total medals honoured?.....................15
TASK 14........................................................................................................................................16
a) Give the total number of medals for Germany and Great Britain using Excel Function......16
b) Calculate the average number of silver medals for a European country, using Excel..........16
c) Sum the Medals Total for Gold for those countries with less than 20 games involvement...16
d) Search the whole database to find ‘Italy’ and also the proportionate Medals Total, using
Excel..........................................................................................................................................16
TASK 15........................................................................................................................................16
a) Compute the median for each medal type, giving the formula used for finding the median
for the gold medals, using Microsoft Excel and attach the screenshot......................................16
b) Calculate the mean for each type of medal, state the formula which can be used for
determining the mean for the bronze medals, using Excel and give the screenshot..................17
c) Find out the standard deviation of total number of medals granted to each country using the
formula. Show all the steps........................................................................................................18
d) Using the data sheet as a basis, discuss the use of standard deviation from the given data..19
TASK 16........................................................................................................................................20

Use an appropriate labelled chart to compare the gold, silver and bronze medals in Excel of all
the countries given.........................................................................................................................20
Use a suitable labelled chart to show the share of total medals of each country in Excel.........20
CONCLUSION..............................................................................................................................21
REFERENCES..............................................................................................................................22

INTRODUCTION
This report presents the calculation and analysis of the numeric data. Numeracy means
the skills and behaviour one need to solve the mathematical problems. These skills are needed in
the arithmetic dealings in addition, subtraction, multiplication, and division. This ability of
solving is used in day to day activities for the fundamental calculations. The concept of
numeracy is applied on even a small calculation in everyday activities, such as understanding of
the numbers, sorting accordingly to the question demanding and thinking which type of numeric
problem is this. Fractions represents the number as a whole. It includes numerator and
denominator. It can be proper, improper and mixed portion. The highest and the lowest common
factor, is used to solve the fractions to its simplest or lowest forms. The data interpretation is
used for the analysis of the statistical data (Behle and Behle, 2017). Excel is used for the
calculation of statistical data and the function used to find out the solution and to interpret the
data.
TASK 1
Define the terms:
(a) Numerator: It is the part of the fraction which lies above the line. When a certain portion is
given as a/b, where a is the numerator and b is the denominator. In other words, the above
number above the bar signifies the numerator. For example, 5/9 is the fraction given in the
question. So, here 5 will be the numerator.
(b) Denominator: It is the bottom number of a fraction, which lies under the line. It represents
the number of equal parts an item will be divided into. A denominator can never be zero. For
example, 15/9 is the fraction. Here, 9 is the denominator, which means that the numerator 15 will
be divided by 9 to get the number. It is also known as the divisor (Cavadel and Frye, 2017).

TASK 2
Express 24/40 and 18/42 in its lowest forms.
Simplest Forms: It the term which is commonly used in fractions where no common
factor other than is present in the numerator and denominator. It basically means reducing the
factor to its lowest terms.
Steps of simplifying fractions:
1. Find the Highest Common Factor (HCF) of numerator and denominator.
2. Divide both the numerator and denominator by the HCF.
3. The faction will be in its lowest form (Civil, Stoehr and Salazar, 2020).
a) 24/40: It can be simplified in the following steps:
1. HCF of 24/80 is 8.
2. Divide 24 and 40 by 8
3. 3/5 will come.
Simplest form of 24/40 is 3/5.
b) 18/42: The simplification steps are:
1. HCF of 18/42 is 6
2. Divide 18 and 42 by 6
3. 3/7 will come
Lowest form of 18/42 is 3/7.
TASK 3
a) Solve the fractions 2/3, 3/4 and 5/6 with a denominator of 12.
The denominator given is 12.
 2/3: The steps will need to be followed for the calculation are:
1. The denominator given is 12, it will be divided by 3. The value will come by dividing
12/3 = 4
2. After this, numerator and denominator will be multiplied by 4
3. After multiplying, the fraction will be 8/12
 3/4