Quelpr
4 marksTabulations, Data Management, and Integration

CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2 · Question 3(c)

Insert four columns to the right of the last column shown, naming them TOTAL STUDENTS, MEALS, TRAVELLING, and SCHOOL TOTAL, respectively.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(a)Type the provided tabular document in a spreadsheet following all instructions.[4 marks]
  2. 3(b)Use the names of the schools as created in the data file in Question 2.[2 marks]
  3. 3(d)Apply MEALS cost at 15.00 per student and TRAVELLING cost at 200.00 per school.[2 marks]
  4. 3(e)Determine the entries for the added columns using the necessary calculations.[6 marks]
  5. 3(f)Save as BUDGET1.[2 marks]
  6. 3(g)Create and label a pie chart comparing the total number of boys and girls.[4 marks]
  7. 3(h)Save the pie chart on the same page as the spreadsheet.[2 marks]
  8. 3(i)Save the document as BUDGET2.[2 marks]
  9. 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