CSEC Information Technology Paper 1 May/June 2007 - Free CXC Past Paper with Answers

Answer the following questions using the icons in the table below:

(a) Using the number and corresponding name, categorize the above icons into the following groups: (i) Input devices (ii) Output devices (iii) Storage devices (b) Describe ONE common use of icon number 4.

Input devices: 1, 2, 4, 6, 8. Output devices: 3, 9. Storage devices: 5, 7.

Input devices: 1, 2, 4, 8. Output devices: 3, 6, 9. Storage devices: 5, 7.

Input devices: 1, 2, 4, 6, 8. Output devices: 3, 9. Storage devices: 5, 7.

Input devices: 1, 2, 4, 8. Output devices: 3, 6, 9. Storage devices: 5, 7.

Explain ONE common use of a printer which uses heat on chemically treated paper. State the name of this type of printer.

Label printing; Thermal printer

Faxing; Thermal printer

Receipt printing; Thermal printer

Barcode printing; Thermal printer

Explain in which of the interfaces a mouse is used.

Write the path required to reach the Class List.

C:\SBA\PRACTICAL\Class List

C:\PRACTICAL\Class List

C:\SBA\PRACTICAL\TESTS\Class List

Explain ONE possible solution to this error message.

Format the floppy disk.

Insert a different floppy disk.

Check if the floppy disk is inserted correctly and try again.

Delete unnecessary files from the floppy disk.

Communicating with friends or students

State ONE use of EACH of the terms indicated in (a) (i) to (iii).

State ONE qualification that EACH of them should possess.

State ONE advantage and ONE disadvantage of the use of the tools.

An insurance company gathers medical reports on its clients from the computer system of a certain out-patient clinic. The insurance company increases its insurance payments according to the number of visits to the clinic. State with reasons, whether this involves: (a) Electronic eavesdropping (b) Electronic surveillance (c) Computer fraud

State ONE advantage and ONE disadvantage of EACH generation.

Calculate MyQuotient and MyProduct if the numerator = 10 and the denominator = 2.

MyQuotient = 5, MyProduct = 20

MyQuotient = 5, MyProduct = 10

MyQuotient = 12, MyProduct = 20

MyQuotient = 12, MyProduct = 10

Consider the following programming statements:

Total = 45 Temp = 'T' Total = Total + 90

(a) Identify the variable(s). (b) State the data type(s) of the variable(s). (c) Calculate the result of Total.

a) Total, Temp b) Integer, Character c) 135

a) Total b) Integer c) 135

a) Total, Temp b) Integer, String c) 135

a) Total b) String c) 135

num = 10 For count = 1 to 2 do Write num

How would you print the content of a page across the length of the paper?

Change the page orientation to Landscape.

Change the page orientation to Portrait.

Adjust the margins to narrow.

Adjust the font size to smaller.

Explain how you would format all numeric values in the range, B7:F7 so that all thousands are separated by commas.

Select the range B7:F7, click Format Cells, Number tab, select Comma.

Select the range B7:F7, click Format Cells, Currency tab, select Comma.

Select the range B7:F7, click Format Cells, Percentage tab, select Comma.

Select the range B7:F7, click Format Cells, Scientific tab, select Comma.

The following questions relate to Database Management: The Traffic Department is concerned about reckless driving by drivers of public transportation vehicles using a particular route. On a daily basis, the traffic department would like to store information on the Registration Number of the Vehicle, the type of Vehicle (Bus, Mini-Bus, and Hired Car), the driver of the vehicle and the number of tickets issued to the driver. You have been asked to create a database table named TICKET to store the information.

(a) Create the structure of the table TICKET. Your structure should indicate the name, data type and size for EACH field in your table. ( 3 marks) (b) State ONE reason for using a form to input data into your table. ( 1 mark ) (c) Give ONE example of a record in the TICKET table. ( 1 mark ) (d) Suppose you now need to store the sex of the driver, what would you do to accomplish this task, assuming that your table has 10 records already? ( 2 marks) (e) Write a query to show ALL female drivers of Hired Cars. ( 1 mark ) (f) How would you print the data in a table for the date, 24/12/06? ( 2 marks)

CSEC Information Technology Paper 1 May/June 2007 - Free CXC Past Paper with Answers

CSEC Information Technology Paper 1 May/June 2007 Questions