CSEC Information Technology · 2015 · Paper 2

47 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 marksConvert the decimal number 78 to hexadecimal, showing all working.
2. 1(b)4 marksThe BCD of a signed decimal number is 1011 0011 0111 1000. State the decimal number.
3. 1(c)2 marksThe ASCII representation of the character 'K' is 1001011. What is the ASCII representation of the character 'H'?
4. 1(d)2 marksThe two's complement 8-bit representation of a decimal number is 11000100. What is the decimal number?
5. 2(a)(i)3 marksFrom the given list, state the devices that are classified as input devices.
6. 2(a)(ii)2 marksFrom the given list, state the devices that are classified as output devices.
7. 2(b)5 marksFor EACH device listed in the table (Pressure sensor, Plotter, Headphone, Scanner, Joystick), give an example of an application suitable for the device.
8. 3(a)(i)1 markState the name of the hardware component that stores the 'boot up' program.
9. 3(a)(ii)1 markState the name of the hardware component that executes the sequencing of instructions in the CPU.
10. 3(a)(iii)1 markState the name of the hardware component that stores data to be used later.
11. 3(a)(iv)1 markState the name of the hardware component that allows data to be entered into the computer.
12. 3(a)(v)1 markState the name of the hardware component that displays the results of processing to the user.
13. 3(b)(i)1 markFrom the specifications provided, identify the resolution of the monitor.
14. 3(b)(ii)1 markFrom the specifications provided, identify the size of the hard drive.
15. 3(b)(iii)1 markFrom the specifications provided, identify the size of the RAM.
16. 3(b)(iv)1 markFrom the specifications provided, identify the type of processor.
17. 3(b)(v)1 markFrom the specifications provided, identify the speed of the optical drive.
18. 4(a)1 markState ONE example of an operating system software used on a desktop computer.
19. 4(b)4 marksState TWO types of software user interface other than a graphical user interface (GUI). Indicate the main input device used in EACH.
20. 4(c)1 markState ONE example of a hardware user interface.
21. 4(d)2 marksIdentify TWO characteristics or features found in a GUI.
22. 4(e)2 marksApart from providing the user interface, state TWO other functions of an operating system software.
23. 5(a)2 marksState TWO methods that can be used to ensure that the data is entered accurately into the computer.
24. 5(b)2 marksExplain how the TWO methods named in (a) above ensure that the data is entered accurately into the computer.
25. 5(c)6 marksState the names of THREE checks and explain how they work to ensure that the data entered is valid.
26. 6(a)4 marksList FOUR hardware devices that are required for this laboratory.
27. 6(b)6 marksMatch each meaning in Column Y with the appropriate term in Column X (1. UPLOAD, 2. VOIP, 3. HOTSPOT, 4. URL, 5. LAN, 6. FTP) by writing the corresponding number.
28. 7(a)1 markState the name of the feature used in the spreadsheet to align the text "BJ STORES" across the columns used in the spreadsheet.
29. 7(b)2 marksWrite the function to find the maximum YEARLY Total for the period 2013-2015.
30. 7(c)2 marksIt is projected that the 2016 sales for each branch will increase by 10% over the 2015 sales. Write the formula to compute the 2016 projected sales for the BCE branch.
31. 7(d)1 markThe sales figures in the spreadsheet have been formatted. State the format used.
32. 7(e)1 markIf the spreadsheet is sorted in ascending order by the total sales for each branch, which branch will be at the top of the spreadsheet?
33. 8(a)2 marksName TWO data types other than the TEXT data type used in the stock table.
34. 8(b)2 marksState the field MOST appropriate for use as the primary key and indicate the reason for your choice.
35. 8(c)2 marksA query was created on the STOCK table and the result is shown in Query2. State the criterion used for the query.
36. 8(d)(i)1 markFrom the ITEMS REPORT generated from the table, state the field used to group the records.
37. 8(d)(ii)1 markState which field was used to sort the records in the report.
38. 9(a)2 marksState the name of the control structure used in the program and indicate the line numbers.
39. 9(b)9 marksDraw a flowchart to represent the program.
40. 9(c)2 marksIndicate the value of the constant used in the program and state what the value represents.
41. 9(d)2 marksState the name of the variable which contains tax paid by public servants for 2015, and what is its data type.
42. 10(a)4 marksDeclare the array named OMEGA in Pascal code.
43. 10(b)4 marksAssign the values 5 and 10 to the first and second locations of the array respectively, using two Pascal statements.
44. 10(c)2 marksAdd the values in the first and second locations of the array and store the sum in the third location of the array in Pascal code.
45. 1110 marksWrite the missing word next to each number (1 to 10) in the table provided, choosing from the given capitalized words.
46. 12(a)6 marksIn the table, write numbers 1 to 6 to indicate the correct order of steps corresponding to the problem-solving activities listed.
47. 12(b)4 marksFor EACH of the programming languages (Structured Query Language (SQL), Pascal, Machine Language, Assembly Language), state the generation (first to fourth) to which it belongs.