ISO 9001:2015 Certified MSME Registered 4.8 Rating CBSE Board Aligned
School Curriculum Course

CBSE Class 12 Computer
Syllabus in Howrah & Kolkata

Master the complete CBSE Class 12 Computer Science (Code 083) syllabus — covering Computer Networks, Database Management (SQL), Python Data Structures, and AI/NLP. Build strong computational thinking aligned with the CBSE Board curriculum and ace your board exams.

Networking Database (SQL) Python NLP & AI Board Practical
2/Week
Classes
12 Months
Duration
4
Units
10–15
Batch Size
Enroll Now Call: 9239412412
Course Details

What You Get

Everything your child needs to ace CBSE Class 12 Computer Science — in one structured, hands-on course aligned with the CBSE Board syllabus.

Computer Networks

Understanding network topologies, MAC/IP addressing, DNS, protocols (HTTP, FTP, TCP/IP), and cloud computing basics for seamless connectivity.

Database Management

Relational database concepts, SQL commands (DDL/DML), joins, and integrity constraints. Extra coverage on database architecture and normalization.

Py

Python Programming

Comprehensive Python programming covering lists, dictionaries, stacks, queues, and functions. Added algorithms and time complexity concepts.

Computer Vision & NLP

Introduction to Artificial Intelligence, Optical Character Recognition (OCR), Face Recognition, and Natural Language Processing (NLP) steps.

Practical & Project

Hands-on lab sessions creating SQL databases, solving real-world problems with Python, and preparing the board-mandated project report.

Detailed Syllabus

Complete Unit-wise Breakdown

Each topic from the CBSE Class 12 Computer Science (Code 083) syllabus is covered in depth with theory, practicals, and worksheets.

Unit 1: Computer Networks

Understanding network topologies, devices, protocols, and cloud computing. Includes network security basics and data transmission media.

Topologies MAC/IP Protocols Cloud
01
Network Topologies & DevicesIntroduction to network topologies (Star, Bus, Tree). Types of networks: LAN, MAN, WAN, PAN, BAN. Wireless LAN (WLAN). Network devices: Hub, Switch, Repeater, Gateway, Modem, Wi-Fi cards.
02
MAC Address vs IP AddressUnderstanding Media Access Control (MAC) address (physical address, 48-bit). Internet Protocol (IP) address (logical address, IPv4 32-bit & IPv6 128-bit). Difference between MAC and IP. Static vs Dynamic IP.
03
Domain Name System (DNS)What is DNS? How domain names are resolved into IP addresses. Domain name hierarchy (TLD, ccTLD). URL structure and its components (Protocol, Domain, Path).
04
Network ProtocolsDetailed study of protocols: HTTP (HyperText Transfer Protocol), HTTPS, FTP (File Transfer Protocol), SMTP (Simple Mail Transfer Protocol), POP3, TCP/IP, UDP, SLIP, PPP. How data is routed across networks.
05
Cloud Computing & SecurityIntroduction to Cloud Computing (IaaS, PaaS, SaaS). Examples of cloud services (Google Drive, AWS). Network security basics: Firewalls, malware, antivirus, and ethical hacking overview.
06
Practice Worksheet & MCQsChapter-wise worksheet with network diagram labeling, IP vs MAC differentiation, true/false, short answer questions, and multiple-choice questions based on CBSE board pattern.

Unit 2: Database Management

Relational database concepts, SQL commands, joins, and normalization. Added extra info on DBMS architecture, transaction control, and security.

