Quelpr

CSEC Electronic Document Preparation and Management · 2014 · Paper 2

28 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.

Practise this paper
  1. 110 marksType the copy test passage in double line spacing using 1" (2.54 cm) margins and Times New Roman size 12 font.
  2. 2(a)2 marksProduce the main document and the data file following all given instructions.
  3. 2(b)3 marksUsing A4 or letter size paper, create a suitable letterhead with an appropriate logo using the provided organization information.
  4. 2(c)5 marksUsing the letterhead, create the letter in semi-blocked style with top and bottom margins of 1" (2.54 cm) and left and right margins of 1.25" (3.175 cm), incorporating the manuscript amendments and subject line.
  5. 2(d)1 markSave the main document as 'letter'.
  6. 2(e)2 marksPrint one copy of the main document showing the merge fields.
  7. 2(f)4 marksCreate the data file from the four recipient addresses provided.
  8. 2(g)1 markSave the data file as 'data1'.
  9. 2(h)3 marksSort the data file by last name.
  10. 2(i)1 markSave the sorted data file as 'data2'.
  11. 2(j)3 marksPrint one copy of each data file, 'data1' and 'data2', displaying the records.
  12. 2(k)4 marksMerge the documents ('letter' and 'data2') and print the FIRST and LAST letters.
  13. 2(l)3 marksProduce and print an envelope addressed to Mrs. Bianca Madison.
  14. 3(a)8 marksType the registration data in a spreadsheet using landscape orientation, following all layout and formatting instructions.
  15. 3(b)(i)3 marksCalculate the Balance Owed for each participant.
  16. 3(b)(ii)2 marksCalculate the Total Fee.
  17. 3(b)(iii)2 marksCalculate the Total Amount Paid.
  18. 3(b)(iv)2 marksCalculate the Average Fee.
  19. 3(b)(v)2 marksCalculate the Average Amount Paid.
  20. 3(c)2 marksCenter the spreadsheet vertically and horizontally on the page.
  21. 3(d)9 marksCreate a column chart titled 'Payments to Date' displaying total fees and total payments to date, labelling all axes.
  22. 3(e)3 marksSave the document as 'spreadsheet' and print the spreadsheet and chart on separate pages.
  23. 4(a)(i)9 marksCreate the circular letter in semi-blocked style using 1" (2.54 cm) margins all around, using the letterhead designed in Question 2 and incorporating manuscript instructions.
  24. 4(a)(ii)2 marksFollow all editorial and manuscript instructions given on the draft.
  25. 4(a)(iii)2 marksSave the circular letter as 'circular' and print it.
  26. 4(b)(i)9 marksCreate the conference registration form following all layout and typographical instructions, using the same letterhead created for Question 2.
  27. 4(b)(ii)1 markSet equal left and right margins of 1" (2.54 cm) on A4 or letter size paper.
  28. 4(b)(iii)2 marksSave the document as 'form' and print it.

More CSEC Electronic Document Preparation and Management papers