Revision Notes IT CODE 402 Class 10.pdf

Notes for class 10 students for IT revision. Designed for CBSE students.

1. www.crackmycbse.com
CBSE CLASS 10 Board Exam
Unit 4: Web Application And
Security
Final Revision Notes
IT CODE 402
www.crackmycbse.com

2. Accessibility refers to the user friendliness of a computersystem for
all, regardless of their disability., it enables a person witha disability
or impairment to use a computer.
LAUNCHING ACCESSIBILITY OPTIONS
• To launch accessibility options in WindowsXP, Click Start >Control
Panel > Accessibility Options.
SESSION 1: WORKING WITH ACCESSIBILITY OPTIONS

3. KEYBOARD TAB
Sticky Keys
allows modifier keys like Ctrl and Shift to remain active even when you're not
pressing them.
FilterKeys
tells the keyboard to ignore brief or repeated keystrokes, making typing easier
for people with hand tremors.
ToggleKeys
Atoggle keyis a key that is used to turn a function on or off, or to switch
between two functions.
Display Tab
High Contrast: n change the size and color of fonts and the background
Cursor Options :changing the blink rate and width of the cursor.

4. Sound Tab
ShowSounds
ShowSoundsinstructs applications that convey information by sound,to also
provide information visually, through text captions orinformative icons.
SoundSentry
SoundSentrygenerates visual warnings, such as a blinking title bar or a flashing
border, whenever the computer generates a sound.
Mouse Tab
MouseKeys :This option uses the keyboard (especially numeric keypad) as a
pointing device instead of a mouse.
General Tab
Serial Keys: special devices such as Sip, Puff and Breath Switches to provide
input to the computer through Serial Ports.

5. A computer network is a collection of computers and other hardware
components interconnected by communication channels (cables or
satellites) that allow sharing of resources and information
PEER-TO-PEER (P2P) ARCHITECTURE: Networks in which all computers have
an equal status are called peer to peer networks. Generally in such a network
each terminal has an equally competent CPU.
CLIENT-SERVER ARCHITECTURE: Networks in which certain computers have
special dedicated tasks, providing services to other computers (in the network)
are called client server networks.
SESSION 2 : NETWORKING FUNDAMENTALS

6. •LAN(LocalAreaNetwork):smallareasuchasbuilding,office.
•PAN(PersonalAreaNetwork):networkarrangedwithinanindividualperson,
typicallywithinarangeof10meters.
•MAN(MetropolitanAreaNetwork):coversalargergeographicareaby
interconnectingadifferentLAN
•WAN(WideAreaNetwork):overalargegeographicalareasuchasstatesor
countries.

7. INTERNET
The Internet is a global system of interconnected computer
networksthat use the standard Internet protocol suite to serve
billions ofusers worldwide.
WORLD WIDE WEB
World Wide Web (abbreviated as WWW or W3, commonly
knownas the Web), is a system of interlinked hypertext
documentsaccessed via the Internet. With a web browser, one
can view webpages that may contain text, images, videos, and
other multimedia

8. Advantagesof Internet

9. GETTING ACCESS TO THE INTERNET
To use the Internet, you need an Internet connection. Internetconnections are provided by Internet Service
Providers
INTERNET SERVICE PROVIDER
An Internet service provider (ISP) is an organization which providesyou with access to the Internet via a dial-up
(using modem) ordirect (hard wired) or wireless connection.
MODEM
Á modem is a device that converts digital computer signals into aform (analog signals) that can travel over
phone lines. It also re converts the analog signals back into digital signals. The wordmodem is derived from its
function MOdulator/DEModulator.

10. Dial-up: the facilities of the public switched telephone network (PSTN) to establish
a connection
(ISP) via telephone lines using a device called MODEM.
DSL: Digital subscriber line(DSL) provide Internet access by transmitting digital
data over wires of a local telephone network.
Cable Internet Access: Cable Internet Access is a form of broadband Internet
access that uses the cable television infrastructure.
3G: 3G, short for 3rd Generation is a set of standards used for mobile devices and
mobile telecommunication services and networks
WiMAX: WiMAX (Worldwide Interoperability for Microwave Access) is a wireless
communications standard designed to provide mobile broadband connectivity
across cities and countries
WI-Fi: Wi-Fi is a popular technology that allows an electronic device such as
computers or mobile phones to exchange data wirelessly over a network

