CSEC Information Technology · 2022 · Paper 2

35 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)(i)2 marksCircle TWO direct data entry devices from the given list: Barcode reader, Joystick, Light pen, Touchscreen, Optical mark reader.
2. 1(a)(ii)2 marksName an application in which any ONE of the circled devices in (a)(i) is used, and describe the type of data captured with that device.
3. 1(b)(i)2 marksDescribe what is meant by a turnaround document.
4. 1(b)(ii)2 marksExplain how data is captured from a turnaround document.
5. 1(c)2 marksDetermine the number of 5 MB documents that could fit on a 16 GB flash drive. (Show all working.)
6. 1(d)(i)2 marksState the steps (in correct order) required to find the number of words in the given paragraph using a word processing program.
7. 1(d)(ii)3 marksList the steps (in correct order) required to conduct a spell-check on the given paragraph using a word processing program.
8. 1(e)(i)2 marksBriefly explain why it would be safer to use the 'Replace' option rather than the 'Replace All' option in the dialogue box shown.
9. 1(e)(ii)3 marksOutline the steps needed to replace all occurrences of the word 'print' with the word 'produce' using the Replace All option in the dialogue box.
10. 2(a)8 marksState the location on the network where EACH of the following hardware devices could be found AND describe the function of EACH device: - Network interface card - Wireless network adaptor - Modem - Router
11. 2(b)2 marksThe wireless devices were accessing the Internet but Sharon's desktop computer was unable to access the Internet. Suggest TWO instructions that could be given to Sharon to help her troubleshoot the problem.
12. 2(c)(i)4 marksList the steps (in the correct order) required to create the chart from data in a spreadsheet.
13. 2(c)(ii)2 marksState ONE other type of chart which is appropriate to represent the data in the spreadsheet and state how it differs from the one shown.
14. 2(c)(iii)2 marksName ONE type of chart other than those mentioned in (c)(i) and (ii) and describe when it is BEST used.
15. 2(c)(iv)2 marksWrite the formula/function to be inserted in Cell B8 to calculate the total number of books sold on Monday.
16. 3(a)5 marksComplete the table by inserting the MOST appropriate web technology concepts from the given list (Web browser, Hyperlink, Web server, Hypertext markup language, File transfer protocol, Hypertext transfer protocol,…
17. 3(b)(i)1 markState the feature that is used to establish and maintain the accuracy of data between the two database tables.
18. 3(b)(ii)1 markState why it is necessary to maintain the accuracy of data between the two database tables.
19. 3(b)(iii)2 marksOutline how the one-to-many relationship is formed between the two database tables.
20. 3(c)4 marksCreate a query by completing the query design view window to extract the fields ID, FirstName, LastName and Phone from the STUDENTS table, and the field SportName from the SPORTS table, for all married students who play…
21. 3(d)2 marksState the record IDs of the record(s) that would be extracted when the query designed in (c) is executed.
22. 3(e)(i)3 marksThere are four steps in implementing a program. List THREE of these steps.
23. 3(e)(ii)2 marksDescribe what is involved in any TWO of the steps listed in (e)(i).
24. 3(f)5 marksComplete the pseudocode by writing a nested if-then-else statement to produce the required output based on the number of goals scored by Team A and Team B.
25. 4(a)2 marksIdentify TWO variables which when added will always be equal to the monthly repayment amount of $1000.
26. 4(b)(i)2 marksThe pseudocode has a logic error. Identify the line with the error and make the necessary corrections.
27. 4(b)(ii)2 marksIdentify the stage in program implementation where the type of error stated in (b)(i) will show up and state the consequences of the error.
28. 4(c)1 markState the type of looping construct used in the pseudocode.
29. 4(d)2 marksSuggest ONE reason why the looping construct stated in (c) was used in the pseudocode.
30. 4(e)2 marksExplain ONE other named looping construct that could be used in the program.
31. 4(f)4 marksComplete the trace table by inserting the missing values for the variables in EACH row representing the first THREE times the pseudocode loops.
32. 4(g)(i)2 marksDescribe the concept of 'telecommuting' and state ONE reason why telecommuting is so impactful.
33. 4(g)(ii)3 marksDescribe the term 'denial-of-service (DOS) attack', giving ONE example.
34. 4(g)(iii)2 marksState ONE similarity and ONE difference between Bluetooth and Wi-Fi technologies.
35. 4(g)(iv)3 marksState TWO advantages and ONE disadvantage of buying software applications stored in the cloud.