INFORMATICS PRACTICES || CLASS 12 || NOTES|| AMRESH ACADEMY

 

---

INFORMATICS PRACTICES - Course Content

---

Chapter 1: Querying and SQL Functions

• 1.1 Introduction
• 1.2 Functions in SQL
• 1.3 GROUP BY in SQL
• 1.4 Operations on Relations
• 1.5 Using Two Relations in a Query

---

Chapter 2: Data Handling using Pandas - I

• 2.1 Introduction to Python Libraries
• 2.2 Series
• 2.3 DataFrame
• 2.4 Importing and Exporting Data between CSV Files and DataFrames
• 2.5 Pandas Series Vs NumPy ndarray

---

Chapter 3: Data Handling using Pandas - II

• 3.1 Introduction
• 3.2 Descriptive Statistics
• 3.3 Data Aggregations
• 3.4 Sorting a DataFrame
• 3.5 Group by Functions
• 3.6 Altering the Index
• 3.7 Other DataFrame Operations
• 3.8 Handling Missing Values
• 3.9 Import and Export of Data between Pandas and MySQL

---

Chapter 4: Plotting Data using Matplotlib

• 4.1 Introduction
• 4.2 Plotting using Matplotlib
• 4.3 Customisation of Plots
• 4.4 The Pandas Plot Function (Pandas Visualisation)

---

Chapter 5: Internet and Web

• 5.1 Introduction to Computer Networks
• 5.2 Types of Networks
• 5.3 Network Devices
• 5.4 Networking Topologies
• 5.5 The Internet
• 5.6 Applications of Internet
• 5.7 Website
• 5.8 Web Page
• 5.9 Web Server
• 5.10 Hosting of a Website
• 5.11 Browser

---

Chapter 6: Societal Impacts

• 6.1 Introduction
• 6.2 Digital Footprints
• 6.3 Digital Society and Netizen Responsibilities
• 6.4 Data Protection
• 6.5 Creative Commons
• 6.6 Cyber Crime
• 6.7 Indian Information Technology Act (IT Act)
• 6.8 E-waste: Hazards and Management
• 6.9 Impact on Health

---

Chapter 7: Project Based Learning

• 7.1 Introduction
• 7.2 Approaches for Solving Projects
• 7.3 Teamwork
• 7.4 Project Descriptions

---