SYLLABUS Python for Class XII
Introduction to Computer Networks 6 Topics
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.
Data Handling using Pandas 9 Topics
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.
Importing/Exporting Data between CSV files and Data Frames.
Customizing plots: adding label, title, and legend in plots.
Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram.
Database Query using SQL 5 Topics
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.
Societal Impacts 5 Topics
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.
Data Handling 6 Topics
Create a panda’s series from a dictionary of values and a ndarray
Given a Series, print all the elements that are above the 75th percentile.
Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.
Create a data frame for examination result and display row labels, column labels data types of each column and the dimensions
Filter out rows based on different criteria such as duplicate rows.
Importing and exporting data between pandas and CSV file
Data Visualization 3 Topics
Given the school result data, analyses the performance of the students on different parameters, e.g subject wise or class wise.
For the Data frames created above, analyze, and plot appropriate charts with title and legend.
Take data of your interest from an open source (e.g. data.gov.in), aggregate and summarize it. Then plot it using different plotting functions of the Matplotlib library.
Data Management 7 Topics
Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
Insert the details of a new student in the above table.
Delete the details of a student in the above table.
Use the select command to get the details of the students with marks more than 80.
Find the min, max, sum, and average of the marks in a student marks table.
Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.
Write a SQL query to order the (student ID, marks) table in descending order of the marks
What you'll learn Python for Class XII
- 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.
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 51% Scholarship
-
Thursday 23-May-2024 -
Friday 24-May-2024 -
Monday 27-May-2024 -
Wednesday 29-May-2024
About Python for Class XII Course in
Python programming is powering the global job market because the benefits of Python are clear. Python is one of the top three programming languages in the world, and is poised to become the most popular, according to ZDNet. In fact, according to the PYPL Index, Python is the most popular programming language world-wide, so if you want to work in a different country, you have a good chance of landing a job in, say, Switzerland or Australia. Where would you like to work? Adding Python to your skill set could be your ticket to anywhere. Python is used in everything from machine learning to building websites and software testing. Python is used across a wide variety of industries. Of Course, the most common areas where Python language is used are for building mobile, web and desktop applications. Python is also used when testing these applications. It is used in creating recommendation algorithms, building software that controls self-driving cars, automates our everyday tasks, from web development to scripting, software testing, and prototyping. Below we have listed the different uses of Python.
Exam & Certification Python for Class XII
An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.
Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.
![ISPL Academy Certificate Sample](images/certificate03.jpg)
Frequently Asked Questions
What is the duration of course Python Language?
Python Language is a short term course of 3 months.
What is the fee of Python Language for Class XII?
The fee of course is Python Language for class XII Rs.11300/-
Where is ISPL Academy located?
ISPL Academy is located at Shanti Vihar, GMS Road, Dehradun, Uttarakhand INDIA and at Tilak Road, Dehradun.
Can I Pay my Fee in Installments?
Yes, you can pay your fee in easy monthly installments.