Informatics Practices

S.No.Name of UnitTopicVideo LinksPresentation/ document pdfAssessment questionsQuiz LinkMCQ questionsAny other material
1UNIT 1Unit 1: Data Handling using Pandas and Data Visualization
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.  		ClickClickClick  Click
   Click    Click
2UNIT 1Data 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.ClickClickClick ClickClick
   Click     
   Click     
   Click     
3UNIT 11.Importing/Exporting Data between
 CSV files and Data Frames.
2. Data handling using Pandas – II
Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance. 		ClickClickClickClick Click
   ClickClick   Click
   Click     
4UNIT 1DataFrame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting. Handling missing values – dropping and filling. Importing/Exporting Data between MySQL database and Pandas.ClickClickClick  Click
        Click
        Click
5UNIT 1Data 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. 		ClickClickClick  Click
     Click  Click
        Click
6UNIT 22: 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 (*). Querying and manipulating data using Group by, Having, Order by. Operations on Relations – Union, Intersection, Minus,  Cartesian Product,  JOIN 		ClickClickClick  Click
6UNIT 2 ClickClick   Click
   ClickClick   Click
    Click    
         
7UNIT 3Unit 3: Introduction to Computer Networks Introduction to networks, Types of network: LAN, MAN, WAN. Network Devices: modem, hub, switch, repeater, router, gateway Network Topologies: Star, Bus, Tree, Mesh. ClickClickClickClick Click
 UNIT 3Unit 3: Introduction to Computer Networks Introduction to networksClick    Click
8UNIT 3Introduction to Internet, URL, WWW and its applications- Web, email, Chat, VoIP.
 Website: Introduction, difference between a website and webpage, static vs dynamic web page, web server and hosting of a website. Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies.		ClickClickClick  Click
8UNIT 3Unit 3: Introduction to Computer Networks Introduction to networks  Click  Click
  Unit 3: Introduction to Computer Networks Introduction to networks     Click
9UNIT 4Unit 4: Societal Impacts Digital footprint, net and communication etiquettes, data protection, intellectual property rights (IPR), plagiarism, licensing and copyright, free and open source software (FOSS), ClickClick  Click
  Unit 4: Societal Impacts Digital footprint     Click
10UNIT 4cybercrime 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. ClickClick  Click
 UNIT 4Unit 4: Societal Impacts Digital footprint ClickClick   
11PRACTICAL LIST PRACTICAL PROGRAM LIST AS PER CURRICULUM Click   Click
12INVESTIGATORY PROJECT IDEASCLASS 12 IP PROJECT IDEAS Click   Click