Computer Application(X)

  • Course Outline
  • 6 Months duration
  • 4 Sessions per month

Unit 1: Computer Fundamentals

Evolution of Computers

Characteristics and Applications of Computers

Components of Computer System

Input, Output, and Processing Cycle

Central Processing Unit (CPU): ALU, Control Unit, Registers

Memory: Primary and Secondary

Storage Devices (HDD, SSD, Pen Drive, Optical Discs)

Unit 2: Operating System

Meaning and Importance of Operating System

Functions of Operating System

Types of Operating Systems

Windows / Linux Basics

File and Folder Management

System Utilities

Unit 3: Number System & Boolean Logic

Decimal Number System

Binary Number System

Number Conversion (Decimal <-> Binary)

Basic Binary Arithmetic

Introduction to Boolean Algebra

Logic Gates (AND, OR, NOT)

Unit 4: Introduction to Programming (C / Python / School Prescribed Language)

Problem Solving Techniques

Algorithm and Flowchart

Program Structure

Keywords and Identifiers

Variables and Constants

Data Types

Operators

Unit 5: Control Structures

Conditional Statements

IF

IF–ELSE

Nested IF

Switch Case (If Applicable)

Looping Statements

FOR

WHILE

DO–WHILE

Practical Programming Examples

Unit 6: Functions and Arrays

Concept of Functions

Types of Functions

Function Declaration and Definition

Arrays (One-Dimensional)

String Handling (Basic)

Unit 7: Database Concepts

Introduction to Database

DBMS Concepts

Advantages of Database System

Basic SQL Commands:

CREATE

INSERT

SELECT

UPDATE

DELETE

Unit 8: Office Automation Tools

Word Processing

Formatting Documents

Tables

Page Layout

Printing

Spreadsheets

Formulas and Functions (SUM, AVG, MAX, MIN)

Charts

Data Sorting and Filtering

Presentation

Slide Creation

Animations and Transitions

Slide Show

Unit 9: Internet and Networking

Introduction to Internet

World Wide Web (WWW)

Web Browsers and Search Engines

Email and Communication

Basics of Computer Networking

Unit 10: Cyber Safety and Ethics

Safe Internet Usage

Cyber Crimes and Prevention

Password Security

Data Privacy

Digital Etiquette

Computer Ethics

Unit 11: Practical & Project Work

Program Writing and Debugging

Database Queries

Office Application Tasks

Mini Project

Project Documentation and Presentation

 

Download content Click here