CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2 · Question 3(b)
Use the names of the schools as created in the data file in Question 2.
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(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(e)Determine the entries for the added columns using the necessary calculations.[6 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