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

For EACH of the following, describe TWO reasons for

creating or modifying an information system

analyzing actual documents for data collection

using the direct conversion approach

Consider the following paragraph:

When you tackle a project you should follow the five stages in the systems (1) ___________ life cycle, starting with the (2) ___________ and ending with an (3) ___________ of the work that you have done. Wherever possible, you should complete one stage before going on to the next. You will also be expected to produce a (4) ___________ of how the project should be produced before it is (5) ___________. After all, you may have (6) ___________ the system and convinced yourself that it works, but how are you going to convince the person assessing your work?

Copy the numbers 1 to 6 in your examination booklet and next to each number write one of the following terms which is suitable to complete the paragraph: tested, evaluation, analysis, development, implemented and design.

Describe TWO responsibilities of EACH of the following personnel in the systems development life cycle:

Systems Analyst

Project Leader

Project Team

A supermarket uses a Point of Sale (POS) terminal to keep track of the goods that it has in stock and to produce bills for customers. Whenever an item is sold, the product code of the item is read by a barcode scanner. The price and name of the product is checked in the supermarket's stock database, and this information is printed on the customer's receipt. It also updates the product's record in the stock file to indicate that the product has been sold.

Draw a data flow diagram, using the information given in the scenario above.

Explain whether this type of processing mode is batch, interactive, on-line or real-time.

Draw a decision table based on the following scenario on orders placed by a supermarket:

If orders of 5000 units or more are placed, and there is a credit facility in place, then the supermarket is given 90 days to pay. If, however, there is no credit facility in place, then the supermarket must pay 25% of the cost. If the order is less than 5000 units, and there is a credit facility, then it is given 30 days to pay. The supermarket must pay full cost otherwise.

Given the number $6.312 \times 10^4$ in standard form

identify the mantissa

identify the exponent

define the base or radix

write the number in non-standard form.

Determine if the result of $0011 + 1100$ can be stored as a four-bit binary number.

Consider the following membership form:

Membership Form

Membership #: 20221 Name: Terri Hall Gender: Male Phone: 222-2345 Date of Birth: 08/12/05

Explain the purpose of designing a good data capture form.

This form has been poorly designed. Describe TWO areas on the form that can be confusing.

State TWO codes that can help make the form easier to understand.

Name and explain TWO types of checks that can be implemented in the data entry program.

Give an example of the data coded from the membership form that is ready for data entry.

Consider the following definitions:

MOV A, B – Put the value of B into A SUB A, B – Subtract the value of B from the value in A, and put the result in A ADD A, B – Add the value of A to the value in B

Give the result of SUM and AMT after the following segment of code is executed, if SUM contains the initial value of 15 and AMT contains 5:

MOV D, SUM MOV F, AMT SUB D, F ADD D, 50 MOV SUM, D

Explain why a program counter is important in executing a program.

Explain what the program counter contains.

State the official name of a program counter.

Declare variables for SUM, AVG and COUNT.

Set SUM and COUNT equal to zero (0).

Prompt the user to enter the first number.

Read the value.

Check to see if this value is zero. If it is, continue from step (k) otherwise continue from step (f).

Add this first value to the Sum and make this new value the new Sum.

Add one to the Count and make this new value the Count (increment the count).

Prompt the user to input another number.

Read the value.

Repeat from steps (e) to (i).

Compute the average.

Print the statement: "The Sum of the values entered is" and include the value for SUM.

Print the statement: "The Average of the values entered is" and include the value for AVG.

Print the statement: You entered COUNT values.

Stop the program.

Find the Letter Grade for the first course (Biology).

Add the credit (associated with the course) to the value in CRD.

Multiply the Credits for this course in part (a) with the Value per Credits.

Add this result from part (c) to the GPA.

Go to the next course.

Repeat steps $a$ to $d$ for the second and third course.

When the first person (Robert) is finished, divide the value in the GPA variable by the value in the CRD variable and store the results as RobGPA.

Reset the values in GPA and CRD to zero.

Move on to the next person (Rupert) and do steps (a) to (f) once more.

When this person (Rupert) is finished, divide the value in the GPA variable by the value in the CRD variable. Store the results as RupGPA.

Compare RobGPA with RupGPA. The highest value identifies the winner of the award.

Print "The award goes to:" followed by the name of the winner.

In one computer language, the notation $a++$ means that a user would add the value 1 to the value $a$ after using it in an operation. The notation $++a$ means that a user would add the value 1 to the value $a$ before using it in an operation.

Use the trace table to show the values of $a$ and $x$.

x = 3, a = 1;
while a < 4
{
  x = x * a++;
  x = x – a;
}

Use the trace table to show the value of $a$ and $x$.

x = 3, a = 1;
while a < 4
{
  x = x * ++a;
  x = x – a;
}

A teacher is writing a piece of program code that will help to determine the letter grade that a student will receive based on the marks earned. A student who earns a 90 and above will receive an "A". A student who earns between 80 and 89 will receive a "B". 70 to 79 is a "C" and 60 to 69 is a "D". Below 60 is an "F". The code below is an incomplete set of nested IF statements. Some of the statements are also incorrect. Correct and complete the code so that the appropriate correct responses will be provided.

If mark > 89
  Lettergrade = "A"
Else
  If mark > 79
    Lettergrade = "B+"
  Else
    If mark > 60
      Lettergrade = "C"
    Else
      If mark >58
        Lettergrade =

The following statements use the operator $&&$ to mean a logical AND, and the operator $||$ to mean a logical OR combining elements of a programming statement. If $LegalAge = 17$ and $DriverAge = 24$, what would be the response returned after evaluating the two statements below (True or False)?

$(LegalAge > 16) \text{ \&\& } (DriverAge = LegalAge)$

$(LegalAge < 21) \text{ || } (DriverAge = 21)$

I wish to employ a driver who is of legal age but not older than 21. Write a statement using the operators and variables provided above to represent my wishes.

Two students are having an argument about the difference between an interpreter and a compiler for a computer program. Provide the students with a definition of each word so that it is clear what the difference is.

Draw a flowchart to represent this algorithm. Be sure to use appropriate symbols.

Write a segment of programming code in a language of your choice to represent the algorithm.