CSEC Information Technology Paper 2 January 2022 - Free CXC Past Paper with Answers

State TWO methods that can be used to prevent members of the public from having physical access to stored information.

Suggest TWO software methods that can be used to prevent unauthorized staff from accessing sensitive data on a network.

State TWO ways in which the integrity of data can be destroyed.

Cyndra has created a web-enabled database application to allow her friends from the university to enter their own data from a webpage. The database consists of the following two tables, CONTACTS and DEGREES. Data entered in the Gender field must be "M" for male and "F" for female and all dates of birth entered must be prior to 30 June 2000.

TABLE 1: CONTACTS DATABASE

TABLE 2: DEGREES DATABASE

Identify the MOST appropriate field types for EACH of the following fields.

State what is meant by the term 'primary key' in a database table.

Identify TWO primary keys from the database tables on page 9.

Outline the role of a 'foreign key' in a database table.

Identify the field(s) from the database tables mentioned on page 9 that can be used to establish EACH of the following foreign keys.

Describe the relationship that is established between Table 1 and Table 2 on page 9.

Roger, a new employee in the information technology department of a supermarket, notices that discounts are being calculated manually. Roger asks for a pseudocode to be generated that would handle 25% discounts on merchandise totals.

Write the pseudocode for the algorithm that will

• initialize the variables
• prompt the user to input the price and quantity of the items
• calculate the discount amount at 25% of the total if the total is greater than $1800
• output the discount amount.

Roger has been tasked with reconfiguring the network system for the supermarket, which is expanding.

List THREE types of networks.

Describe ONE type of network that would be suitable for effectively managing the functions of all departments of the supermarket from a central location.

Roger is considering segregating the users of the network. Differentiate between an 'intranet' and an 'extranet'.

Roger must produce a table showing the cost of the equipment he will need to purchase in order to facilitate the expansion of the network. The table below illustrates a part of the spreadsheet that was produced.

Write the formula to be inserted in Cell D5 to calculate the total cost of the switches.

Write the function that would be placed in Cell D12 to calculate the average cost.

Roger's employer wants to have the spreadsheet on page 14 sorted in alphabetical order. List, in the correct order, the steps that would be required to do this.

During a staff meeting, management decided that docks were an unnecessary cost. State, in the correct order, the steps required to delete Row 9 from the spreadsheet on page 14.

List FOUR main computer hardware devices that Keva will need to facilitate her business.

Keva has to ensure that her devices are equipped with sufficient storage. Describe the function of any TWO features of a hard drive/disk.

State ONE reason for using passwords.

Give ONE example of an effective password.

Keva writes the pseudocode below for her first client. Study the pseudocode carefully and answer the questions that follow.

Start Line 1. Set MAX $\leftarrow$ 0 Line 2. Write "Enter Integer" Line 3. Read NUM Line 4. WHILE NUM $>$ MAX THEN Line 5. Set MAX $\leftarrow$ NUM Line 6. Write "Enter integer or 0 to stop" Line 7. Read NUM Line 8. ENDWHILE Line 9. Write "max" , MAX Stop

State the purpose of the pseudocode.

Name the constructs that are in the pseudocode.

State the line which represents initialization.

State the purpose of the second output statement.

State the names of the variables that are used in the pseudocode on page 17.

Identify the TWO lines in the pseudocode on page 17 that demonstrate relational operators.

Keva, having written the pseudocode in (b) on page 17, wants to use flowcharting techniques to show the structure of the program.

Draw a flowchart depicting the WHILE loop.