Information and Communications Technology Grade 9 Notes

Educational Context and Preface

  • Framework: The Grade 9 Information and Communications Technology (ICT) workbook is based on the National Curriculum Framework: Grades 7, 8 & 9 (2016) - Nine-Year Continuous Basic Education (NYCBE) project by the Ministry of Education, Tertiary Education, Science and Technology of Mauritius.

  • Goal: The curriculum aims to prepare learners with ICT skills for an emerging knowledge society, focusing on digital literacy, problem solving, programming, and understanding technologies such as Artificial Intelligence (AI) and Robotics.

  • MIE Panel Members:

    • Professor Vassen Naëck (Head, Curriculum Implementation).

    • Kaviraj Goodoory (Coordinator, Associate Professor).

    • Senior Lecturers: Marday Pyneandee, Dr Vikash Kumar Jhurree, Christian Li Luen Ching, Paramaseeven Sooben.

    • Educators: Abdullah Mohammud Ismail Buxoo, Louis Daniel Clarel Berry, Jameel Foondun, Minta Hurryman, Mohammad Arshaad Khodabocus, Shunno Devi Nenduradu, Sarita Raggoo-Lollbeharee.

  • Pedagogy: The workbook is learner-oriented, blending theory with practical activities, games, and summative exercises. The character "Tipiyu" serves as a guide throughout the book.

Unit 1: Computer Operations and Fundamentals

The Operating System (OS)

  • Definition: An operating system is system software that controls the hardware and allows communication between the user and the computer system. It consists of essential files required for computer function.

  • Common Examples:

    1. Microsoft Windows: Most common for personal computers.

    2. MAC OS X: Used in Apple Inc. manufactured computers.

    3. Linux: A free operating system for personal computers.

    4. Android: Used for smartphones and tablets.

Seven Key Functions of an Operating System

  1. User Interface: Provides a Graphical User Interface (GUI) allowing interactions via icons and menus.

  2. Memory Management: Deals with loading and running applications, allocating memory space to programs/data, and tracking free/used memory.

  3. Processor Management: Allocates CPU time to different tasks using a "time slice" for simultaneous processing.

  4. File Management: Manages the transfer, saving, organizing, loading, and finding of files.

  5. Hardware Management (Peripheral Management): Controls attached devices, accepts data from input devices, sends data to output devices, and manages backing storage transfers.

  6. System Security Management: Monitors/restricts access to programs and data via usernames and passwords.

  7. Error Handling: Detects and handles errors during program execution or data transfer and informs the user.

Types of Operating Systems

  • Single-user system: Supports only one user at a time.

  • Multi-user system: Allows multiple users to access resources simultaneously using a server and terminals.

    • Server: A computer providing data to others.

    • Terminal: A personal computer connected to a network.

  • Multi-processing system: Supports and utilizes more than one computer processor (CPU 1, CPU 2, etc.).

  • Multi-tasking system: Allows several programs to run simultaneously.

Basic Troubleshooting Techniques

Troubleshooting is a trial-and-error process of identifying and resolving hardware or software problems.

  • Computer does not start:

    1. Check power cord security (system unit and outlet).

    2. Test the outlet with another device (e.g., a lamp).

    3. For laptops: Ensure the battery is charged; plug in the AC adapter.

  • Computer freezes (Unresponsive):

    1. Press Ctrl+Alt+DelCtrl + Alt + Del to start Task Manager, highlight the program, and click "End Task".

    2. Hard Reboot: Press and hold the power button for 55 to 1010 seconds (Use as last resort; risk of data corruption).

    3. Ultimate resort: Unplug the power cable or remove the laptop battery.

  • Printer failure: Check if it is on, check cables, and look for paper jams.

  • Mouse/Keyboard failure: Check wired connections or change batteries for wireless devices.

  • Sound issues: Check volume levels in the audio button (bottom-right) and ensure external speakers are connected to the correct audio/USB port.

  • Slow performance: Run a virus scanner for malware or check hard drive space. Use Disk Defragmenter to rearrange files for faster access.

  • Accidental Deletion: Check the Recycle Bin and click "Restore"; press Ctrl+ZCtrl + Z; or right-click the folder and select "Undo Delete".

Unit 2: Word Processing

Table of Contents (TOC) and Styles

  • Table of Contents: A list at the start of a document showing titles, subtitles, and page numbers.

  • Styles Ribbon: Uses predefined formatting.

    • Heading 1: For main titles.

    • Heading 2: For subtitles.

  • Process to Generate TOC:

    1. Highlight text and apply specific Headings.

    2. Place cursor at the document start.

    3. Go to the "References" tab, click "Table of Contents", and select an automatic style (e.g., "Automatic Table 2").

