Numeracy, Data and IT Assessment: A Practical Guide

Desklib provides solved assignments and past papers to help students succeed.

Using Numeracy, Data and IT
Assessment

Contents
List Of figures..................................................................................................................................3
Section 1..........................................................................................................................................5
Question 1....................................................................................................................................5
Question 2....................................................................................................................................6
Question 3:...................................................................................................................................7
Question 4....................................................................................................................................9
Question 5..................................................................................................................................10
Question 6..................................................................................................................................11
Question 7..................................................................................................................................12
Question 8..................................................................................................................................13
Question 9..................................................................................................................................14
Question 10................................................................................................................................15
Section 2........................................................................................................................................16
11 Solution:....................................................................................................................................16
11 a):..........................................................................................................................................16
11 b):..........................................................................................................................................18
11 c):..........................................................................................................................................18
11 d):..........................................................................................................................................19
11 e):..........................................................................................................................................20
11 f):...........................................................................................................................................21
12 Solution.....................................................................................................................................22
12 a.............................................................................................................................................22
12 b............................................................................................................................................22
12 c.............................................................................................................................................23
12 d............................................................................................................................................24
12 e.............................................................................................................................................25
Assessment 2.................................................................................................................................26
a)................................................................................................................................................26
b. Solution:.................................................................................................................................29
c) Solution:.................................................................................................................................33

d)................................................................................................................................................36
References......................................................................................................................................38
List Of figures
Figure 1 : Tally marks table.............................................................................................................5
Figure 2: Data Tab available on Spreadsheet................................................................................17
Figure 3: Option for Shorting available on the spreadsheet..........................................................17
Figure 4: Shorted data in ascending order (alphabetical)..............................................................17
Figure 5: List of employee worked "<35" hours a week...............................................................18
Figure 6: Count of employee earned more than the average amount............................................19
Figure 7: Net Amount earned graph..............................................................................................20
Figure 8: Columns with replication of data...................................................................................20
Figure 9: Calculation of result value in cell H20...........................................................................21
Figure 10: Calculation of total no. of females...............................................................................22
Figure 11: Calculation of records (<£25 hourly rate)....................................................................23
Figure 12: Calculation of surnames starting with “P”...................................................................24
Figure 13: Calculation of the total sum of the amount earned by females which are “>=£495”. .25
Figure 14: Finding “Messi” and his deduction..............................................................................25
Figure 15 : Table showing the total spending................................................................................26
Figure 16 : Table showing the mean..............................................................................................27
Figure 17 : Table showing the median..........................................................................................28
Figure 18 : Table showing the standard deviation.........................................................................29
Figure 19: Line graph established for the spending done over “Food” by students......................30
Figure 20: Line graph established for the spending done over “Clothing” by students................31
Figure 21: Line graph established for the spending done over “Entertainment” by students.......32
Figure 22: Line graph established for the spending done over “Charitable Giving” by students. 33
Figure 23: Scatter diagram designed for Food..............................................................................34
Figure 24: Scatter diagram designed for Clothing.........................................................................34
Figure 25: Scatter diagram designed for Entertainment................................................................35
Figure 26: Scatter diagram designed for Charity...........................................................................36

Figure 27 : Table showing the spending more than 500................................................................36
Figure 28 : Table showing the persons who are married...............................................................37
Figure 29 : Table showing the persons based in London..............................................................37
Figure 30 : Table showing final probability..................................................................................37

Section 1
Question 1: What is the result of the following calculation? Leave your answer in a tally
format.
I I I I I I I – I I I I
Solution - The above digits are written in the Roman form which is also known as tally marks,
thus firstly we have to convert this in the numerical form.
Figure 1 : Tally marks table
The numerical form of these digits are written as -
I I I I = 5, I I I = 3, I I I I = 4
= 5 + 3 - 4
= 8 - 4
= 4
The output which has been attained in numerical Form is 4
Thus, the tally marks output will be display in the form = I I I I

