Explain the terms (a) numerator, (b) denominator [Solved] Use basic numerical operations with whole numbers, integers, fractions and decimals

Assessment Task

Learning Outcomes

Guidance

Part 1 and Part 2 Weighting (20% of the module)

Part 1 (60 marks)

Part 2 (40 marks)

Part 3 Weighting (80% of the module)

Part 3 (100 marks)

This is a case study with 5 questions.

1. Use basic numerical operations with whole numbers, integers, fractions and decimals
2. Calculate ratios and proportions, percentages, averages
3. Construct and use appropriate graphical techniques to present simple data
4. Construct and use a spreadsheet application to record numerical data and use simple formula functions

Even though some questions in Section 1 specifically ask you to show working, you are encouraged to show working on all questions (as much as possible) in Section 1 of Part 1 and also in Part 2.

Please note that for Part 2, you are to use the given spreadsheet screenshot to answer the respective questions (that is, question 11). You are not to reproduce the given spreadsheet / table.

For Part 3, however, you will need to create the given spreadsheet to aid you in performing the given calculations and to enable you to create the necessary charts/graphs.

It is good practice to include references, if you source information for any of the questions in Part 2, making sure you use the Arden University Harvard Referencing Guide, which is available on iLearn.

Part 1 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)

1 & 2

1 & 2

Explain each term. Citing a reference for each term is not mandatory. For higher marks, give an example in each case.

In answering Question 2, reduce both fractions to their simplest terms.

In answering Question 3a, you are expected to convert each fraction but not to carry out any additions.

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)

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)

1 & 2

1 & 2

In answering Question 3b, visualise the scenario. The answer expected is a percentage, not the actual quantity number of computing books. You need to show your working.

In answering Question 4, again visualise the scenario: How much did she give them? How much change was she given? How much did she spend? What was the price of each pair of running shoes?

Again, show your working. This is a question about money, so your final answer should reflect this.

In answering Question 5a, remember that significant figures and decimal places are NOT the same thing.

In writing your answer for Question 5b, write the power of 10^x in a superscript format as shown (using the superscript formatter in Microsoft Word).

In answering Question 6a, think about what the discount means. What would have been the full price if there was no discount? How much are they saving? Do take note of the word ‘total’, reflecting how much was paid altogether (as a group) by Patty and her siblings. Show your working. This is a question about money, so your final answer should reflect this.

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

1 & 2

In answering Question 6b, please note that you will need the answer to Question 6a to be able to get the savings amount. Show your working. This is a question about money, so your final answer should reflect this.

In answering Question 7a, please show your working.

In answering Question 7b, explain your answer.

In answering Question 8, it is important to note that every piece of information given is useful. Show your working. Your final answer should be a percentage.

In answering Question 9, the focus is on the latest time that Annabelle can leave home without getting to the conference location later than 10.30am. Also note the train times and the journey times from home to the train station and from the train station to Birmingham, and the journey time from the station to the conference centre.

Show your full working.

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)

. Total Marks for Part 1 is 60.

In answering Question 10, please show your working.

Part 2 – Using Data (40 Marks)

Given below is Medals Table for one of the recent Olympic Games

2

In answering Part 2, use only the given information in the medals table, showing your working wherever possible. Do not reproduce/create the spreadsheet.

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)

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. smallest range) ? Show your working.

(7 marks)

Total Marks for Section 2 is 40.

Part 3 (80% of the module)

This part requires the use of Microsoft Excel.

12. Create the spreadsheet below using Excel. Include the rows and columns identifiers, text formatting and column highlighting as shown.

(15 marks)

3 & 4

In answering the questions for this section, use the given spreadsheet screenshot to answer the questions that follow.

Reproduce the given spreadsheet, including the rows and columns labels, the headings and the gold, silver and bronze shading of the columns.

13.

a) What actions or steps in Excel can you take to rank them from 1^st 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

In answering Question 13a, please state the specific steps you would follow, in a bulleted or numbered fashion. This will involve noting the specific column and row labels and the appropriate tools on the Excel toolbars. There is more than one way to accomplish the sorting. Just explain ONE way of doing this.

In answering Question 13b, please state the specific steps you would follow, in a bulleted or numbered fashion. This will involve noting the specific column and row labels and the appropriate tools on the Excel toolbars. There is more than one way to accomplish the filtering. Just explain ONE way of doing this.

In answering Question 13c, just state a type of graph or chart that will be suitable for representing the Gold medals information (shown in Column C).

In answering Question 13d, ask yourself what replication is and why it might be used. With that understanding, you can then identify the

total medals awarded?

(3 marks)

14) Write the Excel functions for the following:

(5 Marks each)

1. Give the total number of medals for Germany and Great Britain.
2. Give the average number of silver medals for a European country,
3. Sum the Medals Total for Gold for those countries with less than 20 games involvement.
4. Search the database (the whole spreadsheet) to find

‘Italy’ and also the corresponding Medals Total. 

15)

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)

columns. You may add the reasons for your choices. [Don’t confuse rows with columns.]

In answering Question 13e, just state ONE formula you would use to get the Grand Total (as there can be more than one way to do this).

In answering Question 14, please ensure that for each of the 5 given sub-questions, you use the correct column label/letters and row numbers with the respective Excel functions. Also ensure that for each function used, you state it in the proper format.

In answering Question 15a, use your spreadsheet to calculate the median of the gold medals, median of the silver medals and median of the bronze medals. Also write the Excel formula you used in calculating the median of the gold medals. Use basic numerical operations with whole numbers, integers, fractions and decimals

In answering Question 15b, use your spreadsheet to calculate the mean of the gold medals, mean of the silver medals and mean of the bronze medals. Also write the Excel formula you used in calculating the mean of the gold medals.

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).

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.

a) Produce an appropriate fully-labeled chart to compare the gold, silver and bronze medals totals of the 10 countries.

(10 marks)

b) Use a suitable and fully-labeled chart to reflect the contribution of each country to the overall medals total.

(10 marks) Total Marks for Part 3 is 100.

In answering Question 15c, show all the intermediate steps used to calculate the standard deviation. Then verify your answer using the Excel standard deviation function, STDEV.P

In answering Question 15d, cite credible sources to support your answer. Make sure you use the AU Harvard Referencing format.

In answering Question 16, ensure that the charts are fully-labelled.