Information and Communications Technology Grade 9 Study Guide

Information and Communications Technology: Grade 9 Definitive Study Guide

Introductory Information and Administration

• Project Framework: Based on the National Curriculum Framework: Grades 7, 8 & 9 (2016) - Nine-Year Continuous Basic Education.

• Producer: Mauritius Institute of Education (MIE) under the Ministry of Education, Tertiary Education, Science and Technology.

• Curriculum Panel:

  • Head of Curriculum Implementation: Professor Vassen Naëck.

  • Coordinator: Kaviraj Goodoory (Associate Professor, MIE).

  • MIE Members: 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.

  • Design: Rakesh Sookun (Graphic Designer).

• Educational Philosophy: Built upon competencies from Grades 7 and 8 to improve cognitive skills using contextualized materials, preparing learners for the emerging knowledge society.

• Key Character: Tipiyu (the avatar guide introduced in Grade 7).

Unit 1: Computer Operations and Fundamentals

1.1 Operating Systems (OS)

• Definition: System software that controls hardware and allows communication between the user and the computer system. It consists of essential files needed for functionality.

• Examples of OS:

1. Microsoft Windows: Most common OS used in personal computers.

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

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

4. Android: Used for compatible smartphones and PC tablets.

1.2 Functions of an Operating System

1. User Interface: Modern computers use a Graphical User Interface (GUI) consisting of icons and menus.

2. Memory Management: Allocates memory space to programs and data; tracks parts of memory in use versus free sections.

3. Processor Management: Allocates CPU time slices to different tasks. A time slice is the specific duration given to each job processed.

4. File Management: Manages data transfer, saving, organizing, locating, and loading files.

5. Hardware/Peripheral Management: Controls attached devices, transfers data from input devices to memory, and directs output to the correct device.

6. System Security Management: Monitors/restricts access via usernames and passwords to prevent unauthorized access.

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

1.3 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 (provides data) and terminals (PCs connected to a network).

• Multi-processing System: Supports and utilizes more than one computer processor (CPU).

• Multi-tasking System: Allows several programs to run at the same time.

1.4 Basic Troubleshooting Techniques

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

Common Problems and Solutions

• Computer Does Not Start:

  • Check the power cord connection at the system unit and outlet.

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

  • For laptops, plug in the AC adapter if the battery is drained.

• Computer Freezes (Unresponsive):

  • Keyboard Solution: Press $Ctrl$, $Alt$, and $Delete$ simultaneously to open Task Manager, then end the frozen task.

  • Hard Reboot: Hold the power button for $5$ to $10$ seconds (last resort, risk of data loss).

  • Physical Reboot: For PCs, unplug the power cable; for laptops, remove the battery.

• Printer Not Working:

  • Check if turned on; check cables; check for paper jams; check ink/toner and paper levels.

• Input Devices Stop Working:

  • For wired devices, ensure they are plugged into the system unit.

  • For wireless devices, replace the batteries.

• No Sound:

  • Check volume levels in the audio button on the taskbar. Ensure external speakers are plugged into the correct port and powered on.

• Blank Screen:

  • Check if in "Sleep" mode (press a key/move mouse). Check monitor cables and power connection.

• System Runs Slowly:

  • Run a virus scanner for malware. Delete unneeded files if the hard drive is full. Run Disk Defragmenter to rearrange files and increase access speed.

• Accidental Deletion of File:

  • Restore from Recycle Bin. Press $Ctrl + Z$. Right-click the folder and select "Undo Delete."

Unit 2: Word Processing (Advanced)

2.1 Table of Contents and Figures

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

• Styles Ribbon: Essential for automatic TOC generation. Includes Heading 1 (main titles) and Heading 2 (subtitles).

• TOC Generation Steps: Apply Heading styles to text -> Select References Tab -> Table of Contents -> Select "Automatic Table 2."

• Captions and Table of Figures:

  • A caption is a label for an image or table.

  • Process: Select the object -> References Tab -> Insert Caption -> Reference Tab -> Insert Table of Figures.

2.2 Mail Merge

• Definition: A software function used to produce multiple (potentially large numbers of) documents with identical formatting but varying specific portions.

