ICT course

Lesson 1 • Digital Communication Tools

Surveys email, messaging, and collaboration platforms used in professional settings. Connects digital communication skills to workplace productivity goals.

Lesson 2 • Core ICT Concepts and Terminology

Introduces fundamental ICT definitions, categories of technology, and their real-world applications. Establishes shared vocabulary used throughout the entire course.

Lesson 3 • Computer Hardware Components

Examines internal and external hardware components, their functions, and how they interact. Provides the physical foundation needed to understand software and system performance.

Lesson 4 • Digital Citizenship and Ethics

Defines responsible online behavior, intellectual property rights, and ethical technology use. Grounds students in the professional and social responsibilities of ICT users.

Lesson 1 • Network Types and Topologies

Distinguishes LAN, WAN, MAN, and wireless networks and maps common physical and logical topologies. Provides the structural framework for all subsequent networking topics.

Lesson 2 • Protocols and the OSI Model

Explains the layered OSI model and key protocols that govern data transmission. Students map real traffic to model layers to reinforce conceptual understanding.

Lesson 3 • Internet Services and Web Technologies

Surveys how the internet delivers web, email, and streaming services through browsers and servers. Students understand the client-server model underpinning all online activity.

Lesson 4 • Network Performance and Troubleshooting

Introduces bandwidth, latency, and common connectivity issues with structured diagnostic approaches. Prepares students to resolve everyday network problems independently.

Lesson 1 • Network Security Controls

Introduces firewalls, intrusion detection systems, VPNs, and network segmentation strategies. Builds on networking knowledge to apply layered defensive controls.

Lesson 2 • Encryption and Data Protection

Explains symmetric and asymmetric encryption, hashing, and secure data transmission protocols. Connects cryptographic concepts to practical file and communication security.

Lesson 3 • Authentication and Access Control

Covers password policies, multi-factor authentication, and role-based access principles. Students implement controls that limit unauthorized access to systems and data.

Lesson 4 • Threat Landscape and Attack Types

Catalogs malware, phishing, social engineering, and denial-of-service attacks with real examples. Establishes threat awareness as the foundation for all security decisions.

Lesson 1 • Spreadsheet Design and Data Analysis

Covers cell referencing, formulas, functions, and chart creation for data-driven decision-making. Connects raw data management to meaningful business insights.

Lesson 2 • Automating Repetitive Office Tasks

Introduces macros, basic scripting, and built-in automation features to reduce manual effort. Bridges productivity software skills toward process efficiency and automation.

Lesson 3 • Word Processing for Professional Documents

Teaches formatting, styles, templates, and collaborative editing in word processing software. Produces professional reports and correspondence aligned with workplace standards.

Lesson 4 • Collaboration and Cloud-Based Productivity

Explores real-time co-authoring, version history, and cloud storage integration across productivity suites. Prepares students for distributed team workflows.

Lesson 1 • Database Administration Basics

Introduces user management, backup procedures, indexing, and performance monitoring for database administrators. Prepares students to maintain reliable, secure database environments.

Lesson 2 • Database Design and Normalization

Covers normalization forms, redundancy elimination, and schema design best practices. Students transform raw data requirements into efficient, maintainable database structures.

Lesson 3 • SQL Querying Fundamentals

Teaches SELECT, WHERE, JOIN, GROUP BY, and ORDER BY clauses for data retrieval. Connects schema knowledge to practical data extraction and reporting tasks.

Lesson 4 • Data Manipulation and Transactions

Covers INSERT, UPDATE, DELETE statements and transaction control for data integrity. Students manage data changes safely using commit and rollback operations.

Lesson 1 • JavaScript for Interactivity

Introduces variables, functions, DOM manipulation, and event handling to add dynamic behavior. Builds on static HTML/CSS pages to create interactive user experiences.

Lesson 2 • Responsive Web Design

Introduces media queries, fluid grids, and mobile-first design principles for multi-device compatibility. Connects layout skills to real-world requirements for accessible, device-agnostic sites.

Lesson 3 • Publishing and Testing Web Pages

Covers web hosting, FTP deployment, browser developer tools, and performance testing basics. Students deploy and validate functional web pages in a live environment.

Lesson 4 • CSS Styling and Layout

Covers selectors, the box model, Flexbox, and Grid for visual design and layout control. Students style HTML pages to match professional design specifications.

Lesson 1 • Systems Development Life Cycle

Maps the SDLC phases from planning through maintenance and compares waterfall and agile models. Establishes the process framework students apply in all subsequent development activities.

Lesson 2 • Software Testing and Quality Assurance

Covers unit, integration, and user acceptance testing strategies with defect tracking workflows. Ensures students can verify that software meets specified requirements before deployment.

Lesson 3 • System Modeling and Design

Introduces UML diagrams, data flow diagrams, and system architecture patterns for solution design. Translates requirements into structured visual models that guide implementation.

Lesson 4 • Requirements Gathering and Analysis

Teaches stakeholder interviews, use cases, and functional vs. non-functional requirements documentation. Produces clear, testable requirements that guide design and development decisions.

Lesson 1 • Descriptive and Exploratory Analysis

Applies statistical summaries, distributions, and correlation analysis to uncover patterns in data. Connects cleaned datasets to meaningful preliminary findings for stakeholders.

Lesson 2 • Business Intelligence Tools

Introduces BI platforms for connecting data sources, building reports, and sharing interactive dashboards. Applies visualization principles to professional-grade analytical tools.

Lesson 3 • Predictive Analytics and Decision Models

Introduces regression, classification concepts, and decision trees for forward-looking business analysis. Students interpret model outputs and communicate predictions to non-technical decision-makers.

Lesson 4 • Data Collection and Preparation

Covers data sourcing, cleaning, transformation, and validation to produce analysis-ready datasets. Builds on database skills to handle real-world messy data effectively.