11. DATA TRANSFER ON THE INTERNET
∙ The data is broken up into bits of same sized pieces called packets.
∙ A header is added to each packet explaining where the data hascome from,
where it should end up and where it fits in with therest of the packets.
∙ Each packet is sent from computer to computer until it finds itsdestination. All
packets may not take the same route. ∙ At the destination, the packets are
examined. If any packets aremissing or damaged, a message is sent asking for
them to beresent. This continues until all packets have been received intact.
∙ The packets are now reassembled into their original form. All thisdone in
seconds!

12. Instant messaging (IM) is a form of communication over the
Internetthat offers an instantaneous transmission of text-based
messagesfrom sender to receiver. Most instant messaging
software include theoption for performing file transfers, audio chat,
video calling andconferencing, sharing desktops, etc.
Key Features of an instant messaging are as follows:
• Text Messages can be sent to one or more person (Similar
toSMS)
• Audio calling and conferencing.
• Video calling and conferencing.
• File transfers (Not limited to documents, spread sheets,
audiofiles, video files, etc.)
• Message history (Save messages for future reference).
SESSION 3: INTRODUCTION TO INSTANT MESSAGING

13. INSTANT MESSAGING SERVICES
1) Application Based:-These software are downloaded andinstalled on user’s
computer. Eg.Google Talk , Yahoo!Messenger , Skype , Window Live Messenger ,
Rediff Bol etc.
2) Web Based:-They are accessed using browsers such asInternet Explorer etc.
Eg.MSN Web Messenger , Yahoo!Messenger for the Web , Meebo, IMO etc.

14. general rules and etiquettes to be followed whilechatting.
•Messages should be short and to the point.
• Always introduce yourself by name if your screen name doesn’treflect
it.
• Always ask if the other person has time to chat first
-Give people time to respond –
SESSION 4: CHATTING WITH A CONTACT –GOOGLE TALK

15. WEB PAGES –BLOG
A blog is a discussion style site used by users forcreating personal web pages.
Blog is similar to an online personaldiary and similar to use. A blog is used to
convey messages,events, news, announcements etc.
Blogs are usually managed through web browser which needs aninternet
connection.
Examples of Websites that offer blog services:-
www.blogger.com
www.wordpress.com
www.weebly.com
www.blog.com
SESSION 5: CREATING AND PUBLISHING WEB PAGES –BLOG

16. general rules and etiquettes to be followed whilechatting.
•Messages should be short and to the point.
• Always introduce yourself by name if your screen name doesn’treflect
it.
• Always ask if the other person has time to chat first
-Give people time to respond –
SESSION 5: CREATING AND PUBLISHING WEB PAGES –BLOG

17. If you do not have an active internet connection, you can
createblogs using a blog application and publish the blog
wheneverinternet connectivity is available.
-Qumana
-Windows Live Writer
-Blogdesk
-BlogJet
-Ecto
SESSION 6: USING OFFLINE BLOG EDITORS

18. The transactions over the internet are called Online Transactions
Examples
1) For Buying Goods :-amazon, jabong, myntra, flipkart, ebayetc.
2) For Booking of Tickets :-IRCTC , Redbusetc.
3) For Payment of School Fee :-
Payments tools to use Online transaction
For completing an online transaction we must need:-1) Valid Debit Card
2) Valid Credit Card
3) Net Banking Subscription
SESSION 7: ONLINE TRANSACTIONS

19. Objectives of Internet Security
The main objective of internet security is to establish rules andmeasures to use
against attacks over the internet.
Online Threats
The threats / vulnerabilities that uses World Wide Web (Internet)to facilitate crimes
are called Online Threats.
1) Phishing
2) Email spoofing
3) Chat Spoofing:-
SESSION 8: INTERNET SECURITY