Table of Figures

  1. Add a caption to images/tables: Select item -> References tab -> Insert Caption.

  2. Place cursor after the TOC.

  3. References tab -> Insert Table of Figures.

Mail Merge

  • Definition: Automatically generates multiple copies of a document (template) adapted for different recipients.

  • Three Main Components:

    1. Main Document (Template): Contains static text and graphics.

    2. Mailing List (Data Source): A database or table containing variable info (surname, address, grade).

    3. Merge Fields: Placeholders (e.g., <<Surname>>) that are replaced by data from the source.

  • Mail Merge Wizard (Step-by-Step):

    1. Mailings tab -> Start Mail Merge -> Step-by-Step Mail Merge Wizard.

    2. Select document type (Letters).

    3. Select recipients (Type a new list or use existing).

    4. Customize columns (Add fields like Grade, Section; Rename/Delete fields).

    5. Insert Fields: Use "More Items" to place specific fields in the letter.

    6. Preview and Complete Merge: Generates personalized letters for every record in the data source.

Unit 3: Spreadsheet

Advanced Formatting

  • Conditional Formatting: Applies formatting (e.g., cell fill, text color) based on a criteria rule (e.g., highlight marks < 35 in red).

  • Cell Styles: A set of formatting features (font, bold, borders) that can be applied to keep sheets consistent.

  • Format as Table: Excel provides predefined styles to convert ranges into tables with headers.

Advanced Formulae and Functions

  • IF Statement: Tests a condition and returns one value for TRUE and another for FALSE.

    • Syntax: =IF(logical test,value if true,value if false)=IF(\text{logical test}, \text{value if true}, \text{value if false})

    • Example: =IF(B3 < 35, "FAIL", "PASS").

  • COUNTIF Function: Counts the number of cells in a range that meet a specific condition.

    • Syntax: =COUNTIF(Range,Criteria)=COUNTIF(\text{Range}, \text{Criteria})

    • Example: To count how many students scored over 3535: =COUNTIF(B3:B12, ">=35").

  • Fill Handle: Used to replicate formulas or fill a series.

Unit 4: Presentation

Slide Master View

  • Definition: A special feature used to format all slides in a presentation consistently and quickly. Changes to the Slide Master affect all other slides.

  • Components:

    • Slide Master: The top-level slide thumbnail that stores theme/formatting info.

    • Layout Masters: Smaller thumbnails representing specific slide types (Title slide, Title and Content).

  • Commands: Found under the "View" tab -> "Slide Master".

  • Placeholders: Areas for Date, Footer, Slide Number, and Content.

Design Templates

  • Template: A design scheme containing layouts, colors, and fonts saved as a .potx.potx file.

  • Multiple Slide Masters: Used when a presentation requires different themes for different sections.

Unit 5: Internet

Network Components

  • ISP (Internet Service Provider): A company providing internet access.

  • NIC (Network Interface Card): Sends data from the computer onto the network.

  • WiFi: Uses radio waves for high-speed wireless internet.

  • Modem: Allows sending/receiving data over cables.

  • Router: Connects two or more networks together (connects home network to the internet).

  • Firewall: Software/hardware preventing unauthorized access by monitoring traffic.

Types of Networks

Type

Size

Purpose

PAN (Personal Area Network)

Small room/office

Connecting personal devices (Bluetooth/USB).

LAN (Local Area Network)

Building/Single site

Devices sharing resources in a school/office.

MAN (Metropolitan Area Network)

City/Town

Connecting LANs across a city area.

WAN (Wide Area Network)

Country/Worldwide

Long-distance connection (the Internet).

SAN (Storage Area Network)

Large area

Accessing storage devices from multiple servers.

VPN (Virtual Private Network)

Public Network

Creating a secure connection to a private network.

Network Topologies

  1. Bus: All nodes connect to a single cable. Network fails if the cable breaks.

  2. Ring: Nodes form a circular arrangement; data flow is sequential.

  3. Star: All nodes connect to a central server/hub. Most common LAN setup.

  4. Mesh: All nodes connect to each other. Used for WAN high reliability.

  5. Tree: Hierarchical arrangement (like branches). Used for WAN expansion.

Intranet vs. Extranet

  • Intranet: Private network for internal employees only (high security).

  • Extranet: Private network allowing external partners (suppliers/customers) access.

