cove 01229020 ~ | FORM TP 2018014 B JANUARY 2018 CARIBBEAN EXAMINATIONS COUNCIL CARIBBEAN SECONDARY EDUCATION CERTIFICATE® EXAMINATION INFORMATION TECHNOLOGY Paper 02 — General Proficiency 2 hours 15 minutes READ THE FOLLOWING INSTRUCTIONS CAREFULLY. 1. This paper consists of THREE sections and TWELVE questions. Answer ALL questions. booklet. Write your answers in the spaces provided in t 3. Do NOT write in the margins. 4. Code is to be written in Pascal 5. Ifyou need to rewrite any answer and there is not enough space to do soon | the original page, you must use the extra lined page(s) provided at the back of this booklet. Remember to draw a line through your original answer, 6. Ifyou use the extra page(s) you MUST write the question number clearly in the box provided at the top of the extra page(s) and, where relevant, include the question part beside the answer. DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO. it © 2017 Caribbean Examinations Council Al rights reserved. 0 fel 01229020/JANUARY 2018 0122902003 Copyri(b) SECTION I THEORY ~ 60 marks Answer ALL questions. State whether EACH of the following devices is an input or output devices. Plotter .. Joystick... OCR. Printer Speaker... Microphone (6 marks) State ONE device which could be used for EACH of the following activities: (Participants in an online meeting sharing video to see each other ‘A bank teller processing cheques A cashier checking out items being purchased in a supermarket (iv) Electronic marking of 10 000 multiple choice sheets (4 marks) Total 10 marks GO ON TO THE NEXT PAGE, 01229020/IANUARY 2018 ee i if '0122902004DO NOT WRITE IN THIS AREA 4 DO NOT WRITE IN THIS AREA i : : DONOT @ () 4 Sharon is at a workshop and decides to join a teleconference with her staff. Which audio output device would you recommend that she use? Give a reason for your recommendation. Audio output device Reason marks) For EACH of the following, suggest ONE scenario (and provide a reason), in which it would be more suitable to use (a dot matrix as opposed to a laser printer (2 marks) (i) plotter as opposed to a printer @ marks) GO ON TO THE NEXT PAGE, 01229020 ANUARY 2018 fess 0122902005, acl4x Gi) a magnetic tape as opposed to a flash (USB) drive (iv) a joystick as opposed to a mouse. (@ marks) Total 10 marks GO ON TO THE NEXT PAGE (01229020/JANUARY 2018 [ee3. (a) Convert 42,, to base two. Ss = g GB marks) : 2 (b) Determine the decimal equivalent of 1001,. = 2 5 (2 marks) (©) Write a representation for the positive sign of a binary-coded decimal (BCD), (mark) GO ON TO THE NEXT PAGE | (01229020/J ANUARY 2018 [asr -8- 4 (@) Ifthe ASCII equivalent of the letter P is 1010000, determine the ASCII equivalent for the letter U. 01229020/JANUARY 2018 fee (4 marks) Total 10 marks GO ON TO THE NEXT PAGE7 * 7 4. (@)_—_ At Magnet Defence Systems Ltd there is a 24-hour production system in place. ‘Timely reports must be constantly produced and sent to the engineers for immediate action. A decision must be made on the choice of processing modes to be used: batch, real-time or time-sharing. (Explain which processing mode is MOST suitable for the production of the reports. Gi) Describe TWO situations in which one mode, other than the one explained in (a) (i), would be MOST suitable. marks) GO ON TO THE NEXT PAGE 01229020/JANUARY 2018 jen a = rer -10- ‘Study the laptop specifications below and answer the questions which follow. Windows 10 Home 64 Intel® Core ™ 17-6560U Processor Beautiful 33.8 cm (13.3*) Diagonal Quad-HD OLED (2560 *1440) Touchscreen display 8 GB RAM and 512 GB PCle® SSD Storage 500 GB SATA Hard Drive 720 RPM Intel® IRIS™ Graphics; Audio by Bang & Olufsen ‘True Vision Full-HD Webcam Cortana Optimized Microphone; QWERTY Keyboard State (the primary memory capacity Gi) the type of hard drive Giii) the operating system (iv) the hardware interface (v) TWO input devices. (6 marks) ‘Total 10 marks GO ON TO THE NEXT PAGE, 01229020/JANUARY 2018or a 1 5. (a)_The following is a list of terms associated with the use of computer systems to facilitate a variety of secondary storage media and devices. DO NOT WRITE IN THIS AREA Broadcast, Computer fraud, Extranet, Half-duplex, Simplex, Intranet, Propaganda, Wifi, Point-to-point, Software piracy Select the appro} ate term from the list to match EACH of the following situations: (High-speed wireless access to a network or the Internet Gi) Direct line between two computers (iii) Data can travel in two directions but only one way at a time (iv) A private network that belongs to an organization (¥) Unauthorized distribution of computer programs (vi) Use of computer systems to distribute information GO ON TO THE NEXT PAGE 01229020/JANUARY 2018 le V0 atr “t 7 (b) State ONE advantage and ONE disadvantage of using EACH of the following devices: @ bvb Advantage Disadvantage ... (i) External hard drive Advantage Disadvantage . GO ON TO THE NEXT PAGE al 01229020JANUARY 2018 L. ‘TOO 0122902012hastralbhasedividiihlubnsdrcditanhansicnhnsnastal DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA ; DO NOT WRITEIN THIS AREA 6 @ (b) -13- | ‘The DIGITS company collects personal data from customers which it stores in filing cabinets or on computers, (State TWO possible effects of improper storage of data (2 marks) For EACH of the following storage locations, state TWO measures that can be used to protect the data: Filing cabinets . Computer systems (4 marks) Outline when EACH of the following procedures would MOST likely be applied to the company’s data: Recovery ... oi “@ marks) . ‘a mark) Backing up ... (mark) Total 10 marks GO ON TO THE NEXT PAGE 01229020/JANUARY 2018 L 80 A a 0122902013-14- | SECTION II PRODUCTIVITY TOOLS ~ 15 marks Answer ALL questions. 7. The following is an excerpt from an advisory that was sent out to shoppers warning them of the dangers of shopping online during the Christmas season. CARCIRT-Ad-2017.002v_1 (ALL) First Release: November 1, 2017 ADVISORY [CHRISTMAS] Caribbean CIRT Christmas Advisory mportant information from CARIBBEAN CIRT 1/11/2017 12:40 PM EST The Christmas season is one of the times of the year for major shopping. Online shopping is becoming increasingly popular and we are being bombarded with offers of all types. Online shopping is great but shoppers are encouraged to take certain precautions especially when using their credit cards. (@) —_@_State TWO text formatting features, other than bold and underline, used in the document, (ii) State the line justification used in the first two lines of the document. (mark) What word processing feature will allow the first two lines of this advisory to be repeated on every page of the document? (1 mark) GO ON TO THE NEXT PAGE, 01229020/JANUARY 2018 LL NE A 0 a] 0122902014“BO NOT WRITE IN THIS AREA AN THIS AREA DONOT WRITE () -15- aay ‘The committee wants to personalize the advisory for distribution to its workers without having to type each worker's name into the advisory. (Name the word processing feature that is MOST suitable to achieve this (i mark) List THREE fields that should be inserted into the advisory “(@ marks) (iii) Insert the THREE fields listed in (b) (ii) on the advisory on page 14. (1 mark) Total 8 marks GO ON TO THE NEXT PAGE 01229020 ANUARY 2018 eer -16- 7] 8. Thedirector of Emrock is creating a budget for the company’s small response division, and produces the following spreadsheet which has been sorted. A B = D 1 Items Quantity | Cost per item | Total Cost 2 _| Digital Forensic Tool Kit 1 3000 3-_| Write Blocker Kit 2 1699 4 | Mac Desktop 1 1100, 5 | Desktop Workstation 4 900 6 | Wireless Router 2 500 7 | Computer Screens 27” and 34” 4 400 8 | Response Field Kit 2 300 (@) Write the formula to be inserted into cell D2 to calculate the total cost of the digital forensic tool kit, 3 marks) (b) Outline how to insert the formula in (a) into cell D3 to D8 in order to calculate the totals of the remaining items without retyping the formula. (c) State (@ the field that was used to sort the spreadsheet i) the order used to sort the field. “@ marks) Total 7 marks GO ON TO THE NEXT PAGE 01229020/JANUARY 2018 fe AAT |eatin SM NOE WORETE IN THES AREA DO NOT WRITE IN THIS AREA : | i s = = 3 8 THIS AREA RO NOT WRITE IN THIS AR + +17 | SECTION II PROBLEM-SOLVING AND PROGRAMMING ~ 45 marks Answer ALL questions, 9. Consider the following algorithm, INPUT WEIGHT, YEAR IF (WEIGHT < 180.0) AND (YEAR = 1990) ‘THEN PRINT “PERFECT” ELSE PRINT “NOT FIT” ENDIF (2) @_ Explain the purpose of the program. (2 marks) (ii) State the data type of the variable WEIGHT. (1 mark) (b) State TWO examples of data that would NOT be suitable to test the pseudocode. Example 1 Example 2 (2 marks) (©) Complete the following trace table to show the output from the two algorithms. IF (WEIGHT< 180) AND IF (WEIGHT< 180) OR WEIGHT | YEAR (YEAR = 1990) (YEAR = 1990) THEN PRINT “PERFECT” | THEN PRINT “PERFECT” 150 1990 130 | 1998 2 180 | 1990 200 | 1998 (S marks) Total 10 marks GO ON TO THE NEXT PAGE, 01229020 ANUARY 2018 (aDy ™ 7 10. Consider the following pseudocode for a program. Initialize count to zero Initialize temp to zero While temp is not equal to —1 Input temp Output ‘temp accepted” If (temp =—I) then Output “End of test” Else add 1 to count ‘Output “Exit In the space on page 19, draw a flow chart for the program. GO ON TO THE NEXT PAGE 01229020 ANUARY 2018 fee ‘Ne Pe al| DONOT WaITE IN DONOTWRITEIN THISAREA | (IS marks) ‘Total 15 marks GO ON TO THE NEXT PAGE 01229020/JANUARY 2018iB 2 1 11, Consider the following one-dimensional array named CLASS wl of students in Class I to Class 4. h is used to store the number Class | 45 | 54 | 63 | 76 Index | 1 (@) State (i) the number of children in Class 1 (ii) the elass that has $4 children, (b) Write Pascal code for EACH of the following: (@__ Input the number 63 into Class 3 (4 marks) (ii) Add the number of childrei named TOTAL. the four classes and store the total in a variable (marks) Total 10 marks GO ON TO THE NEXT PAGE 01229020 ANUARY 2018 fsr 2 2 incorrect. Rewrite EACH 12. Each of the following programming statements in the table below statement using correct Pascal code. Incorrect Programming Statement Correct Programming Statement (i) [cost: array 1, 8 of real; ‘DO NOT WRITE IN THIS AREA (ii) |wnite (week < 5) Week = Week + 1; ii) INTEREST < 25%; (iv) | Repeat Print Ans; Ans : Ans + 1; Until Ans = 4 or 5; DO NOT WRITE IN THIS AREA (10 marks) Total 10 marks END OF TEST IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST. DO NOT WRITE IN THIS AREA 01229020/JANUARY 2018 [es ‘i a |r = 7 EXTRA SPACE Ifyou use this extra page, you MUST write the question number clearly in the box provided. Question No. 01229020/JANUARY 2018 Ee i A 4 10122902022