Page 10 - Information_Practice_Fliipbook_Class11
P. 10

SYLLABUS                                                                    CLASS-XI




               INFORMATICS PRACTICES [CODE-065]




            1.  Prerequisites. None
            2.   Learning Outcomes
                At the end of this course, students will be able to:
                a.  Identify the components of computer system.
                b.  Create Python programs using different data types, lists and dictionaries.
                c.  Understand database concepts and Relational Database Management Systems.
                d.  Retrieve and manipulate data in RDBMS using Structured Query Language.
                e.  Identify the Emerging trends in the fields of Information Technology.
            3.   Distribution of Marks and Periods

                  Unit                                                          Periods     Periods     Total
                                       Unit Name                    Marks
                  No.                                                           Theory     Practical    Period
                   I.   Introduction to computer system               10          10          -           10
                   II.  Introduction to Python                        25          35          28          63
                        Database concepts and the Structured Query
                   III.                                               30          23          17          40
                        Language
                   IV.  Introduction to Emerging Trends                5           7          -            7
                        Practical                                     30           -          -           -

                        Total                                        100          75          45         120
            4.   Unit Wise Syllabus
                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, if-elif-else, while loop, for loop
                Lists:  list  operations  -  creating,  initializing,  traversing  and  manipulating  lists,  list  methods  and  built-in  functions  –  len(),  list(),
                append(),insert(), count(), index(), remove(), pop(), reverse(), sort(), min(), max(), sum()
                Dictionary: concept of key-value pair, creating, initializing, traversing, updating and deleting elements, dictionary methods and built-in
                functions – dict(), len(), keys(), values(), items(), update(), del(), clear()
                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 DATABASE, CREATE TABLE, DROP, ALTER
                    Data Query: SELECT, FROM, WHERE with relational operators, BETWEEN, logical operators, IS NULL, IS NOT NULL.
                    Data Manipulation: INSERT, DELETE, UPDATE

                                                             (viii)
   5   6   7   8   9   10   11   12   13   14   15