CSEC Information Technology · May/June 2018 · Paper 1

38 multiple-choice items from this paper. Open one to see it in full, then practise it on Quelpr and get it marked against the mark scheme.

1. Q11 mark · multiple choiceWhich of the following items are considered computer hardware?
2. Q21 mark · multiple choiceScanning an item at a computerized checkout station in a supermarket is an example of data
3. Q51 mark · multiple choiceThe primary storage device that holds the data currently being processed by the computer is known as the
4. Q71 mark · multiple choiceWhich of the following devices is used to input data into the computer?
5. Q81 mark · multiple choiceIn which of the following interface types is the user required to remember specific instructions and syntax?
6. Q101 mark · multiple choiceIn order to use a program stored on a flash drive, the program must be transferred into
7. Q111 mark · multiple choiceWhich of the following tasks is NOT a function of the control unit (CU)?
8. Q181 mark · multiple choicePrograms that duplicate the knowledge and diagnostic skills displayed by humans performing specialized tasks are referred to as
9. Q191 mark · multiple choiceTransferring data from a remote computer to your computer is referred to as
10. Q201 mark · multiple choiceWhich of the following operations is considered a feature of a biometric system?
11. Q211 mark · multiple choiceTelecommuting can be BEST described as
12. Q221 mark · multiple choiceA webmaster is important to a company because he/she
13. Q231 mark · multiple choiceThe task of keeping a company's data files and software organized through the cataloguing and storing of tapes and disks is that of the
14. Q241 mark · multiple choiceWhich of the following checks is NOT a validation technique?
15. Q251 mark · multiple choiceThe process of scrambling messages at the sending end and unscrambling them at the receiving end is called
16. Q261 mark · multiple choiceThere are many software restrictions used by computers to protect data and maintain data integrity. Which of the following entities are software restriction media? I. Viruses II. Passwords III. Encryptions
17. Q271 mark · multiple choiceItem 27 refers to the following diagram which shows a form being completed. The data from the form shown above is captured by
18. Q281 mark · multiple choiceWhich of the following statements is true of accessing files sequentially?
19. Q291 mark · multiple choiceA graph is stored and sent to another user. When the user opens the file he understands the graph he receives. This graph is a form of
20. Q301 mark · multiple choiceWhich of the following activities is NOT an example of commercial data processing?
21. Q311 mark · multiple choiceThe following formula is located in position B6 of a spreadsheet. What would be the resulting formula if it was copied to the position located immediately on the left? = B3 + B4 + B5
22. Q321 mark · multiple choiceSpreadsheet formulae use
23. Q331 mark · multiple choiceThe intersection of a row and a column in a spreadsheet is called a
24. Q341 mark · multiple choiceWhich of the following would MOST likely be placed above a graph?
25. Q361 mark · multiple choiceWhich of the following is NOT a valid data type in Microsoft Access?
26. Q371 mark · multiple choiceWhich of the following facilities is normally used for website-to-website connections?
27. Q391 mark · multiple choiceWhich of the following functions are performed by spreadsheets? I. Performing automatic re-calculation when values have been updated II. Applying formulae to numerical data to determine values III. Capturing,…
28. Q401 mark · multiple choiceIn creating a query, a student entered the following criteria for the date field. >= 05/11/2017 and <= 05/14/2017 The output will show days
29. Q411 mark · multiple choiceInformation produced from queries and tables in a specific format that can be printed from a database is called
30. Q441 mark · multiple choiceIn a spreadsheet, the column titles will always be visible when you scroll the spreadsheet if you first
31. Q451 mark · multiple choiceWhich of the following sequences of steps is correct for deleting a field in a database table?
32. Q471 mark · multiple choiceItem 47 refers to the following pseudocode and trace table. a \leftarrow 7 b \leftarrow 1 For n \leftarrow 1 to 3 do a \leftarrow b + 1 b \leftarrow a + b \begin{tabular}{|c|c|c|} \hline \textbf{n} &…
33. Q491 mark · multiple choiceIn representing algorithms, which of the following statements would be placed in the flow chart box shown below?
34. Q501 mark · multiple choiceIn an algorithm, item_price is a variable used to store the price of a grocery item. The MOST appropriate data type used for item_price is
35. Q511 mark · multiple choiceItem 51 refers to the following algorithm. Read (A, B) If A<B Then Print(A); Which of the following tasks does the following algorithm perform?
36. Q521 mark · multiple choiceIn preparing a computer program, the programmer should FIRST
37. Q531 mark · multiple choiceItem 53 refers to the following statements. (1) PRINT "ENTER an integer" (2) READ n (3) While n <> -1 DO (4) n = n - 1 (5) Print n (6) Endwhile Which of the following series of numbers represents the correct…
38. Q581 mark · multiple choiceItem 58 refers to the following algorithm. I users for length, width II length, width area \leftarrow length * width III "Area of rectangle is", area Which of the following options can be used to replace I, II and…