(PRACTICAL)
- A teacher of drama and dance has requested you to come up with a poster for an upcoming school musical. Use a Desktop publishing application to develop one as follows.
(a) (i) Open a Desktop Publishing program and set the page layout as follows: (5 marks)
Paper size A4 Portrait ( 21cm by 29.7cm)
Left margin 2 cm
Right margin 2 cm
Top margin 2cm
Bottom margin 2 cm
(ii) Save the publication as moonman (1 mark)
(b) Design the poster as indicated in the figures below. Figure 1 (42 marks)
- Kings high requires you to prepare a spreadsheet model in figure 2 that they will use to capture and process votes for the indicated school leadership positions. Voters will indicate their preferred candidate by making the entry YES for their proffered candidates but leave blank for non preferred candidates. Formulae will be used to determine the class level tally, final tally , winners and the percentage by which they will have won, and total votes per category. Discrepancy in voting will be determined by comparing those who voted for the Deputy positions versus those who did not.
- Prepare the model and include all relevant formulae. Save the model a form34A (32 marks
(10 marks
- prepare a pie chart to display the final results for the School captains position showing
the percentages of votes garnered by the two candidates. Save is as form34C (4 marks)
(d) print:
(4 marks)
– form34A
* showing the design
*showing the formulae used
– form34B
– form 34c
