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

Christopher is contemplating using cloud-based storage. To assist Christopher with his decision-making, complete Column 2 of the table below by stating true or false for each of the statements about cloud-based storage made in Column 1.

Outline the MAIN difference between 'systems software' and 'application software'.

State ONE example of a hardware device with a user interface.

Classify EACH of the following data entry devices as either manual data entry or direct data entry.

Mouse Optical character reader Light pen Sensor

State the name of the feature used to create a connection between the flyer and the company’s website.

The connection between the flyer and the company’s website is to be tested before the flyer is distributed. State the reason for having to do this test.

Identify TWO text formatting features used in the design of the first column of the flyer on page 10.

Identify TWO page formatting features used in the design of the flyer.

The graphic artist would like to amend the Word document he created in order to produce a new flyer but would still keep a copy of the original document. Describe how he could create the updated document.

Name ONE word-processing feature that would allow you to protect your document while you are working on it and ONE feature that could protect the final document.

Identify the type of network that would be MOST suitable for ensuring connectivity between a physical computer in two different locations as well as the online classroom.

Complete the following table by stating whether the listed transmission media items are wired or wireless.

The following spreadsheet is part of a master timetable issued for the institution for the September 2021 academic year.

The administration of the institution would like to be able to easily view the days when most students are engaged. List the steps to be taken, in the correct order, to create a graphical representation of this information.

Using the spreadsheet on page 12, write the function or formulae to calculate the average number of students in a class.

Create the formula in Cell F2 to output "YES", if the class is over 30 students.

Identify the steps to be followed to copy the formula in Cell F2 to the range of cells from F3:F11.

Consider the following times table algorithm.

START
Set VALUE ← 7

Write "NUMBER ", "PRODUCT "
FOR NUMBER ← 0 TO 12 DO
    PRODUCT ← NUMBER * VALUE
    Write "", NUMBER, "", PRODUCT
ENDFOR

State the names of the variable(s) and constant(s).

Variable(s) Constant(s)

Name the type of construct that is being used.

State the type of computer system that is required for EACH of the following purposes.

• Processing of scientific data
• Distribution of data over a network
• Working from home

Identify the function of EACH of the labelled components, A–E, as ONE of the following: input, systems unit, storage, output. EACH function may be used more than once.

A B C D E

State ONE device that may be found on a computer monitor that is used for video conferencing. Give ONE reason for your answer.