Figure 4 is a full set of page formatting options captured from MS Word application. Use it to answer questions 18 and 19. A user who was typing a document in portrait orientation decided to complete the next few pages in landscape orientation. Which one of the following options illustrates the correct order of steps the user must follow by clicking on the labelled parts to achieve this?
A.I, III and V
B.I, IV and V
C.II, III and V
D.II, IV and V
Show the answer and explanation
Answer: D (II, IV and V)
Explanation
Choose Landscape (II), set Apply to: This point forward (IV) so earlier pages stay portrait, then click OK (V).
Figure 4 is a full set of page formatting options captured from MS Word application. Use it to answer questions 18 and 19. Which one of these options gives the correct order of steps to revert to portrait orientation after typing in landscape orientation for a while?
A.I, III and V
B.I, IV and V
C.II, III and V
D.II, IV and V
Show the answer and explanation
Answer: B (I, IV and V)
Explanation
Choose Portrait (I), Apply to: This point forward (IV) so the landscape pages already typed stay, then OK (V).
Paper 2, Section A: Short-structured questions (a) Explain the following terms: (i) data processing; (ii) data collation. (b) Describe Data Processing Cycle. (c) State four benefits of the computer as a tool for processing data.
Show the model answer
Model answer
(a)(i) Data processing is carrying out operations on raw data (sorting, calculating, summarising) to turn it into useful information. (ii) Data collation is gathering data from different sources and putting it together in an organised form ready for processing. (b) The data processing cycle is the repeated series of stages that turn data into information: input (collect and enter data) → processing (sort, calculate, analyse) → output (present the information) → storage (save data/information for later), with feedback from the output used to correct or improve the next input. (c) Any four: speed; accuracy; large storage; automation; reliability; versatility; easy retrieval and sharing; high productivity.
Explanation
Name the stages in order: input, processing, output, storage.
Paper 2, Section A: Short-structured questions Figure 1 is a setup of computer system. Use the setup to answer questions 2(a) to 2(c). (a) Identify the part labelled: (i) A; (ii) B; (iii) C; (iv) D. (b) For each device in the setup, tick (√) the box to show if it is an input device or an output device. (c) Name two devices that can be used for both input and output operations.
Show the model answer
Model answer
(a)(i) A – monitor. (ii) B – printer. (iii) C – mouse. (iv) D – keyboard. (b) A (monitor) – output; B (printer) – output; C (mouse) – input; D (keyboard) – input. (c) Any two: touch screen; modem; headset with microphone; multifunction printer (print and scan); network card; flash drive/disk drive (storage read and write).
Explanation
A device for both must take data in and send data out, e.g. a touch screen.
Paper 2, Section A: Short-structured questions (a) With the aid of well-labelled diagram, explain the following modes of information transmission: (i) simplex; (ii) half duplex; (iii) full duplex. (b) State one example of: (i) simplex; (ii) half duplex; (iii) full duplex, mode of information transmission. (c) Name one component of a data communication system.
Show the model answer
Model answer
(a)(i) Simplex – data flows in one direction only, from sender to receiver (Sender → Receiver). (ii) Half duplex – data can flow both ways, but only one way at a time (Sender ⇄ Receiver, taking turns). (iii) Full duplex – data flows both ways at the same time (two arrows in opposite directions at once). (b)(i) Radio or TV broadcast (or keyboard to computer). (ii) Walkie-talkie. (iii) Telephone/mobile phone call. (c) Any one: sender (source); receiver; transmission medium; message; protocol.
Explanation
Draw sender and receiver boxes with arrows for each mode.
Paper 2, Section A: Short-structured questions (a) Differentiate between hackers and spammers. (b) State one importance of add-in in MS Excel. (c) Explain the following terms in computing: (i) cookies; (ii) plugin; (iii) web crawlers.
Show the model answer
Model answer
(a) A hacker breaks into computer systems or networks without permission, while a spammer sends large numbers of unwanted messages (spam) to many people. (b) An add-in adds extra commands or features to Excel (e.g. Analysis ToolPak, Solver) for special tasks. (c)(i) Cookies are small files a website stores on the user's computer to remember information such as login and preferences. (ii) A plugin is a small program added to a larger application (e.g. a browser) to give it a new feature, such as playing video. (iii) Web crawlers (spiders) are programs used by search engines to visit web pages automatically and index them.
Paper 2, Section B: Test of Practical Work Figure 2 is an interface of an application software. Use it to answer questions 5(a) to 5(e). (a) Identify the type of application whose interface is shown in Figure 2. (b) Outline the steps to: (i) insert a new slide to the interface; (ii) delete a slide from the interface. (c) State two examples of the application in Figure 2. (d) Give two: (i) uses of the application in Figure 2; (ii) differences between transitions and animations in the application shown in Figure 2. (c) Highlight the steps to: (i) run slideshow in the application shown in Figure 2: (ii) print a handout of 6 slides on a page of the application shown in Figure 2.
Show the model answer
Model answer
(a) A presentation package (Microsoft PowerPoint). (b)(i) Click Home → New Slide (or press Ctrl + M), choose a layout. (ii) Select the slide in the slide pane → press Delete (or right-click → Delete Slide). (c) Any two: Microsoft PowerPoint; Google Slides; Apple Keynote; LibreOffice Impress; Prezi. (d)(i) Any two: preparing lessons and lectures; business presentations; seminars and workshops; adverts and product launches; school projects. (ii) Transitions are effects when moving from one slide to the next; animations are effects on objects (text, pictures) within a slide. Transitions apply to whole slides; animations apply to individual items. (last part)(i) Click Slide Show → From Beginning (or press F5). (ii) Click File → Print; under Settings choose Handouts → 6 Slides Horizontal/Vertical; click Print.
Explanation
Transitions are between slides; animations are on objects within a slide.
Paper 2, Section B: Test of Practical Work You are provided with a list of existing contacts in a database. Describe in detail. the step-by-step approach to: (a) create: (b) preview and complete. a mail merge using a template in MS Word.
Show the model answer
Model answer
(a) Open MS Word and choose a template (File → New → letter template, or open the letter); click Mailings → Start Mail Merge → Letters; click Select Recipients → Use an Existing List; browse to the contacts database, choose the table and click OK; place the cursor where each detail should go and click Insert Merge Field (e.g. Title, First Name, Address), or use Address Block and Greeting Line. (b) Click Preview Results and use the arrows to check each letter; correct any problem; click Finish & Merge → Edit Individual Documents (to create all letters) or Print Documents / Send E-mail Messages; click OK.
Explanation
The Mailings tab holds every mail-merge step in order.