ICT Grade 9 – Comprehensive Study Notes

Operating System (OS) = system software managing hardware/resources and enabling user communication.
- Essential files; most important software on a computer.
- Examples: Microsoft Windows, macOS X, Linux, Android.
Core functions of an OS
- • User Interface – usually GUI (icons, menus).
- • Memory Management – allocate / track $RAM$ segments.
- • Processor Management – time-slice CPU among tasks.
- • File Management – save, organise, locate files.
- • Hardware (Peripheral) Management – route I/O to correct device.
- • System Security – authentication; monitor access.
- • Error Handling – detect/report run-time & data-transfer errors.
Types of OS
- Single-user, Multi-user, Multi-processing, Multi-tasking.
Troubleshooting (trial-and-error) Common problems & fixes:
- PC won’t start → check power cord/outlet; charge laptop battery.
- Frozen system → $\text{Ctrl+Alt+Del}$ → Task Manager → End Task; hard reboot; unplug/battery-pull.
- Printer issues → power on; check cables, paper jam, ink/toner.
- Keyboard/Mouse → reseat plug/change batteries.
- No sound → raise volume; check speaker cable/power.
- Blank screen → wake from Sleep; ensure monitor cable/power.
- Slow PC → malware scan; free disk space; run Disk Defragmenter.
- Accidental deletion → Recycle Bin → Restore; $\text{Ctrl+Z}$ ; Undo Delete.

Automatic Table of Contents (TOC)
- Apply Heading 1 (main titles) & Heading 2 (sub-titles).
- Insert → References → Table of Contents → Automatic.
Automatic List of Figures/Tables
- Insert caption (References → Insert Caption) under each table/figure.
- Insert Table of Figures via References.
Mail Merge (letters → multiple recipients)
- Steps: 1) Main Document (template). 2) Data Source (mailing list). 3) Merge Fields.
- Wizard: Mailings → Start Mail Merge → Step-by-Step Wizard.
- Create/Customise columns (Surname, First Name, Grade, Section, Address).
- Insert merge fields within letter; preview; complete merge.
- Benefits: personalised bulk letters, labels, emails, etc.

Advanced Formatting
- Conditional Formatting: Home → Styles → Highlight Cells Rules.
- E.g. Less Than 35 → Light Red Fill + Dark Red Text (fail marks).
- Cell Styles: quick consistent themes (Titles & Headings, Themed styles).
- Table Styles: Format as Table → predefined colour/layout.
Advanced Formulae/Functions
- IF statement: \text{=IF(test, value_if_true, value_if_false)}.
- Example: =IF(B3<35,"FAIL","PASS").
- COUNTIF: $\text{=COUNTIF(range, criteria)}$ counts cells meeting condition.
- Example: $=COUNTIF(C3:C12,"PASS")$ – number of passes.
Trace & Fill Handle: copy formulas quickly.

Slide Master View
- View → Slide Master: top slide stores theme, fonts, placeholders.
- Apply company-wide fonts (e.g. Calibri), colours, background, logos once.
- Layout Masters inherit from Slide Master; edit specific layouts.
Design Templates
- Save master as .potx; Design → Browse for Themes to reuse.
Multiple Slide Masters
- Insert Slide Master to mix two themes (e.g. Facet + Slice) in same file; choose layout when inserting new slide.

Network Components
- ISP, NIC, Modem, Router (often modem/router combo), Wi-Fi radio, Firewall.
Network Types (size/purpose)
- PAN (personal, Bluetooth/USB). LAN (building). MAN (city). WAN (country/planet). SAN (storage-centric). VPN (secure tunnel over public net).
Topologies
- Bus, Ring, Star, Mesh, Tree (hierarchical). Advantages/disadvantages: expansion, fault isolation, use-case.
Intranet vs Extranet
- Intranet = private internal network; Extranet = extension for partners via VPN.
E-Discussion Tools
- Videoconferencing (Skype, WhatsApp), Podcast/Vodcast (audio/video RSS), Wiki (Wikipedia – collaborative editing), Blog (online diary), Social Networking (FB, IG, Twitter), Chat rooms, Forums.
- Netiquette & safety: avoid sharing personal data, verify sources.
Basic Website in HTML
- File → .html; essential tags: <html>, <head>, <title>, <body bgcolor="">, , , ,  , , <img src="" width="" height="">.

Comic Strip = sequence of boxes/panels with images, captions & dialogues.
- Caption – narrative text; Dialogue – speech balloons.
Speech Balloon Types: General, Whisper (dotted), Thought (cloud), Sound/Expression (e.g. POW!).
Creation Workflow
1. Write Script (beginning–middle–end); storyboard panels.
2. Decide format (# rows/panels).
3. Authoring tools: online (ToonDoo, StripGenerator, Pixton); offline (Comic Life, PowerPoint).

Data Backup: regular copies to recover from hardware failure, malware, disasters.
Data Protection Act – key principles
- Lawful, fair collection; used only for stated purpose; accurate & up-to-date; kept secure; retained no longer than necessary; subject-access rights.
Ownership vs Copyright vs Plagiarism
- Ownership = possessor of copy; Copyright = legal right to reproduce/distribute; Plagiarism = presenting others’ work as own.
- Avoid plagiarism: cite sources, use quotes, paraphrase, run plagiarism checkers (DupliChecker, Grammarly, Paperrater).
Health Hazards & Ergonomics
- RSI (keyboard/mouse), Back/Neck pain, Eye strain.
- Prevention: adjustable chair/monitor, neutral wrists, $90^\circ$ elbow/knee, footrest, screen brightness/anti-glare, breaks & stretches.
Internet Dangers
- Hacking, malware, inappropriate content, cyber-bullying, sexting, chat-room predators, game addiction, pedophilia.
- Safety: firewalls, antivirus, strong passwords, parental controls, cautious sharing.

Flowchart Symbols
- Terminator (Start/Stop), Input/Output parallelogram, Process rectangle, Decision diamond (Yes/No), Flowline arrows.
Dry-Run & Trace Table: test logic with sample data, record variable changes.
Variables: named memory boxes; values change during run.
Python Programming Basics
- Install from $\text{python.org}$ ; IDLE interface (>>> prompt).
- print() – output; strings in quotes, numbers bare; print('A' * 3).
- Variables & Assignment name = 'John' ; age = 15.
- input() – user entry: name = input('Enter name: ').
- Selection if condition: ... else: ....
- Loops
- while loop with counter.
- for item in list: or for x in range(10):.

Tables – fields with data types (Short Text, Number, Currency, Yes/No). Primary Key uniquely identifies record.
Queries
- Retrieve specific info; Simple vs Complex.
- Criteria examples: ="French", >10, Between 2000 And 2010, Is Null, Like "*Rowling*".
- Logical operators: AND, OR, NOT.
- Query Wizard vs Query Design.
Forms
- For data entry/display; Form Wizard layouts (Columnar, Tabular, Datasheet…); Navigation bar (First, Previous, Next, New record).
Reports
- Summarize/print data; Report Wizard steps: choose table/query, fields, grouping levels, sort order, layout (Stepped, Outline, Justified, Block), orientation (Portrait/Landscape), title.
- Content is read-only.