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
0 Comments