Page 10 - Informatics_Practices_Fliipbook_Class12
P. 10
INFORMATICS PRACTICES CLASS-XII
[CODE-065]
1. Prerequisites
Informatics Practices – Class XI
2. Learning Outcomes
At the end of this course, students will be able to:
a. Create Series, Data frames and apply various operations.
b. Visualize data using relevant graphs.
c. Design SQL queries using aggregate functions.
d. Import/Export data between SQL database and Pandas.
e. Learn terminology related to networking and internet.
f. Identify internet security issues and configure browser settings.
g. Understand the impact of technology on society including gender and disability issues.
3. Distribution of Marks and Periods:
Unit Unit Name Marks Periods Periods Total
No. Theory Practical Periods
1. Data Handling using Pandas and Data Visualization 25 25 25 50
2. Database Query using SQL 25 20 17 37
3. Introduction to Computer Networks 10 12 - 12
4. Societal Impacts 10 14 - 14
Project - - 7 7
Practical 30 - - -
Total 100 71 49 120
4. Unit Wise Syllabus
Unit 1: 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;
Importing/Exporting Data between CSV files and Data Frames.
Data Visualization
Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram
Customizing plots: adding label, title, and legend in plots.
Unit 2: Database Query using SQL
Revision of database concepts and SQL commands covered in class XI
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 (*).
Querying and manipulating data using Group by, Having, Order by.
Working with two tables using equi-join
(viii)