20. Best practices for security over Internet
1. Use strong passwords: A combination of alphanumeric andspecial characters
could be used for creating a password thatis not so easy to crack or guessed by
other users
2. Backup your data:
4. Keep username and password private:
5. Registering with website:
6. Do not share personal information:
7. Secure transactions:
8. Use Antivirus and antispyware software:
9. Do not immediately respond to mails from unknown users:
10. Install firewalls:
11. Regularly update your operating system and softwareapplications.

21. Basic Fire safety rules in an organization are :
-Fire escape plans must be installed at proper levels -Conduct regular drills
-Maintenance of safety equipment must be taken care ofregularly
Falls and Slips Safety rules
-Workplace must be proper ventilated
-Floors must be clean and dry
-Oil spills, dust must be immediately cleaned.
Electrical safety rules:
-Electrical equipment approved by a recognisedorganization. -Take care that the
outlets/ circuits should not be overloaded
SESSION 9 : Maintain workplace safety

22. Accident: an accident is an unplanned event that may happen all ofa
sudden and may lead to unwanted or unprecedentedresults/outcomes.
Handling accidents:
-Safety measures must be placed to prevent workplaceaccidents
-Immediately call the medical team for any injury -Stay alert
-Pay attention to and follow emergency drills
Session 10 : Prevent Accidents and Emergencies

23. The workstation should:
●provide sufficient space for the user to alter positioncomfortably
●provide adequate lighting
The display screen should:
●display well-defined characters of adequate size and spacing ●have
easily adjustable brightness and contrast
The keyboard should:
●be able to tilt easily and should be able to separate from thescreen to
allow the user to adopt a comfortable workingposition
The work surface should:
●provide adequate space for the user
●be of an adequate size to allow the screen, keyboard
Session 11: Protect Health and Safety at work

24. Workplace Evacuation
In case of emergency there should be provision for
evacuation.Evacuation is the process of emptying a place in case of
anemergency, disaster.
An evacuation policy : Every organization must have anevacuation
policy.
Organization must have a designated assembly point foremergencies
Periodic evacuation drills should be conducted.
Healthy Living
-healthy eating habits
-physical activities
-stress management
-healthy mind
-sound sleep

25. PLATINUM CLASSES
www.crackmycbse.com
Learn Simple| Learn Easy
For more visit to www.crackmycbse.com

26. www.crackmycbse.com
CBSE CLASS 10 Board Exam
Unit 3: Database Management
System
Final Revision Notes
IT CODE 402
www.crackmycbse.com

27. What is Database?
Adatabaseis an organized collection of data, so that it can be easily accessed and
managed.
You can organize data into tables, rows, columns, and index it to make it
easier to find relevant information.
Database Management System (DBMS)
A database management system is a software package with computer
programs that controls the creation, maintenance and use of a database. A
DBMS allows different user application programs to concurrently access the
same database. Some of the DBMSs are Oracle, IBM DB2, Microsoft SQL
server, Microsoft Access, PostgreSQL, MySQL,

28. What is Database Server?
Database servers are Computers usedto store and manage databases
that are stored on the server and to provide data access for
authorized users. This type of server keeps the data in a central
location that can be regularly backed up.
Database Management System (DBMS)
A database management system is a software package with computer
programs that controls the creation, maintenance and use of a database.
A DBMS allows different user application programs to concurrently
access the same database. Some of the DBMSs are Oracle, IBM DB2,
Microsoft SQL server, Microsoft AccessMySQL,

29. Data can be organized into two types:-
Flat File: Data is stored in a single table. Usually suitable for
less amount of data.
Relational: Data is stored in multiple tables and the tables are
linked using a common field. Relational is suitable for medium to
large amount of data.
RDBMS:-A relational database management system (RDBMS) is
adatabase management system that is based on the
relationalmodel. In the relational model of a database, all data
isrepresented in terms of tuples (rows), grouped into
relations(tables). A database organized in terms the relational model
is arelational database.

