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

Identify the feature/function of the spreadsheet which was used to produce the summarized data in Worksheet 2.

State the information that is provided when a value in the Grand Total row of Worksheet 2 is double clicked.

If the values in Worksheet 1 are updated, the values in Worksheet 2 are not automatically updated. State the TWO steps required, in the correct order, to manually update the values in Worksheet 2.

Complete the missing parameters in the VLOOKUP formula for Cell B10 of Worksheet 2, to find the amount of sales made during the month of March by the salesperson in Cell A10.

$= \text{VLOOKUP} \quad ($

State the change that should be made to Parameter 3 in (f) (iv), in order to obtain the Grand Total for the salesperson in Cell A10.

Jay has outlined to the proprietor that in order to facilitate the expansion multiple computer systems would be needed.

List the FOUR basic components that each computer system should have.

Jay has listed a number of specialized peripheral devices that will be required. Complete the table below by indicating the category of EACH device.

Jay will need to set up a wired network to facilitate communication between the computer systems.

List THREE types of transmission media that could be used to facilitate the communication.

Identify the transmission media in (b) (i) which would be MOST appropriate for use in the scenario described.

In presenting his proposal for the expansion to the proprietor, Jay prepares the following spreadsheet which outlines the costs of materials for one of the new branches, Rock Site Startup.

Cell D4

Cell D14

To improve the presentation of the document, Jay formatted Cell A1 across all columns as shown in the spreadsheet in (c) on page 9.

Identify the formatting feature used.

List the steps taken by Jay, in the correct order, to apply the formatting feature identified in (d) (i).

State the steps, in the correct order, required to create a formula to find the average of a range of numbers in a spreadsheet.

List THREE groups of ICT- related personnel that Chavvi will need to invite to the symposium.

State TWO ways in which the extensive use of ICT has positively impacted the field of business.

State ONE reason for using bullets and numbering in a Word document.

Other than bullets and numbering, identify TWO formatting features used in the extract from the memorandum.

Describe how the positions of paragraphs 1 and 2 from the extract can be interchanged, using the drag and drop feature.

Describe the steps used in conducting a spell check in a Word document.

The pseudocode below will calculate and output the number of participants and the average age of all participants attending the ICT symposium. The algorithm will terminate and display the output when an age of 999 is entered.

Complete the following pseudocode by filling in the blank spaces, labelled 1–10, with the MOST appropriate variables and/or reserve words.

Start
Set COUNT $\leftarrow$ 0
Set AGE $\leftarrow$ 0
Set AVERAGE $\leftarrow$ 0
Set TOTAL $\leftarrow$ 0

"Enter Participant's age"
1 _________________________

Read AGE
WHILE AGE <> 2 _________________________
3 _________________________

Set TOTAL $\leftarrow$ TOTAL + AGE
Set COUNT $\leftarrow$ COUNT +
4 _________________________

Set 5 _________________________ $\leftarrow$ TOTAL / COUNT
"Enter another age or 999 to terminate the program"
Read 6 _________________________

7 _________________________

Write "The Number of Participants are: ", 8 _________________________
Write "The average age of Participants are: ", 9 _________________________

10 _________________________

The Stennet Marketing Company collects personal data from customers which it stores on computers.

State TWO possible effects of the improper storage of data.

State TWO measures that can be used to protect the data stored on a computer.

Outline the function of the loop construct in computer programming.

State TWO distinguishing features for EACH of the following types of loops.

• WHILE . . . ENDWHILE
• REPEAT . . . UNTIL

You are hired as a programmer by Stennet Marketing Company, to write a pseudocode for a supermarket. This pseudocode would be presented to the company, before the source code is written. The requirements for the pseudocode are as follows:

• Prompt the cashier to enter the price and quantity of items.
• Calculate the discount amount at 5% of the total, if the total is greater than $500.
• Otherwise, calculate the discount amount at 10% of the total.
• The algorithm should output the total and discount.

Write the pseudocode with the requirements as outlined above.

Write the pseudocode, using NESTED IF STATEMENTS, to do the following:

If the mark entered is greater than or equal to 70, then display the statement "GRADE A". Otherwise, if the mark entered is greater than or equal to 60, then display the statement "GRADE B". For all other marks entered, display the statement "GRADE NOT AVAILABLE".