Class 12 (2nd Year) – Official CHSE IT Syllabus Notes
Download Textbook PDFTopics Covered: Computer Networking, Internet and Its Applications, Network Security on Internet.
Networking Overview
Network Devices (Hub, Switch, Bridge, Router, Repeater, Gateway)
Types of Network (LAN, MAN, WAN, PAN)
Network Topologies (Star, Ring, Bus, Tree)
Wired Media (Co-Axial, Ethernet, Optical Fiber)
Wireless Media (Bluetooth, Infrared, Microwave, Satellite)
Internet Backbone & Access (Dial-Up, Broadband)
ISP & Protocols (TCP/IP, HTTP, FTP, TELNET, WAIS, GOPHER)
IP Address, Domain Name, MAC Address
Web Browsers & Search Engines
Mobile Communication (GSM, CDMA, WLL, 3G, 4G)
Network Security & Viruses
Firewall, Cookies & Digital Signatures
Cyber Crimes & Indian IT Act 2000
Topics Covered: Programming Fundamentals - Java OOP, HTML Based Web Pages Covering Basic Tags.
Access Specifiers (public, private, protected, default)
Inheritance Concepts in Java
Java String Class Methods (toString, concat, length, toLowerCase, toUpperCase, trim, substring)
Java Math Class Methods (pow, round)
JDBC / ODBC Connection to MySQL
HTML Document Structure & Tags
Headings (H1..H6), Paragraph (P), Line Break (BR), HR
Font Formatting & Lists (UL, OL)
HTML Tables & Form Controls
Static vs Dynamic Web Pages
Introduction to DHTML & XML
Topics Covered: Database Fundamentals & SQL Grouping, Introduction to MySQL & Built-in Functions.
Database Transactions (COMMIT & ROLLBACK)
Grouping Records (GROUP BY)
Aggregate Functions (MAX, MIN, AVG, SUM, COUNT, COUNT*)
DISTINCT Clause & Handling NULLs
Displaying Data from Multiple Tables
Cartesian Product, Union, Foreign Key, Equi-Join
ORDER BY Clause & Column Aliases
UPDATE & DELETE Commands
ALTER TABLE (ADD/DROP columns) & DROP TABLE
MySQL String Functions (ASCII, CHAR, CONCAT, INSTR, LCASE, UCASE, LENGTH, LTRIM, MID, RIGHT, RTRIM, TRIM, SUBSTR)
Mathematical Functions (POWER, ROUND, TRUNCATE)
Date & Time Functions (CURDATE, MONTH, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, NOW, SYSDATE)
Topics Covered: e-Business & e-Commerce, Front-end Interface & Back-end Database, Digital Transactions in India.
e-Business & e-Commerce Definition
Types of e-Commerce (B2B, B2C, C2C, C2B)
Salient Features of e-Business Websites
Societal Impact & Challenges of e-Business
Front-end Components (Text Box, Radio Button, Checkbox, List)
Back-end Database Requirements & Table Attributes
Database Development for e-Governance Applications
Digital Transactions in India (UPI, BHIM, AEPS, NEFT, RTGS)
Advertisement – 728×90
Class 11 (1st Year) – Official CHSE IT Syllabus Notes
Download Textbook PDFTopics Covered: Hardware Concepts, Software Concepts, Open Source Concepts & Odia UNICODE.
Hardware Concepts & Architecture
Input & Output Devices
Memory Units & Storage Hierarchy
System Software & Language Processors
Utility Software (Antivirus, Compression)
General vs Specific Purpose Application Software
FOSS / FLOSS Open Source Concepts
Common Open Standards (WWW, HTML, XML, TCP/IP)
Indian Language Computing & UNICODE
Odia Script UNICODE Character Chart
Topics Covered: Programming using IDE - Swing GUI, Programming Fundamentals, Programming Guidelines.
Rapid Application Development (RAD) using IDE
Java Swing GUI Controls (Label, TextField, TextArea, Button, CheckBox, RadioButton, ComboBox, List)
Component Methods (setText, getText, isSelected, setSelected)
Built-in Data Types (Byte, Int, Float, Double, Char, Boolean)
Type Conversion Methods (parseInt, parseDouble)
Control Structures - Decision (if, switch) & Loops (while, for)
Syntax, Run-time & Logical Errors
Debugging & Problem Solving Procedure
Topics Covered: Database Management System, Introduction to MySQL.
Database Concepts (Relation, Attribute, Tuple)
Data Types (CHAR, VARCHAR, INT, DATE)
Keys (Primary Key, Candidate Key, Foreign Key, Alternate Key)
SQL Command Categories (DDL vs DML)
CREATE DATABASE, USE & DESC Commands
SELECT Queries & Arithmetic Operators
WHERE Filtering & Operators (=, BETWEEN, IN, LIKE, AND, OR, NOT)
Eliminating Duplicates with DISTINCT
Topics Covered: e-Governance, e-Learning.
e-Governance Definition & Citizen Benefits
e-Governance Portals, Features & Challenges
e-Learning Definition & Benefits (Students, Teachers, Institutions)
e-Learning Websites & Societal Impact