SECTION 1 — COMPUTER FUNDAMENTALS & INFORMATION PROCESSING

1. Information Technology (IT)

Definition

Information Technology is the use of computers and communication systems to collect, process, store and share
information.

Uses of IT

 Education

 Banking

 Business

 Medicine

 Communication

 Transportation

 Entertainment

Advantages

 Faster communication

 Greater accuracy

 Large storage capacity

 Automation

 Easier research

Disadvantages

 Cybercrime

 Job displacement

 Health issues

 Privacy concerns

 Addiction

2. Types of Computers

Type Features Examples

Weather
Supercomputer Extremely powerful
forecasting

Handles many
Mainframe Banks
users

Desktop Personal use Offices

Laptop Portable School/work

Tablet Touchscreen Media use

Mobile
Smartphone Android/iPhone
communication
Type Features Examples

Embedded
Built into devices Microwaves, cars
System

3. Hardware Components

Input Devices

Used to enter data.

Examples:

 Keyboard

 Mouse

 Scanner

 Microphone

 Webcam

 Barcode reader

Output Devices

Used to display results.

Examples:

 Monitor

 Printer

 Speakers

 Projector

 Plotter

Storage Devices

Primary Storage

Temporary memory.

 RAM (Random Access Memory)

o Volatile

o Temporary

 ROM (Read Only Memory)

o Permanent

o Stores startup instructions

Secondary Storage

Permanent storage.

Examples:

 Hard Drive (HDD)

 SSD

 Flash Drive
 CD/DVD/Blu-ray

 Memory Card

Types of Printers

 Printers are output devices used to produce hard copies of documents, images, and graphics on paper.

 1. Impact Printers

 These printers print by physically striking an ink ribbon against paper.

 Dot Matrix Printer

 Uses tiny pins to strike ribbon

 Produces characters as dots

 Noisy

 Can print multi-copy forms (carbon copies)

 Cheap to maintain

 Advantages

 Low running cost

 Durable

 Good for invoices/receipts

 Disadvantages

 Slow

 Noisy

 Lower print quality

 Uses

 Banks

 Stores

 Receipt printing

 Daisy Wheel Printer

 Uses a wheel shaped like a flower

 Each petal contains a character

 Produces letter-quality text

 Advantages

 Good text quality

 Simple technology

 Disadvantages
 Very slow

 Cannot print graphics

 Noisy

 2. Non-Impact Printers

 These printers do not strike the paper physically.

 Inkjet Printer

 Sprays tiny droplets of ink onto paper

 Common home printer

 Advantages

 High quality color printing

 Good for photos

 Relatively inexpensive to buy

 Disadvantages

 Ink can be expensive

 Ink may smudge

 Slower than laser printers

 Uses

 Homes

 Schools

 Small offices

 Laser Printer

 Uses toner powder and laser technology

 Produces high-quality prints quickly

 Advantages

 Fast printing

 Sharp text quality

 Good for heavy use

 Disadvantages

 More expensive initially

 Toner cartridges costly

 Uses

 Offices
 Businesses

 Schools

 Thermal Printer

 Uses heat on special paper

 Advantages

 Quiet

 Fast

 Low maintenance

 Disadvantages

 Needs special paper

 Print may fade over time

 Uses

 ATMs

 Cash registers

 POS systems

 3D Printer

 Creates physical 3D objects layer by layer

 Advantages

 Can create models and prototypes

 Useful in engineering and medicine

 Disadvantages

 Expensive

 Slow for large objects

 Uses

 Engineering

 Architecture

 Medical field

 Quick Comparison Table

 Printer
 Speed  Quality  Noise  Common Use
Type

 Dot Matrix  Slow  Low  Noisy  Receipts/forms

  Printer
 Speed  Quality  Noise  Common Use
Type

 Daisy  Very
 Good text  Noisy  Old office typing
Wheel Slow

 Inkjet  Medium  High color  Quiet  Home use

 Laser  Fast  Very high  Quiet  Offices

 Thermal  Fast  Medium  Quiet  Receipts

 Object  Mediu  Models/

 3D Printer  Slow
creation m prototypes

4. Units of Storage

Unit Value

Smallest
Bit
unit

Byte 8 bits

Kilobyte (KB) 1024 bytes

Megabyte
1024 KB
(MB)

Gigabyte
1024 MB
(GB)

Terabyte
1024 GB
(TB)

5. Software

System Software

Controls hardware.

Examples:

 Operating systems

 Utility software

 Device drivers

Operating Systems

Examples:

 Windows

 Linux

 macOS

 Android

Functions:
  Memory management

 File management

 Device management

 User interface

