Quelpr
4 marksTabulations, Data Management, and Integration

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

Spreadsheet task involving student attendance numbers, calculated meal costs, travel costs, and overall school totals.

Type the provided tabular document in a spreadsheet following all instructions.

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(b)Use the names of the schools as created in the data file in Question 2.[2 marks]
  2. 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. 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