CSEC Information Technology January 2025 P2
Exam Instructions
Exam Information
Test Code: 01229020
Exam: Caribbean Secondary Education Certificate® (CSEC)
Subject: Information Technology
Paper: 02 - General Proficiency
Duration: 2 hours
General Guidelines
Answer ALL questions in the spaces provided.
Do NOT write in the margins.
Use extra lined pages if needed, marking clearly the question number.
Wait for instructions before turning the page.
Section 1 - Gallery Operations
1. Cloud Storage
(a)
Benefit of Cloud Storage:
Accessibility from any device with internet, allowing for remote work and easy sharing of files.
Limitation of Cloud Storage:
Dependency on internet connectivity; data may not be accessible without internet access.
2. Device Deployment
(b)
(i) Fingerprint Scanner
(ii) Portable Speakers
(iii) Barcode Scanner
(iv) Computerh
3. Database Requirements
(c)
(i) Difference between Data and Information:
Data: Raw facts and figures without context.
Information: Processed data that has meaning and is useful.
(ii) Table of Data Types:
Field Name
Data Type
Customer Name
Text / String
Date of Visit
Date
Ticket Cost
Currency
Address
Text / String
(iii) Primary Key: Customer Name could be a potential primary key as it uniquely identifies each customer.
4. Data Manipulation
(d) Two objects for data manipulation:
Query
Form
Section 2 - School Attendance Records
1. Attendance Records
(a)
(i) Complete Record Example:
MP1234, Marcia Prendergast, March 10, 2013, Mathematics Club.
(ii) Formatting Features:
Table Borders, Cell Shading, Font Style
2. Merging and Inserting Records
(b)
Cell Merging: Select two cells, then choose "Merge Cells" from the format menu in a word processor.
(c) Steps to Insert New Record:
Click on the row below where you want to insert.
Right-click and select "Insert Row".
Input the data for the new record.
3. Hyperlinks
(d) Types of hyperlinks:
(i) URL link (https://...) - External link
(ii) Email link (info@...) - Email connection link
Section 3 - Advertising and Printing
1. Printing Needs
(e)
(i) Billboard: Non-impact printer for large format graphics.
(ii) Posters: Inkjet printer for high-quality images.
(iii) Receipts: Thermal printer for receipts.
2. Troubleshooting Printing Issues
(i)
Reboot the printer and check connections.
Ensure there is ink/paper in the printer.
(ii)
Check printer settings for visibility options.
Replace the ink cartridge if necessary.
3. Problem-solving Steps
(iii) Order of Steps for Application Development:
Define the problem.
Develop algorithm.
Propose and evaluate solutions.
Test and validate solution.
Determine the most efficient solution.
4. Pseudocode Writing
(d) Pseudocode example for field trip:
INPUT number of students IF number < 25 THEN PRINT "Contact the school" ELSE IF number == 25 THEN PRINT "All students in attendance" ELSE PRINT "Trip invoice update required"
Section 4 - Application Management
1. Spreadsheet Functions
(a)
(i) Function to determine number of T-shirt types: COUNT function.
(ii) Formatting Features:
Currency Format, Percentage Format, Number Format
(iii) Absolute Addressing: Refers to a fixed reference that doesn’t change when copied or filled elsewhere.
(iv) Final Cost Formula for Travel T-shirts:
=B13*(1-$B$6)+$B$12(v) Formula for Average Final Cost:
=AVERAGE(C12:C15), Cell Reference: C16
2. Networking Devices
(b)
(i) Wi-Fi Access Point
(ii) Functions of Devices:
Network Adapter: Connects devices to a network.
Wi-Fi: Wireless communication technology.
Router: Routes traffic between networks.
Modem: Modulates and demodulates signals for internet access.
3. Logical Evaluation
(c)
(i) Evaluating expression: TRUE, because (5 MOD 2 = 1).
(ii) Evaluating expression: FALSE, as (5 != 2 AND 3 < 10).
4. Truth Table
(d) Complete Truth Table:
A
B
A OR B
TRUE
TRUE
TRUE
TRUE
FALSE
TRUE
FALSE
TRUE
TRUE
FALSE
FALSE
FALSE
5. Operators in Flow Charts
(e)
Arithmetical operators: Used to perform mathematical calculations.
Relational operators: Used to compare values and determine relationships.