30. Advantages of Database/ DBMS
Reduces Data Redundancy : no chance of encountering duplicatedata
Sharing of Data : the users of the database can share the dataamong
themselves
Data Integrity : Data integrity means that the data is accurate andconsistent in
the database
Data Security : Only authorisedusers are allowed to access thedatabase and
their identity is authenticated using a username andpassword
Privacy : The privacy rule in a database states that only theauthorized users can
access a database according to its privacyconstraints
Backup and Recovery : Database Management Systemautomatically takes
care of backup and recovery.

31. Database Concepts:-
TABLE :-A table is a set of data elements that is organizedusing a model of vertical columns and
horizontal rows. Each rowis identified by a unique key index or the key field.
COLUMNS OR FIELD :-A column is a set of data values of aparticular simple type, one for each row of
the table. For eg.Emp_No, E_Name, Profile etc.
ROWS OR RECORDS OR TUPLES : -A row represents a single,data items in a table. Each row in a
table represents a set ofrelated data, and every row in the table has the same structure.

32. Database Concepts:-
Item : -Item is about which information is stored in the database.
Value:-Value is the actual text or numerical amount or datethat you put in while
adding information to your database.
Key Field :-Key Field is a value in a Field that uniquely. Ex-Emp_No

33. PRIMARYKEY:-Aprimarykeyisauniquevaluethatidentifiesarowinatable.
Thesekeysarealsoindexedinthedatabase,makingitfasterforthedatabaseto
searcharecord.
FOREIGNKEY:-AFOREIGNKEYisafield(orcollectionoffields)inonetable,
thatreferstothePRIMARYKEYinanothertable.
Note:-The“one”sideofarelationisalwaystheparent,andprovidesthe
PK(PrimaryKey)Attributestobecopied.The“many”sideofarelationisalways
thechild,intowhichtheFK(ForeignKey)attributesarecopied.
Memorize it : one, parent, PK (Primary Key) ; many, child , FK(Foreign
Key)

34. DATA TYPES :-Datatypes are used to identify the type
of datawe are going to store in the database.
Categories of data types:-Data types can be broadly
classifiedinto five categories:-
1.Numeric Types-Numbers
2.Alphanumeric Types-Alphabet and Numbers
3.Binary Types-Photo, Music
4.Date Time-Date and Time
5.Other variable Types –Java objects etc

35. Numeric Data Type

36. Common DDL Statements are:-
1. Create :-Used to create database objects.
2. Alter :-Used to modify database objects.
3. Drop :-Used to delete database objects.
DATA MANIPULATION LANGUAGE (DML): -It is a standard forcommands that enables users to access and
manipulate data in adatabase.
Common DML Statements are:-
1. SELECT :-Used for retrieval of information from the database.
2. INSERT :-Used for insertion of new information into the database.
3. DELETE :-Used for deletion of information in the database.
4. UPDATE :-Used for modification of information in the database.
DATA DEFINITION / DESCRIPTION LANGUAGE: -It is a standard for commands that define the
different structures in a database. DDL statements create,modifyand remove database objects such as
tables, indexes and users.
There are two types of languages:-

37. SELECT Emp_no, E_nameFROM t; Query data in columns c1, c2 from a table
SELECT * FROM EMPLOYEE; Query all rows and columns from a table
SELECT Emp_no, Profile FROM EMPLOYEE WHERE Profile = ‘CLERK’; Query data and filter rows with a
condition
SELECT Emp_no, E_nameFROM EMPLOYEE ORDER BY EMP_noASC;
SELECT Emp_no, E_nameFROM EMPLOYEE ORDER BY EMP_noDESC;
SELECT * FROM EMPLOYEE WHERE Profile = ‘CLERK’ ORDER BY EMP_noDESC;
TABLE EMPLOYEE
SQL COMMANDS

38. CREATE TABLE EMPLOYEE (
Emp_noINT,
E_nameVARCHAR,
);
DROP TABLE EMPLOYEE ; Delete the table from the database
UPDATE EMPLOYEE SET Profile = Manager WHERE Emp_no= 8369;
ALTER TABLE EMPLOYEE ADD COLUMN HRA; Add a new column to the table
ALTER TABLE EMPLOYEE DROP COLUMN Salary ; Drop column c from the table
TABLE EMPLOYEE
SQL COMMANDS

