# CBSE Class 11 | Informatics — Python Syllabus

Counters | File handling | Loops | Python Methods and Functions

(Optional for the 2018-19 school year and mandatory for the 2019-20 school year and beyond)
1. Prerequisites: No basic prerequisites are required for this course other than basic math skills. However, it will be helpful if the student has a basic knowledge of computer applications.
2. Learning outcomes:

1. Develop basic computational thinking. Learn how to reason with variables, state transitions, conditions, and iterations.
2. Understand the concept of data types and higher-order data structures such as lists, tuples, and dictionaries.
3. Assess the concept algorithm and understand its structure, including how the algorithms handle corner cases.
4. Develop basic knowledge of computer systems — architecture, OS, mobile and cloud computing.
5. Learn the basics of SQL programming.

3. Distribution of signs

` Unit No. Unit Name Marks 1. Programming and Computational Thinking - 1 35 2. Computer Systems and Organization 10 3. Data Management - 1 15 4. Society, Law and Ethics - 1 10 5. Practical 30 Total 100 `

4.1 Unit 1: Programming and Computational Thinking (PCT-1) (80 Theory + 70 Practical)
An introduction to the basics of Python programming: a simple hello world program , L-values ​​and Rvalue, even if not explicitly taught), if, if-else, if-elif-else ; simple programs: for example: decision trees and pseudocode; write many programs: factorials
Debugging idea: lists , tuples and accessing items in a collection using numbers and names.
Sorting algorithm: Strings in Python : comparison, concat , Basic Computer Organization : Description of the computer system and mobile system, processor, memory, hard disk, I / O, battery, power.
Software types: bit, byte, MB, GB, TB, and PB
Boolean logic: De Morgan's laws Number representation: base numbers 2, 8, 16, unsigned integers, binary addition
Strings: ASCII, UTF8, UTF32, ISCII (Indian script code )
Program execution: main compilation thread —  interpreters (process one line at a time) , difference between compiler and interpreter , operating system as resource manager
Cloud computing: relationship , keys, primary key, foreign key delete table
SQL Commands: design and combine ; indexes and lots of practice in the classroom.
NoSQL Database Basics : adware, viruses, trojans
Secure data transfer: secure connections, eavesdropping, phishing and identity verification.

5. Practical

 S.No. Unit Name Marks (Total = 30) 1. Lab Test (12 marks) Python program (60% logic + 20% documentation + 20% code quality) 8 SQL program (at least 4 queries) 4 2. Report File + viva ( 10 marks) Report file: Minimum 20 Python programs and 8 SQL commands 7 Viva voce (based on the report file) 3 3. Project (that uses most of the concepts that have been learned) (See CS-XII for the rules regarding the projects ). 8

5.1. Python Programming: By at least the following Python concepts should be covered in a
lab sessions: expressions, conditionals, loops, list, dictionary, and strings. Below are some typical lab assignments.

1. Find the third largest listed number .
2. Find if a string is palindrome or not .
3. Given two integers x and n, calculate x n.  is the number equal to the sum of the cubes of its digits . Find the smallest and largest such numbers.

5.2. Data management: SQL commands. During the lab, at least the following SQL commands should be considered: delete , select and