CBSE CS and IP

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

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


4 comments:

  1. hi,sir your videos give a good explanation currently i am in class 12 your videos are helping me so much as this lockdown is there and our schools are not open yet your videos help so much,keep the great work doing,love from uttarakhand :)

    ReplyDelete
  2. hey sir you are doing very great but please uplades notes of last 2 unit of XII-IP fast

    ReplyDelete
  3. You can purchase notes from https://www.cbsecsip.in/2021/01/xii-ip-crash-course-ebook-pdf.html

    ReplyDelete