Change language

# CBSE Class 11 | Informatics — Python Syllabus

| | |

(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.
6. Learn all about cybersecurity.

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

## Shop

Learn programming in R: courses

\$

Best Python online courses for 2022

\$

Best laptop for Fortnite

\$

Best laptop for Excel

\$

Best laptop for Solidworks

\$

Best laptop for Roblox

\$

Best computer for crypto mining

\$

Best laptop for Sims 4

\$

Latest questions

NUMPYNUMPY

Common xlabel/ylabel for matplotlib subplots

NUMPYNUMPY

How to specify multiple return types using type-hints

NUMPYNUMPY

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

NUMPYNUMPY

Flake8: Ignore specific warning for entire file

NUMPYNUMPY

glob exclude pattern

NUMPYNUMPY

How to avoid HTTP error 429 (Too Many Requests) python

NUMPYNUMPY

Python CSV error: line contains NULL byte

NUMPYNUMPY

csv.Error: iterator should return strings, not bytes

## Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically