# DAT0001B Using Numeracy, Data & IT By Assignment Experts UK

**DAT0001B Using Numeracy, Data & IT**

Portfolio of Tasks

## Assignment Brief

As part of the formal assessment for the programme you are required to submit a **Using Numeracy, Data and IT **assignment. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments.

## Learning Outcomes:

After completing the module, you should be able to:

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

Your assignment should include: a title page containing your student number, the module name, the submission deadline and a word count; the appendices if relevant; and a reference list in Arden University (AU) Harvard format. You should address all the elements of the assignment task listed below. Please note that tutors will use the assessment criteria set out below in assessing your work.

**Maximum word count: **3000 words

**DAT0001B Using Numeracy, Data & IT**

*Please note that exceeding the word count by over 10% will result in a reduction in grade by the same percentage that the word count is exceeded.*

**You must not include your name **in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number.

# Assessment Weighting: Parts 1 & 2 together (20%), Part 3 (80%)

## Assignment Task: **DAT0001B Using Numeracy, Data & IT**

**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

## Question 5

a) What is 240.50 x 19.54? Give your answer to 2 significant figures.

b) Write the number 52100 as a power of 10 (6 marks)

**(4 marks)**

**(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**

b) Work out the average savings per person. (5 marks)

**(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)

**DAT0001B Using Numeracy, Data & IT**

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

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

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

** This part requires the use of Microsoft Excel. Covers Learning Outcomes 3 & 4**

**Create the spreadsheet below using Excel**. Include the rows and columns identifiers, text formatting and column highlighting as shown. (15 marks)

13)

a) What **actions or steps in Excel **can you take to rank them from 1^{st} to 10^{th}. (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)*

- Give the total number of medals for Germany and Great Britain.
- Give the average number of silver medals for a European country,
- Sum the Medals Total for Gold for those countries with less than 20 games involvement.
- Search the database (the whole spreadsheet) to find ‘
**Italy’**and also the corresponding Medals Total.

## 15) By using Microsoft Excel and provide screenshots:

**DAT0001B Using Numeracy, Data & IT**

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). (10 marks) **Hint: **You can use the STDEV.P function to cross-check your final answer.

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) ****(LOs: 3 & 4)**

**End of questions**

**Formative Feedback**

You have the opportunity to submit a portfolio of tasks to receive formative feedback.

The feedback is designed to help you develop areas of your work and it helps you develop your skills as an independent learner.

If you are a distance learning student, you should submit your work, by email, to your tutor, no later than 2 weeks before the actual submission deadline. If you are a blended learning student, your tutor will give you a deadline for formative feedback and further details.

Formative feedback will not be given to work submitted after the above date or the date specified by your tutor - if a blended learning student

## Guidelines: **DAT0001B Using Numeracy, Data & IT**

You **MUST **underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using the AU Harvard system(s).

The My Study Skills Area on iLearn contains useful resources relating to referencing.

*Additional notes:*

*Students are required to indicate the exact word count on the title page of the assessment.*

*The word count excludes the title page, tables, figures, diagrams, footnotes, reference list and appendices. Where assessment questions have been reprinted from the assessment brief these will also be excluded from the word count. ALL other printed words ARE included in the word count. See ‘Word Count Policy’ on the homepage of this module for more information*

## Submission Guidance

**Assignments submitted late will not be accepted and will be marked as a 0% fail.**

Your assessment should be submitted as a single *Word (MS Word) or PDF *file. For more information please see the “Guide to Submitting an Assignment” document available on the module page on iLearn.

You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is on the homepage of your module and also in the Induction Area).

**DAT0001B Using Numeracy, Data & IT**

Tailored to your instructions