Relational Model SQL Commands Joins Normalization
01
Database & Relational ModelIntroduction to database, DBMS, and RDBMS. Relational data model: degree, cardinality, domain, tuple, attribute. Keys: Candidate, Primary, Alternate, Foreign. Database architecture (1-tier, 2-tier, 3-tier).
02
SQL: DDL & DML CommandsData Definition Language (DDL): CREATE, DROP, ALTER. Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE. Understanding data types in SQL (int, varchar, date, float).
03
SQL Constraints & OperatorsApplying constraints: PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK, DEFAULT. SQL operators: Relational, Logical (AND, OR, NOT), Arithmetic.
04
SQL Functions & GroupingBuilt-in SQL functions: Math (SUM, AVG, MAX, MIN), String (UPPER, LOWER), Date & Time functions. Grouping records using GROUP BY, HAVING clause, and sorting using ORDER BY.
05
Joins & Multiple TablesJoining multiple tables together: Cartesian product (CROSS JOIN), Equi join, Natural join. Using foreign key references to fetch combined data.
06
Normalization & TCLExtra info: Normalization (1NF, 2NF, 3NF) to reduce data redundancy. Transaction Control Language (TCL): COMMIT, ROLLBACK, SAVEPOINT. Protecting databases against unauthorized access.
07
SQL Practice & WorksheetWriting 20+ SQL queries to create tables, insert records, apply joins, sort data, and execute functions. Error-finding exercises and output prediction questions.
Py

Unit 3: Python Programming

Comprehensive Python course covering functions, lists, dictionaries, stacks, and queues as per the CBSE Class 12 syllabus. Added info on algorithms and complexity.

Functions Lists Dictionaries Stacks & Queues
01
Functions in PythonDefining user-defined functions using the 'def' keyword. Arguments, default parameters, and variable scope (local & global). Return statement. Lambda functions (anonymous functions).
02
Python ListsIntroduction to lists (mutable sequences). Creating, accessing, and modifying lists. List operations (concatenation, repetition, slicing). List methods: append(), extend(), insert(), remove(), pop(), sort(), reverse(), count().
03
Python DictionariesCreating dictionaries (key-value pairs). Accessing and modifying values. Dictionary methods: keys(), values(), items(), get(), update(), clear(), del.
04
Stacks & QueuesData structures using lists. Stack operations: push (append), pop, peep (peek). Queue operations: enqueue (append), dequeue (pop(0)). Understanding LIFO (Last In First Out) and FIFO (First In First Out).
05
Algorithms & Time ComplexityExtra info: Understanding algorithm efficiency. Calculating Time & Space complexity (Big-O notation). Difference between Bubble sort, Selection sort, and Linear search.
06
File Handling in PythonReading and writing text files. File opening modes (r, w, a). Reading line-by-line. Appending data to existing files. Closing files using .close() method.
07
Practice Programs & WorksheetWriting 25+ Python programs covering functions, list manipulation, dictionary operations, stack/queue implementation, and file handling. Output prediction and error-finding exercises.

Unit 4: Practical Lab & Project Work

Hands-on practical sessions creating SQL databases, solving real-world problems with Python, and preparing the board-mandated project report.

Python Lab SQL Lab Project Report
01
Python Programming LabPractical lab writing Python functions, lists, and dictionary programs. Implementing data structures like Stacks and Queues practically.
02
SQL Database PracticalCreating relational databases in MySQL. Executing DDL, DML, TCL commands. Implementing Joins and applying group functions practically.
03
Python File Handling LabPractical implementation of file handling. Writing Python scripts to read, write, and append data into text files for real-world scenarios.
04
NLP & Computer Vision PracticalExploring Python libraries for AI. Basic implementation of Optical Character Recognition (OCR) and understanding NLP steps practically.
05
Board Project ReportGuidance on preparing the CBSE Class 12 practical file. Selecting a real-world problem, writing the algorithm, creating the code (Python/SQL), and documenting the project for board submission.

Computer Vision & NLP

Introduction to Artificial Intelligence, Computer Vision applications, Face Recognition, OCR, and Natural Language Processing (NLP).

