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

Evaluation Pattern

Evaluation Pattern of KLiC Creditized Courses consists of 4 Sections as per below table:

Section	Section Name	Total Marks	Passing Marks
Section 1	Learning Progression	35	14
Section 2	Continuous Comprehensive Assessment (Blue and Red Challenges)	35	14
Section 3	Final Examination - Credit End Test (Online)	30	12
Total Marks		100	40
Passing Criterion: Combined passing in Sections 1, 2 and 3 by scoring at least 40% marks.

Courses Fee Structure from 01 July, 2025 Onwards

KLiC 60 hour course fee applicable from 01 July, 2025 all over Maharashtra

KLiC Course Duration	MFO: MKCL Share (Including 18% GST)	ALC Share (Service Charges to be collected by ALC)
60 hours	Rs. 500/-	Rs. 2,500/-

Important Points:
* Above mentioned fee is applicable for all Modes of KLiC Courses offered at Authorised Learning Center (ALC) and at Satellite Center
* Total fee is including of Course fees, Examination fees and Certification fees
* MKCL reserves the right to modify the Fee anytime without any prior notice

KLiC Courses Fee Structure upto 30 June, 2025

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