E-Discussion and Web Tools

  • Videoconferencing: Live visual communication (Skype, WhatsApp).

  • Podcast/Vodcast: Audio/Video files for streaming or download (RSS feeds).

  • Wiki: Website allowing users to add/modify content (Wikipedia).

  • Blog: Online journal written by a ‘blogger’.

  • Social Networking: Online services for staying in touch (Facebook, YouTube, Instagram).

  • Online Forum/Newsgroup: Website for debates/discussions monitored by administrators.

Website Creation (HTML)

  • HTML (Hyper Text Markup Language): Language used to create websites using tags (<>).

  • Essential Tags:

    • <HTML>: Starts the document.

    • <HEAD>: Contains meta-info like title.

    • <BODY>: Contains visible content (text, images, videos).

    • <bgcolor>: Attribute for background color.

    • <p>: Paragraph; <B>: Bold; <I>: Italic; <br>: Line break.

    • <img src="url">: Inserts an image.

Unit 6: Multimedia

Comic Strips

  • Definition: A sequence of images in panels/boxes that tell a story using dialogues and captions.

  • Components:

    • Panel/Box: A single frame of the comic.

    • Caption: Additional messages about actions/situations.

    • Dialogue: Thoughts or speech in bubbles.

    • Tail: Indicates the speaker.

  • Speech Balloon Types:

    1. General: Normal speech.

    2. Secret/Whisper: Dotted line.

    3. Thought: Cloud-like shape.

    4. Sound/Expression: Spiky shapes for effects (POW, ZOOM).

  • Authoring Tools:

    • Online: Pixton, StripGenerator, ToonDoo.

    • Offline: Comic Life, MS PowerPoint.

Unit 7: Health, Safety & Ethics

Data Protection and Ethics

  • Data Backup: Recovering data from media (HW failure, virus, disaster).

  • Data Protection Act: Law to protect privacy of personal data. Principles: Legal collection, accuracy, secure storage, and used only for stated purpose.

  • Ownership vs. Copyright: Ownership is buying a physical copy; Copyright is the legal right of the creator to say how the work is reproduced.

  • Plagiarism: Stealing resources and claiming them as your own.

    • Avoidance: Citations, paraphrasing correctly, using quotation marks, and using checkers like Grammarly or DupliChecker.

Computer Health Risks (Ergonomics)

  • Repetitive Strain Injury (RSI): Wrist/finger pain from typing. Prevention: Frequent breaks, wrist rests.

  • Back and Neck Pain: Constant poor posture. Prevention: Adjustable chairs, monitor at eye level, foot rests.

  • Eye Strain/Headaches: Fixed focus/flicker/radiation. Prevention: Screen cleaning, anti-glare, adjusting brightness.

Internet Dangers

  • Hacking: Illegal access.

  • Chat Room Predators/Pedophilia: Manipulators trapping children with fake profiles.

  • Cyberbullying: Harassing/harsh messages.

  • Addictions: Gaming and social media overuse.

Unit 8: Practical Problem Solving and Programming

Flowcharts and Logic

  • Symbols:

    • Oval: Start/Stop.

    • Parallelogram: Input/Output.

    • Rectangle: Process (calculations).

    • Diamond: Decision (Yes/No).

  • Dry Run: Testing a flowchart using a Trace Table to record variable values.

  • Variables: Named memory locations holding values (e.g., Age=15\text{Age} = 15).

  • Constructs: Sequence (top-to-bottom), Selection (IF), Repetition (Loop).

Python Programming

  • Prompt: The >>> symbol where commands are entered.

  • Basic Commands:

    • print("text"): Displays info. Use quotes for strings, none for numbers.

    • input(): Accepts user data and stores it in a variable.

    • Operators: + (add/concatenate), * (multiply/repeat string).

    • Selection: if condition: ... else: ....

    • Loops:

      • while: Repeats based on a condition.

      • for: Repeats over a range or a list (e.g., for x in range(10):).

Unit 9: Databases

Database Components (Microsoft Access)

  • Queries: Retrieves info based on conditions (AND, OR, NOT).

    • Criteria Examples: > 10, < 2010, "French".

  • Table Views:

    • Datasheet View: Shows contents.

    • Design View: Shows structure (Field names, Data Types like AutoNumber, Short Text, Currency).

  • Primary Key: Uniquely identifies each record in a table.

  • Forms: User interface for entering and editing data (Form Wizard).

  • Reports: Organized, printable display of data in tabular form (Report Wizard).