Consulting services can provide valuable insights, strategic guidance, pecialized

1901 Shiloh, Hawaii 81063

Shopping cart

Subtotal $0.00

View cartCheckout

WELCOME TO NICE IT SERVICES

Class XII Information Practices Python

Enroll in our Courses Class XII Information Practices Python to gain hands-on experience.

4.8 out of 5 based on 30 reviews

Class XII Information Practices Python

The Class XII Information Practices (IP) Course with Python builds on previous knowledge to advance programming and data analytics skills. It covers data handling with Pandas for dataframes and advanced data visualization using Matplotlib and Seaborn. Students learn about file handling, structured query language (SQL) for database management, and connectivity between Python and databases.

Enquire Now

Contact Form Demo

Total 4 Units ( Click For Details )

UNIT 1 : DATA HANDLING USING PANDAS AND DATA VISUALIZATION => (25 MARKS)
1. 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.
2. Data Visualization
  • Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot,
  • bar graph,
  • histogram
  • Customizing plots: adding label, title, and legend in plots.
UNIT 2 : DATABASE QUERY USING SQL =>(25 MARKS)
1. Revision Of XI class MySQL
2. Math Functions

POWER (), ROUND (), MOD ().

3. Text Functions

UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (),LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().

4. Date Functions

NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().

5.Aggregate Functions

MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).

6. Querying And Manipulating Data Using Group By, Having, Order By.
UNIT 3 : INTRODUCTION TO COMPUTER NETWORKS=> (10 MARKS )
1. Introduction To networks, Types oF Network

LAN, MAN, WAN.

2. Network Devices

Modem, hub, switch, repeater, router, gateway

3. Network Topologies

Star, Bus, Tree, Mesh.

4. Introduction To Internet

URL, WWW, and its applications- Web, email, Chat, VoIP.

5. Website

Introduction, difference between a website and webpage, static vs dynamic web page, web server and hosting of a website.

6. Web Browsers

Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies.

UNIT 4 : SOCIETAL IMPACTS =>(10 MARKS )
  • 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.

Find The Right Course For You

Testimonials

Enquire Now

Contact Form Demo
Call Now Button