S 5 And 6 Ict Practical Guide Caltec S.5

A’ LEVEL SUBSIDIARY ICT PRACTICAL QUESTIONS TABLE OF CONTENTS WORD PROCESSING .................................................................................................................. 2 SPREAD SHEETS ...................................................................................................................... 17 PRESENTATION ........................................................................................................................ 28 DATABASES .............................................................................................................................. 40 DESKTOP PUBLISHING ........................................................................................................... 52 Question one Using word processing software, load the file moralpaper.docx and save it as your name and personal number. (01 mark) a) Apply font size 20, color purple, Center, double underline on to the heading of the document. (02 marks) b) Make the rest of the text in the document to font size 13. (01mark) c) Change the border width to a 3D-6pt. (01 mark) d) Insert the picture bet1.JPG as the header of the document. (02 marks) e) Insert your name and personal number as a footer of the document. (01 mark) f) Insert page numbers at the bottom of your document starting from 5. (01 mark) g) Insert a Decision auto shape at the bottom of the document (01mark) Change the colour of the auto shape to green (01 mark) Add a centered text “THE CHOICE IS YOURS” (01 mark) Send it back (01 mark) h) Drop the first letter of the second paragraph to cover 2 lines. (01 mark) i) Make the sub-headings standout as underlined with a 16 font size and Bradley hand ITC font style (02 marks) j) Make the word “addictive” in the fourth paragraph a hyperlink to www.google.com (01 mark) k) Copy the document to another page. (01 mark) l) Save and print your work (01 mark) Question Two Using a suitable software package, load the file ramathan.doc and save it as Word Processing. i) Change the case of title to UPPERCASE and bold the title and change the font of all the text size 13. ii) Instead of word brother/sister put both your names. iii) Apply a header as your company name with word art …