Reference no: EM132420639
DAT0001B - Using Numeracy, Data and IT - Arden University
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?