Using Numeracy

at
Categories
Tags

 

This part covers Learning Outcomes 1 and 2 of the module.
Question 1
Explain the terms (a) numerator, (b) denominator.
(4 marks)
Question 2
Express 24/40 and 18/42 in their simplest forms.
(4 marks)
Question 3
a) Express the fractions 2/3, 3/4 and 5/6 as equivalent fractions with a denominator of
12.
(3 marks)
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?
(4 marks)
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.
(6 marks)
Question 5
a) What is 240.50 x 19.54? Give your answer to 2 significant figures.
(4 marks)
b) Write the number 52100 as a power of 10.
(2 marks)
Page 4 of 12
[565]
Question 6
a) As a promotional offer, a new gym is offering a 30% discount to those who sign
up in the first month. Patty and her 2 siblings take advantage of the offer and
sign up for total amount of £210. What were the total savings made? Show
your working.
(5 marks)
b) Work out the average savings per person.
(3 marks)
Question 7
Work out the following:
a) 3/4 – 7/9 + 2/3
(4 marks)
b) Which is the largest of the following numbers?
0.1, 0.02, 0.003, 0.0004, 0.00005
(2 marks)
Question 8
90 men and 60 women were asked if they had watched the latest ‘Expendables’ movie.
Altogether 3/5 of the people said Yes.
3/10 of the women said Yes.
What percentage of the men said No? (Show your working)
(7 marks)
Question 9
Annabelle lives at Bermondsey in London. She has to speak at a conference in
Birmingham at 10.30am. It will take her an hour from her home to get to Euston Rail
Station, from where she will get a train to Birmingham. The train journey from Euston
to Birmingham is an hour and 10 minutes. Trains to Birmingham run at the following
times: 5 minutes past the hour, 25 minutes past the hour and 45 minutes past the
hour. The meeting venue in Birmingham is a 5-minute walk from the station. What is
the latest time that Annabelle can leave home, if she is to make it on time for
the meeting in Birmingham? Show your working.
(8 marks)
Question 10
A box of Shredded Wheat weighs 0.35 kg and a box of Weetabix weighs 9/25 kg?
Which box is heavier? Show your working.
(4 marks)
(Part 1 – 60 marks)
(LOs: 1 & 2)
Page 5 of 12
[565]
Part 2 – Using Data (40 Marks)
This part covers Learning Outcome 2 of the module.
Given below is the Medals Table for Summer Olympic Games
11)
a) Which country had the lowest number of overall medals among the ten
countries?
(2 marks)
b) Which country/countries competed in the least number of games?
(2 marks)
c) What is the mode in the number of games countries participated in?
(2 marks)
d) What is the range between the gold medals awarded to the 10
countries?
(3 marks)
e) How many countries got more silver medals than bronze medals?
(3 marks)
Page 6 of 12
[565]
f) Apart from the United States, which country/countries got more gold
medals, more silver medals and more bronze medals than Great
Britain?
(3 marks)
g) In comparing the number of games a country participated in and the
overall number medals received, which country did the best (i.e.
highest number of medals received per game)? Show your working
to justify your answer.
(6 marks)
h) Using the given data, give TWO likely reasons why a country like
Jamaica does not feature in the top 10 medals even though it does very
well in athletics.
(6 marks)
i) Using the given information, determine the medal category in which the
United States far outperformed its closest competitor. Show your
working to justify your answer.
(6 marks)
j) Which 3 countries had the most evenly distributed number of gold,
silver and bronze medals (i.e. least smallest range)? Show your
working.
(7 marks)
(Part 2 – 40 marks)
(LOs: 2)
Part 3 – Using IT (100 Marks)
This part requires the use of Microsoft Excel. Covers Learning Outcomes 3 & 4
12. Create the spreadsheet below using Excel. Include the rows and columns
identifiers, text formatting and column highlighting as shown.
(15 marks)
Page 7 of 12
[565]
13)
a) What actions or steps in Excel can you take to rank them from 1st to 10th
.
(4 marks)
b) State the specific action(s) or step(s) in Excel that will produce a list/display
of those countries with 800 or more medals in total?
(4 marks)
c) Which type of graph will be suitable for representing only gold medals
information?
(2 marks)
d) In which column(s) might replication have been used?
(2 marks)
e) What Excel formula can be used to calculate the overall total medals
awarded?
(3 marks)
14) Write the Excel functions for the following: (5 Marks each)
a. Give the total number of medals for Germany and Great Britain.
b. Give the average number of silver medals for a European country,
c. Sum the Medals Total for Gold for those countries with less than 20
games involvement.
d. Search the database (the whole spreadsheet) to find ‘Italy’ and also the
corresponding Medals Total.
15) By using Microsoft Excel and provide screenshots:
Page 8 of 12
[565]
a) Calculate the median number of medals for each medal type, stating the
formula you would use for determining the median for the gold medals.
(5 marks)
b) Calculate the mean number of medals for each of the 3 medal types, stating
the formula you would use for determining the mean for the bronze medals.
(5 marks)
c) Calculate the standard deviation of the total medals awarded to each country
(column F) using the formula below. Show all the steps (full working).
Hint: You can use the STDEV.P function to cross-check your final answer.
(10 marks)
d) Using the given spreadsheet as a basis, discuss the usefulness of a standard
deviation in a given dataset. You need to cite any literature sources you use.
(10 marks)
16) By using Microsoft Excel:
a) Produce an appropriate fully labeled chart in Excel to compare the gold, silver
and bronze medals totals of the 10 countries.
(10 marks)
b) Use a suitable and fully labeled chart in Excel to reflect the contribution of
each country to the overall medals total.
(10 marks)
(Part 3 – 100 marks)

 

