Information Practices

0. Python Overview of Class XI (Not in Syllabus)

• Python Fundamentals
• Data Types & Operators
• List & Tuple
• Dictionaries
• Modules
• NumPy

1. Pandas Series : 05 Marks

• Introduction to Python libraries- Pandas
• Data structures in Pandas - Series and data frames.
• Series Creating Ways Via List, Dictionary, Arrays , and Scalar Values
• Series Attributes and Data Types
• Arithmetic and Relational operations on Series
• head and tail functions
• Indexing and slicing on Series
• Operation on Series
• Selection Record
• Adding Record
• Deleting Record
• Updating Record
• Extensive Live Programming Practice (Minimum 30 Programs)

2.Pandas DataFrame : 10 Marks

• Introduction to Data Frame
• Data Frame Creating Ways
• Data Frame attribute and Data Types
• Operation on rows(Select/add/Delete/Update/rename)
• Operation on Column (Select/add/Delete/Update/rename)
• Slicing DataFrame
• Deleting and Renaming Index
• Head and Tail functions
• indexing using labels
• Boolean indexing
• Iteration of Data Frame
• Descriptive Statistics: max, min, count, sum, mean, median, mode
• Importing/Exporting Data between CSV files and Data Frames.
• Extensive Live Programming Practice (Minimum 60 Programs)

3. Data Visualization 10 Marks

• Purpose of plotting
• Drawing, Customizing & saving of Line plots using Matplotlib
• Drawing, Customizing & saving of Bar Graph using Matplotlib
• Drawing, Customizing & saving of Histogram using Matplotlib
• Extensive Live Programming Practice (Minimum 30 Programs)
• Create a small project integrating all concepts covered up to this point.

1. Simple Queries in SQL

• Introduction to database concepts
• The relational model Terminology & Keys
• SHOW ,USE, & Desc Command
• SELECT ,FROM ,WHERE , & DISTINCT Command
• Column Alias using AS Command
• Operators in SQL
• Relational Operators
• Logical Operators
• Range Operators
• List Operators
• Like Operators
• Searching NULL Values
• Order by Clause

2. DDL & DML Commands

• SQL Data Types
• Creating Database & Tables
• SQL Constraints
• Inserting Record
• Updating Record
• Deleting Record
• Adding Column, Removing Column using Alter Command
• Removing Database & Table
• Extensive Live Query Practice (Minimum 45 Query)

3. SQL Functions

• Introduction to Function and It’s Type
• Single Row Function
• String Functions
• Numeric Functions
• Date and Time Functions
• Multirow Functions
• Group by and Having Clause
• What is Joining and understanding equi join
• Extensive Live Query Practice (Minimum 45 Query)

• Introduction to networks and Advantage & Disadvantage
• Types of network:PAN, LAN, MAN, WAN.
• Network Devices: modem, hub, switch, repeater, router, gateway
• Network Topologies: Star, Bus, Tree, Mesh.
• Introduction to Internet, URL, WWW and its applications- Web, email, Chat, VoIP.
• Introduction to website, difference between a website and webpage
• static vs dynamic web page
• web server and hosting of a website.
• Introduction to Web Browsers, commonly used browsers
• browser settings, add-ons and plug-ins, cookies.

• Digital footprint, net and communication etiquettes
• data protection, intellectual property rights (IPR), plagiarism, licensing and copyright
• free and open source software (FOSS)
• cybercrime and cyber laws, hacking, phishing, cyber bullying
• overview of Indian IT Act
• E-waste: hazards and management. Awareness about health concerns related to the usage of technology

• 1.Programs using Pandas and Matplotlib 08 Marks
• 2. SQL Queries: 07 Marks
• 3 Practical file: 05
• 4 Project Work: 05 Marks
• 5.Viva-Voce : 05 Marks

Aspernatur laborum N.