DCA Course

Lesson 1 • Software Categories and Functions

Distinguishes system software, application software, and utilities. Prepares students to navigate and manage software environments effectively.

Lesson 2 • Introduction to Computing Concepts

Covers the definition, history, and classification of computers. Provides the foundational context for understanding modern digital systems.

Lesson 3 • Computer Hardware Components

Identifies and explains the function of core hardware units. Connects physical components to their roles in processing and storage.

Lesson 4 • Number Systems and Data Representation

Teaches binary, octal, and hexadecimal systems and data encoding. Builds the numerical literacy required for programming and hardware understanding.

Lesson 1 • System Configuration and Maintenance

Addresses user account management, updates, and basic troubleshooting. Prepares students to maintain a stable and secure computing environment.

Lesson 2 • Command-Line Interface Basics

Introduces text-based commands for file and system operations. Provides a foundation for scripting and advanced administration covered later.

Lesson 3 • File System and Directory Management

Covers file system structures, path conventions, and file operations. Directly supports document and data management tasks in later chapters.

Lesson 4 • Graphical User Interface Navigation

Teaches desktop environment navigation, settings, and accessibility features. Enables students to operate a GUI-based OS efficiently.

Lesson 1 • Printing and Document Publishing

Addresses print settings, PDF export, and document sharing options. Completes the document lifecycle from creation to distribution.

Lesson 2 • Advanced Document Features

Covers headers, footers, page numbers, and mail merge. Prepares students to produce multi-page and automated professional documents.

Lesson 3 • Text Formatting and Styles

Teaches font, paragraph, and style formatting for consistent document appearance. Connects visual design principles to professional document standards.

Lesson 4 • Tables, Graphics, and Objects

Explains inserting and formatting tables, images, and shapes. Enables students to create visually rich and structured documents.

Lesson 1 • Formulas and Built-in Functions

Teaches arithmetic formulas, logical functions, and lookup operations. Enables students to automate calculations and data retrieval.

Lesson 2 • Data Formatting and Validation

Covers number formats, conditional formatting, and data validation rules. Ensures data integrity and professional presentation in spreadsheets.

Lesson 3 • Spreadsheet Interface and Navigation

Introduces the spreadsheet environment, cell references, and workbook structure. Provides the operational foundation for all spreadsheet tasks.

Lesson 4 • Sorting, Filtering, and PivotTables

Explains data sorting, filtering criteria, and PivotTable summarisation. Develops analytical skills for extracting insights from large datasets.

Lesson 1 • Presentation Software Interface

Introduces the presentation environment, slide layouts, and view modes. Establishes the workspace familiarity needed for efficient slide creation.

Lesson 2 • Presentation Delivery and Export

Covers presenter view, speaker notes, and export options. Prepares students to deliver and distribute presentations confidently.

Lesson 3 • Multimedia and Object Integration

Teaches inserting images, audio, video, and SmartArt into slides. Enables students to create engaging, multimedia-rich presentations.

Lesson 4 • Animations and Slide Transitions

Explains entrance, emphasis, and exit animations and transition effects. Teaches purposeful use of motion to enhance audience engagement.

Lesson 1 • Online Collaboration and Cloud Tools

Introduces cloud storage, shared documents, and real-time collaboration platforms. Prepares students for modern team-based digital workflows.

Lesson 2 • Digital Communication Etiquette

Addresses professional norms for email, messaging, and virtual meetings. Connects communication skills to workplace expectations and reputation.

Lesson 3 • Internet Fundamentals and Browsing

Explains how the internet works, browser features, and effective search strategies. Grounds students in the skills needed for all online tasks.

Lesson 4 • Email Setup and Management

Covers email account configuration, composing, and inbox organisation. Enables professional and efficient email communication.

Lesson 1 • Database Design and Normalisation

Covers entity-relationship modelling and normalisation rules. Teaches students to design efficient, redundancy-free database structures.

Lesson 2 • Queries and Data Retrieval

Explains select queries, criteria, calculated fields, and aggregate functions. Develops the ability to extract and summarise meaningful data.

Lesson 3 • Database Fundamentals

Defines databases, data models, and the relational model. Provides the conceptual foundation for all database design and query work.

Lesson 4 • Creating Tables and Forms

Teaches table creation, field data types, and form design in database software. Enables students to build user-friendly data entry interfaces.

Lesson 1 • Network Hardware and Connectivity

Explains routers, switches, modems, and wireless access points. Connects physical infrastructure knowledge to network setup and troubleshooting.

Lesson 2 • Security Practices and Data Protection

Teaches firewalls, encryption, strong passwords, and backup strategies. Equips students to implement practical security measures in any environment.

Lesson 3 • Internet Protocols and Services

Covers HTTP, FTP, SMTP, and other key protocols and their roles. Enables students to understand how internet services function at a protocol level.

Lesson 4 • Cybersecurity Threats and Concepts

Identifies malware types, social engineering, and common attack vectors. Develops threat awareness as the foundation for protective measures.