Page 6 - Plus_V2.2_C6_Flipbook
P. 6
INSIDE THE SERIES
The key features of the series have been designed to ensure better learning and assessment.
Learning Resources
1 Computer Networking 3 Advanced Features
Let's Surf provides of Excel
Let’s surf
Computer Network an overview of the
Need for Computer Network
Advantages of Computer Network
Network Terminologies Components of a Network Let’s surf
Types of Networks Devices Required for a Network Filtering Data
Network Architecture Topology chapter contents. Sorting Data
Protocol Wireless Networking Technology Conditional Formatting
Let’s PLug-in Let’s PLug-in __________
State whether these statements are True or False.
Write any four methods of communication that you can think of. 1. Area chart displays the data trends over a period of time. __________
__________
1. __________________________ 2. A chart helps us to represent data pictorially. __________
2. __________________________ 3. Plot area contains the actual chart and its other components.
3. __________________________
4. __________________________ 4. Excel provides eight categories of charts.
In the previous chapter, you have learned about different types of charts in Excel. In this chapter you
are going to learn how to sort and filter data. You will also learn about conditional formatting.
The process of connecting computers and peripheral devices with each other, so that they can
exchange data is called computer networking. Various hardware devices, protocols and software
are required for networking. In this chapter you are going learn about networking and the concepts
related to computer networking.
SORTING DATA
COMPUTER NETWORK Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data means
Let's Plug-in links back to to organise the data in ascending or descending order. Excel allows you to sort both numeric and
textual data. You can sort the data according to a particular column as well as a range of data. To sort
A computer network is a group of interconnected computer systems and other computing devices.
There are different kinds of computer networks that work in different ways. Networks may be very
data, follow these steps:
previous knowledge before Step 1: Select a column or range of data to be sorted. In this case, we have selected the range
small and simple or they may be complex as a global network like the Internet. There may be wired
or wireless connection between computers on the network.
A3:D8.
The computers on the network can communicate with each other as well as work independently.
starting the lesson. Step 2: Click on the Sort & Filter command from Editing group under the Home tab. A dropdown
Each computer in a network is called a node. The computers in the network maybe linked through a
Step 3: Click on the Sort A to Z (for text) and Sort Smallest to Largest (for numbers) to sort the
cable, hub, switch, NIC (Network Interface Card), modem or router.
list appears.
data in ascending order.
Computer Networking
7
Touchpad PLUS (Version 2.1)-VII
26
Number Keys
Number keys are used to type numbers. We also call them numeric keys. There Tech Hint Factopedia adds
are 10 number keys. * ( ) provides a tip excitement to learning Factopedia • POP3 - Post Office Protocol Version 3: It is an Internet standard
! 1 @ 2 # 3 $ 4 % 5 ^ 6 & 7 8 9 0 from an e-mail server.
On a keyboard, there are two sets of number keys. One set is above the alphabet to help the by providing some • IMAP - Internet Message Access Protocol: It is an e-mail protocol
protocal that allows e-mail clients to retrieve e-mail messages
keys. The other set is on the right side of the keyboard. This set is also called
Num
Numeric keypad. The numeric keypad works only when the Num Lock key
Lock
that stores e-mail messages on a mail server and allows the user
from their computer.
to view, access and manipulate the messages on the mail server
ICANN is an
is on. Num Lock / * – Tech Hint students in the more interesting organisation that • SMTP - Simple Mail Transfer Protocol: It is an e-mail protocol for
sending e-mail messages across the Internet.
7 8 Pg Up 9 information. keeps track of all the
IP addresses of all
Home + To activate the lab. the websites on the Let’s CatCh Up
4 5 6 numeric keypad: Num Lock Internet. Write the full forms of the following:
1 2 Pg Dn 3 Num Lock key
End Enter 2. IMAP-
1. HTTPS- __________________________________________
0 Ins Del . Tech Fact presents 3. FTP- __________________________________________
Spacebar Key
Spacebar key is used to give a blank spaces when we type words, letters or a fact about 4. TCP/IP- __________________________________________
__________________________________________
numbers. It is the longest key on the keyboard. approximately 61.5%
Of all the traffic
on the Internet,
the topic. is caused by bots and Let’s BaCk-Up
malware.
my school • The computer network means the system of interconnected
computers.
myschool Spacebar key • The components needed for a network are Network
cable and gateway.
Interface Card, hub or a switch, router, modem, networking
and WAN.
• The different types of networks are PAN, CAN, LAN, MAN
tree, ring and mesh.
If, for any reason,
the Internet shuts • Various types of topologies used in a network are bus, star,
Tech Fact down, approximately • There are two types of computer network architectures—
When we type, we see a blinking line on the screen. and 3 billion Google • In a wireless networking technology, no wires or physical
200 million email
peer-to-peer network and client-server network.
It is called the Cursor. searches will have to • Protocol is a set of rules that governs the communication
media is used for connecting computers.
wait.
Cursor between the computers over a network.
The Keyboard and The Mouse 25 18 Touchpad PLUS (Version 2.1)-VIII
8
7 Introduction to Artificial Let's Back-Up
Intelligence
Reasoning and Critical
Thinking
Let’s surf provides a summary
Ø Natural and Artificial Things
Ø Natural Intelligence
Ø Artificial Intelligence
Let’s surf of the chapter for
Ø Shapes
Ø Pattern Let’s PLug-in
Ø Word Search quick recapitulation.
Critical Thinking
Circle the things that are made by human beings.
Let’s PLug-in
Experiential Learning Special Chapter on
Colour the shapes as per the given hints to complete the picture.
(Hints)
= Blue
Computational Thinking
= Green
and Artificial Intelligence.
= Yellow When you look around, you may see many things. Some of these are made by human,
while others are found in nature. Let us find out more about them.
= Purple
shape. NATURAL AND ARTIFICIAL THINGS
The given figure is made up of different shapes. Let us learn about each
artificial.
SHAPES
When you look around yourself, you may find two types of objects— natural and
sun, flowers, etc.
Things that are found naturally are known as natural things. For example, trees,
You have often observed various objects and wonder as to what shape they are
made up of. Let us discuss about some of the basic shapes.
69
Introduction to Artificial Intelligence
61
Reasoning and Critical Thinking

