Wednesday, August 5, 2020


Class 12 (IP Subject Code - 065)

Class 11 (IP Subject Code - 065)


Pandas- Series and DataFrame Revised Notes 2022-23 

 

Basic Computer Organization

Pandas- Charts REVISED Notes 2022-23

 

Python Programming Basics Notes

stake     

DBMS and MySql Notes

 

Emerging Trends

parti 

Computer Network Notes

 

Relational Databases

 

Societal Impacts Notes

 

Simple Queries in SQL

quiz 

Practical File Programs

MySql Questions & Answers

Python Functions

 

Table Creation and Data Manipulation commands

PRA 

XII CBSE Syllabus IP Revised 2022-23

 


 

Sample Paper Class 12 IP

 


 

Project Layout Files

 

Python Function

 

Project Format

 

 

 

Project Data

 

MySQL Sample Exam Question & Answer

 

Python Pip Commands

 

XI CBSE Syllabus IP Revised 2022-23

 

Python Project

 

Class 11 Book Revision Questions Page No

 

IP Sample Practical Paper

 

Class 11 Sample Practical Programs

 

 

 

NCERT Class 11 IP PDF E - BOOK 2022-23

 

download pythonpython 3.7.4 for 32 bit machine

 


 

Python installation guidelines

 


 

NCERT Class 12 IP PDF  E-Book 2022-23

 

 

 

 

 

 

 

 

 

 


 Class 10 (IT Subject Code - 402)

Class 9 (IT Subject Code - 402)

 

 ch-6 Fundamentals of computer 1

 

 ch-6 Fundamentals of computer 1

 

 ch-6 Fundamentals of computer 2

 

 ch-6 Fundamentals of computer 2

 

 ch-6 Fundamentals of computer 3

 

 ch-6 Fundamentals of computer 3

 

 ch-7 Word Processing 4

 

 ch-6 Fundamentals of computer 4

 

 ch-7 Word Processing 5

 

 ch-6 Fundamentals of computer 5

 

 ch-7 Word Processing 6

 

 ch-6 Fundamentals of computer 6

 

 ch-8 Spread sheets application 7

 

 ch-7 Mastering Typing 7

 

 ch-8 Spread sheets application 8

 

 ch-7 Mastering Typing 8

 

 ch-8 Spread sheets application 9

 

 ch-8 Word Processing Basic 9

 

 ch-9 Digital Presentation application 10

 

 ch-8 Word Processing Basic 10

 

 ch-9 Digital Presentation application 11

 

 ch-8 Word Processing Basic 11

 

 ch-9 Digital Presentation application 12

 

 ch-8 Word Processing Basic 12

 

 ch-10 Email Messaging application 13

 

 ch-9 Spreadsheet Basic 13 

 

 ch-10 Email Messaging application 14

 

 ch-9 Spreadsheet Basic 14  

 

 ch-10 Email Messaging application 15

 

 ch-9 Spreadsheet Basic 15

 

ch-11 Database Development (BASIC) 16

 

 

 

ch-11 Database Development (BASIC) 17 

 

 

 

 

 

 

 

sql script 

 

 

 

402- CBSE IT Sample Question Paper

 

 



SNO

DATE WISE

ONLINE VIDEO ADDRESS ON YouTube

ASSIGNMENTS

1

20-04-2020

Dataframe creation with  basic operation

Dataframe assignment 5

2

23-04-2020

DataFrame Access and Arithmetic Operation

Dataframe assignment 6

3

26-04-2020

Series Creation and Indexing

Series assignment 7

4

29-04-2020

DataFrame Creation of Various Concept

DataFrame assignment 8

5

02-05-2020

DataFrame Change operation- add, drop and rename

DataFrame assignment 9

6

22-05-2020

DataFrame Joining

DataFrame assignment 10

7

25-05-2020

DataFrame - Boolean Index, Import and Export

DataFrame assignment 11

8

28-05-2020

DataFrame - Handling NaN, various index methods

DataFrame assignment 12

9

01-06-2020

DataFrame - Sorting and Pivoting