Application Software

Programs for specific tasks.

Examples:

 Word processors

 Spreadsheets

 Databases

 Browsers

6. Computer Processing Cycle

IPO Cycle

Input

Data entered into system.

Processing

CPU manipulates data.

Output

Information produced.

Storage

Data saved for future use.

7. CPU (Central Processing Unit)

Known as the “brain” of the computer.

Components

 Control Unit (CU)

 Arithmetic Logic Unit (ALU)

 Registers

ALU

Performs calculations and logical operations.

CU

Controls activities of computer.

8. Data vs Information

Data Information

Raw facts Processed data

Data Information

Unorganized Meaningful

Example: 85, “Average score is

90 87.5”

9. Information Processing Stages

1. Collection

2. Preparation

3. Input

4. Processing

5. Output

6. Storage

7. Distribution

10. File Types

Extensi
File Type
on

Word
.docx
Document

Spreadsheet .xlsx

Presentation .pptx

Image .jpg/.png

Audio .mp3

Video .mp4

Database .accdb

11. Computer Ethics

Ethics

Rules governing proper computer use.

Examples:

 Respect privacy

 Do not pirate software

 Do not hack systems

12. Ergonomics & Health Issues

Ergonomics

Designing workplaces for comfort and safety.

Problems
  Eye strain

 Back pain

 RSI (Repetitive Strain Injury)

Prevention

 Proper posture

 Adjustable chair

 Frequent breaks

 Correct monitor height

13. Troubleshooting

Common Problems

Hardware

 Loose cables

 Printer jams

 Dead battery

Software

 Freezing

 Viruses

 Application crashes

SECTION 2 — COMPUTER NETWORKS & WEB TECHNOLOGIES

1. Network

A network is a group of connected computers.

2. Types of Networks

Typ Meanin
e g

1. Types of Networks

Networ
Meaning Explanation
k

A network that connects devices in a small area such as a home, school, office, or
Local Area
LAN computer lab. It is usually fast and privately owned. Example: computers connected
Network
in a school lab.

Metropolitan A network that covers a city or large town. It connects multiple LANs together over a
MAN
Area Network wider area. Example: a company connecting branches across Port of Spain.

Wide Area A network that covers very large areas such as countries or the entire world. The
WAN
Network internet is the largest WAN.

Simple Comparison
Typ Coverage
Example
e Area

LAN Small School computer lab

Network connecting branches in

MAN City/Town
a city

Country/
WAN Internet
World

2. Network Devices

Device Function Explanation

Sends data between different networks and chooses the best path for
Router Directs traffic
data. It also connects your home network to the internet.

Connects computers and devices in a network and sends data only to the
Switch Connects devices
correct device. Faster and smarter than a hub.

Connects devices but sends data to ALL devices on the network, even if
Hub Broadcasts data
only one device needs it. Less secure and slower than a switch.

Connects to Converts signals so devices can access the internet through an ISP
Modem
internet (Internet Service Provider).

NIC (Network Allows network Hardware inside a computer/device that allows it to connect to a network
Interface Card) connection using wired or wireless communication.

3. Transmission Media

Transmission media are the paths through which data travels from one device to another.

Wired Media

Twisted Pair Cable

 Made of pairs of copper wires twisted together.

 Commonly used in Ethernet networks.

 Cheap and easy to install.

 Can suffer from interference.

Example: Ethernet cables used in schools and homes.

Coaxial Cable

 Has a central copper wire surrounded by insulation.

 Stronger signal than twisted pair.

 Used for cable TV and some internet connections.

Advantages

 Better protection from interference

 More durable

Fibre Optic Cable

  Uses light signals instead of electricity.

 Very fast and reliable.

 Can transmit data over long distances.

 Expensive but provides high-speed internet.

Advantages

 Extremely fast

 Very little interference

 High bandwidth

Wireless Media

Wi-Fi

 Uses radio waves to connect devices wirelessly.

 Allows laptops, phones, and tablets to access networks without cables.

Example: Home wireless internet.

Bluetooth

 Short-range wireless technology.

 Used to connect nearby devices.

Examples

 Wireless headphones

 Speakers

 Keyboards

Infrared

 Uses infrared light signals.

 Requires a direct line of sight.

 Short-range communication.

Example: TV remote controls.

Easy Way to Remember

Networks

 LAN = small area

 MAN = city area

 WAN = worldwide

Devices

 Router → routes data

  Switch → smart connector

 Hub → broadcasts everything

 Modem → internet connection

 NIC → allows network access

