Free CXC Information Technology Paper 2 May/June 2022 past paper from 2022. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Answer keys are free on Caribbean AI. View the answers to every past-paper question at no cost - no payment needed - with step-by-step worked solutions and instant AI marking available on Premium.
CSEC Information Technology Paper 2 May/June 2022 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2022 past paper from 2022. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Opening the interactive papers…
Every question from this paper as text. See the answers and worked solutions. Questions are the property of the Caribbean Examinations Council; Caribbean AI is not affiliated with CXC.
Answer ALL questions.
Connect Academy is an independent school that serves students at the secondary level. The school has embraced the use of technology to enhance the teaching and learning of course content.
Identify TWO types of computers that can be used by teachers and students during lessons.
[2 marks]
Name ONE hardware device that may be useful for presenting lessons in the classroom.
[1 mark]
The school uses a database to manage its data which is stored on its local network. Identify ONE other storage method by which the school can gain access to its data in the event that the data on its local storage gets lost or becomes corrupted.
[1 mark]
The following data was taken from the school's database.
| Student ID | Student | Age | Grade level |
|---|---|---|---|
| CACS0069 | Lea, Tomas | 18 | 12 |
| CACS0123 |
| Hutton, Esther |
| 15 |
| 10 |
| CACS0127 | McKenzie, Marie | 19 | 13 |
| CACS0131 | Lipton, Kellie | 16 | 10 |
| CACS0203 | Parr, Noreen | 16 | 11 |
| CACS0240 | Palmer, Shelley | 13 | 7 |
| CACS0302 | Hodges, Gaynor | 14 | 9 |
| CACS0352 | Wills, Shona | 14 | 9 |
| CACS0422 | Newman, Abbie | 13 | 8 |
| CACS1002 | Thorp, Rosie | 12 | 7 |
| ID | Math | English | Biology | Physics | Chemistry | Computer Science | Modern Languages |
|---|---|---|---|---|---|---|---|
| 1 | 66 | 53 | 39 | 100 | 41 | 37 | 50 |
| 2 | 53 | 31 | 58 | 75 | 99 | 67 | 67 |
| 3 | 97 | 95 | 97 | 63 | 69 | 31 | 37 |
| 4 | 32 | 63 | 37 | 63 | 37 | 73 | 80 |
| 5 | 100 | 68 | 46 | 69 | 76 | 60 | 63 |
| 6 | 97 | 35 | 88 | 72 | 70 | 83 | 68 |
| 7 | 40 | 89 | 48 | 55 | 81 | 100 | 78 |
| 8 | 88 | 51 | 89 | 61 | 75 | 97 | 75 |
| 9 | 50 | 38 | 38 | 54 | 79 | 49 | 54 |
| 10 | 82 | 95 | 78 | 40 | 87 | 96 | 27 |
State the appropriate data types that would have been used in creating EACH of the following field names of the Student table.
| Field name | Data type |
|---|---|
| Student ID | |
| Student | |
| Age | |
| Grade level |
[4 marks]
State the field that would be used as the primary key in the Student table.
[1 mark]
Identify the field in the Course table that can be used to link the Course table and the Student table and state the name of the key given to the field.
[2 marks]
The following is the result of a query which was designed to display the course average of each student.
| Student ID | Course Average |
|---|---|
| CACS0069 | 53.13 |
| CACS0123 | 68.38 |
| CACS0127 | 53.00 |
| CACS0131 | 53.00 |
| CACS0203 | 72.25 |
| CACS0240 | 72.25 |
| CACS0302 | 76.25 |
| CACS0352 | 72.13 |
| CACS0422 | 52.38 |
| CACS1002 | 71.13 |
State the feature that was used in the query to generate the course average.
[1 mark]
When creating reports in a database, grouping can be very useful. Explain the purpose of grouping.
[2 marks]
The school recently held security workshops for both staff and students, to heighten their awareness of security threats and practices. <br/> (i) Describe TWO ways by which staff can protect their computers and data from possible security threats. <br/> (ii) State TWO personal security measures students should take when they are online.
[6 marks]
Impact Security Services provides a number of security options for its clients that includes security guards for personal and business purposes as well as monetary (cash) pickup. The company recently added computer and data security services along with a product line of security equipment. <br/> (a) The following is an invoice that was sent to a customer from the sales department.
28 Tropical Boulevard Carib Town www.impactsecure.com [email protected]
| Name / Address | Date | Invoice # | |
|---|---|---|---|
| Family Genetics | 1/6/2023 | 21073 | |
| 34 Dunbar Road | Delivery | Terms | Rep |
| 1/30/2023 | 50% deposit to be made | Ava Spence | |
| 1 week before delivery |
| Description | Qty | Cost | Total |
|---|---|---|---|
| Security camera | 10 | $189.99 | $1,899.90 |
| Alarm system | 2 | $430.00 | $860.00 |
| Security monitor | 4 | $116.72 | $466.88 |
| Biometric lock system | 1 | $184.73 | $554.94 |
| Labour - installation | 1 | $580.65 | $580.65 |
| Optional services | 1 | $300.00 | $300.00 |
| Subtotal | $4,662.36 | ||
| Sales Tax (15.0%) | $696.35 | ||
| Total | $5,338.72 |
[2 marks]
The company's logo is missing from the invoice. The logo is stored in a desktop folder on the sales manager's computer.
List, in correct order, the steps that should be taken to insert the logo to the right of the company's name.
[4 marks]
The company's website was recently updated to include the new services and products available.
Outline TWO checks that should be carried out before publishing a website.
[4 marks]
When customers hire Impact Security Services for their computer and data security needs, the company does an audit to assess the areas of vulnerability and the possible threats that may occur.
Define EACH of the following terms in relation to computer security and provide an example of each.
[8 marks]
Vulnerability
[4 marks]
Threat
[4 marks]
The company hosts webinars on its website every month to discuss the different types of security threats and attacks that companies may be exposed to. State ONE example of EACH of the following security threats and attacks that may be discussed in the webinars.
[4 marks]
Industrial espionage
[1 mark]
Denial of service attack
[1 mark]
Ransomware
[1 mark]
Data theft
[1 mark]
State TWO ways in which phishing messages can be sent.
[2 marks]
Kickstart Investments offers a range of options to its clients, from low risk to high risk investments. Due to an increase in clientele, the decision was made to open a second office in another city to accommodate more of its clients.
(a) Both office locations have their own Local Area Network (LAN). Identify the type of network that would be needed to connect both locations.
(b) Differentiate between an 'intranet' and an 'extranet'.
(c) Complete the following paragraph by filling in the blank spaces with the MOST appropriate term provided from the word list below.
software developer network adapter server switch modem web page web server copper cable
Internet web manager hyperlinks
Shortly after the opening of the new office, some of the employees and customers were experiencing difficulties completing tasks. The ____________________ did some troubleshooting and realized that the ____________________ that converts digital data to analog signals was disconnected from the ____________________ that manages and serves all the computers on the network. This prevented the employees from going online and accessing the ____________________. The employees on the third floor were unable to access certain files on the network due to a power supply (hardware) failure of the ____________________ that was used to connect all the devices on that floor to the main computer that manages the network. The ____________________ also did some checks which revealed that some of the ____________________ on the website were broken. This prevented customers from completing certain transactions.
[13 marks]
Both office locations have their own Local Area Network (LAN). Identify the type of network that would be needed to connect both locations.
[1 mark]
Differentiate between an 'intranet' and an 'extranet'.
[2 marks]
Complete the following paragraph by filling in the blank spaces with the MOST appropriate term provided from the word list below.
software developer network adapter server switch modem web page web server copper cable
Internet web manager hyperlinks
Shortly after the opening of the new office, some of the employees and customers were experiencing difficulties completing tasks. The ____________________ did some troubleshooting and realized that the ____________________ that converts digital data to analog signals was disconnected from the ____________________ that manages and serves all the computers on the network. This prevented the employees from going online and accessing the ____________________. The employees on the third floor were unable to access certain files on the network due to a power supply (hardware) failure of the ____________________ that was used to connect all the devices on that floor to the main computer that manages the network. The ____________________ also did some checks which revealed that some of the ____________________ on the website were broken. This prevented customers from completing certain transactions.
[7 marks]
Kickstart Investments needs an algorithm written to accept the initial investment amount made and the rate of return. The algorithm should calculate and print the return on investment earned using the formula below.
Return on investment = (initial investment + (initial investment*rate/100)) – initial investment
[15 marks]
Complete the following Input Processing Output (IPO) chart for the algorithm to be written.
[3 marks]
Write the pseudocode for the algorithm.
[8 marks]
If initial investment is greater than $100 000, then the rate of return is 45% and if initial investment is less than or equal to $100 000, then the rate of return is 37%.
Write an appropriate compound conditional statement to evaluate each rate.
[3 marks]
State the return on investment that would be received if the initial investment amount was $150 000 and the rate of return was 45%.
[1 mark]
Nigel is the manager at Elite Sports, a small sports club that provides its members with access to personal training and multiple sporting activities.
Nigel takes the data from application forms filled out by potential customers and enters it into the system for effective record-keeping.
[1 mark]
State ONE type of error that could be present after entering the data from the application forms.
[1 mark]
Describe TWO verification checks that can be performed when entering data from application forms.
[4 marks]
The following spreadsheet shows monies collected from members for training at the sports club for one week.
[1 mark]
Name the spreadsheet function that will display the number of cells in the range B3:B10 that contains the activity "Tennis".
[1 mark]
Write the formula that was used in Cell E3 to calculate the amount due.
[3 marks]
The IF function performs a logical comparison between two values in a spreadsheet.
Describe the syntax of the IF function.
[4 marks]
Identify both the primary field and the secondary field used to sort the data as displayed in the spreadsheet at (b).
Primary field Secondary field
[2 marks]
The following pseudocode was created to generate the total funds received from member payments.
Start
total = 0
Print "Enter amount due for member"
Read amountdue
While (amountdue <> 0) do
total = total + amountdue
Print "Enter amount due for next member"
Read amountdue
Endwhile
Print "Total amount collected:", total
Stop
Design a flowchart to represent the pseudocode above.
[10 marks]