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

16 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. 1(a)6 marksCreate a datafile containing specified fields (<Title>, <First Name>, <Last Name>, <Address 1>, <Address 2>, <Address 3>, <Course>, <Date>, <Fees>) using the provided recipient details.
2. 1(b)4 marksCreate a suitable letterhead with an appropriate logo for Howells University College, including address, telephone, fax, and email.
3. 1(c)14 marksType the standard letter in blocked style with 2.54 cm margins, incorporating the required mail merge fields, edits, 24-hour time formatting, and core course table arranged in day order.
4. 1(d)2 marksPrint a copy of the standard letter showing the merge fields.
5. 1(e)2 marksMerge the datafile with the standard letter.
6. 1(f)2 marksPrint the merged letters for Mr Ronaldo Morris and Mrs Silvia Finestre.
7. 2(a)16 marksType the spreadsheet in landscape orientation following all instructions: header, Algerian font size 14, 'output' cell style for headings, formula to calculate average marks, tutor's signature, today's date, and…
8. 2(b)10 marksType the memorandum to The Registrar from the Dean of Faculty, Business Studies (reference MJC/(your initials) and today's date), copy the table from the spreadsheet, fill in the count of regular students achieving over…
9. 320 marksDisplay the organizational chart in landscape orientation following all formatting and dimension instructions (box sizes 1.5" / 3.81 cm wide, font sizes, line spacing, initial caps, centering text inside boxes, and…
10. 4(a)2 marksSet margins to narrow (top 0.5", bottom 0.5", left 0.5", right 0.5").
11. 4(b)2 marksInsert a text box for the invitation layout.
12. 4(c)12 marksCreate two identical invitations using the provided draft text, line spacing, fonts, and alignment instructions.
13. 4(d)4 marksInsert an appropriate graphic in the upper left hand corner under Ministry of Education, with a single line border around the graphic.
14. 4(e)2 marksEnsure that both invitations are placed on the same side of the paper.
15. 4(f)1 markSave the document as invitation.
16. 4(g)1 markPrint the invitations.