CBSE CS and IP

CBSE Class 11 & 12 Computer Science and Informatics Practices Python Materials, Video Lecture

Showing posts with label Study Material. Show all posts
Showing posts with label Study Material. Show all posts

CLASS 12 INFORMATICS PRACTICES

CLASS 12 INFORMATICS PRACTICES STUDY MATERIAL

TOPICS

UNIT - 1: Data Handling using Pandas

  1. Introduction to Python libraries
    1. Pandas
    2. Matplotlib
  2. Data structures in Pandas - Series and Data Frames.
    1. Series
      1. Creation of Series from – ndarray, dictionary, scalar value
      2. Mathematical operations on Series
      3. Head and Tail functions
      4. Accessing Series Elements
        1. Accessing Single Elements
        2. Accessing Series Slices
      5. Modifying Series Elements
      6. Series Attributes
      7. Series Methods
    2. Data Frames
      1. Creation - from the dictionary of Series, list of dictionaries, Text/CSV files
      2. Display the DataFrame
      3. Iteration over DataFrame
      4. Operations on rows and columns of DataFrame - add, select, delete, rename
      5. Head and Tail functions
      6. Indexing using Labels
      7. Boolean Indexing
      8. Importing/Exporting Data between CSV files and Data Frames
      9. Dataframe Methods
    3. NaN Values in Python Pandas
  3. Data Visualization
    1. Introduction - Purpose of plotting
    2. Line Plot
    3. Bar graph
    4. Histogram
    5. Customizing plots: adding label, title, and legend in plots
    6. subplot() Function

UNIT - 2: Database Query using SQL

  1. Math functions
  2. Text functions
  3. Date Functions
  4. Aggregate Functions
  5. Group by, Having
  6. Order by

UNIT - 3: Introduction to Computer Network

  1. Computer Network LAN, MAN, WAN
  2. Network Devices
  3. Network Topology
  4. Introduction to the Internet
  5. website Introduction
  6. Web Browser

Practical List 2020-21


CLASS 11 INFORMATICS PRACTICES

CLASS 11 COMPUTER SCIENCE

Class 11 Computer Science Study Material


TOPICS

UNIT - 1 Computer system and organization

  1. Introduction to computer and Input/Output Device
  2. Components of a Computer System 
  3. Computer Memory
  4. Software - Purpose and Types
  5. Memory Units and Number System
  6. Boolean Logic and De Morgans Law

UNIT - 2  Computational Thinking and programming 

  1. How to Download and install Python
  2. Basics/Features/History of Python programming
  3. Assembler/Compiler/Interpreter and Script/Interactive modes
  4. Python Tokens (Keywords/Identifiers/Operators/Literal/Punctuators)
  5. Data Types (Number/String/List/Tuple/Dictionary)
  6. Variables And Memory Addresses In Python
  7. Comments (Single/Multiline/Continuation)
  8. Errors (Syntax/Run time/Logical error)
  9. Conditional Statement(if/if else/if elif else condition)
  10. Strings data type
    1. String Definition (Traversal and Operations)
    2. String Methods
    3. String Slicing
  11. Lists data type
    1. List Definition(Traversal and Operations)
    2. List Methods
    3. List Slicing
  12. Tuples data type
    1. Tuples Definition (Traversal and Operations)
    2. Tuples Methods
    3. Tuples Slicing
  13. Dictionary data type
    1. Dictionary Definition (Traversal and Operations)
    2. Dictionary Method
  14. Math Module
  15. Random Module
  16. Statistics Module

UNIT - 3 Society, Law and Ethics

  1. Cyber Safety and Security 
  2. Usage of social networks
  3. Safely accessing web sites〈adware, malware, viruses, trojans〉
  4. Intellectual property rights
  5. Plagiarism
  6. Privacy Laws 〈fraud/IT act〉
  7. Technology and society


CLASS 12 COMPUTER SCIENCE

CLASS 12 COMPUTER SCIENCE STUDY MATERIAL


TOPICS

UNIT - 1 Computational Thinking and programming 2

  1.  Functions
  2.  File Handling
  3.  Text file (Absolute /Relative path) and pickle module
  4.  Binary File (Absolute /Relative path) and pickle module
  5.  CSV file (Read/Write/Open/Close File)
  6.  Python Libraries 
  7.  Data structure (List / Stack / Queue)
  8. Interesting Example in Recursion (Removed from Syllabus 2020-21)
  9. Python MODULES, PACKAGES, LIBRARIES & FRAMEWORK

UNIT-2 Computer Network

  1. Evolution of Networking (ARPANET/Internet/Circuit and packet Switching)
  2. Data communication technology
  3. Transmission media (Twisted pair cable/coaxial cable/optical fibre)
  4. Computer Network LAN, MAN, WAN
  5. Network Devices (Modem/Connector/Router/Switch/Gateway)
  6. Network Topologies 
  7. Network Protocol 
  8. Mobile Telecommunication
  9. Network security concept
  10. Web services (WWW/HTML/XML/HTTP)

UNIT 3 Database management