39. PLATINUM CLASSES
www.crackmycbse.com
Learn Simple| Learn Easy
For more visit to www.crackmycbse.com

40. www.crackmycbse.com
CBSE CLASS 10 Term 2 Board Exam
Unit 3: Database Management System
Most Importat4 Marks Questions
IT CODE 402
Table Type (SQL Command)

47. PLATINUM CLASSES
www.crackmycbse.com
Learn Simple| Learn Easy
For more visit to www.crackmycbse.com

48. www.crackmycbse.com
CBSE CLASS 10 Board Exam
Unit 4: Entrepreneurial Skills
Final Revision Notes
Employability Skills
www.crackmycbse.com

49. Entrepreneurship is the type of self-employment where one is running a
business to satisfy the needs of people and looking for ways to make the
business better to make profits.
Successful entrepreneurs have the following qualities
•They are confident.
•They believe in themselves and their abilities.
•They keep trying new ideas in their business.
•They are patient.
•They are creative and think differently about business ideas.
•They take responsibility for their actions.
•They take decisions after thinking about them.
•They work hard.
•They do not give up when they face a difficulty.
Session 1: Entrepreneurship and Society

50. What do entrepreneurs do when they runtheir business?
Fulfil Customer Needs
Demand means a product or service that people want.Entrepreneurs find out what
people want. Then, theyuse their creativity to come up with a business idea that
will meet that demand.
Use Local Materials
Entrepreneurs use the material and people availablearound them, to make products at
low cost.
Help Society
Entrepreneurs have a positive relationship with society.They make profits through
activities that benefitsociety. Some entrepreneurs work towards saving theenvironment,
some give money to build schools andhospitals. This way, the people and area around
thembecomes better.

51. Create Jobs
With the growth of a business, entrepreneurs look formore people to help them.
They buy more material, andfrom more people. The also hire more people to work
for
them. In this way, more people have jobs.Sharing of WealthWealthmeans having
enough money to live a comfortablelife. As entrepreneurs grow their business, the
people
Lower Price of Products
As more entrepreneurs sell the same product, the priceof the product goes down.
For example, when moremobile phones were getting sold in India, the cost of the
phone became lesser.

52. Session 2: Qualities and Functions of an Entrepreneur

53. Session 2: Qualities and Functions of an Entrepreneur

55. Misconceptions
1. The misconception is that every business idea needs to be unique or
special.
2. The misconception we have is that a person needs a lot of money to start
a business.
3. A misconception we have is that only a personhaving a big business is
an entrepreneur.
4.A misconception we have is that entrepreneurs are born, not made.
Session 3: Myths about Entrepreneurship

56. Wage Employed: Wage employed people are people who work for a
person or an organization and get paid for that work.
Self-employed: Self-employed people are those who start businesses to
satisfy the needs of people.
A selfemployedperson who is always trying to make his/her business
better by taking risks and trying new ideas is an entrepreneur.
Session 4: Entrepreneurship as a Career Option

57. A person who becomes an entrepreneur goes througha career process. This
process is as follows:

58. PLATINUM CLASSES
www.crackmycbse.com
Learn Simple| Learn Easy
For more visit to www.crackmycbse.com

59. www.crackmycbse.com
CBSE CLASS 10 Board Exam
Unit 5: Green Skills
Final Revision Notes
Employability Skills
www.crackmycbse.com

60. What is Sustainable Development?
Sustainable development is the development thatsatisfies the needs of the present
without compromisingthe capacity of future generations, guaranteeingthe balance
between economic growth, care for theenvironment and social well-being.
Session 1: Sustainable Development
Importance of Sustainable Development Economic development is using up
resources of the world so quickly that our future generations, the young people
of the world, would have serious environmental problems, much worse than
those that we are facing at present. With increasing population and income, the
consumption of goods is increasing day by day. This has led to increase in
production and utilisationof natural resources, which are required for
producing goods.

