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

CBSE Class 11 Computer
Syllabus in Howrah & Kolkata

Master the complete CBSE Class 11 Computer Science (Code 083) syllabus — covering Computer Systems & Organization, Python Programming (with Lists, Tuples, Dictionaries), Database Management using MySQL, and Cyber Safety. Build strong computational thinking aligned with the CBSE Board curriculum and ace your board exams.

Computer Systems Python MySQL Cyber Safety Society & Law
2/Week
Classes
12 Months
Duration
4
Units
10–15
Batch Size
Course Details

What You Get

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

Computer Systems

Overview of computer architecture, input/output devices, CPU, memory hierarchy (RAM, ROM, Cache), and logic gates (AND, OR, NOT, NAND, NOR, XOR).

Python Programming

Comprehensive Python programming covering variables, data types, operators, conditional statements, loops, lists, tuples, dictionaries, and functions.

Py

Database (MySQL)

Introduction to databases, Relational Database Management System (RDBMS), MySQL interface, DDL, DML, DCL commands, and SQL queries.

Cyber Safety & Ethics

Safe browsing, protecting personal information, cyberbullying, digital footprints, IT Act, and intellectual property rights (Copyrights, Patents, Trademarks).

Practical & Project

Hands-on lab sessions creating Python programs, executing MySQL queries, and preparing the board-mandated project report with algorithms and flowcharts.

Detailed Syllabus

Complete Unit-wise Breakdown

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

Computer Systems & Organisation

Understanding computer architecture, input/output devices, CPU components, memory types, logic gates, and Boolean logic.

