Quelpr
2 marksTabulations, Data Management, and Integration

CSEC Electronic Document Preparation and Management · 2014 · Paper 2 · Question 2(a)

Mail merge exercise involving producing a main document and a data file based on the provided draft letter and recipient addresses.

Produce the main document and the data file following all given instructions.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 2(b)Using A4 or letter size paper, create a suitable letterhead with an appropriate logo using the provided organization information.[3 marks]
  2. 2(c)Using 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),…[5 marks]
  3. 2(d)Save the main document as 'letter'.[1 mark]
  4. 2(e)Print one copy of the main document showing the merge fields.[2 marks]
  5. 2(f)Create the data file from the four recipient addresses provided.[4 marks]
  6. 2(g)Save the data file as 'data1'.[1 mark]
  7. 2(h)Sort the data file by last name.[3 marks]
  8. 2(i)Save the sorted data file as 'data2'.[1 mark]
  9. 2(j)Print one copy of each data file, 'data1' and 'data2', displaying the records.[3 marks]
  10. 2(k)Merge the documents ('letter' and 'data2') and print the FIRST and LAST letters.[4 marks]
  11. 2(l)Produce and print an envelope addressed to Mrs. Bianca Madison.[3 marks]

More practice: the rest of this paper · more Tabulations, Data Management, and Integration questions · all CSEC Electronic Document Preparation and Management past papers