DataFrame assignment 13

10

04-06-2020

DataFrame - Pivoting and Grouping

DataFrame assignment 14

11

08-06-2020

DataFrame - Grouping and sub grouping

DataFrame assignment 15

12

11-06-2020

DataFrame - Import and Export- mysql and dataframe

DataFrame assignment 16

13

15-06-2020

DataFrame - quantile method

DataFrame assignment 17

14

18-06-2020

DataFrame - quantile and each value accessing

DataFrame assignment 18

15

22-06-2020

DataFrame - loc and iloc comparison

DataFrame assignment 19

16

25-06-2020

DataFrame - loc and iloc slice operation

DataFrame assignment 20

17

29-06-2020

Dataframe Slicing, Statistical Operation, Transpose

DataFrame assignment 21

18

02-07-2020

Pandas Chart Introduction and Line chart

Chart assignment 22

19

06-07-2020

Pandas Bar and Pie Chart

Chart assignment 23

20

09-07-2020

Pandas Boxplot and Histogram

Chart assignment 24

21

13-07-2020

Pandas Histogram and Scatter Chart

Chart assignment 25

22

16-07-2020

Pandas xlim, ylim, xticks, yticks methods

Chart assignment 26

23

20-07-2020

DBMS Introduction

MySql assignment 27

24

23-07-2020

MySql Commands

MySql assignment 28

25

27-07-2020

MySqlSelect commands clauses

MySql assignment 29

26

30-07-2020

MySqlMethods

MySql assignment 30

27

06-08-2020

MySql creation, constraints, insert, update commands

MySql assignment 31

28

07-08-2020

MySql describe, alter, delete, drop, join 

MySql assignment 32

29

08-08-2020

MySql groupby, having, other commands

MySql assignment 33

30

10-08-2020

Computer network, types, devices, layout

Computer Network assignment 34

31

14-08-2020

Internet, URL, WWW,  Web, email 

Computer Network assignment 35

32

17-08-2020

Chat, VoIP, Web site, Web page, static and dynamic 

Computer Network assignment 36

33

18-08-2020

Web server, hosting, addons, plugins

Computer Network assignment 37

34

20-08-2020

Computer Networks- Cookies, browser settings

Computer Network assignment 38 

35

21-08-2020

Societal impacts digital footprints, Netiquette, IPR

Societal impacts assignment 39  

36

24-08-2020

Plagiarism, Software license, Copyrights, Software Types

Societal impacts assignment 40

37

25-08-2020

Hacking, Phishing, Cyber Bullying

Societal impacts assignment 41

38

27-08-2020

Cyber law, IT Act, e-waste, Awareness 

Societal impacts assignment 42

39

28-08-2020

Class 12 syllabus revised 2020

Societal impacts assignment 43

40

31-08-2020

Pandas Series Practical - List, Scalar, Array, Dict 

Series Practical assignment 44

41

01-09-2020

Pandas Series Label, Default, Loc, iloc 

Series Practical assignment 45 

42

03-09-2020

Pandas Series Basic details size,shape,sum,min etc 

Series Practical assignment 46 

43

04-09-2020

Pandas Series Practical - Arithmetic Operation 

Series Practical assignment 47  

44

07-09-2020

Pandas Series Slicing Practical - using loc, iloc

Series Practical assignment 48 

45

08-09-2020

Pandas Series Practical - using head and tail method

Series Practical assignment 49  

46

10-09-2020 

DataFrame Creation-using a list inside sub lists, a dictionary of lists 

DataFrame Practical assignment 50

47

11-09-2020 

DataFrame Creation-using a list of dictionaries , CSV file 

DataFrame Pract. assignment 51

48

12-09-2020 

DataFrame Basic Details- Dimension, Size, Shape, sum, max, min etc. 

DataFrame Pract. assignment 52 

49

14-09-2020 

Pandas DataFrame Access-rows, columns and values p

DataFrame Pract. assignment 53 

50

 

 

 

51

 

 

 

52

 

 

 

53

 

 

 

54

 

 

 

55