Computer Science

1. Python Overview of Class XI in Depth: 16 Marks

• Getting Started with Python
• Python Fundamentals
• Data Types & Operators
• Conditional Statements
• Loop Statements
• Strings Handling
• Working with Lists & Tuples
• Working with Dictionaries
• Extensive Live Programming Practice (Minimum 60 Programs)

2. User Defined Function : 7 Marks

• Introduction to Functions and its Purpose
• Types of Functions
• Defining and Calling Functions
• Flow of Execution in a Function Call
• Arguments and Parameters
• Parameterized & Non-Parameterized Functions
• Returning single & multiple values from Functions
• Passing Parameters ways
• Handling Lists, Tuples, and Dictionaries as Parameters
• Scope of variables
• Format of Function
• What is a Library & Module
• Module Importing Ways
• Some standard Library Modulus (math,random statistics)
• Some important built in Function.
• Extensive Live Programming Practice (Minimum 30 Programs)

3. Exception Handling :

• Introduction to Exception Handling
• Problem without Exception Handling
• Need of Exception Handling
• Understanding try,except & finally block
• Extensive Live Programming Practice (Minimum 3 Programs)

4.Data File Handling : 14 Marks

• What is Data Files & Purpose of File
• Types of Files
• Steps Required for working on File
• File Opening ways
• Closing Files
• Introduction to Text Files
• Understanding write() & writelines() method
• Understanding read(),readline() & readlines() method
• Text File Operations (Read, Write, Search, Update, Delete)
• File Pointer and flush method
• Different File Modes
• Introduction to Binary Files
• Understanding pickle module
• Understanding dump() & load() method
• Binary File Operations(Read, Write, Search, Update, Delete)
• Introduction to Binary Files
• Understanding csv module
• Understanding reader & writer() method
• Understanding writerow() & writerows() method
• CSV File Operations(Read, Write, Search, Update, Delete)
• File Path
• Extensive Live Programming Practice (Minimum 45 Programs)

5. Data Structures : 3 Marks

• Introduction of Data Structure & Stack
• Stack Applications
• Stack Operation(Push ,Pop & Display)
• Extensive Live Programming Practice (Minimum 9 Programs)

6.Connectivity with MySQL using Python : 5 Marks

• What is Connectivity and its recruitment
• Steps for Creating Database Connectivity
• Understanding connect() method & Cursor class
• Understanding execute() method
• Understanding fetchall(),fetchone(),fetchmany() method
• Understanding commit() method
• CRUD Operation with Database using Python
• Integrated Python and MySQL Mini Projects

1 Relational Databases

• What is Database and use of Database
• Relationship between DBMS & RDBMS
• Advantage & Disadvantage of Database
• Understanding Different Data Models
• Basic Terminology about DBMS
• Keys
• Different Tools Used for DBMS
• NULL Values & Comments
• SHOW ,USE & DESC Command
• SELECT ,FROM ,WHERE,AS & DISTINCT Command
• Operators in SQL
• Searching NULL Values
• ORDER BY Clause
• Extensive Live Query Practice (Minimum 45 Query)

2. DDL & DML Commands

• SQL Data Types
• Creating Database & Tables
• SQL Constraints
• 3 Ways of Inserting Record
• Updating Record
• Uses of Alter Command
• Deleting Record
• Removing Database & Table permanently
• Extensive Live Query Practice (Minimum 30 Query)

3. Grouping & Joining

• Understanding Aggregate Functions
• Group By & Having Clause
• Introduction to Joining
• Understanding different types of Joining(equi-join, Natural Join, Cartesian Product)
• Extensive Live Query Practice (Minimum 18 Query)

• Evolution of networking
• Introduction to Computer Networks & its types
• Data communication terminologies
• Transmission media
• Network Devices
• Network topologies
• Network protocol
• Introduction to web services

• Lab Test (12 Marks)
• Practical Report File (7 Marks)
• Project (8 Marks)
• Viva Voce (3 Marks)