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

Storage and manipulation of data can occur in different ways within a computer system. Complete the following table by stating the correct term for EACH example of data manipulation and storage method. An example has been done for you.

AC5 is represented as 1010 1100 0101

This method converts the number to binary, converts the digits, and adds one to the result.

$1 + 1$ is represented as $10_2$

$8_{10}$ is stored as $10_8$

The following ASCII code represents some of the keys on a computer keyboard.

Write the representation of the character 'D'.

Using the code for 'C', calculate the ASCII code for the letter 'H'. Show all steps.

Reyna created another episode of her video so that viewers can automatically download the video episodes over the Internet and watch them from their computer or mobile device.

She also created a webpage as a journal to share her experiences while creating each video.

She used a program on the Internet to call her aunt in another country to tell her about her progress at school.

Reyna had to submit a script to the school's online course page for her teacher to grade.

Her school's network is private and restricted to students and teachers.

On weekends, she communicates over the Internet with her family and friends via instant text messages.

She purchased a new camera lens from an online store and paid for it with her credit card.

Reyna followed rules and procedures to transmit some files over the Internet to the server at school.

She read the messages about her films that were posted by others on a central system on the Internet.

Reyna's brother wrote a short note using a computer and sent it to her via an Internet connection.

Identify the security measure and the type of restriction, software (S) or physical access (P), represented by EACH image in the following table.

Explain the purpose of EACH of the following security procedures:

Archiving

Recovery

Processing modes can be completed either via batch, online/real-time or time sharing. The following table describes the characteristics of two of these processing modes. Complete the table by entering a relevant statement for the online/real-time processing mode for EACH characteristic.

Specify the MOST applicable processing mode (batch or online/real-time) for EACH of the following:

Credit card billing systems

Electronic funds transfer systems

Flight stimulation systems

Calculating number of hours worked at the end of the week

Processing each customer's payments for the current month

Complete the table below by providing the guidelines for the data entry.

State whether the data checks in (a) represent validation or verification of the data.

State the type of alignment that has been applied to column A.

Suggest a reason why the values in column F are displayed as decimals.

The formula E2/SES5 in cell F2 was copied to cell F3. Write the new formula for cell F3.

The value in cell B3 is changed. List TWO cells whose values will be affected.

State

the number of records in the SCHOOL table

the field that can be used as a primary key in the SCHOOL table

an appropriate data type for the NoofStudents field

the field that can be used to join the two tables.

Complete the following query to determine the schools that have fewer than 500 students.

State the RCode and SchoolName that would be at the top of the table if the SCHOOL table on page 14 was sorted in descending order by RCode and then by SchoolName.

Romario can add money to his mobile phone by entering a specific code via a text message. The instructions are entered using the format below. Answer the questions based on the instructions below.

Identify the error in the following code:

AD 40 87662509 0945

Name the process that locates and fixes errors in the code.

Complete the table below to show whether the message will be accepted or not accepted for EACH of the following options.

Draw a flowchart, including START and STOP symbols, to illustrate the following:

• Input SCODE
• If SCODE is equal to 0945
• Then add money to the phone
• Otherwise Output 'ERROR – Code Incorrect'

State

the index location for the payment of $30

the amount of money added at index 25.

Write Pascal code for EACH of the following:

Declare the array called MONEY.

Initialize the array to 0.

Print the amount of money stored at the 54th location in the array.

the type of loop

a relational operator used in the code

the data type of Amount

the location of the cursor when the area code is input

the result when the area code is 876.

Complete the following trace table using the values (12, 3, 0, 15, 5) that were entered when the program above was executed.

State the purpose of the code in line 13.

Name the type of error that would occur if the program does NOT produce the correct results.

Explain the statement in line 6 of the program code on page 20.