COMPUTER APPLICATIONS
TECHNOLOGY
Theory
,Contents
Summary of everything ........................................................................................................... 2
Module 1.1............................................................................................................................. 6
Module 1.2............................................................................................................................. 9
Module 1.3........................................................................................................................... 18
Module: 2.1.......................................................................................................................... 21
Module:2.2 .......................................................................................................................... 25
Module 4.1: Revising and Improving Skills ............................................................................. 27
Module 4.2: Calculations ..................................................................................................... 28
Module 4.3: Decisions and Charts ........................................................................................ 29
Module 5.1: Introduction to Databases ................................................................................. 30
Module 5.2: Forms ............................................................................................................... 31
Module 5.3: Queries ............................................................................................................. 32
Module 5.4: Designing a Database Table ............................................................................... 33
Module: 6.1.......................................................................................................................... 34
Module 7.1: Finding Information ........................................................................................... 36
,Summary of everything
Computer Applications Technology (CAT)
June Examination In-Depth Study Notes
Modules Covered: 1.1–1.3, 2.1–2.2, 3.1–3.5, 4.1–4.3, 5.1–5.4, 6.1, 7.1
Systems Technologies
(Modules 1.1 – 1.3)
1. Hardware:
• Input Devices: Used to input data into the system.
o Examples: Keyboard, Mouse, Scanner, Webcam, Microphone.
• Output Devices: Display or produce the result of processed data.
o Examples: Monitor, Printer, Speakers, Projector.
• Storage Devices:
o Primary Storage: RAM (volatile), ROM (non-volatile)
o Secondary Storage: HDD, SSD, USB Flash Drives, DVDs
• Processing Unit:
o CPU (Central Processing Unit): The "brain" of the computer.
o Components: ALU (Arithmetic Logic Unit), CU (Control Unit), Registers.
o Clock Speed: Measured in GHz, e.g., 3.2 GHz.
o Multicore Processors: Dual-core, Quad-core, Octa-core.
2. Software:
• System Software: Controls hardware and basic system operations.
o Operating Systems (Windows, macOS, Linux)
o Utility Programs (Antivirus, Disk Cleanup, Defragmenter)
• Application Software: User-focused programs.
o Examples: MS Word, Excel, Access, Photoshop.
• Programming Software: Tools for creating applications.
o Examples: IDEs like Visual Studio, Eclipse.
3. Factors Affecting Performance:
• RAM size, processor speed, number of cores, type of storage (SSD faster than HDD),
cooling systems.
, 4. Mobile Devices:
• Laptops, Tablets, Smartphones, Hybrids.
• Advantages: Portability, connectivity, battery-powered.
• Limitations: Smaller screens, limited upgrade options.
Social Implications
(Module 2.1 – 2.2)
1. Ethical Use:
• Plagiarism: Copying work without crediting the source.
• Software Piracy: Using illegal software copies.
• Digital Citizenship: Respecting others online.
2. Online Safety:
• Cyberbullying, Phishing, Scams, Malware
• Use strong passwords, enable 2FA, update antivirus regularly.
3. Ergonomics:
• Set up workspace to avoid RSI (Repetitive Strain Injury), eye strain.
• Use adjustable chairs, take breaks, keep monitors at eye level.
4. Digital Divide:
• Unequal access to technology based on socioeconomic status, location.
• Example: Rural schools with limited internet vs urban schools with fast fibre.
Internet & Network Technologies
(Modules 3.1 – 3.5)
1. Network Types:
• LAN (Local Area Network)
• WAN (Wide Area Network)
• PAN (Personal Area Network)
• MAN (Metropolitan Area Network)
2. Network Hardware:
• Router: Connects different networks.
TECHNOLOGY
Theory
,Contents
Summary of everything ........................................................................................................... 2
Module 1.1............................................................................................................................. 6
Module 1.2............................................................................................................................. 9
Module 1.3........................................................................................................................... 18
Module: 2.1.......................................................................................................................... 21
Module:2.2 .......................................................................................................................... 25
Module 4.1: Revising and Improving Skills ............................................................................. 27
Module 4.2: Calculations ..................................................................................................... 28
Module 4.3: Decisions and Charts ........................................................................................ 29
Module 5.1: Introduction to Databases ................................................................................. 30
Module 5.2: Forms ............................................................................................................... 31
Module 5.3: Queries ............................................................................................................. 32
Module 5.4: Designing a Database Table ............................................................................... 33
Module: 6.1.......................................................................................................................... 34
Module 7.1: Finding Information ........................................................................................... 36
,Summary of everything
Computer Applications Technology (CAT)
June Examination In-Depth Study Notes
Modules Covered: 1.1–1.3, 2.1–2.2, 3.1–3.5, 4.1–4.3, 5.1–5.4, 6.1, 7.1
Systems Technologies
(Modules 1.1 – 1.3)
1. Hardware:
• Input Devices: Used to input data into the system.
o Examples: Keyboard, Mouse, Scanner, Webcam, Microphone.
• Output Devices: Display or produce the result of processed data.
o Examples: Monitor, Printer, Speakers, Projector.
• Storage Devices:
o Primary Storage: RAM (volatile), ROM (non-volatile)
o Secondary Storage: HDD, SSD, USB Flash Drives, DVDs
• Processing Unit:
o CPU (Central Processing Unit): The "brain" of the computer.
o Components: ALU (Arithmetic Logic Unit), CU (Control Unit), Registers.
o Clock Speed: Measured in GHz, e.g., 3.2 GHz.
o Multicore Processors: Dual-core, Quad-core, Octa-core.
2. Software:
• System Software: Controls hardware and basic system operations.
o Operating Systems (Windows, macOS, Linux)
o Utility Programs (Antivirus, Disk Cleanup, Defragmenter)
• Application Software: User-focused programs.
o Examples: MS Word, Excel, Access, Photoshop.
• Programming Software: Tools for creating applications.
o Examples: IDEs like Visual Studio, Eclipse.
3. Factors Affecting Performance:
• RAM size, processor speed, number of cores, type of storage (SSD faster than HDD),
cooling systems.
, 4. Mobile Devices:
• Laptops, Tablets, Smartphones, Hybrids.
• Advantages: Portability, connectivity, battery-powered.
• Limitations: Smaller screens, limited upgrade options.
Social Implications
(Module 2.1 – 2.2)
1. Ethical Use:
• Plagiarism: Copying work without crediting the source.
• Software Piracy: Using illegal software copies.
• Digital Citizenship: Respecting others online.
2. Online Safety:
• Cyberbullying, Phishing, Scams, Malware
• Use strong passwords, enable 2FA, update antivirus regularly.
3. Ergonomics:
• Set up workspace to avoid RSI (Repetitive Strain Injury), eye strain.
• Use adjustable chairs, take breaks, keep monitors at eye level.
4. Digital Divide:
• Unequal access to technology based on socioeconomic status, location.
• Example: Rural schools with limited internet vs urban schools with fast fibre.
Internet & Network Technologies
(Modules 3.1 – 3.5)
1. Network Types:
• LAN (Local Area Network)
• WAN (Wide Area Network)
• PAN (Personal Area Network)
• MAN (Metropolitan Area Network)
2. Network Hardware:
• Router: Connects different networks.
