CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2 · Question 3(e)
Determine the entries for the added columns using the necessary calculations.
The mark scheme is shown once you've answered.
Practise this questionOther parts of this question
- 3(a)Type the provided tabular document in a spreadsheet following all instructions.[4 marks]
- 3(b)Use the names of the schools as created in the data file in Question 2.[2 marks]
- 3(c)Insert four columns to the right of the last column shown, naming them TOTAL STUDENTS, MEALS, TRAVELLING, and SCHOOL TOTAL, respectively.[4 marks]
- 3(d)Apply MEALS cost at
15.00 per student and TRAVELLING cost at200.00 per school.[2 marks] - 3(f)Save as BUDGET1.[2 marks]
- 3(g)Create and label a pie chart comparing the total number of boys and girls.[4 marks]
- 3(h)Save the pie chart on the same page as the spreadsheet.[2 marks]
- 3(i)Save the document as BUDGET2.[2 marks]
- 3(j)Print BUDGET1 and BUDGET2.[2 marks]
More practice: the rest of this paper · more Tabulations, Data Management, and Integration questions · all CSEC Electronic Document Preparation and Management past papers