Transmission Media

 Twisted pair → common cheap cable

 Coaxial → stronger cable

 Fibre optic → fastest cable

 Wi-Fi → wireless internet

 Bluetooth → short-range wireless

 Infrared → remote controls

5. Internet Terms

Term Meaning

WWW World Wide Web

URL Website address

Internet Service
ISP
Provider

Browser Access websites

Search
Finds information
Engine

6. Web Browsers

Examples:

 Chrome

 Firefox

 Edge

 Safari

7. Website Types

 Static websites

 Dynamic websites

 E-commerce sites

 Educational sites

8. Cloud Computing

Using internet servers for storage/services.

Examples:

 Google Drive

 OneDrive

 Dropbox

Advantages:

 Accessible anywhere

 Backup storage

 Collaboration

Disadvantages:

 Requires internet

 Security risks

SECTION 3 — SOCIAL & ECONOMIC IMPACT OF ICT

Positive Effects

 Faster communication

 Online learning

 Remote work

 E-commerce

 Telemedicine

Negative Effects

 Cyberbullying

 Identity theft

 Unemployment

 Privacy invasion

2. Cybersecurity

Protection of systems and data.

Threats

 Viruses

 Worms

 Trojans

 Malware

 Spyware

 Phishing

3. Cybercrime
Illegal computer activities.

Examples:

 Hacking

 Identity theft

 Software piracy

 Online scams

4. Safety Measures

 Antivirus software

 Firewalls

 Strong passwords

 Encryption

 Backups

 Two-factor authentication

5. Intellectual Property

Legal ownership of creations.

Copyright

Protects creators’ work.

Plagiarism

Using someone’s work without credit.

6. E-commerce

Buying/selling online.

Advantages:

 Convenient

 Global access

Disadvantages:

 Fraud risks

 Delivery delays

SECTION 4 — WORD PROCESSING & WEB PAGE DESIGN

WORD PROCESSING

Features

 Spell check

 Grammar check

 Mail merge
  Tables

 Columns

 Headers/footers

Text Formatting

Feature Purpose

Bold Emphasis

Italics Style

Underlin
Highlight
e

Alignme Position
nt text

Mail Merge

Combines:

 Main document

 Data source

Used for:

 Letters

 Labels

 Certificates

A mail merge lets you send the same document (like a letter or email) to many people, but with
personalized details (name, address, etc.). The exact steps depend on what program you’re using—
most people use Microsoft Word with Microsoft Excel.

 Here’s the simplest way to do it:

 🧾 Step 1: Prepare your data (Excel)

 Create a spreadsheet with columns like:

 FirstName

 LastName

 Address

 Email

 Example:

 FirstNa  LastNa
 Email
me me

 john@[Link]
 John  Smith
m

 Jane  Doe  jane@[Link]

 FirstNa  LastNa
 Email
me me

 Save the file.

 📄 Step 2: Create your document (Word)

 Open Word and type your letter or message.

Example:

 Dear [FirstName],

We are happy to invite you to our event!

 🔗 Step 3: Connect Word to your list

 Go to Mailings tab

 Click Select Recipients → Use an Existing List

 Choose your Excel file

 Step 4: Insert merge fields

 Replace placeholders with real fields:

 Click Insert Merge Field

 Choose FirstName, etc.

 Now it looks like:

 Dear «FirstName»,

 👀 Step 5: Preview

 Click Preview Results to see how each letter/email looks.

 📤 Step 6: Finish the merge

 Click Finish & Merge

 Choose:

 Print Documents (letters)

 Send Email Messages (if emailing)


  ✉️Bonus: Sending emails

 If you want to email instead of print:

 Your Excel file must have an Email column

 Word will use your default email app (like Microsoft Outlook)

 👍 Quick summary

 Excel = your contact list

 Word = your message

 Mail Merge = combines them automatically

WEB PAGE DESIGN

HTML Basics

HTML = HyperText Markup Language

Basic Structure

<html>
<head>
<title>My Page</title>
</head>

<body>
<h1>Hello</h1>
</body>
</html>

Common HTML Tags

Functio
Tag
n

<h1> Heading

Paragrap
<p>
h

<img
Image
>

Hyperlin
<a>
k

<table
Table
>

Hyperlinks

Used to connect pages.

<a href="[Link]">Click Here</a>

Example link:
[Link]

Breakdown of the Link

Part Example Meaning

Rules used to transfer data. HTTPS is

Protocol https://
secure.

[Link]
Domain Name The website’s name/address.
m

Subdomain www A section of the website.

Top-Level Domain Type/category of website (.com, .org, .edu,

.com
(TLD) etc.)

Path /search Specific page or section on the site.

Query String ?q=cats Extra information sent to the website.

