Quelpr

CSEC Electronic Document Preparation and Management · May/June 2016 · Paper 2

22 questions and parts from this paper. Open one to see it in full, then practise it on Quelpr and get it marked against the mark scheme.

  1. 110 marksType the provided text passage following all specifications (double line spacing, 1-inch margins, Times New Roman 12, justified).
  2. 2(a)4 marksProduce the main document and the data file following all given handwritten instructions and formatting rules.
  3. 2(b)4 marksUsing A4 or letter size paper, create the letter in blocked style with 1 inch (2.54 cm) margins.
  4. 2(c)2 marksSave the main document as ICT1.
  5. 2(d)4 marksSave the data file as schools.
  6. 2(e)6 marksMerge the documents (ICT1 and schools) and save as ICT2.
  7. 2(f)4 marksPrint ICT1 and schools.
  8. 2(g)4 marksPrint the FIRST and LAST letters of ICT2.
  9. 3(a)4 marksType the provided tabular document in a spreadsheet following all instructions.
  10. 3(b)2 marksUse the names of the schools as created in the data file in Question 2.
  11. 3(c)4 marksInsert four columns to the right of the last column shown, naming them TOTAL STUDENTS, MEALS, TRAVELLING, and SCHOOL TOTAL, respectively.
  12. 3(d)2 marksApply MEALS cost at 15.00 per student and TRAVELLING cost at 200.00 per school.
  13. 3(e)6 marksDetermine the entries for the added columns using the necessary calculations.
  14. 3(f)2 marksSave as BUDGET1.
  15. 3(g)4 marksCreate and label a pie chart comparing the total number of boys and girls.
  16. 3(h)2 marksSave the pie chart on the same page as the spreadsheet.
  17. 3(i)2 marksSave the document as BUDGET2.
  18. 3(j)2 marksPrint BUDGET1 and BUDGET2.
  19. 4(a)6 marksProduce the brochure in landscape orientation following all instructions.
  20. 4(b)4 marksUse A4 or letter size paper and margins of 1 inch (2.54 cm) top, bottom, left, and right.
  21. 4(c)4 marksUse Times New Roman font 14, unless otherwise instructed.
  22. 4(d)18 marksSave as ICT Brochure and print.

More CSEC Electronic Document Preparation and Management papers