Sample Solution

Using Numeracy

The first time you saw a fraction, you probably noticed that there were two numbers involved: a top number and a bottom number. When numbers are written in the form of a fraction, it can be represented as a/b, where a is the numerator, and b is the denominator. For example, 4/5 is a fraction, and the line separating the numbers 4 and 5 is the fraction bar. Here the number above the fraction bar is the numerator, and the one below the fraction bar is the denominator. A numerator represents the number of parts out of the whole, which is the denominator.

It appears everything is moving on the web nowadays. Indeed, even our instruction is moving onto the web. Numerous individuals may quarrel about the impediments of this marvels, yet today, I need to talk about the upsides of getting training on the web. This is a relevant subject, as the eventual fate of instruction is moving increasingly more towards moving physical instructive organizations on the web. There are explanations behind this: multiple occasions you can realize anything you desire, it is increasingly agreeable in an assortment of ways, online courses frequently look great on resumes, the pacing of learning is overseen by the student, and the expense of virtual instruction is regularly lower than conventional training. The opportunity to pick your instructive way is a suffering nature of online training. For progressively inventive individuals, or individuals who need to concentrate on a solitary action, this can be a fantasy materialized. As indicated by elearning Industry, “You can pick the program you had always wanted in conventional training, as well, however that would include voyaging endlessly from home, living in a totally obscure city, and battling in an amazingly aggressive learning condition. With online instruction, you can take any program or course present in conventional four-year colleges” (Norman, Stephanie). Along these lines, the straightforward entry to the courses and majors you are endeavoring to consider are generally accessible on the web. This builds chances to pick up the training we want as opposed to making unnecessary trade offs. Like the last point, comfort becomes the dominant focal point for some understudies. Incalculable understudies pick online instruction so as to abstain from sitting around voyaging and on numerous different exercises so as to go to physical training organizations. As indicated by the Open Education Database, “Ads that element online understudies concentrating in their night robe just skims the outside of one of the advantages of online instruction: no physical class sessions. Understudies tune in to addresses and complete assignments sent to them electronically, with no compelling reason to battle traffic, go home right on time for class, or miss significant family time. As opposed to miss significant class sessions (because of climate conditions), understudies in online courses can generally “visit” by taking an interest in discourse loads up or talk sessions, turning in their work on schedule, and watching talks or understanding materials” (“10 Advantages of Taking Online Classes”). As such, by being an online understudy, you circumnavigate a large number of the issues that ordinary understudies suffer consistently. Furthermore, numerous businesses are glad to see online seminars on resumes. Numerous scouts consider the to be of online courses as an indication of stepping up to the plate. As expressed by Pongo Resume, “Bosses regard a degree earned online as much as a degree earned from going to a physical school. They comprehend that with the mechanical advances we have today, an ever increasing number of representatives are getting their instruction and preparing on the web. Since employing supervisors esteem proceeding with instruction and expert advancement, having the applicable courses and projects in the training area of your resume will exhibit that you are creative and have stepped up and remain on top of things and improve expertly” (“The Advantages of Online Learning for You and Your Career”). Along these lines, not exclusively is online training seen as equivalent to standard instruction by managers, however it is additionally seen as being equipped in the most recent advancements and patterns. Back to the understudies, one of the extraordinary points of interest of online instruction is that students can learn at their very own pace. As per eLearning Industry, “This kind of framework doesn’t require going to live sessions; you can get to the materials whenever that works for you. In the event that you need to work or deal with your home and youngsters during the day, you can learn around evening time. That is a bit of leeway the conventional instructive framework can’t beat” (Norman, Stephanie). Likewise, individuals who need to set aside a more drawn out effort to get a degree can do as such with no weight. At last, the expense of getting online training is less expensive all things considered than accepting customary instruction. As indicated by the Open Education Database, “However not every single online degree offer more affordable net educational cost costs than conventional schools, related costs quite often cost less. For instance, there are no driving expenses, and now and again required course materials, for example, reading material, are accessible online at no expense. Likewise, numerous schools and colleges acknowledge credits earned by means of free monstrous open online courses (MOOCs), the latest development in online instruction” (“10 Advantages of Taking Online Classes”). In this manner, there are an assortment of reasons why online instruction costs less. Getting online training is turning out to be increasingly more well known because of a large number of preferences it has over customary guidance. These preferences incorporate, to give some examples: understudies can realize anything they desire, it is increasingly agreeable, online courses frequently look extraordinary on resumes, the pacing of learning is overseen by the student, and the expense is regularly lower than conventional instruction. With these reasons, it is difficult to not perceive any reason why this type of instruction is on the ascent. Works Cited Norman, Stephanie. “5 Advantages Of Online Learning: Education Without Leaving Home.” eLearning Industry, 3 Aug. 2017, elearningindustry.com/5-favorable circumstances of-web based learning-instruction without-venturing out from home. “10 Advantages of Taking Online Classes.” OEDB.org, Copyright © 2006-2019 OEDb – Accredited Online, Specialty, and Campus-Based Colleges, 10 Aug. 2018, oedb.org/ilibrarian/10-favorable circumstances to-taking-online-classes/.

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.
Hi, how can I help?