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

Complete the following table with FOUR contrasting differences between an Intranet and the Internet.

On a data capture form, a user enters passport number and age. Identify ONE appropriate type of validation check which can be used for EACH entry, giving a reason.

Passport number:

Age:

Complete the following table with the missing description and term relating to computer misuse.

Figure 1, Quarter1Sales, is a worksheet which shows a summary of the total amount sold by each salesperson and Figure 2 is a 1-D PivotTable created from Figure 1.

Figure 3 shows the fields from the worksheet Quarter1Sales in Figure 1 that were dragged into the different areas of the PivotTable Fields dialogue box to produce the 1-D PivotTable in Figure 2.

Describe the change you would make to the PivotTable Fields Dialogue Box in Figure 3, to show a summary of the total amount sold by EACH region.

Describe the change you would make to the PivotTable Fields Dialogue Box in Figure 3 to create the following.

A 2-D PivotTable showing a summary with a column for EACH salesperson's monthly sales (January, February and March) and the salesperson's total amount sold.

< ![CDATA[Write the formula for Cell C17 of the worksheet Quarter1Sales to calculate the total of all order amounts in Column C.

Link the 1-D PivotTable in Figure 2 with the worksheet Quarter1Sales in Figure 1, by writing a formula for Cell C1 of the PivotTable, to show the sum of all order amounts created for Cell C17 in (iii) .

< ![CDATA[Write a formula for Cell C2 in Figure 2, to be replicated through to Cell C7, to calculate what percentage of the total order amounts in Cell C1 is the salesperson's order amount in B1. (Percentage is calculated by salesperson's order amount divided by total order amounts multiplied by 100.)

< ![CDATA[A relational database is composed of the following four objects, that all work together with the same data.

Tables, Forms, Queries, Reports

Complete EACH of the statements below using the most appropriate term from the list above. (Any term may be used more than once.)

< ![CDATA[A relational database stores data in a number of related files, more commonly referred to as .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................- .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................-

................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................- are used to ask detailed questions of the database when searching for records that satisfy particular conditions.

................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................- display fields extracted from .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................- in a particular order.

................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................- use a graphical representation to allow users to enter, modify, delete and view records in the database.

ID

Customers ID

Enforce Referential Integrity

Using the following Query Design window, create a query to extract the fields ID, First Name, Last Name, Phone Number and City from the CUSTOMERS table for all customers from the city of Carenage and whose phone numbers are greater than 868-500-000.

State the ID(s) of the record(s) extracted when the query designed in (c) is executed.

The following flowchart shows a REPEAT UNTIL loop. Complete the flowchart by labelling the TWO directional lines leaving the condition box as TRUE and FALSE.

Draw a flowchart of the WHILE DO ... ENDWHILE loop in the box provided below.

Complete the table below based on the statements in it and the flowcharts in (e) (i) and (ii).

State the MAIN requirement for the use of the FOR loop.

An algorithm is needed to read the age of each student until it reads an age of 999. It should then calculate the average age and output both the number of students and the average age of all students.

Complete the IPO Chart below to define the problem by decomposing it into EACH of its significant components: Input, Processing and Output.

The following is the pseudocode for the algorithm mentioned in (a).

START
Set COUNT ← 0
Set AGE ← 0
Set AVERAGE ← 0
Set TOTAL ← 0
Write "Enter Student's age"
Read AGE

WHILE AGE <> 999 DO
  Set TOTAL ← TOTAL + COUNT
  Set COUNT ← COUNT + 1
  Write "Enter another age or 999 to terminate the program"
  Read AGE
ENDWHILE
Set AVERAGE ← TOTAL / COUNT
Write "Number of Students:", COUNT
Write "Average age of Students:", AVERAGE
STOP

< ![CDATA[Identify TWO impacts of Information Communication Technology (ICT) on the work pattern of employees in the health sector.

< ![CDATA[The workplace has changed drastically because of the ICT revolution. State ONE positive and ONE negative aspect of automation on skilled and unskilled jobs.

Positive: Negative:

For EACH of the following files, state the MOST appropriate file organization method and give a reason for EACH choice.

• File A: Meter reading records submitted by customers monthly
• File B: Personal data of customers in a master file
• File C: Customers' usernames and passwords