A search instruction (q = query, cats =

Parameter q=cats
search term).

Simpler Example

[Link]

Part Meaning

Secure
https://
connection

youtub
Website name
e

Commercial
.com
domain

Common Types of Domains

Domai
Meaning
n

.com Commercial/business

.org Organization

Educational
.edu
institution

.gov Government

Network/service
.net
provider

HTTP vs HTTPS

HTTP HTTPS

Secure/
Less secure
encrypted

Data can be Data protected

HTTP HTTPS

intercepted

Modern
Older standard
standard

Visual Breakdown

[Link]
│ │ │ │
│ │ │ └── Query/Parameters
│ │ └──────── Path
│ └────────────────── Domain Name
└────────────────────────── Protocol

Images

<img src="[Link]">

Web Design Principles

 Consistency

 Simplicity

 Readability

 Proper navigation

 Suitable colours

SECTION 5 — SPREADSHEETS

Spreadsheet

Software used for calculations.

Examples:

 Microsoft Excel

 Google Sheets

Terminology

Term Meaning

Row Horizontal

Column Vertical

Cell Intersection

Formula Calculation

Workboo Spreadsheet
k file
Formula Basics

Starts with =

Example:

=A1+B1

Functions

SUM

Adds values.

=SUM(A1:A10)

AVERAGE

=AVERAGE(A1:A10)

MAX

=MAX(A1:A10)

MIN

=MIN(A1:A10)

Relative vs Absolute Cell Reference

Exampl
Type
e

Relative A1

Absolut
$A$1
e

Charts

Types:

 Bar chart

 Pie chart

 Line graph

Uses:

 Visualize data

 Compare trends

SECTION 6 — DATABASE MANAGEMENT

Database

An organized collection of data.

Database Terms
Term Meaning

Field Single item

Record Complete set

Collection of
Table
records

Primary
Unique identifier
Key

DBMS

Database Management System.

Examples:

 Microsoft Access

 MySQL

Data Types

 Text

 Number

 Date/Time

 Currency

 Boolean

Queries

Used to search/filter data.

Forms

Used to enter data.

Reports

Used to print organized information.

Relationships

Type Meaning

One-to-One Single match

One linked to
One-to-Many
many

Many-to-
Multiple links
Many
SECTION 7 — PROBLEM SOLVING & PROGRAM DESIGN

Problem Solving Stages

1. Define problem

2. Analyze problem

3. Design solution

4. Test solution

5. Implement solution

6. Evaluate

Algorithms

Step-by-step instructions.

Pseudocode

Structured English instructions.

Example:

START
INPUT number
IF number > 0 THEN
DISPLAY "Positive"
ENDIF
STOP

Flowcharts

Symbols:

Symbol Meaning

Oval Start/End

Rectangle Process

Diamond Decision

Parallelogra Input/
m Output

Input Process Output

Number 1, Add the two Sum of the

Number 2 numbers numbers

Simple Pseudocode

START
INPUT number1
INPUT number2
sum = number1 + number2
PRINT sum
END

Example
Input:

 5

 3

Process:

 5+3=8

Output:

 8

Another easy one:

Area of a Rectangle IPO Chart

Outpu
Input Process
t

Length, length ×
Area
Width width

START
INPUT length
INPUT width
area = length * width
PRINT area
END

Control Structures

Sequence

Instructions in order.

Selection

Decision making.

Iteration

Repeating steps.

SECTION 8 — PROGRAM IMPLEMENTATION

Programming Languages

Examples:

 Python

 Java

 C++

 Pascal

Variables

Stores data.

Example:

age = 15
Constants

Values that do not change.

Data Types

Exampl
Type
e

Integer 5

Float 5.5

String "Hello"

Boolea
True
n

Operators

1. Arithmetic Operators

Arithmetic operators are used to perform mathematical calculations.

Common Arithmetic Operators

Operat Exampl Answ

Meaning
or e er

+ Addition 5+3 8

- Subtraction 9-4 5

* Multiplication 6*2 12

/ Division 10 / 2 5

Modulus
% 10 % 3 1
(remainder)

^ or ** Power/Exponent 2^3 8

Example

x = 10
y=3

x + y = 13
x -y=7
x * y = 30
x / y = 3.33
x %y=1

Modulus %

Gives the remainder after division.

Example:

17 % 5 = 2

Because:

17 ÷ 5 = 3 remainder 2
2. Relational Operators

Relational operators are used to compare values.

The answer is usually either:

 TRUE

 FALSE

Common Relational Operators

Operat Exampl Resul

Meaning
or e t

== Equal to 5 == 5 TRUE