• Three Key Components:

1. Main Document (Template): The standard letter containing text and graphics.

2. Data Source (Mailing List): A table containing variable information (Surname, Address, etc.) often stored as a $.mdb$ (Access) file.

3. Merge Fields: Placeholders where the variable data is inserted.

• The Mail Merge Wizard: Accessed via the Mailings Tab. Allows step-by-step creation of the mailing list, customization of columns (Add, Rename, Delete fields), and previewing of individual letters.

Unit 3: Spreadsheet (Advanced)

3.1 Advanced Formatting

• Conditional Formatting: Applying cell formatting (e.g., light red fill with dark red text) based on specific criteria (e.g., cell value < 35).

• Cell Styles: Predefined formatting (fonts, borders, fills) to keep worksheet appearance consistent. Examples: Heading 1, Accent1.

• Formatting Tables: Using “Format as Table” to apply predefined styles with headers and filter buttons.

3.2 Advanced Formulae and Functions

• The 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)$

  • Parts: The test (Condition), the True Result, and the False Result.

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

  • Syntax: $=COUNTIF(Range, Criteria)$

  • Criteria: Can be a number, expression, or text entry (e.g., > 49 or "PASS"). Text criteria for functions must be in double quotes (e.g., $"PASS"$).

• Fill Handle: Used to replicate/copy formulae into a series of cells.

Unit 4: Presentation

4.1 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.

• Hierarchy:

  • Slide Master: The top slide thumbnail. Stores theme, layout, background, and placeholder positions.

  • Layout Masters: Individual thumbnails below the main master (e.g., Title Slide, Title and Content). Changes here only affect slides using that specific layout.

• Components: Placeholders for titles, subtitles, dates, footers, and slide numbers.

4.2 Templates and Themes

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

• Multiple Slide Masters: Required when a user wants to use two or more different themes (e.g., "Facet" and "Slice") within a single presentation file.

Unit 5: Internet

5.1 Network Components

• Internet Service Provider (ISP): Company providing Internet access.

• Network Interface Card (NIC): Takes data from the computer and sends it out onto the network.

• WiFi: Networking technology using radio waves for high-speed wireless Internet.

• Modem: Hardware allowing a computer to send/receive data over communication links.

• Router: Hardware connecting two or more networks (connects home network to the Internet). Must be connected to a modem.

• Firewall: Software or hardware preventing unauthorized access to/from a private network.

5.2 Types of Networks

• PAN (Personal Area Network): Smallest size, limited to a room for one person (Bluetooth/USB).

• LAN (Local Area Network): Limited to a building or single site (uses cables or WAP).

• MAN (Metropolitan Area Network): Designed for a town or city; connects multiple LANs.

• WAN (Wide Area Network): Spans countrywide or worldwide (e.g., the Internet).

• SAN (Storage Area Network): Network of storage devices accessible to multiple servers.

• VPN (Virtual Private Network): Creates a secure connection over a public network (Internet) to access a private network.

5.3 Network Topologies

• Bus: All nodes connected to a single cable (bus). If the cable breaks, the network fails.

• Ring: Circular arrangement. Easy to troubleshoot but requires shutdown to add devices.

• Star: All nodes connected to a central server/hub. If the central computer fails, the network stops.

• Mesh: All nodes connected to each other. Most difficult to troubleshoot but high redundancy.

• Tree (Hierarchical): Arranged like branches; simple to extend.

5.4 Communication Concepts

• Intranet: Private network accessible only to people within an organization.

• Extranet: Private network allowing limited access to authorized outsiders (e.g., suppliers).

• E-discussion: Online conversations (text, audio, video). Includes Videoconferencing (live visual communication), Podcasting (audio stream/download), Vodcasting (video files), Wiki (user-editable websites like Wikipedia), Blogs (online journals written by a blogger), and Forums/Newsgroups (online debate spaces monitored by administrators).

5.5 Website Creation (HTML)

• HTML: Hyper Text Markup Language. Uses Tags (<>) to instruct browsers.

• Common Tags:

  • $$: Defines the file as HTML.

  • $$: Contains metadata like the $$