Quelpr

CSEC Information Technology · January 2014 · Paper 2

57 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)1 markName ONE example of an operating system software for personal computers.
  2. 1(a)(ii)2 marksState TWO functions of an operating system.
  3. 1(b)3 marksA graphical user interface (GUI) displays applications using icons. List THREE other features of a GUI.
  4. 1(c)1 markState ONE example of a software user interface other than graphical user interface.
  5. 1(d)1 markState ONE example of a hardware user interface.
  6. 1(e)(i)1 markState ONE example of an application that uses batch processing.
  7. 1(e)(ii)1 markState ONE example of an application that uses real-time processing.
  8. 2(a)(i)1 markState the technical term for: Network of computers within a small area.
  9. 2(a)(ii)1 markState the technical term for: Network of computers within a wide geographical area.
  10. 2(a)(iii)1 markState the technical term for: Data transmission in one direction at a time.
  11. 2(a)(iv)1 markState the technical term for: Data transmission in both directions at the same time.
  12. 2(a)(v)1 markState the technical term for: Electronic service for the posting and reading of public messages.
  13. 2(b)(i)1 markState the technical term for: A teacher uses a website to share his/her personal comments on school issues.
  14. 2(b)(ii)1 markState the technical term for: An audio file containing the Prime Minister's speech on Independence Day has been placed on the Internet for downloading and listening.
  15. 2(b)(iii)1 markState the technical term for: CXC sends results to each candidate electronically.
  16. 2(b)(iv)1 markState the technical term for: Adam uses the Internet to purchase his textbooks from Amazon.
  17. 2(b)(v)1 markState the technical term for: Kim is doing a degree in nursing using the Internet.
  18. 3(a)(i)3 marksOther than computers and power protection devices, list THREE hardware devices which could be used with the computer systems.
  19. 3(a)(ii)3 marksGive ONE example of an appropriate use by the teacher of EACH of the three additional hardware devices listed in 3(a)(i).
  20. 3(b)(i)1 markGive a suitable example of how a Pascal compiler could be used by an IT teacher.
  21. 3(b)(ii)1 markGive a suitable example of how spreadsheet software could be used by an Accounting teacher.
  22. 3(b)(iii)1 markGive a suitable example of how presentation software could be used by an English teacher.
  23. 3(b)(iv)1 markGive a suitable example of how CD/DVD burning software could be used by a Social Studies teacher.
  24. 4(a)2 marksClassify the activity as EITHER verification OR validation, and state either the purpose (if verification) or the name of the check (if validation): You are asked to enter a new password twice.
  25. 4(b)2 marksClassify the activity as EITHER verification OR validation, and state either the purpose (if verification) or the name of the check (if validation): Check to verify that letters have been entered instead of digits on a…
  26. 4(c)2 marksClassify the activity as EITHER verification OR validation, and state either the purpose (if verification) or the name of the check (if validation): Check to see if the date entered for April is between 1 and 30…
  27. 4(d)2 marksClassify the activity as EITHER verification OR validation, and state either the purpose (if verification) or the name of the check (if validation): Check that the gender of a person is "M", if the title is "Mr".
  28. 4(e)2 marksClassify the activity as EITHER verification OR validation, and state either the purpose (if verification) or the name of the check (if validation): Check to see if the year(yy) is entered as 68 instead of 86.
  29. 5(a)3 marksFind the decimal representation of a SIGNED number represented by BCD, 1011 0110 0101 0100. Show all working.
  30. 5(b)3 marksFind the two's complement eight-bit representation of the decimal number, -42. Show all working.
  31. 5(c)4 marksCopy and complete the table by indicating the type of storage media and the method used to access data for DVD-ROM and Data tape.
  32. 610 marksMatch Column X with Column Y by writing the numbers 1 to 10 and next to each number, the corresponding letter chosen from Column Y.
  33. 7(a)3 marksState the cell address and the function required in the cell to compute the total revenue collected from sponsors.
  34. 7(b)1 markWhat format has been applied to the numeric data in the spreadsheet?
  35. 7(c)2 marksA pie chart was created for the data in the spreadsheet. Each slice of the pie indicates the month, the total for the month and the percentage of the total revenue collected. State the ranges for the category name and…
  36. 7(d)(i)1 markState the criterion to implement the filter to extract all revenue items with a TOTAL greater than 25 000 for the six-month period. (Indicate the column heading and the criterion to be inserted under the column heading.)
  37. 7(d)(ii)1 markHow many revenue items will be extracted by the filter?
  38. 8(a)1 markState the name of the table used to store data in the database.
  39. 8(b)1 markWhich field in the table can be used as the primary key?
  40. 8(c)1 markIf the records in the table are sorted from the newest to the oldest member, what will be the Membership_No. of the member who would be at the TOP of the sorted list?
  41. 8(d)(i)1 markHow many fields will be displayed when the query shown in the grid is executed?
  42. 8(d)(ii)1 markHow many records will be displayed when the query shown in the grid is executed?
  43. 8(e)2 marksA report is generated from the database table. State TWO fields which could be used to group the data.
  44. 9(a)5 marksWrite codes in PASCAL to declare the array TEST1.
  45. 9(b)5 marksA third array DIFF is created by subtracting TEST2 scores from TEST1 scores. Assuming all three arrays begin at index 1, write the content of the array DIFF when the given fragment of code is executed.
  46. 10(a)6 marksUsing the provided Pascal program, copy and complete the trace table.
  47. 10(b)4 marksA water company awards a waiver of monthly water charges if: (i) Applicant is 65 years or older, AND (ii) Applicant must NOT be working. Copy and complete the truth table.
  48. 11(a)2 marksState ONE difference between a variable and a constant.
  49. 11(b)2 marksState ONE difference between conditional branching and looping control structures.
  50. 11(c)2 marksState ONE difference between syntax and logic errors.
  51. 11(d)2 marksState ONE difference between testing and debugging.
  52. 11(e)2 marksState ONE difference between source code and object code.
  53. 12(a)2 marksWrite PASCAL code to declare the duties rate and luxury tax rate.
  54. 12(b)5 marksDraw a flow chart to check the engine size of a car and compute the luxury tax to be paid. Use the variable car_val to store the value of the car and the variable engine to store the size of the car engine.
  55. 12(c)3 marksWrite PASCAL code to declare THREE variables with meaningful names to be used in the program.
  56. 12(d)2 marksWrite PASCAL code to initialize the variable that will contain the total duties and taxes to 0.
  57. 12(e)3 marksWrite PASCAL code to calculate the duty to be paid on a car. Use the variables you declared.

More CSEC Information Technology papers