Caribbean Secondary Education Certificate Examination Notes

CARIBBEAN EXAMINATIONS COUNCIL - CSEC EXAMINATION NOTES

Candidate Information Section

  • Instructions to fill out all information clearly in capital letters.

  • Test Code:

  • Subject Proficiency:

  • Registration Number:

  • School/Centre Number:

  • Name of School/Centre:

  • Candidate’s Full Name (First, Middle, Last):

  • Date of Birth: (DD/MM/YYYY)

  • Candidate’s Signature:

Exam Paper Details

  • Subject: Information Technology - Paper 02

  • Date of Exam: 18 January 2021 (a.m.)

  • Form: TP 2021016

  • Duration: 2 hours

  • General Instructions:
      - This paper consists of FOUR questions. Answer ALL questions.
      - Write your answers in the spaces provided in the booklet.
      - Do NOT write in the margins.
      - Use extra lined pages at the back for any rewrites; draw a line through your original answers.
      - Clearly write the question number in the extra pages provided if used.
      - Do not turn the page until instructed.

Questions Overview

Question 1: Computer Systems in Meteorology

  1. Meteorological Station Setup
       - Suitable Computer System: Supercomputer
       - (a) Reasons for Suitability:
         - High processing power required for complex calculations and simulations.
         - Ability to process large datasets from various sources.
       - (b) Network Connection
         - (i) Hardware Required: [Identify the most important hardware device]
         - (ii) Role of Hardware Device: [Explain the function of the device]
       - (c) Industries Using Supercomputers:
         - Aerospace
         - Healthcare
       - (d) Characteristics of Personal Computers:
         - User-friendly interface for general consumers.
         - Availability and affordability.
       - (e) Areas of Use for Personal Computers:
         - Educational institutions.
         - Home offices.
       - (f) Sales Data Analysis
         - (i) Identify feature/function of the spreadsheet for summarizing data (e.g., Pivot Table).
         - (ii) Information provided on double-clicking Grand Total row.
         - (iii) Two steps to manually update values in a second worksheet.
         - (iv) Complete missing parameters in the VLOOKUP formula for sales in March.
         - (v) State changes for parameters to obtain Grand Total.

Question 2: ICT Infrastructure for Company Expansion

  1. Setup Requirements
       - (a) Basic Components of Computer Systems:
         - Central Processing Unit (CPU)
         - Memory (RAM)
         - Storage (HDD/SSD)
         - Input/Output Devices
       - (b) Peripheral Devices
         - Complete Category Table for each device:
           - Joystick: Entertainment
           - Scanner: Input Device
       - (c) Transmission Media for Networks:
         - Twisted pair cables.
         - Fiber optic cables.
         - Coaxial cables.
         - (i) Identify most appropriate medium for setup.

Question 3: Planning an ICT Symposium

  1. Inviting Personnel
       - (a) Three groups of personnel to invite (e.g. IT Managers, Cybersecurity Experts, Network Engineers).
       - (b) Positive impacts of extensive ICT usage on business:
         - Improved efficiency and productivity.
         - Enhanced communication and collaboration.
       - (c) Memorandum Formatting and Features:
         - (i) Reason for bullets and numbering in documents.
         - (ii) Identify two other formatting features from the memorandum.
       - (d) Steps for using drag and drop to reorder paragraphs.
       - (e) Steps for conducting a spell check in documents.

Question 4: Programming Concepts and Pseudocode

  1. Handling Data Safely
       - (a) Effects of improper data storage:
         - Data breaches, loss of customer trust.
         - Potential legal implications.
       - (b) Measures for data protection:
         - Encryption techniques.
         - Regular backups.
       - (c) Loop Constructs Explanation:
         - (i) Definition and purpose of loops in programming.
         - (ii) Features of WHILE and REPEAT loops.
       - (d) Write pseudocode for supermarket sales calculation with discounts based on total value of sales.
       - (e) Write pseudocode with NESTED IF STATEMENTS to determine grades based on marks entered.

Extra Space Section

  • If extra space is used during the exam, write the question number clearly in the designated box provided.

Candidate’s Receipt

  • Instructions for completing and keeping track of your exam materials and results.