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
   1   2   3   4   5   6   7   8   9   10   11