CPU Memory Logic Gates
01
Overview of Computer SystemIntroduction to computers, history, and generations. Basic architecture: Input unit, CPU (ALU, Control Unit), Output unit. Concept of system software and application software.
02
Input & Output DevicesDetailed study of input devices (keyboard, mouse, scanner, microphone) and output devices (monitor, printer, speakers). Introduction to OMR, OCR, MICR, and barcode readers.
03
Memory ConceptsPrimary memory vs Secondary memory. RAM (SRAM, DRAM) and ROM (PROM, EPROM, EEPROM). Memory hierarchy: Registers, Cache, Main Memory, Secondary Storage. Units of memory (Bit, Byte, KB, MB, GB, TB).
04
Logic Gates & Boolean AlgebraIntroduction to Boolean logic. Basic logic gates: AND, OR, NOT. Universal gates: NAND, NOR. Derived gates: XOR, XNOR. Truth tables, logical expressions, and basic laws of Boolean algebra (De Morgan's Theorems).
05
Number SystemsDecimal, Binary, Octal, and Hexadecimal number systems. Conversions between different bases. Binary arithmetic (Addition, Subtraction using 1's and 2's complement).
06
Software ConceptsSystem software (Operating Systems, Compilers, Interpreters, Assemblers). Application software (Word processors, Spreadsheets). Utility software and open-source concepts.
07
Practice Worksheet & MCQsChapter-wise worksheet with truth table completion, number system conversions, true/false, short answer questions, and multiple-choice questions.

Society, Law & Ethics

Staying safe in the digital world, understanding cyber laws, intellectual property, and the impact of technology on society.

Cyber Safety E-Waste IT Act
01
Digital FootprintsWhat is a digital footprint? Active and passive footprints. How data is collected by websites and apps, and the long-term impact of online posts on career and reputation.
02
Cyber Crimes & SafetyUnderstanding cyberbullying, identity theft, phishing, and hacking. How to protect personal information (not sharing addresses, phone numbers, or passwords). Privacy settings and secure browsing (HTTPS).
03
Malware & VirusesWhat are computer viruses, worms, trojans, spyware, and ransomware? Symptoms of an infected computer. The role of antivirus software and firewalls in network security.
04
Intellectual Property Rights (IPR)Respecting intellectual property: Copyrights, Patents, and Trademarks. Why copying software, movies, or text without permission is wrong. Open-source software and Creative Commons licenses.
05
Cyber Laws & IT ActIntroduction to the Information Technology (IT) Act 2000. Cyber offenses and penalties. Hacking vs. Ethical hacking. Digital signatures and authentication.
06
E-Waste & Technology AddictionUnderstanding e-waste, its environmental impact, and proper disposal methods (recycling). Health issues related to technology overuse (eye strain, posture, addiction) and digital detox.
07
Practice Worksheet & MCQsReal-life scenario-based questions on cyber safety, identifying phishing emails, understanding IPR, and a worksheet covering all ethical concepts.
Py

Python Programming

Comprehensive Python programming course covering variables, data types, operators, conditional statements, loops, lists, tuples, dictionaries, and functions as per the CBSE Class 11 syllabus.

Basics If-Else Loops Lists & Tuples
01
Getting Started with PythonWhat is Python? History and features. Setting up the Python environment (IDLE). Understanding the interactive shell vs. script mode. Python keywords, variables (dynamic typing), and comments.
02
Data Types & OperatorsMutable vs Immutable types. Data types: Number (int, float, complex), String, Boolean, None. Using the type() function. Arithmetic, Relational, Logical, Assignment, Identity (is, is not), and Membership (in, not in) operators.
03
Input & OutputUsing the print() function (sep, end parameters). Taking user input using the input() function. Typecasting input from string to integer or float. Writing interactive mathematical programs.
04
Conditional StatementsIntroduction to decision making. Syntax of if, if-else, and if-elif-else statements. Writing programs to check if a number is positive/negative, odd/even, finding the greatest of three numbers.
05
Looping StatementsWorking with while loop and for loop (using range() function). Writing programs to print patterns, calculate factorials, and sum of series. Break, continue, and pass statements.
06
Lists & TuplesCreating, accessing, and modifying lists. List operations (concatenation, repetition, slicing). List methods (append, insert, remove, pop, sort, reverse). Introduction to immutable Tuples.
07
Dictionaries & SetsCreating dictionaries, accessing values via keys. Dictionary methods (keys(), values(), items(), update()). Introduction to sets (union, intersection, difference).
08
Functions in PythonWhat is a function? Built-in vs User-defined functions. Defining functions using the def keyword. Parameters, arguments, default arguments. The return statement. Scope of variables (local, global).
09
Practice Programs & WorksheetWriting 25+ Python programs covering basic arithmetic, user input, conditional logic, pattern printing, list/dictionary operations, and functions. Output prediction and error-finding exercises.

Practical Lab & Project Work

Hands-on practical sessions solving real-world problems with Python, executing MySQL queries, and preparing the board-mandated project report.

Python Lab MySQL Lab Project Report
01
Python Basic ProgramsWriting Python scripts to accept user input, perform mathematical calculations, and display formatted output using print statements.
02
Python Logic BuildingPractical implementation of if-else and loops in Python. Writing programs to generate patterns, calculate factorial, check prime numbers, and find Fibonacci series.
03
Python Data Structures LabPractical implementation of Lists, Tuples, and Dictionaries. Writing programs to manage a student database, count frequencies, and search/sort elements.
04
MySQL PracticalCreating databases and tables. Inserting, updating, and deleting records. Executing SELECT queries with WHERE, ORDER BY, and GROUP BY clauses.
05
Python Functions LabCreating modular Python scripts using user-defined functions. Passing arguments, returning values, and calling functions within main programs.
06
Board Project ReportGuidance on preparing the CBSE Class 11 practical file. Selecting a real-world problem, writing the algorithm, drawing the flowchart, creating the code (Python), and documenting the project for board submission.

Database Management (MySQL)

Introduction to databases, understanding Relational Database Management System (RDBMS), and learning SQL to store, manipulate, and retrieve data efficiently.

RDBMS SQL Commands Clauses
01
Database ConceptsWhat is a database? Need for databases. DBMS vs RDBMS. Concepts of tables, records, fields, and keys (Primary Key, Foreign Key, Candidate Key, Alternate Key).
02
Introduction to MySQLInstalling MySQL. Understanding the MySQL interface. Basic SQL syntax. Data types in MySQL (INT, VARCHAR, DATE, FLOAT, CHAR).
03
DDL & DML CommandsData Definition Language (DDL): CREATE, ALTER, DROP, TRUNCATE. Data Manipulation Language (DML): INSERT INTO, UPDATE, DELETE. Creating tables and managing records.
04
SQL SELECT QueriesRetrieving data using SELECT statement. Using WHERE clause with operators (=, <, >, BETWEEN, IN, LIKE, IS NULL). DISTINCT clause and column aliases.
05
SQL Clauses & OperatorsSorting records using ORDER BY (ASC, DESC). Grouping records using GROUP BY. Applying conditions to groups using the HAVING clause. Aggregate functions (SUM, AVG, COUNT, MAX, MIN).
06
SQL Joins & OperationsIntroduction to Cartesian product and Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN). Using joins to retrieve data from multiple related tables. DCL and TCL commands (COMMIT, ROLLBACK).
07
Practice Worksheet & MCQsWriting SQL queries based on real-world scenarios (School database, Hospital database, Employee database). Output prediction and error-finding exercises.
Learning Outcomes

After Completing This Course

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

Understand Hardware

Explain computer architecture, memory hierarchy, logic gates, and perform number system conversions.

Apply Cyber Ethics

Apply cyber safety measures, understand IT laws, protect intellectual property, and practice ethical digital behavior.

Py

Write Python Programs

Develop a strong foundation in Python programming by handling user input, using conditional logic, loops, lists, dictionaries, and functions.

Manage Databases

Design relational databases, create tables, write complex SQL queries, and retrieve data using joins and clauses.

Complete Practical Lab

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

Think Logically

Enhance problem-solving abilities by creating algorithms and flowcharts before writing actual code.

Who Is This For

Perfect For These Students

CBSE Class 11 Students

Students currently in Class 11 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 coding, and MySQL query exercises.

Future Programmers

Students who enjoy logic, puzzles, 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 11 Computer Science course at PBA Institute?

+

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

Is this course aligned with the CBSE Class 11 syllabus?

+

Yes. This course strictly follows the official CBSE Class 11 Computer Science (Code 083) syllabus covering Computer Systems, Python, MySQL, and Cyber Ethics, 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 11 students.

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

+

Yes. Students get practical sessions where they write and run Python programs, execute MySQL queries, 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 and MySQL 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 11 Computer?

Join PBA Institute's Batch Class for just ₹800/month. Build a strong foundation in Computer Systems, Python, MySQL, and Cyber Safety — all aligned with the CBSE Board syllabus.

More Courses