AI Basics Face Recognition OCR NLP Steps
01
Introduction to AIWhat is Artificial Intelligence? Machine Learning vs Deep Learning. Applications of AI in daily life (smart assistants, self-driving cars, recommendation systems).
02
Computer VisionDefinition of Computer Vision. Its applications in medical imaging, autonomous vehicles, and security. Basics of Face Recognition, Retina Recognition, and Biometrics.
03
Optical Character Recognition (OCR)What is OCR? How it converts images of typed, handwritten, or printed text into machine-encoded text. Real-world applications like scanning documents and automated toll plazas.
04
Natural Language Processing (NLP)Introduction to NLP. The 5 stages of NLP: Lexical Analysis, Syntactic Analysis, Semantic Analysis, Discourse Integration, and Pragmatic Analysis.
05
Practice Worksheet & MCQsReal-life scenario-based questions on AI, differentiating between Vision and NLP, and a worksheet covering all ethical and application-based concepts.
Modules
Networking
Database (SQL)
Python
Practical Lab
Vision & NLP
Skills Gained
Networking SQL Databases Python Coding Board Practical AI & NLP Logical Thinking Data Structures DBMS Architecture
Course Info
Duration12 Months
Classes/Week2
Total Units4
MediumBengali & Hindi & English
ModeBatch Class
Learning Outcomes

After Completing This Course

Your child will gain these measurable skills and knowledge by the end of the course.

Master Networking

Explain different network topologies, MAC/IP addressing, protocols, and cloud computing basics used to build and maintain modern networks.

Manage Databases

Design relational databases and manipulate data using SQL commands, joins, aggregate functions, and normalization techniques.

Py

Code in Python

Develop a strong foundation in Python programming by handling functions, lists, dictionaries, stacks, queues, and file handling.

Complete Practical Lab

Successfully complete the CBSE board practical file, project report, and viva voce with real-world Python & SQL projects.

Understand AI & Vision

Apply basic Artificial Intelligence concepts, understand Computer Vision, OCR, and implement the steps of Natural Language Processing (NLP).

Think Logically

Enhance problem-solving abilities by understanding algorithms, time complexity, and creating structured logic before writing code.

Who Is This For

Perfect For These Students

CBSE Class 12 Students

Students currently in Class 12 under the CBSE board who want to build a strong foundation in Computer Science and score 90+ in board exams.

Students Needing Revision

Students who have studied these topics but need structured revision with practice worksheets, Python projects, and SQL hands-on coding.

Future Engineers

Students who enjoy logic, AI, and problem-solving and want to start their text-based programming journey early with Python and Databases.

FAQ

Frequently Asked Questions

What is the fee for the CBSE Class 12 Computer Science course at PBA Institute?

+

The fee for the CBSE Class 12 Computer Science course at PBA Institute is ₹800 per month for Batch Class.

Is this course aligned with the CBSE Class 12 syllabus?

+

Yes. This course strictly follows the official CBSE Class 12 Computer Science (Code 083) syllabus covering Networking, Database Management, Python, and NLP, ensuring students are fully prepared for board exams.

Do you provide practice papers and board-level assessments?

+

Yes. We provide chapter-wise worksheets, board-pattern question papers, and assessments after each module to ensure thorough exam readiness for CBSE Class 12 students.

Will my child get hands-on practice with Python and SQL?

+

Yes. Students get practical sessions where they write and run Python programs, execute SQL queries, create databases, and complete the board practical file — all under guided supervision.

What is the class schedule and batch size?

+

Classes are held 2 times per week, Monday to Saturday, between 8 AM and 8 PM. Batch size is limited to 10–15 students to ensure personal attention for every student.

Is Python software provided for home practice?

+

Yes. We provide complete Python and MySQL software installation support so students can practice at home. Step-by-step installation guidance is given during the first class.

Ready to Master Class 12 Computer?

Join PBA Institute's Batch Class for just ₹800/month. Build a strong foundation in Networking, Python, SQL Databases, and AI — all aligned with the CBSE Board syllabus.

Enroll Now Call: 9239412412
More Courses

CBSE Class 8 Computer

Advanced Number System, HTML, Python Basics & Cyber Safety

₹700/Month 12 Months

CBSE Class 9 Computer

Advanced Python, Data Structures, HTML & Cyber Ethics

₹800/Month 12 Months

CBSE Class 10 Computer

Advanced HTML, CSS, Python & Cyber Ethics

₹800/Month 12 Months

ICSE Class 10 Computer

Advanced Java, Inheritance, Interfaces, File Handling & Board Prep

₹800/Month 12 Months