Quelpr

CSEC Information Technology · May/June 2013 · Paper 2

54 questions and parts from this paper. Open one to see it in full, then practise it on Quelpr and get it marked against the mark scheme.

Practise this paper
  1. 1(a)(i)1 markViewing images from one computer to another over the Internet.
  2. 1(a)(ii)1 markProducing architectural drawings such as building plans.
  3. 1(a)(iii)1 markPlaying games using the computer.
  4. 1(a)(iv)1 markRetrieving information electronically from a code on a product.
  5. 1(a)(v)1 markIdentifying users by scanning their fingerprints.
  6. 1(b)2 marksState TWO characteristics of printers that Kim should consider when purchasing a printer.
  7. 1(c)1 markState the general name associated with devices such as a printer.
  8. 1(d)2 marksExplain what is meant by a 'bistable' device.
  9. 2(a)(i)2 marksName TWO types of user interface.
  10. 2(a)(ii)2 marksState an appropriate input device for EACH interface named in (a)(i).
  11. 2(b)2 marksName the type of menu illustrated in Menu A and Menu B.
  12. 2(c)(i)1 markName ONE operating system.
  13. 2(c)(ii)3 marksExplain ONE function of an operating system.
  14. 3(a)(i)1 markSecret information is obtained by spying on competitors or opponents.
  15. 3(a)(ii)1 markA malicious program that is designed to corrupt files on a computer or to cause the computer hardware to malfunction.
  16. 3(a)(iii)1 markThe illegal copying of programs.
  17. 3(a)(iv)1 markUsing another person's credit card for transactions without his/her permission.
  18. 3(a)(v)1 markUsing a computer to alter company data.
  19. 3(b)5 marksState the technical term that describes EACH of the types of misuse of data labelled (i), (ii), (iii), (iv) and (v) as underlined in the passage: (i) used emails to mount a vicious attack on a supervisor (ii)…
  20. 4(a)2 marksState TWO differences between RAM and ROM.
  21. 4(b)2 marksGive TWO reasons why it is necessary for computers to have secondary storage.
  22. 4(c)6 marksMatch EACH term in column X ((I) to (VI)) with the letter ((A) to (F)) that corresponds to the MOST appropriate term in column Y.
  23. 5(a)(i)1 markState the purpose of encryption.
  24. 5(a)(ii)1 markSuggest the type of data that the company may want to encrypt.
  25. 5(b)2 marksSuggest TWO security measures that can be used to prevent an agent from viewing another agent's confidential files.
  26. 5(c)2 marksState TWO precautionary measures that can be taken to protect the client data in case of a fire.
  27. 5(d)4 marksExplain TWO validation checks that the company can carry out while entering data in the computer.
  28. 6(a)2 marksWhat is the hexadecimal equivalent for the decimal number 21? [Working must be shown.]
  29. 6(b)4 marksThe ASCII representation for the letter 'D' is 1000100. What is the ASCII representation for the letter 'G'? [Working must be shown.]
  30. 6(c)3 marksWhat does the acronym BCD stand for?
  31. 6(d)1 markState how many bits are represented by one digit using BCD representation.
  32. 7(a)1 markState the number of rows that are illustrated in the spreadsheet.
  33. 7(b)(i)4 marksWrite the formula used to calculate the total number of students who passed Chemistry.
  34. 7(b)(ii)1 markIf range A4 to F6 was sorted in ASCENDING order by subject, state the cell location of Biology after the sort.
  35. 7(c)(i)1 markState the name of the function that should be used to find the number of subjects listed in the spreadsheet.
  36. 7(c)(ii)1 markState the name of the function that should be used to find the LEAST number of passes with Grade I.
  37. 8(a)3 marksComplete the database structure table by specifying Field Name, Data Type, and Field Description to store the given customer data.
  38. 8(b)1 markState a field name from the list you have provided in (a) above that can be used as a primary key.
  39. 8(c)2 marksWrite the criteria to search the database table for all the persons who owe more than $500.00.
  40. 8(d)1 markState the feature of a database management system that prints data in a specified format with a title.
  41. 9(a)7 marksDraw a flowchart to illustrate the following fragment of code: IF P > Q THEN PA = P - Q ELSE QA = Q - P
  42. 9(b)8 marksComplete the trace table using the code provided in (a).
  43. 10(a)(i)2 marksState the output from the program when 4 is input for both X and Y.
  44. 10(a)(ii)1 markState the line number that produced the output statement in (a)(i) above.
  45. 10(a)(iii)1 markThe output suggests an error exists. State the name of the type of error.
  46. 10(a)(iv)2 marksState the line number in which the error exists and rewrite the program code that would correct the error.
  47. 10(a)(v)1 markState the type of structure that is used in lines 7 to 9.
  48. 10(b)(i)2 marksWrite a statement to initialize the variable X to zero.
  49. 10(b)(ii)1 markState the line number in which the statement in (b)(i) above could be appropriately inserted.
  50. 115 marksRewrite the Pascal statement given below to declare an array called LIST, replacing letters (A), (B) and (C) with the appropriate term or value: VAR (A) : ARRAY [ (B) ] of (C) ;
  51. 12(a)3 marksWrite a program header with the name of the program as TOTAL.
  52. 12(b)4 marksDeclare a variable named SUM to store whole numbers.
  53. 12(c)4 marksInitialize the variable SUM to give it the value, zero.
  54. 12(d)4 marksPrint the value stored in the variable SUM. Ensure that the cursor is placed on the next line.

More CSEC Information Technology papers