Reference no: EM132336674

Using Numeracy, Data and IT - Assessment

Learning Outcomes:

After completing the module, you should be able to:

1) Use basic numerical operations with whole numbers, integers, fractions and decimals.

2) Calculate and compare measures of central tendency.

3) Calculate compound interest.

4) Construct and use appropriate graphical techniques to present simple data.

5) Construct and use a spread sheet application to record numerical data and use appropriate formula functions.
6) Design numerical analyses in response to given problem situations.

Section 1

Question 1

What is the result of the following calculation? Leave your answer in a tally format.

Question 2

What percentage of 70 does 49 equate to?

Question 3

a) Complete the table to show equivalent fractions and percentages.

Fraction	Percentage
	45%
2/3
	22.5%
7/5

1) A carton contains 150 cereal bars.
What fraction of this number will each person get when distributed to a class of 20 students?

Question 4

Samuel paid cash for 3 discount-priced football tickets. He was given £4.20 change from the three £50 notes he tendered. What was the price of each ticket? Show your working.

Question 5

a) Solve this binary arithmetic: 10011 +10101

b) Write the number 0.0101 as a power of 10.

Question 6

As a promotional offer, a new hair salon offered its services at 20% discount for the first 2 weeks. Janice and her friends took advantage of the bargain and had their hair done for a total amount of £100. Show your working.

a) What were the total savings made?

b) Work out the average savings amount if 4 hairdos were done?

Question 7

Here are seven numbers.

5      12    12   8    4   10   5

a) Work out the mean of the seven numbers.

b) What is the mode of the seven numbers?

Question 8

80 men and 120 women were asked if they enjoyed watching football. Altogether 3 / 5 of the people said yes.
9 / 10 of the men said yes.

What fraction of the women said yes? (Show your working)

Question 9

The table shows information about the marks of 20 students in a test.

Mark	Frequency
14	2
15	5
16	4
17	4
18	5
	Total = 20

Students who scored less than the mean mark have to retake the test. How many students have to retake the test? You must show your working.

Question 10

Which fraction is bigger - 3/5 or 5/9?

Section 2

Given below is the payroll for a particular week for GGG Consulting.

GGG Consulting
Weekly Payroll
First Name	Surname	Gender	Hourly Rate	Hrs Worked	Gross Amount	Deductions	Net Amount
Andy	Brayton	M	£15.00	30	£450.00	E67.50	£382.50
8ronwyn	Dykes	F	£22.00	20	£440.00	£66.00	£374.00
Candice	Marfouche	F	£18.00	25	£450.00	£67.50	£382.50
Richard	Clement	M	E30.00	30	£900.00	£135.00	£765.00
Denise	Holten	F	E21.03	35	£735.00	£110.25	£624.75
Tanika	Hall	F	E12.00	28	£336.00	E50.40	£285.60
Sandra	Smith	F	E14.00	26	£364.00	E54.60	£309.40
Fred	Patridge	M	E18.00	40	£720.00	£108.00	£612.00
Patrice	Neville	F	E20.00	35	£700.00	£105.00	£595.00
Everett	Castlemain	M	£25.00	30	£750.00	£112.50	£637.50
Sunil	Praveen	M	£23.00	28	£644.00	£96.60	£547.40
Julia	Morkoe	F	£25.00	28	£700.00	£105.00	£595.00
Charlotte	Mess(	F	£17.00	30	£510.00	£76.50	£433.50
Brendan	Philips	M	£24.00	32	£768.00	£115.20	£652.80
Harry	Charleston	M	E30.00	30	£900.00	£135.00	£765.00
						Grand Total	£5,292.95
						Average Amount	£530.80

a) What actions or steps will you need to take to sort the given spreadsheet in alphabetical and ascending order of Firstname.

b) Write the command(s) to list/display only those who worked less than 35 hours in the week.

c) How many people earn above the given Average Amount?

d) Which type of graph will be suitable for representing the Net Amounts?

e) In which column(s) might replication have been used?

f) What formula results in the value in cell H20?

Question 11) Write the functions or commands for the following:

a. Give the total number of females.

b. Give the total number of records with hourly rate less than £25?

c. Give the total number of surnames with the letter ‘p' in them

d. Sum the Net Amount for the females who earned a Net Amount greater than or equal to £495.

e. Search the database (the whole spreadsheet) to find ‘Messi' and the corresponding Deductions.

Assessment Part 2

This part of the assessment covers Learning Outcomes 2, 3 and 4 and is worth 80% of the total marks for the module.

Students Monthly Spending, excluding accommodation, bills and transportation Monthly Expenditure (in pounds sterling)

Name	Campus	Marital Status	Food	Clothing	Entertainment	Charitable Giving
Jenny	London	S	160	230	80	0
Annie	Manchester	S	180	220	50	10
Haddy	Manchester	M	255	145	45	15
Martin	Birmingham	S	240	165	100	0
Ahmed	London	M	375	195	140	10
Sean	London	S	185	135	130	20
Alice	London	M	260	260	70	20
Belinda	London	M	320	140	105	15
Benjie	Birmingham	S	245	230	60	40
Barbara	Manchester	M	305	150	100	0
Liam	Birmingham	M	400	80	100	20

Managerial Report (max: 2000 words)

Comment on the spending information presented in the table above. Include the following in your report:

a. Totals, mean, median and standard deviation, together with a discussion of what these descriptive statistics tell us about their spending.

b. Graphical summaries for each of the four items.

c. Scatter diagrams to explore the relationship between marital status and each of the four spending items. Discuss.

d. What is the probability that a student spending more than £500 monthly would be both married and based in London?