CBSE Class 11 Computer Science Syllabus (Revised) – NCERT Text Books for XI Class

Central Board of Secondary Education (CBSE) let the students know about the basics of computer programming and data management in class 11th. Studying the computer science subject seriously at school will not only help students in clearing the annual exam but also getting many job opportunities in the future. The CBSE Class 11th Computer Science Syllabus 2021 is divided into two parts i.e. first part is for the theory paper and the second part is for practical paper.

CBSE 11th Class Computer Science Syllabus 2021

Here are the details about unit-wise marks and periods allotted to computer science subject of class 11th.

UnitsMarksPeriods
TheoryPractical
Computer Systems and Organization10102
Computational Thinking and Programming356045
Data Management – 1153023
Society, Law and Ethics – 11010
Total7011070

 Detailed Unit-wise syllabus of CBSE 11th class computer science subject

Unit 1: Computer Systems and Organization

  • Basic computer organisation: description of a computer system and mobile system, CPU, memory, hard disk, I/O, battery.
  • Memory Units: bit, byte, MB, GB, TB, and PB.
  • Types of software: application, System, utility.
  • Boolean logic: OR, AND, NAND, NOR, XOR, NOT, truth tables, De Morgan’s laws.
  • Strings: ASCII, UTF8, UTF32, ISCII (Indian script code), Unicode.
  • Information representation: numbers in base 2, 8, 16, binary addition
  • Concept of Compiler & Interpreter
  • Basic concepts of Flowchart
  • Concept of cloud computing, cloud (public/private), introduction to parallel computing.
  • Running a program: Notion of an operating system, how an operating system runs a program, idea of loading, operating system as a resource manager.

Unit 2: Computational Thinking and Programming

  • Familiarization with the basics of Python programming: A simple “hello world” program, process of writing a program (Interactive & Script mode), running it, and print statements. Simple data-types: integer, float, string.
    • Features of Python, Python Character Set, Token & Identifiers, Keywords, Literals, Delimiters, operators.
    • Introduce the notion of a variable, and methods to manipulate it (concept of Lvalue and R-value even if not taught explicitly).
    • Comments: (Single line & Multiline/ Continuation statements), Clarity & Simplification of expression.
    • Operators & types: Binary operators-Arithmetic, Relational operators, Logical Operators, Augmented Assignment operators.
    • Knowledge of data types and operators: accepting input from the console, assignment statement, expressions, operators and their precedence.
    • Notion of iterative computation and control flow: for(range(),len()), while, flowcharts, suggested programs: interest calculation and factorials, etc.
    • Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, and divisibility.
    • Lists, tuples and dictionary: finding the maximum, minimum, mean; linear search on list/tuple of numbers, and counting the frequency of elements in a list using a dictionary. Introduce the notion of accessing elements in a collection using numbers and names.
    • Idea of debugging: errors and exceptions; debugging: pdb, break points.
    • Strings: Traversing, compare, concat, substring.
    • Sorting algorithm: bubble and insertion sort;count the number of operations while sorting.
    • Introduction to Python modules: Importing math (sqrt, cell, floor, pow, fabs, sin, cos, tan, random (random, randint, randrange), statistics (mean, median, mode) modules.
  • Basics of Computational Thinking: Decomposition, Pattern Recognition/ Data representation, Generalization/ Data Abstraction and algorithm.

Unit 3: Data Management

  • Use SQL – DDL/ DML commands to CREATE TABLE, INSERT INTO, UPDATE TABLE , DELETE FROM, ALTER TABLE,MODIFY TABLE, DROP TABLE, keys, and foreign keys; to view content of a table: SELECT-FROMWHERE-ORDER BY along with BETWEEN, IN, LIKE, (Queries only on single table)
  • Relational databases: Concept of a database, relations, attributes and tuples, keys- candidate key, primary key, alternate key, foreign key; Degree and cardinality of a table.
  • Basics of No SQL databases.
  • Aggregate functions – MIN, MAX, AVG, COUNT, SUM.

 Unit 4: Society, Law and Ethics – Cyber safety

  • Appropriate usage of social networks: spread of rumours, and common social networking sites (Twitter, LinkedIn, and Facebook) and specific usage rules.
  • Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, cyber trolls and bullying.
  • Safely accessing web sites: adware, malware, viruses, Trojans.
  • Safely communicating data: secure connections, eavesdropping, phishing and identity verification.

Practical Exam Syllabus

The basic structure of Practical exam carrying 30 marks is given in the table below.

Unit NameMarks
Part A: Lab Test (12 marks)
Python program (60% logic + 20% documentation + 20% code quality)8
SQL program (at least 4 queries)4
Part B: Report File + viva (10 marks)
Report file: Minimum 20 Python programs and 8 SQL commands
Viva voce (based on the report file)
Part C: Project (8 marks)
Project (that uses most of the concepts that have been learnt)8

Programming in Python:                                                                

  • The following concepts in the python programming language should be covered in the 11th class – loops, conditionals, expressions, dictionary, list, and strings. Given below are the representative lab assignments.
    • Find the largest and smallest numbers in a list.
    • Test for primarily
    • Find the third largest number in a list
    • Given two integers x and n, compute xn.
    • Compute the greatest common divisor and the least common multiple of two integers.
    • Test if a number is equal to the sum of the cubes of its digits. Find the smallest and largest such numbers.

Data Management

  • SQL Commands: create, insert, delete, select, and join. Here are the representative lab assignments.
    • Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
    • Insert the details of a new student in the above table.
    • Use the select command to get the details of the students with marks more than 80.
    • Delete the details of a particular student in the above table.
    • Create a new table (name, date of birth) by joining two tables (student id, name) and (student id, date of birth).
    • Create a new table (order ID, customer Name, and order Date) by joining two tables (order ID, customer ID, and order Date) and (customer ID, customer name, contact name, country).

 

Contents
For More Educational News Updates on Sarkari NaukriSarkari Result, and Employment News Notification. Join us on Twitter | Join Our WhatsApp Groups | Connect with our Telegram Channel

Maheshwari

Content Writer

Schools360 Helpline Online
Hello, How can I help you? ...
Click Here to start the chat...