!= Not equal to 5 != 3 TRUE

> Greater than 8>4 TRUE

< Less than 2<7 TRUE

Greater than or
>= 5 >= 5 TRUE
equal to

Less than or equal

<= 4 <= 9 TRUE
to

Examples

7 > 10 → FALSE
15 == 15 → TRUE
8 != 2 → TRUE

Relational operators are commonly used in:

 Decision making

 IF statements

 Loops

 Databases

 Spreadsheet formulas

3. Logical Operators

Logical operators are used to combine conditions.

Common Logical Operators

Operat Exampl
Meaning
or e

Both conditions must be A AND

AND
TRUE B

Only one condition must

OR A OR B
be TRUE

NOT Reverses the condition NOT A

Truth Tables

AND Operator
 A AND
A B
B

TRUE TRUE TRUE

FALS
TRUE FALSE
E

FALS
TRUE FALSE
E

FALS FALS
FALSE
E E

Rule:

Both conditions must be TRUE.

Example:

(5 > 2) AND (10 > 3)

TRUE AND TRUE
= TRUE

OR Operator

A OR
A B
B

TRUE TRUE TRUE

FALS
TRUE TRUE
E

FALS
TRUE TRUE
E

FALS FALS FALS

E E E

Rule:

At least ONE must be TRUE.

Example:

(5 > 10) OR (7 < 9)

FALSE OR TRUE
= TRUE

NOT Operator

NOT
A
A

FALS
TRUE
E

FALS
TRUE
E

Rule:

Reverses the answer.

Example:
NOT(5 > 2)
NOT(TRUE)
= FALSE

Simple Real-Life Examples

Arithmetic

Calculating money:

Price + Tax

Relational

Checking age:

Age >= 18

Logical

Checking login conditions:

Username correct AND Password correct

Quick Comparison

Type Purpose

Arithmet Performs
ic calculations

Relation
Compares values
al

Combines
Logical
conditions

Easy Way to Remember

 Arithmetic → Math

 Relational → Comparison

 Logical → Decision making

Input & Output

name = input("Enter name")

print(name)

1. Sequential Structure

This is when instructions are executed one after another in order.

Example:

Start
Read A
Read B
Sum ← A + B
Print Sum
End
Key idea:

 No decisions

 No repetition

 Just step-by-step execution

2. Conditional Structure (Selection)

This is when the program makes a decision using conditions.

Types:

 IF statement

 IF…ELSE

 CASE / SWITCH

Example (IF…ELSE):

If age >= 18 then

Print "Adult"
Else
Print "Minor"
End If

Key idea:

 Chooses between options

 Depends on a condition (True/False)

3. Looping Structures (Repetition)

Loops are used when a task repeats.

(a) WHILE Loop (pre-test loop)

Condition is checked before the loop runs.

Example:

While count < 5

Print count
count ← count + 1
End While

Key idea:

 May run 0 times or more

 Condition checked first

(b) FOR Loop (count-controlled loop)

Used when you know exact number of repetitions.

Example:

For i ← 1 to 5
Print i
End For
Key idea:

 Fixed number of loops

 Automatic counter

(c) REPEAT…UNTIL Loop (post-test loop)

Condition is checked after the loop runs.

Example:

Repeat
Input password
Until password = "1234"

Key idea:

 Runs at least 1 time

 Stops when condition becomes TRUE

Quick Comparison

Structu When condition Minimum

re checked runs

WHILE Before loop 0

FOR Fixed count Depends

REPEAT After loop 1

🔹 AND (TRUE only if BOTH are TRUE)

A AND
A B
B

FALS FALS
FALSE
E E

FALS
TRUE FALSE
E

FALS
TRUE FALSE
E

TRUE TRUE TRUE

🔹 OR (TRUE if at least ONE is TRUE)

A OR
A B
B

FALS FALS
FALSE
E E

FALS
TRUE TRUE
E

FALS
TRUE TRUE
E

TRUE TRUE TRUE

🔹 NOT (reverses the value)

NOT
A
A

FALS
TRUE
E

TRUE FALSE

🧠 Super simple way to remember:

 AND = both must be TRUE

 OR = one or more TRUE

 NOT = flips TRUE ↔ FALSE

Selection Statements

if score >= 50:

print("Pass")
else:
print("Fail")

Loops

FOR Loop

for i in range(5):
print(i)

WHILE Loop

while x < 5:
x += 1

Arrays

Stores multiple values.

Example:

marks = [70,80,90]

Testing & Debugging

Types of Errors

Error Meaning

Syntax Grammar mistake

Logic Wrong result

Runtim Occurs during

e execution