Using Numeracy Data & IT Portfolio of Tasks
Added on 2023-06-15
17 Pages4354 Words287 Views
Data Science and Big Data
|
|
|
Numeracy, Data & IT
Table of Contents
INTRODUCTION ..........................................................................................................................3
TASK ..............................................................................................................................................3
Part 1 Using Numeracy...............................................................................................................3
Part 2 Using Data........................................................................................................................7
Part 3 Information Technology...................................................................................................9
CONCLUSION .............................................................................................................................16
REFERENCES..............................................................................................................................17
INTRODUCTION ..........................................................................................................................3
TASK ..............................................................................................................................................3
Part 1 Using Numeracy...............................................................................................................3
Part 2 Using Data........................................................................................................................7
Part 3 Information Technology...................................................................................................9
CONCLUSION .............................................................................................................................16
REFERENCES..............................................................................................................................17
INTRODUCTION
This report is based on the understanding of fundamentals of mathematics in relation to data
and numeracy. It will have solutions to some mathematical problems to know the basics of
mathematics and statistics and understand them better by doing. Use of spreadsheet is done
as the second and third part of this report talks about effectively using data, forming charts
and applying excel functions (Andrade, 2020). It contains topics such as, fractions,
percentage, decimal, logical reasoning, mean, mode, median and various excel function with
graphical representation.
TASK
Part 1 Using Numeracy
Question 1
Explain the terms
(a) Numerator: The word Numerator is derived from Latin verb,'enumerate' which means to
count (Bernard, and Senjayawati, 2019). It is the upper integer in the fraction which counts how
many units are considered from a whole. For example: 2/3 means the two units from a whole
which in total is divided into three units are considered. 2 here is the numerator.
(b) Denominator: The word Denominator is derived from the Latin word 'Nomen' which means
name (Harrisson, 2018). Hence the denominator of a fraction 'names' it. It is the lower part of the
fraction which tells in how much units is the whole divided. For example: 2/5 two-fifth of the
whole is considered. 5 here is the denominator, the whole is divided into 5 equal parts and only
two from these are considered.
Question 2
Express 24/40 and 18/42 in their simplest forms.
24/40 (dividing the fraction by 2)
24/40 = 12/20 = 6/10 = 3/5
3/5 is the simplest form of 24/40
18/42 (dividing the fraction by 2)
18/42= 9/21 (now dividing this further by 3)
9/21 = 3/7
3/7 is the simplest form of 18/42
This report is based on the understanding of fundamentals of mathematics in relation to data
and numeracy. It will have solutions to some mathematical problems to know the basics of
mathematics and statistics and understand them better by doing. Use of spreadsheet is done
as the second and third part of this report talks about effectively using data, forming charts
and applying excel functions (Andrade, 2020). It contains topics such as, fractions,
percentage, decimal, logical reasoning, mean, mode, median and various excel function with
graphical representation.
TASK
Part 1 Using Numeracy
Question 1
Explain the terms
(a) Numerator: The word Numerator is derived from Latin verb,'enumerate' which means to
count (Bernard, and Senjayawati, 2019). It is the upper integer in the fraction which counts how
many units are considered from a whole. For example: 2/3 means the two units from a whole
which in total is divided into three units are considered. 2 here is the numerator.
(b) Denominator: The word Denominator is derived from the Latin word 'Nomen' which means
name (Harrisson, 2018). Hence the denominator of a fraction 'names' it. It is the lower part of the
fraction which tells in how much units is the whole divided. For example: 2/5 two-fifth of the
whole is considered. 5 here is the denominator, the whole is divided into 5 equal parts and only
two from these are considered.
Question 2
Express 24/40 and 18/42 in their simplest forms.
24/40 (dividing the fraction by 2)
24/40 = 12/20 = 6/10 = 3/5
3/5 is the simplest form of 24/40
18/42 (dividing the fraction by 2)
18/42= 9/21 (now dividing this further by 3)
9/21 = 3/7
3/7 is the simplest form of 18/42
Question 3
a) Express the fractions 2/3, 3/4 and 5/6 as equivalent fractions with a denominator of 12.
To convert each denominator into 12, multiplication of the whole fraction would be done
with an integer that would result in 12 as denominator.
2*4/ 3*4 = 8/12
3*3/ 4*3 = 9/12
5*2/ 6*2 = 10/12
Hence, the fractions 2/3, ¾ and 5/6 has converted with the denominator as 12 are
8/12, 9/12 and 10/12, respectively.
b) A library contains 60,000 books. 14,000 are on the subject of 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?
Total Books in the library are= 60000
Business Books= 14000
Healthcare Books= 22000
Psychology and law books= 12000
Remaining books in the library are= 60000-(14000+22000+12000)
= 12000
Books on computing are= 12000*2/3 = 8000
Percentage of computing books in the library are= 8000/60000*100
= 13.3%
Question 4
A sports shop in Manchester is doing a sale on some merchandise. Liz hears about it and goes to
make a purchase of two pairs of running shoes. She gives the sales attendant in the store three
crisp £50 notes and is given change of £10.50. What is the price of each pair of running shoes?
Show your working.
Total amount given by her to the shop= 50* 3= £150
Change she received= £10.50
Total cost of two pair of shoes= £150-£10.50 = £139.5
Cost per pair of shoes= £139.5/2 = £69.75
a) Express the fractions 2/3, 3/4 and 5/6 as equivalent fractions with a denominator of 12.
To convert each denominator into 12, multiplication of the whole fraction would be done
with an integer that would result in 12 as denominator.
2*4/ 3*4 = 8/12
3*3/ 4*3 = 9/12
5*2/ 6*2 = 10/12
Hence, the fractions 2/3, ¾ and 5/6 has converted with the denominator as 12 are
8/12, 9/12 and 10/12, respectively.
b) A library contains 60,000 books. 14,000 are on the subject of 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?
Total Books in the library are= 60000
Business Books= 14000
Healthcare Books= 22000
Psychology and law books= 12000
Remaining books in the library are= 60000-(14000+22000+12000)
= 12000
Books on computing are= 12000*2/3 = 8000
Percentage of computing books in the library are= 8000/60000*100
= 13.3%
Question 4
A sports shop in Manchester is doing a sale on some merchandise. Liz hears about it and goes to
make a purchase of two pairs of running shoes. She gives the sales attendant in the store three
crisp £50 notes and is given change of £10.50. What is the price of each pair of running shoes?
Show your working.
Total amount given by her to the shop= 50* 3= £150
Change she received= £10.50
Total cost of two pair of shoes= £150-£10.50 = £139.5
Cost per pair of shoes= £139.5/2 = £69.75
Using Numeracy, Data
and IT Portfolio of
Task
and IT Portfolio of
Task
Contents
INTRODUCTION...........................................................................................................................5
TASK 1............................................................................................................................................5
Define the terms:..........................................................................................................................5
TASK 2............................................................................................................................................6
Express 24/40 and 18/42 in its lowest forms...............................................................................6
TASK 3............................................................................................................................................6
a) Solve the fractions 2/3, 3/4 and 5/6 with a denominator of 12................................................6
b) If computing books are two-thirds of the remainder. What is the percentage of the
computing books in library?........................................................................................................7
TASK 4............................................................................................................................................7
Calculate the price of each pair of running shoes with full working...........................................7
TASK 5............................................................................................................................................8
a) Define 240.50 x 19.54 in 2 significant figures after decimal..................................................8
b) Compose the figure 52100 as a power of 10...........................................................................8
TASK 6............................................................................................................................................8
a) Compute total savings made by 3 siblings and show working of the answer..........................8
b) Calculate average savings per sibling......................................................................................8
TASK 7............................................................................................................................................8
a) Elaborate 3/4 - 7/9 + 2/3..........................................................................................................8
b) Find the largest of the following numbers- 0.1, 0.02, 0.003, 0.0004, 0.00005?......................9
TASK 8............................................................................................................................................9
What was the percentage of men who said No with working?....................................................9
INTRODUCTION...........................................................................................................................5
TASK 1............................................................................................................................................5
Define the terms:..........................................................................................................................5
TASK 2............................................................................................................................................6
Express 24/40 and 18/42 in its lowest forms...............................................................................6
TASK 3............................................................................................................................................6
a) Solve the fractions 2/3, 3/4 and 5/6 with a denominator of 12................................................6
b) If computing books are two-thirds of the remainder. What is the percentage of the
computing books in library?........................................................................................................7
TASK 4............................................................................................................................................7
Calculate the price of each pair of running shoes with full working...........................................7
TASK 5............................................................................................................................................8
a) Define 240.50 x 19.54 in 2 significant figures after decimal..................................................8
b) Compose the figure 52100 as a power of 10...........................................................................8
TASK 6............................................................................................................................................8
a) Compute total savings made by 3 siblings and show working of the answer..........................8
b) Calculate average savings per sibling......................................................................................8
TASK 7............................................................................................................................................8
a) Elaborate 3/4 - 7/9 + 2/3..........................................................................................................8
b) Find the largest of the following numbers- 0.1, 0.02, 0.003, 0.0004, 0.00005?......................9
TASK 8............................................................................................................................................9
What was the percentage of men who said No with working?....................................................9
TASK 9............................................................................................................................................9
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.....................................................................................9
TASK 10........................................................................................................................................10
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?..........................................................................................................10
TASK 11.........................................................................................................................................10
a) Which country has the lowest number of medals among the ten countries?.........................10
b) Which countries competed in the minimum number of total games?...................................10
c) Calculate the mode from the number of games countries took part in?................................10
d)What is the range between the gold medals awarded to the 10 countries?............................10
e) Determine the number of countries who got more silver medals than bronze medals?........10
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.. .11
h) Give two reasons why a country like Jamaica does not feature in the top 10 medals after
doing very well in athletics........................................................................................................11
i) Ascertain each medal category in which the United States outperformed its closest
competitor, using the given information....................................................................................12
j) Which 3 countries have the most equally distributed gold, silver and bronze medals in the
smallest range.............................................................................................................................12
TASK 12........................................................................................................................................12
Create the worksheet using Excel which includes the text formatting, columns and rows
headings and column highlighting as shown.............................................................................12
TASK 13........................................................................................................................................13
a) What steps in Excel will be taken to rank the countries from 1st to 10th..............................13
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.....................................................................................9
TASK 10........................................................................................................................................10
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?..........................................................................................................10
TASK 11.........................................................................................................................................10
a) Which country has the lowest number of medals among the ten countries?.........................10
b) Which countries competed in the minimum number of total games?...................................10
c) Calculate the mode from the number of games countries took part in?................................10
d)What is the range between the gold medals awarded to the 10 countries?............................10
e) Determine the number of countries who got more silver medals than bronze medals?........10
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.. .11
h) Give two reasons why a country like Jamaica does not feature in the top 10 medals after
doing very well in athletics........................................................................................................11
i) Ascertain each medal category in which the United States outperformed its closest
competitor, using the given information....................................................................................12
j) Which 3 countries have the most equally distributed gold, silver and bronze medals in the
smallest range.............................................................................................................................12
TASK 12........................................................................................................................................12
Create the worksheet using Excel which includes the text formatting, columns and rows
headings and column highlighting as shown.............................................................................12
TASK 13........................................................................................................................................13
a) What steps in Excel will be taken to rank the countries from 1st to 10th..............................13
b) State the specific steps in Excel that will make a list of those countries with 800 or more
medals in total?..........................................................................................................................13
c) Which type of graph will be suitable for representing only gold medals information?........14
d) In which columns might reproduction have been used?........................................................14
e) Which formula will be used in Excel to compute the total medals honoured?......................14
TASK 14........................................................................................................................................14
a) Give the total number of medals for Germany and Great Britain using Excel Function......14
b) Calculate the average number of silver medals for a European country, using Excel..........14
c) Sum the Medals Total for Gold for those countries with less than 20 games involvement...15
d) Search the whole database to find ‘Italy’ and also the proportionate Medals Total, using
Excel..........................................................................................................................................15
TASK 15........................................................................................................................................15
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......................................15
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..................16
c) Find out the standard deviation of total number of medals granted to each country using the
formula. Show all the steps........................................................................................................17
d) Using the data sheet as a basis, discuss the use of standard deviation from the given data.. 18
TASK 16........................................................................................................................................19
Use an appropriate labelled chart to compare the gold, silver and bronze medals in Excel of all
the countries given.........................................................................................................................19
Use a suitable labelled chart to show the share of total medals of each country in Excel.........19
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................20
medals in total?..........................................................................................................................13
c) Which type of graph will be suitable for representing only gold medals information?........14
d) In which columns might reproduction have been used?........................................................14
e) Which formula will be used in Excel to compute the total medals honoured?......................14
TASK 14........................................................................................................................................14
a) Give the total number of medals for Germany and Great Britain using Excel Function......14
b) Calculate the average number of silver medals for a European country, using Excel..........14
c) Sum the Medals Total for Gold for those countries with less than 20 games involvement...15
d) Search the whole database to find ‘Italy’ and also the proportionate Medals Total, using
Excel..........................................................................................................................................15
TASK 15........................................................................................................................................15
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......................................15
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..................16
c) Find out the standard deviation of total number of medals granted to each country using the
formula. Show all the steps........................................................................................................17
d) Using the data sheet as a basis, discuss the use of standard deviation from the given data.. 18
TASK 16........................................................................................................................................19
Use an appropriate labelled chart to compare the gold, silver and bronze medals in Excel of all
the countries given.........................................................................................................................19
Use a suitable labelled chart to show the share of total medals of each country in Excel.........19
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................20
Using Numeracy, Data
and IT Portfolio of
Task
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
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
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
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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Numeracy, Data & IT: Fractions, Calculations, and Olympics Medal Analysislg...
|15
|3346
|221
Using Numeracy Data & ITlg...
|22
|3680
|421
Numeracy, Data & IT: Using Numeracy, Data Analysis and IT Skillslg...
|22
|3447
|345
Numeracy, Data & IT: Basic Arithmetic, Fractions, Olympics Medal Table Analysis, Excel Functionslg...
|21
|3639
|202
Using Numeracy, Data & ITlg...
|22
|2786
|224
Using Numeracy Data and IT - Deskliblg...
|22
|3449
|483