Quelpr

CSEC Information Technology · 2011 · Paper 2

56 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)2 marksList ONE hardware user interface and provide an example of where it is used.
  2. 1(a)(ii)3 marksState TWO types of software user interfaces and indicate which one is more suitable for use by someone who is learning to use a computer.
  3. 1(b)2 marksList ONE advantage and ONE disadvantage of real-time processing.
  4. 1(c)3 marksMatch the application numbered (1, 2, 3) with the type of software letter (A, B, C) that BEST describes the application using the given table.
  5. 2(a)(i)3 marksIf the ASCII code for the letter 'I' is 1100110, find the ASCII code for the letter 'K'. Show ALL calculations.
  6. 2(a)(ii)1 markConvert the binary number 01011110 to hexadecimal.
  7. 2(a)(iii)1 markUsing two's complement, find the 8-bit representation of -72.
  8. 2(b)2 marksJohn has an external hard drive with a capacity of 1 terabyte (TB) and Mary has a USB flash drive with a capacity of 16 gigabytes (GB). Calculate how many flash drives of information, similar to Mary's, can be…
  9. 2(c)(i)1 markFor Flash Memory Card, indicate whether it is a secondary or primary storage media.
  10. 2(c)(ii)1 markFor Random Access Memory, indicate whether it is a secondary or primary storage media.
  11. 2(c)(iii)1 markFor Programmable Read Only Memory (PROM), indicate whether it is a secondary or primary storage media.
  12. 310 marksMatch the tasks (A - J) with the BEST devices (1 - 10) suitable to perform the task. Write the device number alongside the task letter chosen.
  13. 4(a)2 marksExplain, giving a reason, the type of transaction media that is described.
  14. 4(b)2 marksExplain what is a 'hotspot' and give ONE disadvantage of having access to a hotspot.
  15. 4(c)2 marksName TWO devices that can connect to a Wi-Fi.
  16. 4(d)2 marksExplain the difference between 'line-of-sight communication' and 'scattered infrared communication'.
  17. 4(e)2 marksExplain whether line-of-sight communication or scattered infrared communication is MORE effective in transmitting data.
  18. 5(a)2 marksOffering automated voice mail where the caller presses a number to be transferred to an extension.
  19. 5(b)2 marksWorking at home or conducting business using a computer to communicate with colleagues and/or clients.
  20. 5(c)2 marksUsing only credit or debit cards for transactions.
  21. 5(d)2 marksUse of Information Technology and computers in most areas of work.
  22. 5(e)2 marksUsing a computer for a long time to complete an urgent task.
  23. 6(a)(i)1.2 marksFor Direct Access File, state whether the record arrangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).
  24. 6(a)(ii)1.2 marksFor Indexed-Sequential File, state whether the record arrangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).
  25. 6(a)(iii)1.2 marksFor Random Access File, state whether the record arrangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).
  26. 6(a)(iv)1.2 marksFor Sequential File, state whether the record arrangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).
  27. 6(a)(v)1.2 marksFor Serial File, state whether the record arrangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).
  28. 6(b)(i)1 markState whether a Grandfather file is temporary or permanent.
  29. 6(b)(ii)1 markState whether a Master file is temporary or permanent.
  30. 6(b)(iii)1 markState whether a Transaction file is temporary or permanent.
  31. 6(b)(iv)1 markState whether a Transaction log is temporary or permanent.
  32. 7(a)1 markState the range of cells containing the names of the banks.
  33. 7(b)1 markWhat data format has been applied to the data with the number of accounts for each of the banks?
  34. 7(c)1 markThe data in the spreadsheet have been sorted. Indicate the name of the field used for the sort.
  35. 7(d)2 marksWrite the function that should be used to find the HIGHEST number of loan accounts in a bank.
  36. 7(e)2 marksYou are asked to create a pie chart to show the TOTAL number of accounts in EACH bank. Write the TWO ranges of data you would use.
  37. 8(a)1 markWhat field in the COURSE table is used to sort the records?
  38. 8(b)1 markState the primary key in the COURSE table.
  39. 8(c)1 markThe two tables have been joined by a common field. State the name of the Dean of the faculty that is offering the course with Cid = ECN 100.
  40. 8(d)2 marksWrite a query to show ALL courses in the NS faculty with MORE than 5 credits.
  41. 8(e)2 marksIn the COURSE table it is required to insert a calculated field named FEE to compute the fee for EACH course. If the cost per credit is $250, write the formula for the calculated field.
  42. 8(f)1 markState the field in the COURSE table that would be MOST appropriate to use to group the data when preparing a report.
  43. 9(a)5 marksWrite code in Pascal to declare the array List1.
  44. 9(b)5 marksWrite the contents of the two arrays after execution of the following fragment of code: for x := 1 to 4 do List1[x] := List1[x] - List2[x]
  45. 10(a)3 marksinitialize the array
  46. 10(b)6 marksprint the number of stars (*) in the array
  47. 10(c)6 marksprint the comment 'NO' for all characters other than * or # in the array.
  48. 11(a)4 marksCopy and complete the trace table to show the result of the given algorithm: 1 last = 4 2 count = 0 3 While number = 3 to 7 Do 4 While (number <= last) DO 5 Count = Count + 1 6 End While 7 Output count
  49. 11(b)1 markWhat is the name of the structure from lines 3 to 6?
  50. 12(a)2 marksLow-level and high-level languages
  51. 12(b)2 marksLooping structure and conditional structure
  52. 12(c)2 marksTesting and debugging
  53. 12(d)2 marksVariable and constant
  54. 12(e)2 marksThe symbols = and <>
  55. 12(f)2 marksInteger and real values
  56. 12(g)3 marksPseudocode and flowchart

More CSEC Information Technology papers