CSEC Information Technology Paper 2 May/June 2010 - Free CXC Past Paper with Answers

State the type of user interface that is represented in EACH figure.

Indicate by writing the figure number of the interface that (i) uses a mouse (ii) would be easier for someone who is not familiar with a computer.

Give the name of another user interface.

State the name of the system software that provides the user interface.

You wish to change the name of a file you have on your computer. Explain how you would do so using the interface in (i) Figure 1 (ii) Figure 2.

Write the numbers 1 to 5 on separate lines in your answer booklet. Using the information in Table 1, match the number of the device with the letter for the task that the device performs by writing the letter next to the number in your answer booklet.

For EACH of the devices listed in part (a), state ONE organization where each would MOST likely be used.

State ONE natural disaster that can cause damage to computer hardware, physical files or data.

Using the scenario described above, for EACH of the following clearly indicate what type of theft or damage is present and provide TWO examples to justify your response: (i) Deliberate theft OR deliberate damage to computers and files (ii) Accidental theft OR accidental damage to computers and files

Deliberate theft OR deliberate damage to computers and files

Accidental theft OR accidental damage to computers and files

Explain how EACH of the following should be protected from damage or theft: (i) Physical files (ii) Computer equipment (iii) Software and data

Physical files

Computer equipment

Software and data

State the word that the abbreviation 'e' represents in e-learning, e-commerce and e-mail.

State the network of networks that is necessary to transfer this information to users across the world.

State ONE advantage and ONE disadvantage of using any ONE of these methods (e-learning, e-commerce or e-mail) to access or share information.

Write the appropriate term, e-learning, e-commerce or e-mail, that matches EACH of the following examples: (i) Paying a fee to access the latest Top-40 tunes (ii) Accessing a webpage to post a question for a tutor (iii) Sending a single message to four friends

Paying a fee to access the latest Top-40 tunes

Accessing a webpage to post a question for a tutor

Sending a single message to four friends

Explain the difference between 'e-learning' and 'e-commerce'.

State TWO advantages of an information processing system.

State TWO types of processing carried out by a payroll system.

State TWO types of reports generated by the payroll system.

The payroll system uses a master file and a transaction file. Explain what is contained in EACH file.

Records can be organized in a file in a serial or sequential manner. Explain the difference between the two methods of file organization.

List TWO properties of a field.

Explain how you would delete a field from a table.

Give the name of the primary key in the CUSTOMER table.

Write a query to find ALL distributors with YTD SALES greater than $50,000.00.

List TWO types of data that can be entered into a spreadsheet cell.

Write the formula that was inserted in cell B7 to compute the TOTAL sales.

What formatting feature was used on the Sales figures?

All beverages with sales under 100,000.00 are given a status of 'POOR' while others are given a status of 'GOOD'. Write the function that should be entered into cell C2 to show the status of the beverage 'soda'.

Table 3 shows labels in Column 1 and statements that represent the steps in problem solving in Column 2.

Arrange the labels to show the correct order in which the steps in problem solving occur. Write that order in your answer booklet.

TABLE 3

You are using a program to calculate the average number of storms that have recently passed through the Caribbean. This is calculated by adding the number of storms and then dividing by the number of years. The screen for the program looks like the one below:

STORM STATS

Enter the Number of Years (1 to 4) [ ]

Enter the Number of Storms:

Year 1 [ ] Year 2 [ ] Year 3 [ ] Year 4 [ ]

Average number of storms: [ ]

You were told that the number of storms for the last three years were 10, 8, and 12.

State the data that is required to input a) the number of years b) Year 1 c) Year 2 d) Year 3 e) Year 4.

State the result for the 'Average number of storms'.

Write an algorithm using pseudocode to input the total number of storms for three years, to calculate the average number of storms, and to output result.

Each of the following programming statements contains ONE error. Rewrite the statement, correcting EACH error. (i) IF $(X = 3)$ TRY $Y = 8$; (ii) WHILE $(X = 3)$ UNTIL $Y = Y + 1$; (iii) FOR $X = -1$ – 10 DO WriteLn(X);

Explain the difference between a 'variable' and a 'constant'.

Write an example of a constant using a Pascal statement.

Write an example of a value that can be stored in EACH of the following types of variables: (i) Integer (ii) Real (iii) Character (iv) String

Rewrite the following fragment of code using the given control structures:

Mark :=1; While Mark <= 40 DO Begin WriteLn(Mark); Mark := Mark + 1 End;

(i) a FOR loop (ii) A Repeat loop

Rashida wrote a program in Pascal, and used a ___________ to translate all program instructions at one time. The program produced a list of ___________ which suggested that she made mistakes in the language rules of sentence structure when she was writing the program. Luckily, she did not have any ___________ which meant that the sequence of programming statements was correct. Rashida took a long time ___________ the code, since she could not find the errors in her source code. Eventually, her program was working.

State TWO reasons why it is important to document a program.

Explain the difference between 'system documentation' and 'user documentation'.

State the name of the program.

State the name of the array.

State the size of the array.

Explain the purpose of the array.