CBSE Class 12 Informatics Practices Core Syllabus 2020 2021. Students must always refer to the latest syllabus issued by CBSE before starting studies. Download the latest syllabus for 2020 2021 released by CBSE to plan your studies as per the latest syllabus and guidelines issued by CBSE NCERT. The syllabus, weightage of chapters, blue print of question papers and the design of question papers is issued every year for the benefit of students. Access and download syllabus for all subjects here.
Unit 1: Data Handling using Pandas and Data Visualization
Data Handling using Pandas -I
Introduction to Python libraries- Pandas, Matplotlib.
Data structures in Pandas - Series and Data Frames.
Series: Creation of Series from – ndarray, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection, Indexing and Slicing.
Data Frames: creation - from dictionary of Series, list of dictionaries, Text/CSV files; display; iteration;
Operations on rows and columns: add, select, delete, rename; Head and Tail functions; Indexing using Labels, Boolean Indexing; Joining, Merging and Concatenation.
Importing/Exporting Data between CSV files and Data Frames.
Data handling using Pandas – II
Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance.
DataFrame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting.
Handling missing values – dropping and filling.
Importing/Exporting Data between MySQL database and Pandas.
Data Visualization
Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram, pie chart, frequency polygon, box plot and scatter plot.
Customizing plots: color, style (dashed, dotted), width; adding label, title, and legend in plots.
Unit 2: Database Query using SQL
Math functions: POWER (), ROUND (), MOD ().
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (),LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).