Class XII- IP_ Chapter wise Weightage
Marks Pandas Matplotlib SQL Network Societal
Impacts
One 4x1=4 - 6x1=6 3x1=3 5x1=5
mark
Two 3x2=6 - 2x2=4 1x2=2 1x2=2
Marks
Three 2x3=6 - 2x3=6 - 1x3=3
Marks
Four 1x4=4 - 1x4=4 - -
Marks
Five - 1x5=5 1x5=5 1x5=5 -
Marks
Total 20 5 25 10 10
Grand 70
Total
DO NOT CHANGE THE VARIABLE NAME IN THE SERIES/ DATAFRAME
Pandas Series
List and Series replication and multiplication (Vectorization)
DataFRame
To filter rows
Exam[‘Results’]=[“pass”,”fail”,..]
Exam[“bonusmark”]=[Link]*3/100
[Link][11]=[1,”xx”,”ip”,90,”20.9]
Print(exam[[“name”,”marks”,”Results”]])
Print(exam[[Link]>90])
Print(exam[exam[“marks”]>90][“name”])
[Link][5]=[“Folk tale”,“FT”,600]
Alternate method
To display multiple columns
To add a new column with same value
To add a new row with same value
To display specific row and column values
To remove column
To remove more than one column
To modify a value
To select rows
To select more than one rows
To rename column name (If the col. name does not exists,
will not raise error.)
DataFRame Attributes
Debug the code
Import pandas as pdf
df=[Link]({'a':1,'b':2,'a':1)
print(Df)
Corrected Code
import pandas as pd
df=[Link]({'a':1,'b':2,'a':1})
print(df)
Fill in blanks to get the following output
import ----------- as pd
import numpy as -----
Ser=pd.----------([11,22, [Link],77],[‘r1’,’r2’,’r3’,’r4’])
print(-------)
output
r2 22.0
r4 77.0
Answer:
pandas
npy
Series
[Link][[‘r2’,’r4’]]
While writing output, avg() function always return results in decimal even the
values are exactly divides each other.
Distinct with null
Like operator
Note: “Kumar” will display in all the combinations.
Now() and Sysdate() Difference
Now
NOW() returns a constant time that indicates the time at which
the statement began to execute.
SYSDATE () returns the time at which it execute.
SYSDATE() functions returns the current timestamp values.
Group by and Aggregate functions
Note: Will not raise error
Correct query
⓿ Draw TWO layouts (STAR/BUS) and choose the SHORTEST
DISTANCE layouts Points to
⓿ Need not be always STAR topology. REMEMBE
⓿ Give proper JUSTIFICATION for placing the server. R
⓿ LOCATION NAME (1/2 MARK) REASON-1/2 MARK
⓿ suggest SWITCH / HUB( is given)- WRITE switch REASON-
It filters traffic. Don’t write HUB.
⓿ Which hardware device will you suggest to connect all the
computers within locations …?
⓿ SWITCH / HUB
⓿ DO NOT CHANGE THE IMAGE MAP(POSITION) GIVEN IN
THE QUESTION.
⓿ WRITE TOTAL DISTANCE FOR THE PREFERRED LAYOUT.
⓿ FIRST MARK THE SHORTEST DISTANCE.
⓿ Suggest the best wired medium and draw the layout
⓿ OPTICAL FIBRE and then draw the layout.
⓿ Best WIRELESS medium – SATELLITE connection
⓿ Shared INTERNET access - ROUTER
⓿ As per the layout you drawn only
⓿ Suggest Repeater or other devices.
⓿ Don’t add repeater if it is not necessary.
⓿ Reason for Repeater – It regenerates the signal
Name the device. Points to
REMEMBE
The device that shares bandwidth. HUB R
The device that offers dedicated bandwidth.
SWITCH
The device that provides shared internet access.
ROUTER
The device that connects the systems in each block
HUB/ SWITCH
Which hardware device will you suggest to be
procured by the company to be installed to protect
and control the internet uses within the campus?
ROUTER / FIREWALL
The device that amplifies signal. REPEATER (70
METERS)
BETWEEN THE BLOCKS PLACE REPEATER, NOT
INSIDE THE BLOCKS.
LAN- WITHIN FEW KILOMETERS
MAN- UPTO 200 KMS. (CONNECTING BRANCHES OF
ORGANISATION)
WAN- AFTER 200 KMS
Definition:
Web Server, Web Page, Web hosting, Website, URL, Protocol
TCP/IP, Advantages of network, WWW, Home page, DNS,
Plugin/ Add ons, What is topology
Differences
1. Static and Dynamic webpage
2. Plugin and Add on
3. Internet and web.
4. Webserver and browser
5. URL and Domain name
6. Star and bus topologies
7. LAN and PAN
8. LAN and WAN
9. IP Address and MAC address.
10. TCP/IP and HTTP.
Societal Impact
1. Definitions of
Digital Footprint, Cyber bullying, Cyber crime
Net/ Communication/ Societal Etiquettes.
IPR and their violations- Copyright, Patent, Trademark.
Freeware/ FOSS/ Proprietary software- Examples.
Phishing, Identity theft
E-waste Management-
Causes- Learn all the chemicals and their side effects.
How to handle E-waste- 3R’s.
Health Hazards.
Differences:
1. Active and Passive digital footprints.
2. Hacker and Cracker
3. Plagiarism and Patent
4. Copyright and License
5. Cyber law
6. FOSS and Proprietary S/W