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