CSEC Information Technology · May/June 2019 · Paper 2

61 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)2 marksExplain how the photographs and their images can be organized for easy retrieval.
2. 1(b)2 marksIdentify ONE suitable device that could be used to organize the photographs, and state how the images of the photographs are created and transferred to the computer.
3. 1(c)4 marksUsing the provided terms (Hard copy, Soft copy, Human readable, Machine readable), indicate how the photographs are stored and accessed in filing cabinets and stored on computers.
4. 1(d)2 marksFor filing cabinets and storage on computers, state ONE measure for each that can be used to protect the photographs or their images in the event of a fire.
5. 2(a)(i)2 marksIdentify the processing mode used for printing the road tax certificates and state ONE reason why this mode may have been used.
6. 2(a)(ii)2 marksIdentify ONE validation check and state how the system will use it to determine if a certificate should be printed if full payment has not been made.
7. 2(b)(i)5 marksSelect the appropriate term from the list (CPU, Monitor, Speaker, Operating system, Primary memory, Secondary storage device) to match EACH specification in the table.
8. 2(b)(ii)1 markIdentify ONE other device that would be necessary to include with the computer system.
9. 3(a)(i)5 marksComplete the table showing the character representations across Number System #1, Number System #2, and Number System #3.
10. 3(a)(ii)3 marksIdentify the types of number systems that were used for Number System #1, Number System #2, and Number System #3 in the table in (a)(i).
11. 3(b)(i)1 markState the name of the hardware component of a computer system that manipulates data.
12. 3(b)(ii)1 markState the name of the hardware component of a computer system that temporarily stores data.
13. 4(a)6 marksState whether EACH of the storage devices listed in the table is used for primary storage or secondary storage.
14. 4(b)4 marksMatch EACH of the four depicted storage devices with the appropriate name from the list in (a).
15. 5(a)2 marksDescribe ONE scenario where Local Area Network is more useful than Wide Area Network, and vice versa.
16. 5(b)2 marksDescribe ONE scenario where Coaxial cable is more useful than Fibre-optic cable, and vice versa.
17. 5(c)2 marksDescribe ONE scenario where Simplex communication is more useful than Duplex communication, and vice versa.
18. 5(d)2 marksDescribe ONE scenario where Bluetooth is more useful than Wi-Fi, and vice versa.
19. 5(e)2 marksDescribe ONE scenario where Satellite transmission is more useful than Microwave transmission, and vice versa.
20. 6(a)(i)1 markState ONE example of an application that uses batch processing.
21. 6(a)(ii)1 markState ONE example of an application that uses real-time processing.
22. 6(a)(iii)1 markState ONE example of an operating system software for personal computers.
23. 6(b)2 marksOutline the difference between an 'intranet' and an 'extranet'.
24. 6(c)(i)1 markIdentify the hardware device that produces audio output from a computer.
25. 6(c)(ii)1 markIdentify the hardware device that stores program instructions during the execution of the program.
26. 6(d)(i)1 markState the technical term used to describe studying for a degree via the Internet.
27. 6(d)(ii)1 markState the technical term used to describe purchasing school supplies from Amazon via the Internet.
28. 6(d)(iii)1 markState the technical term used to describe sharing personal information on a website.
29. 7(a)2 marksIdentify the field that could be used as a primary key, and state ONE reason why it may NOT be a suitable primary key.
30. 7(b)(i)2 marksComplete the table to show two field names and their data types that could be used in an Instructor table.
31. 7(b)(ii)1 markIdentify the field name from the Instructor table that would be MOST suitable as a primary key.
32. 7(c)2 marksWrite the results of a query that lists the learner drivers assigned to Rick.
33. 8(a)3 marksUsing the letter 'm' for month, 'd' for day, and 'y' for year, write the format for the date that has been applied to the cells.
34. 8(b)2 marksWrite a formula to calculate the number of days that Asmara Royal has had her permit.
35. 8(c)2 marksExplain why the data CANNOT be sorted by the learner's last name.
36. 8(d)1 markState the name of the feature that allows for the viewing of some rows of data in the spreadsheet.
37. 9(a)1 markComplete the statement: 'Annissa wrote code using Pascal, a ... -level language.'
38. 9(b)1 markComplete the statement: 'She typed the ... code and then saved it.'
39. 9(c)1 markComplete the statement: 'While she was typing the code, Annissa made sure to ... certain lines so that the program was easy to read.'
40. 9(d)1 markComplete the statement: 'There were no ... errors, so the program followed the grammar of the language.'
41. 9(e)1 markComplete the statement: 'She then ... the program to see if it was grammatically correct.'
42. 9(f)1 markComplete the statement: 'Annissa then entered some ... data to see if the program produced the correct output.'
43. 9(g)1 markComplete the statement: 'If there were errors, she would have to ... the program to locate and correct these errors.'
44. 9(h)2 marksComplete the statement: 'The program produced the correct results and this meant there were no ... errors or ... errors.'
45. 9(i)1 markComplete the statement: 'Since all was well, Annissa then ... the program with comments.'
46. 10(a)(i)1.5 marksSuggest the appropriate action that should be taken by Millie, a new student, who is NOT yet ready to pay.
47. 10(a)(ii)1.5 marksSuggest the appropriate action that should be taken by Roy, a continuing student, who is ready to pay.
48. 10(b)1 markState the MAIN difference between a new student and a continuing student based on the algorithm.
49. 10(c)6 marksComplete (i) to (vi) in the table by stating the line number of the statement in the algorithm (or 'none') and drawing the corresponding flowchart symbol for each given step.
50. 11(a)5 marksDraw a flowchart to illustrate the provided segment of the algorithm.
51. 11(b)(i)4 marksUsing the course registration algorithm, complete the decision table to determine how students should register for courses based on student type and registration status.
52. 11(b)(ii)1 markState the name of the table that shows the various options.
53. 12(a)(i)1 markState the reference for the student who has to make three payments.
54. 12(a)(ii)1 markState the number of payments for the student with reference 56.
55. 12(a)(iii)1 markState the maximum number of students whose information can be stored in the array.
56. 12(a)(iv)2 marksState the meaning of '...' as shown in the array.
57. 12(a)(v)1 markState the data type for the number of payments.
58. 12(b)4 marksUsing the numbers 1, 2, 3 and 4, write the order in which the given sequence of statements are used in a Pascal program.
59. 12(c)(i)1 markState the purpose of 'count := 0;'.
60. 12(c)(ii)1 markWhat does PAYMENT refer to in the fragment code?
61. 12(c)(iii)3 marksState the purpose of the fragment code.