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
