Python Programs For Class 11 (XI) CBSE

LESSON 2: DATA HANDLING

• Introduction
• Data Types
  • Numbers
  • Strings
  • Lists and Tuples
  • Dictionary
• Mutable and Immutable Types
  • Variable Internals
• Operators
  • Arithmetic Operators
  • Relational Operator
  • Identity Operators
  • Logical Operators
  • Bitwise Operators
  • Operators Precedence
• Expressions
  • Evaluating Expressions
  • Typecasting
• Working with Some Standard Library Modulus
• Working With math Module Of Python
• Using random Module
• Using the statistics Module

LESSON 3: CONDITIONAL AND ITERATIVE STATEMENTS

• Introduction
• Types of Statements in Python
• Statements Flow Control
• Program Logic Development Tools
  • Flowcharts
• The if Statements of Python
  • The if Statement
  • The if – else Statement
  • The if – else Statement
  • The Nested if Statement
• Repetition of Tasks – A Necessity
• The range ( ) Function
• Iteration / Looping Statements
  • The For Loop
  • The While Loop
  • Loop else Statement
  • Jump Statements –break and continue
  • Loop else Statement
  • Nested Loops

LESSON 4 STRING MANIPULATIONS

• Introduction
• Traversing String
• String Operators
  • Basic Operators
  • Membership Operators
  • Comparison Operators
• String Slices
• String Functions and Methods

LESSON 5 DEBUGGING PROGRAMS

• Introduction
• What is Debugging?
• Errors and Exceptions
  • Errors in a Program
  • Exception
• How to debug a program
  • Debugging Techniques
  • Using Debugger Tool

Lesson 6 LIST MANIPULATION

• Introduction
• Creating and Accessing lists
  • Creating Lists
  • Accessing Lists
• List Operations
  • Joining Lists
  • Repeating or Replicating Lists
• Working with Lists
• List Functions and Methods

Lesson 7 TUPLES

• Introduction
• Creating and Accessing Tuples
  • Creating Tuples
  • Accessing Tuples
• Tuple Operations
  • Joining Tuples
  • Slicing the Tuples
  • Tuple Functions and Methods

Lesson 8 DICTIONARIES

• Introduction
• Dictionary – Key : Value Pairs
  • • Creating a Dictionary
    • Accessing Elements of a Dictionary
    • Characteristics of a Dictionary
  • Working with Dictionaries
    • Multiple Ways Of Creating Dictionaries
    • Adding Elements to Dictionary
    • Updating Existing Elements in a Dictionary
    • Deleting Elements from a Dictionary
    • Checking for Existence of a Key
    • Pretty Printing a Dictionary
    • Counting Frequency of Elements in a list using Dictionary
  • Dictionary Functions and Methods

LESSON 9 UNDERSTANDING SORTING

• Introduction
• What is Sorting
• Bubble Sort
• Insertion Sort

Lesson 10 RELATIONAL DATABASES

• Introduction
• Purpose of DBMS
• Relational Database Model
• The Relational Model Terminology
  • Views
  • Structure of Relational Database
• Brief History of MySQL
• MySQL Database Systems
• Starting MySQL
• MySQL and SQL
  • Processing Capabilities of SQL
  • Data Definition Language
  • Classification of SQL Statements

Lesson 11 SIMPLE QUERIES IN SQL

• Introduction
• Some MySQL SQL Elements
  • Literals
  • Data Types
  • Null Values
• SQL Command Syntax
• Sample Database
• Making Simple Queries
  • Accessing Database
  • The SELECT Command
  • Selecting All Columns
  • Reordering Columns in Query Results
  • Eliminating Redundant Data (with Keyword DISTINCT)
  • Selecting from all the Rows – All Keyword
  • Viewing the Structure of Table
  • How to Perform Simple Calculations?
  • Scalar Expressions with Selected Fields
  • Using Column Aliases
  • Handling Nulls
  • Putting Text in the Query Output
  • Selecting Specific Rows – WHERE clause
  • Relational Operators
  • Logical operators
  • Condition Based on a Range
  • Condition Based on a List
  • Condition Based on Pattern Matches
  • Searching for NULL
  • Operators Precedence
  • Sorting Results – ORDER BY clause
• MySQL Functions
  • String Functions
  • Numeric Functions
  • Date and Time Functions
  • Aggregate Functions