Question 2:
What percentage of 70 does 49 equate to?
Solution - The above statement can be written as 70*100: 49
To attained the result of the above statement, the following steps must be followed -
Step 1 - This is to be assumed that 70 is 100%.
Step 2 - The next is to denote the seek value with x
Step 3 - The step 1 is to be follows that 100% is equal to 70
Step 4 - In the same manner, x% is equals to 49
Step 5 - The pair of simple equations is generated, which is outlined as below -
Equation 1 = 100 % is equals to 70
Equation 2 = X% is equals to 49
Step 6 - In this step equation 1 is going to be divided by equation 2, and the equations of left
hand side are same (%). Thus, now this will displayed as
100%/ x% = 70/49
Step 7 - Now, just reciprocal both of the sides
x%/100% = 49/70
Thus, x will equals to 70%
Therefore, the output which is generated is 70% is 49 of 70.
Thus, the result is 70

Question 3:
a). Complete the table to show equivalent fractions and percentages.
Table 1: Fraction and Percentage table
Solution - To attained the output for the above table, the following steps must be followed by the
learner and these are stated below -
Step 1 - x% is equals to X by 100, thus the substitute for x is 45, so this can be written has
45% = 45/100
Now, divide both the sides by 5 in order to reduce the fraction in the easiest form which is 9/20.
Thus the fraction of 455 is 9/20.
Step 2 - The percentage of 2/3 is…,
The percent of any number in the fraction can be written with the denominator of 100, in this 3 is
not the factor of 100.
Thus, 2/3*100 = 200/3%
The three is a problem as this is ending as the recurring decimals.
1/3 is commonly written as 33.3%. Thus in the same way 2/3 can be written as 66.7%
Therefore, the result is 66.7%
Step 3 - The fraction for 22.5% is
Any of the percentage number can be written with the denominator of 100, thus 22.5 % can be
written in the form of 22.5/100
Fraction Percentage
45%
2/3
22.5%
7/5

Thus, the result which is attained is 9/40.
Step 4 - The next and last is the percentage of 7/5
Thus, when the percentage is divided by 100, in the similar way the fractions are multiplied by
100.
Thus, the 7/5 can also be written as 1.4, and when this is converted into the percentage form, the
1.4 is multiplied by 100.
The attained result is 14%
Hence, the table is completed and shown below -
Table 2: Solved Fraction and Percentage table
Fraction Percentage
9/20 45%
2/3 66.7%
9/40 22.5%
7/5 14%
b). A carton contains 150 cereal bars. What fraction of this number will each person get
when distributed to a class of 20 students?
Solution - Number of carton = 1
Number of cereal bars = 150
Total number of students = 20
Each student will get the following number of cereal bar = 150/20
The result is 15/2 which is also written as 7 ½.

Question 4:
Solution - Total number of discount-priced football tickets purchased by Samuel = 3
Samuel paid for 3 tickets = £50
The amount given back to Samuel was £4.20
The amount paid for 3 tickets = £50 - £4.20
= £45.8
Thus, cost of each ticket is £45.8/3 = £15.26.

Question 5:
a). Solve this binary arithmetic: 10011 +10101.
Solution - To attain the result for the above binary arithmetic, the following digits must be
converted into the decimal form.
Number 1 in the form of decimal will be displayed as:
100112 = 1910
Number 2 in the form of decimal will be shown as:
101012 = 2110
Now, there sum will be 19+21, which is equals to 40
The output which is generated in binary form is 4010, which is equals to 1010002
b). Write the number 0.0101 as a power of 10.
Solution - The value of 0 will remain 0 only and the value for 1 will be based on their location.
Thus, this can be written as 10-2 + 10-4 which is equals to 10-6.
Therefore the result is 10-6

Question 6:
a) What were the total savings made?
Solution - Here the new salon has been inaugurated and in that case they are promoting there
business by rendering different offers to their customers.
The offer is of 20% till 2 weeks, so Janice and her friends had an hair cut for the total amount
of £100. Thus this is to calculate the total savings made by Janice and her friends will be -
Let the value will be x
So, the total savings will be x*20% which is equals to 100
Thus, the result is 125
b) Work out the average savings amount if 4 hairdos were done?
Solution - The average savings amount will be 100/4 (25+25+25+25/4)
This is equals to 25

Question 7:
a). Work out the mean of the seven numbers.
Solution - Mean can be calculated as = sum of all the observations/ No. of observations
= 5+12+12+8+4+10+5 / 7
= 56/ 7
The Mean result is 8
b) What is the mode of the seven numbers?
Solution - The mode is the number which is repeated many times.
The mode result is 12 because this has occurred two times.