Exam Structure

The syllabus consists of four units: (i)┬аData Handling using Pandas and Data Visualization, (ii)┬аDatabase Query using SQL, (iii)┬аIntroduction to Computer Networks, and (iv)┬аSocietal Impacts.

Distribution of Marks

# Unit Name Marks
1 Data Handling using Pandas and Data┬аVisualization 30
2 Database Query using SQL 25
3 Introduction to Computer Networks 7
4 Societal Impacts 8
┬а Total 70

Unit 1: Data Handling using Pandas and Data Visualization

Data Handling using Pandas - I

Introduction to Python libraries - Pandas, Matplotlib.

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.

Data 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.

Importing/Exporting Data between CSV files and Data Frames.

Data handling using Pandas - II

Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance.

DataFrame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting.

Handling missing values┬а- dropping and filling.

Importing/Exporting Data between MySQL database and Pandas.

Data 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.

Unit 2: 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

Unit 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.

Introduction 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.

Unit 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), cybercrime 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

Syllabus for Class