Numeracy, Data & IT (Portfolio of Tasks)

Numeracy, Data & IT (Portfolio of Tasks)

Table of Contents
PART 1............................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................3
Question 3....................................................................................................................................3
Question 4....................................................................................................................................3
Question 5....................................................................................................................................4
Question 6....................................................................................................................................4
Question 7....................................................................................................................................4
Question 8....................................................................................................................................5
Question 9....................................................................................................................................5
Question 10..................................................................................................................................5
Part 2................................................................................................................................................6
Part 3................................................................................................................................................8
12. Create excel...........................................................................................................................8
13.................................................................................................................................................8
14) Write the Excel functions for the following........................................................................12
15...............................................................................................................................................14
16...............................................................................................................................................17

PART 1
Question 1
Numerator: It is the value which is placed at upper part of the fraction. It shows how many parts
it have.
Denominator: It is placed lower part of the fraction. It shows in how many equal parts the value
is divided into.
Question 2
24/40 = 0.6
18/42 = 0.43 (approx.)
Question 3
a) 2/3, 3/4 and 5/6
8
12 ,
9
12 ∧10
12
b) Percentage of library books on computing
Remainder book = 60,000 – 14,000 – 22,000 – 12,000
= 12,000
Computing books = 12,000 × 2
3
= 8,000
Percentage of books on computing = 8,000
60,000 ×100
= 13.33%

Question 4
Total money given by Liz = £50 × 3 = £150
Total price of 2 pairs of shoes = £150 - £10.50
= £139.50
Price of each pair of shoes = £139.50/2
= £69.75 per pair
Question 5
a) 240.50 × 19.54
= 4,699.37
b) 521 × 1010
Question 6
a)
Total amount paid for sign up = £210
Total discount received = £210 × 30
100
= £63
Hence, the total savings made = £63
b)
Average savings per person = £63 / 3 (Patty and her 2 siblings)
= £21 per person
Question 7
a) 3/4 - 7/9 + 2/3