I.P Syllabus

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

DELHI PUBLIC SCHOOL, SILIGURI

Session 2022-23
Syllabus
Class: XI, Subject: Informatics Practices (Code No. 065)

Examination: MID TERM

Unit 1: Introduction to Computer System

Introduction to computer and computing: evolution of computing


devices, components of a computer system and their interconnections,
Input/output devices.
Computer Memory: Units of memory, types of memory – primary and
secondary, data deletion, its recovery and related security concerns.
Software: purpose and types – system and application software,
generic and specific purpose software.

Unit 2: Introduction to Python


Basics of Python programming, Python interpreter - interactive and
script mode, the structure of a program, indentation, identifiers,
keywords, constants, variables, types of operators, precedence of
operators, data types, mutable and immutable data types, statements,
expressions, evaluation and comments, input and output statements, data
type conversion, debugging.
Control Statements: if else, for loop
Lists: list operations - creating, initializing, traversing and
manipulating lists, list methods and built-in functions.

1
Examination: UNIT TEST - II

Unit 3: Database concepts and the Structured Query Language

Database Concepts: Introduction to database concepts and its need,


Database Management System.
Relational data model: Concept of domain, tuple, relation, candidate key,
primary key, alternate key
Advantages of using Structured Query Language, Data Definition
Language, Data Query Language and Data Manipulation Language,
Introduction to MySQL, creating a database using MySQL, Data Types
Data Definition: CREATE TABLE
Data Query: SELECT, FROM, WHERE.
Data Manipulation: INSERT

Examination: FINAL TERM

Full Syllabus of Mid Term, UT-I &

Unit 2: Continue………………
Dictionary: concept of key-value pair, creating, initializing, traversing,
updating and deleting elements, dictionary methods and
built-in functions.

Unit 4: Introduction to the Emerging Trends

Artificial Intelligence, Machine Learning, Natural Language Processing,


Immersive experience (AR, VR), Robotics, Big data and its
characteristics, Internet of Things (IoT), Sensors, Smart cities, Cloud
Computing and Cloud Services (SaaS, IaaS, PaaS); Grid Computing,
Block chain technology.

2
Theory Marks Distribution.
Unit No Unit Name Marks

1 Introduction to computer system 10


2 Introduction to Python 25
3 Database concepts and the 30
Structured Query Language
4 Introduction to EmergingTrends 5

Practical 30
Total 100

Practical Marks Distribution

S.No. Unit Name Marks

1 Problem solving using Python programming language 11

3 Creating database using MySQL and performing Queries 7

4 Practical file (minimum of 14 python programs, and 14 7


SQLqueries)

5 Viva-Voce 5

Total 30

You might also like