hide Dance - ome® 07 Royal College - Colombo 07 @gde Bod siatvenc - 2019 Second Term Test - 2019 Seg&s — omdgd mamdeene oprah 8 Grade 9 Information Technology Time: 1 1/2hours ‘Name: 5 Class: PARTI all questions. ‘each of the questions I to 20, pick one of the alternatives (1), (2), (3), (4) which you consider correct or most suitable. (2.x 20= Marks) The first-generation computers used for cireuitry. (Vacuum tube (2) Transistor {G) Integrated Circuits (4) Large Scale Integration The term ‘Pentium’ is related to (DvD (2) Hard Disk (3) Microprocessor “How many cores are included in a core i7 processor? q@! @2 3)4 @7 The type of memory ,that loses its data when the power is switched off is, (1)Volatile memory (2) Non-volatile memory G) Impact memory (4) Non-impact memory Which of the following icons in word processing software can be used to replace @ word in a document? a o Q) [A] @) |B @ [| Auto Correct was originally designed to replace ‘words as you type. (1) Short, repetitive (2) Grammatically incorrect (3) Misspelled __ o(4) Find & Replace What is the short cut key combination to select all contents of a word document page? () Cri+A Qyat+a G)Cul+Alt+A (4) ALT + DEL+A In a certain coding system a binary number represents as follows. What could be the value of ‘that number? o0@@eo Q) 20 2) 6.0 3) 120 (4) 1610 The binary equivalent of 53 is q@y1oi01iz (21100112 (3) 10112 (4) 110101210. What would you call the background in Scratch programming? (Sprite (2) Stage (3) Sense (4) Seript 11. In Scratch programming what's the block type we should use when we want to take an (Sensing 2) Looks (3) Events (4) Control 12. The given computer port sends digital signals of (1) Video (2) Audio (3) Both video &audio (4) None of the above 13. Which of the following computer monitor uses cathode rays to display the images? (LCD Q)LED 3) CRT (4) MICR 14, Ruchith is afield officer in a reputed bank, He used to visit farmers and promote and data from rural areas. What is the most suitable computer type for him according to his j (1) Workstation (2) Desktop (3)All-in- one (4) Tablet Answer the question numbers 15 and 16 using the spread sheet segment given b A 15. What is the cell reference of the active cell? (as Q)A3 @)B3 (4) BS 16, What is the correct formula to calculate the sum of the numbers in the A column? (1) sum(At; A4) (2)=sum(A1:A4) (3) sum(A1:A4) (4)-Sum(A1;A4) 17. Which of the following is not a spreadsheet software? (1) MS Exel (2) iWork Numbers (3) LibreOfice Cale (4) OpenOffice Writer 18, Which of the following logic is used to produce loops in a program logic, when one or instructions may be executed several times depending on some conditions? (1) Iteration Q) Selection GB) Sequence (4) Decision 19. Which of the following is/are representation of algorithms? (A) Pseudocode (B) Flowchart (C) Program ‘ (1) Acaly @Bonly @A&Bonly (4) A, Band Call 20. Which of the following program planning tool allows the programmers to plan program by writing program instructions in an ordinary language. (1) Flowehart (2) Pseudocode (3) Program (4) Loopingall questions. ‘1. Write True or False next to the following statements: Statement. ‘True or False ‘Non-portable computers are operated using the main electricity power supply. The speed of the processor is given in TB Data transfer rate is used to measure the speed of a CPU. Transmission speed can be calculated in mbps. Free and open source operating systems are less expensive. It is advisable to purchase a computer considering only its price. ‘An operating system provides the interface between the user and the hardware. AlLin-one computers are used to mobile computing ‘A notebook computer is usually larger than a personal computer. Charles Babbage is the "Father Of Computers”, (0 marks) 2. Study the specifications given in the following table. And answer the question from the given Specifications only. ‘Central Processing Unit Intel(R) Celeron(R) 2.00GHz "ASUSTeK COMPUTER INC. Herd casts 8 Windows 10Pra Gib [Gastrates period 7 | 3 years] a TE 4096MB Ui [Prie Rs. 49,000.00. ‘What is the speed of the Processor? State the type of the Processor. Find the capacity of the main memory. What is the size of the screen? ae State 3 technical specifications of the computer. mark) (1 mark) (1 mark) (1 mark) (3 marks) Give 3 non-technical specifications to be considered when buying a computer.a fr 4 | 2 [Name 3 Ravindy [Bandera Ruchith |Chiren ‘Highest mark Lowest Mark - Write down the formula that should be written in cell: E3 F3 B8 B9 b) Write two chart types that can be used to compare students? marks? 4. (a) Write the answers for the following Questions. i, Write the main task of the following computer users, User Name Web Designer Programmer Software Engineer marks) Wetc ewo advantages of using Laptop computers than Desktop computers, (2 marks)(b) Some instructions are missing in the following Scratch program that is used to draw the shape given below. Complete the program giving suitable instructions. stant * Note 1 Step = 1mm (5 marks) 5. Some of the tools in a word processing software are given below. Write the label of the tool that can be used to get the function done. Use to write the title in the centre of several cells together. Use to change the colour of a cell background. | Use to change the orientation of the text im a cel. Use to indicate a currency Use to copy the text formatting from one cell to another. Use to move the content of a cell to another cell. | Use to change the colour of the text | | Use to format the text so that it can be displayed on more than one line in a cell if needed. Use to separate thousands with a symbol. Use to decrease the number of decimal places. _ Colombo 07 Page=5 Grade ICT6. A library uses barcodes to identify borrowers a a barcode with an equivalent numerical code, ‘equivalent numerical code, ind books. A borrower has a card con Each book also has a barcode with an Following flowchart shows what happens when book(s) are taken out by aborrower, However, several stages are missing. : (Note: If the barcode isn’ "t recognized by the system, Librarian must enter the aumerie value manually) Several of the statements in the flowchart are missing, 8) Using item number only from the list below. complete the flowchart, { Ttem No: | Statement 1 ___[ any more books to scan? Saslomer SSE 2 hhas book's barcode been recognised? book(s) aad has book's numeric code been recognised? | 4 _| has borrower's barcode been recognised? 5 has borrower's numeric code been recogni ‘barcode on 6 ut book's numeric code manuall eee z input borrower's numeric code manually s 8 scan in barcode shown in book 4 9 [update borrower and book files me No Yes = ¥ + OUTPUT ZR a Aon) No No.