KLiC Certificate in Informatics Practices - Class 12 CBSE (065)

Course Features:

Language: English
Duration: 60 hours
Learning Mode: Center
Jurisdiction: Maharashtra
Certificate of Completion

Topics Covered in the Course

Unit 01 : Querying and SQL Functions
Unit 02 : Data Handling using Pandas - I
Unit 03 : Data Handling using Pandas - II
Unit 04 : Plotting Data using Matplotlib
Unit 05 : Internet and Web
Unit 06 : Societal Impacts
Unit 07 : Project Based Learning

Learning Outcomes

At the end of this course, students will be able to:

Create Series, Data frames and apply various operations.
Visualize data using relevant graphs.
Design SQL queries using aggregate functions.
Import/Export data between SQL database and Pandas.
Learn terminology related to networking and internet.
Identify internet security issues and configure browser settings.
Understand the impact of technology on society including gender and disability issues.

Syllabus

Introduction
Functions in SQL
GROUP BY in SQL
Operations on Relations
Using Two Relations in a Query

Introduction to Python Libraries
Series
DataFrame
Importing and Exporting Data between CSV Files and DataFrames
Pandas Series Vs NumPy ndarray

Introduction
Descriptive Statistics
Data Aggregations
Sorting a DataFrame
Group by Functions
Altering the Index
Other DataFrame Operations
Handling Missing Values
Import and Export of Data between Pandas and MySQL

Introduction
Plotting using Matplotlib
Customisation of Plots
The Pandas Plot Function (Pandas Visualisation)

Introduction to Computer Networks
Types of Networks
Network Devices
Networking Topologies
The Internet
Applications of Internet
Website
Web Page
Web Server
Hosting of a Website
Browser

Introduction
Digital Footprints
Digital Society and Netizen
Data Protection
Creative Commons
Cyber Crime
Indian Information Technology Act (IT Act)
e-waste: Hazards and Management
Impact on Health

Introduction
Approaches for Solving Projects
Teamwork
Project Descriptions

Courses Fee Structure from 01 January, 2025

From 01 January 2025 onwards, the fees for all courses in ALCs of Mumbai Metropolitan Regional Development Authority (MMRDA), Pune Metropolitan Regional Development Authority (PMRDA) and rest of Maharashtra will be applicable as shown in the table below:

KLiC Courses of 60 Hours:

Region	Total Fee (Rupees)
MMRDA, PMRDA and Rest of Maharashtra	3000/-

Total fee is including of Course fees, Examination fees and Certification fees