CSEC Information Technology · January 2013 · Paper 2

55 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.

1. 1(a)6 marksName the components labeled A, B, C, D, E and F.
2. 1(b)(i)1 markGive ONE example of the type of device that may be found in component B or C.
3. 1(b)(ii)1 markGive ONE example of the type of device that may be found in component D.
4. 1(b)(iii)1 markGive ONE example of the type of device that may be found in component E.
5. 1(b)(iv)1 markGive ONE example of the type of device that may be found in component F.
6. 2(a)(i)1 markDetermine its octal equivalent.
7. 2(a)(ii)2 marksDetermine its hexadecimal equivalent.
8. 2(b)(i)1 markState the meaning of the term 'network'.
9. 2(b)(ii)4 marksUse Table 1 to identify the IP address 128.8.74.3.
10. 2(b)(iii)2 marksConvert the number corresponding to Group 4 in the IP address 128.8.74.3 to an eight-digit binary number.
11. 3(a)(i)1 markState what is meant by 'hard copy'.
12. 3(a)(ii)2 marksGive TWO possible reasons to explain the Minister's decision for NOT using hard copies.
13. 3(b)(i)1 markState the meaning of the term 'CD'.
14. 3(b)(ii)1 markState whether a CD is a primary or secondary storage device.
15. 3(b)(iii)2 marksGive TWO reasons to justify the recommendation to use a CD.
16. 3(b)(iv)2 marksName TWO types of CD that could be recommended.
17. 3(b)(v)1 markGive ONE reason why a flash memory card would NOT be suitable in this case.
18. 4(a)(i)1 markName the type of network that consists of computers within a small area.
19. 4(a)(ii)1 markName the type of cabling that consists of a copper wire covered by a thick layer of insulation.
20. 4(a)(iii)1 markName the type of cabling that consists of clear glass fibres enclosed in an outer sheath.
21. 4(a)(iv)1 markName the type of transmission that is capable of transmitting data at a rate of more than 1000 characters per second.
22. 4(a)(v)1 markName the protocol that a network uses for radio frequencies between wireless devices.
23. 4(b)5 marksMatch EACH job responsibility (i)–(v) to the MOST appropriate computer-related professional (A)–(E).
24. 5(a)4 marksFor the selected profession, describe ONE positive impact and ONE negative impact that Information Technology (IT) has had on that profession.
25. 5(b)2 marksGive ONE example of a hardware device or type of software that is used in the selected profession (writing the name in full).
26. 5(c)4 marksDescribe how the hardware device or type of software named in Part (b) is used.
27. 6(a)(i)1 markName the data verification method described.
28. 6(a)(ii)2 marksDescribe ONE type of error that the data verification method would detect.
29. 6(a)(iii)1 markState how the error in (a)(ii) is detected.
30. 6(a)(iv)2 marksOutline how the error in (a)(ii) can be corrected.
31. 6(b)(i)1 markThe student's name does not contain any special characters.
32. 6(b)(ii)1 markThe student's date of birth is after 31 August 2000 but before 01 September 2001.
33. 6(b)(iii)1 markThe student's weight is greater than 500 lbs.
34. 6(b)(iv)1 markThe student's age on the form is correct given the student's date of birth.
35. 7(a)3 marksState an appropriate data type for EACH of the fields: Name, DOB and Phone.
36. 7(b)1 markState the MOST appropriate field that should be a primary key.
37. 7(c)4 marksWrite a query to obtain the names of ALL youths born after 31 December 1994.
38. 8(a)4 marksList the FOUR steps involved in moving a paragraph from the beginning of a word processing document and placing it on the last page of the document.
39. 8(b)2 marksBriefly describe how you can place your cursor on a new page when your cursor is on the current page.
40. 8(c)1 markState the word processing feature that can be used to send a personalized letter to 500 clients.
41. 9(a)1 markState the name of the programming language used to write the code.
42. 9(b)2 marksExplain whether the code in lines 5 to 10 represents a loop, selection, or sequence of statements.
43. 9(c)1 markState the specific purpose of the writeln command.
44. 9(d)8 marksWrite the output from the program when Num1 = 3 and Num2 = 4.
45. 9(e)(i)2 marksFor EACH set of values, state whether a logic error, syntax error or no error is produced.
46. 9(e)(ii)1 markIf an error is produced, indicate whether the value in Num1 or Num2 has caused the error.
47. 10(a)(i)2 marksLow-level.
48. 10(a)(ii)2 marksHigh-level.
49. 10(b)5 marksRewrite the provided list (Compile, Write source code, Execute, Maintain, Link) to show the correct order of steps associated with implementing a program.
50. 10(c)1 markState the name of the code that a program uses for executing.
51. 11(a)1 markState the size of the array.
52. 11(b)1 markState the data type of the contents of the array.
53. 11(c)3 marksState the output produced from the array after executing the code fragment: For Count := 4 to 7 DO Write(LIST[Count-1]);
54. 12(a)14 marksIdentify the line number of EACH error and rewrite the correct statement.
55. 12(b)1 markAll the seven errors are of the same type. State the name of this type of error.