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

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.

Certificate

MKCL provides certificate (for 30/60/90 hours courses) to the KLiC learner after his/her successful course completion.

Academic Approach

The Academic Approach of the course focuses on the “work centric” education i.e. begin with work (and not from a book !), derive knowledge from work and apply that knowledge to make the work more wholesome, useful and delightful. The ultimate objective is to empower the Learner to engage in socially useful and productive work. It aims at leading the learner to his/her rewarding career as well as development of the society.

Learning methodology

Learners are given an overview of the course and its connection to life and work.
Learners are then exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
Learners are then acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
Learners are then acquainted with the architecture of the tool or Tool Map so as to appreciate various parts of the tool, their functions and their inter-relations.
Learners are then exposed to simple application development methodology by using the tool at the beginner’s level
Learners then perform the differential skills related to the use of the tool to improve the given ready-made outputs.
Learners are then engaged in appreciation of real-life case studies developed by the experts.
Learners are then encouraged to proceed from appreciation to imitation of the experts.
After imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression.

Evaluation Pattern

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

Section No.	Section Name	Total Marks	Minimum Passing Marks
1	Learning Progression	25	10
2	Internal Assessment	25	10
3	Final Online Examination	50	20
	Total	100	40
4	SUPWs (Socially Useful and Productive Work in form of Assignments)	5 Assignments	2 Assignments to be Completed & Uploaded

MKCL’s KLiC Certificate will be provided to the learner who will satisfy the below criteria:

Learners who have successfully completed above mentioned 3 Sections i.e. Section 1, Section 2 and Section 3
Additionally, learner should have completed Section 4 (i.e. Section 4 will comprise of SUPWs i.e. Socially Useful and Productive Work in form of Assignments)
- Learner has to complete and upload minimum 2 out of 5 Assignments

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/-

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