CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2 · Question 3(d)
Apply MEALS cost at 15.00 per student and TRAVELLING cost at 200.00 per school.
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(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