61. Problems Related to Sustainable Development
(a) Food:The amount of rich, fertile land needed togrow crops, such as
wheat, rice, etc., is becomingless as we are using up more and more land
forother purposes
(b) Water:We use fresh water from rivers and pondsfor drinking and
cleaning but dump garbage intothem. The rivers and ponds are getting
polluted..
(c) Fuel:We are using a lot of wood from trees asfuels and for construction
of homes and furniture.As more and more trees are being cut, it isaffecting
the climate of the place.

62. Sustainable development includes
• reducing excessive use of resources and enhancingresource
conservation;
• recycling and reuse of waste materials;
• scientific management of renewable resources,especially bio-resources;
• planting more trees;green grassy patches and trees to be
interspersedbetween concrete buildings;
• using more environment friendly material orbiodegradable material and
• use of technologies, which are environmentalfriendly and based on
efficient use of resources.

63. The Sustainable Development Goals
The Sustainable Development Goals (SDGs) were launched at the
United Nations Sustainable Development Summit in New York in
September 2015, forming the 2030 Agenda for Sustainable
Development. It has set targets that the countries have to should work
towards and achieve by 2030.
The 17 SDGs have been made with the aim to take care of important
issues facing businesses, governments and society

65. Sustainable Development Initiatives
MrAshwathHedge found an eco-friendly alternative. He
made a 100 per cent bio-degradable bag which can dissolve
in hot water and decompose in natural environment.
Narayana Peesapatymade edible cutlery made out of a
grain —these spoons can be eaten and even if they are not
eaten they will easily decompose

66. Sustainable Processes
Some practices, such as organic farming, vermi-composting and
rainwater harvesting are being used to help preserve the
environment.
Organic farming is where farmers do not use chemical pesticides
and fertilisersto increase their production. They use organic and
natural fertilisers, such as cow dung to help in growing crops. This
helps in better quality chemical free crops while at the same time
maintaining the soil quality for future use

67. Session 2: Our Role in Sustainable Development
Our Role in Sustainable Development
Quality Education
We should
1. use the facilities present in our areas.
2. take our friends to school.
3. help friends study.
4. stop friends from dropping out of school.
Clean Water and Sanitation
We must make efforts to make India free of open defecation by building toilets and
creating awarenesstowards sanitation.
One initiative was taken by Ministry of Railways in Varanasi and Raibareilly
where they introduced clay pots ‘Kulhads’ to replace plastic and paper
cups and to bring back taste of tradition

68. Affordable and Clean Energy
Using solar power i.e., power generated using the sun does not cause pollution as it
does not require burning of non-renewable fuels, such as coal.
Decent Work and Economic Growth
We can
(a) study and find good jobs to take care of ourselves and our families.
(b) work hard and contribute to society.
(c) learn and develop skills so that we get add value in our community.
Reduced Inequalities
To reduce inequalities we can
1. be helpful to one another.
2. be friendly with everyone.
3. include everyone while working or playing.
4. help others by including everyone whether they are small or big, girl or boy, belong
to any class or caste.

69. Sustainable Cities and Communities
Creating Sustainable Cities
1. Save energy by switching off lights and fans when not in use.
2. Use natural light as much as possible.
3. Use energy-efficient lights (LED bulbs) and appliances.
Responsible Consumers and Producers
We can become responsible about our own environment by
1. reusing paper, glass, plastic, water, etc.
2. taking cloth bags to market carrying fruits and vegetables.
3. donate things we do not use such as clothes, books, furniture, food, etc.
4. Repair leaking taps and pipes to avoid wasting water.
Protect Life Below Water
Tons of plastic is found in the seas, which is killing marine life. Protecting marine life, saving our oceans
from pollution is necessary to preserve the marine life.
Protect Life on Land
Cutting of trees is leading to soil erosion and making land dry and unusable for cultivation. Planting more
tree to replace the ones that we have cut is an important step towards sustainable development.

70. PLATINUM CLASSES
www.crackmycbse.com
Learn Simple| Learn Easy
For more visit to www.crackmycbse.com