Topics
Querying and SQL Functions
- Introduction of Database Query Using SQL
- Functions in SQL
- GROUP BY Clause in SQL
- Operations on Relations
- Using Two Relations in Query
Data Handling using Pandas - I
- Introduction to Python Libraries
- A Series
- DataFrame
- Importing and Exporting Data between CSV Files and DataFrames
- Pandas Series Vs NumPy ndarray
Data Handling using Pandas - II
- Introduction of Data Handling Using Pandas – II
- Descriptive Statistics
- Data Aggregations
- Sorting in Data Structure
- GROUP BY Functions
- Altering the Index
- Other DataFrame Operations
- Handling Missing Values
- Import and Export of Data between Pandas and MySQL
Plotting Data using Matplotlib
- Introduction of Plotting Data Using Matplotlib
- Plotting Using Matplotlib
- Customisation of Plots
- The Pandas Plot Function (Pandas Visualisation)
Internet and Web
- Concept of Computer Network
- Network Devices
- Networking Topologies
- Internet, Web and the Internet of Things
- Applications of Internet
- Key Concepts of Web Technology
- Website Hosting
- Browsers
Societal Impacts
- Introduction of Societal Impacts
- Digital Footprints
- Digital Society and Netizen
- Data Protection
- Software Licensing
- Creative Commons
- Cyber Crimes
- IT Act of India 2000
- E-waste: Hazards and Management
- Impact on Health
Project Based Learning
- Introduction of Project Based Learning
- Approaches for Solving Projects
- Teamwork
- Project Description
- Key Points: Cyber Crimes
Maharashtra State Board: Class 10
Key Points: Cyber Crimes
- Cyber crimes are illegal activities committed using computers, mobile phones, or the internet.
- Sharing personal and banking information like Aadhaar, PAN, card numbers, and PIN can lead to financial fraud.
- Hacking, online fraud, and piracy involve misuse of confidential data and digital content.
- Cyber harassment includes fake social media accounts, spreading false information, and exploiting individuals online.
- Cyber crimes are punishable under the IT Act, 2000, and are investigated by specialized cyber crime units.

