INFORMATICS
PRACTICES - 065
PRACTICAL RECORD
2023-2024
SUBMITTED BY:
ARYAN PARMESHWAR LAL
INFORMATICS PRACTICES PRACTICAL RECORD 23-24
CBSE
PRACTICAL RECORD
2023 - 2024
Name: …ARYAN PARMESHWAR LAL…………………………………
Reg. No.:…………………………………………………………Grade ………………12-B…………………………….
Department Of Computer Science, CEHS Dubai
INFORMATICS PRACTICES PRACTICAL RECORD 23-24
CERTIFICATE
Grade……………12-B…………………………………..
Roll No. ………………………………………………
Certified to be the bonafide record of the work done
by
Master ……….ARYAN PARMESHWAR LAL
…………..in the School laboratory during the
academic year 2023- 2024
Teacher In charge Signature of the Principal
Submitted for the Practical Examination on …………..
… 20………. held in the Crescent English High School,
Dubai
Dubai 1. …………………………………
Department Of Computer Science, CEHS Dubai
INFORMATICS PRACTICES PRACTICAL RECORD 23-24
…………/………./20………. 2. …………………………………
Internal & External Examiners
INDEX
Page Sign. Of
Sl.no. Date Name of the experiments
no. teacher
PYTHON PROGRAMS
I Data Handling Using Pandas
1 02/03/2023 Series From A Dictionary And An Array
2 09/03/2023
Series Of Percentile And Print The Elements
16/04/2023 Dataframe Related To Sales And Find Out
3
The Total Expenditure
23/04/2023
4 Dataframe Related To E-Commerce Data And
Print Descriptive Statistics
30/04/2023
5 Dataframe And Display The Row And Column
Tables Along With Data Type And Shape.
6 6/05/2023
Filter Out Rows Based On A Criteria
13/05/2023
7 Display Sum Of The Column Or That The With
The Lowest Mean
8 20/05/2023 Locate 3 Largest Values In A Dataframe
27/05/2023
9 Subtract The Mean From The Elements Of A
Row In A Dataframe
10 04/06/2023
Dataframe Using Dictionary Of List
11/06/2023
11 Dataframe Using Dictionary Of List And Filter
The Data Based On A Criteria
12 18/06/2023
Demonstrate Iterrows And Iteritems
13 25/06/2023 Read And Display CSV Files
PYTHON PROGRAMS
II Data visualization Using Matplotlib
14 22/06/2023
Plot Line Chart
Department Of Computer Science, CEHS Dubai
INFORMATICS PRACTICES PRACTICAL RECORD 23-24
15 22/06/2023 Plot Bar Graph
24/06/2023 Plot Mu
16
ltiple Bar Graph
17 24/06/2023 Plot Histogram
INDEX
Page Sign. Of
Sl.no. Date Name of the experiments
no. teacher
SQL QUERIES
III
DDL & DML COMMANDS
1.1 19/10/2023 Create And Open Database
1.2 19/10/2023 Display System Date
1.3 19/10/2023 Display Name Of Month
1.4 19/10/2023 Display Power Of A Number
1.5 19/06/2023 Round Off A Number
20/10/2023
2.1 Create A Student Table With A Primary
Key
2.2 20/10/2023
Insert Details In The Above Table.
2.3 20/10/2023 Delete A Particular Data
2.4 20/10/2023
Using Select Command To Get The Data
2.5 20/10/2023 Using Where Clause To Get Data
2.6 20/10/2023 Using Aggregate Functions To Get The Data
2.7 20/10/2023
Using Order By To Get The Data
3.1 26/10/2023
Create A EMP Table With A Primary Key
3.2 26/10/2023
Insert Details In The Above Table.
3.3 26/10/2023
Display The Records Using Where Clause
3.4 26/10/2023
Display The Records Using Math Function
3.5 26/10/2023 Display The Records Using String Function
3.5 26/10/2023 Display The Records Using Order By
Department Of Computer Science, CEHS Dubai
INFORMATICS PRACTICES PRACTICAL RECORD 23-24
Clause
IV Networking & topologies
31/10/2023 IP configuration and topology of the system
Department Of Computer Science, CEHS Dubai
