Page 6 - Plus_V2.2_C7_Flipbook
P. 6

INSIDE THE SERIES



                  The key features of the series have been designed to ensure better learning and assessment.



                    Learning Resources




                        1      Number System                                                   3     Advanced Features
                                                    Let's Surf provides                                  of Excel
                       Let’s surf
                         Number System             an overview of the
                                  Decimal to Binary Conversion
                         Binary to Decimal Conversion
                                  Operations on Binary Numbers                               Let’s surf    Filtering Data
                                                     chapter contents.                          Sorting Data
                                                                                                Conditional Formatting
                      Let’s PLug-in
                      Solve the following sums. Also note the time you took to solve each of them.
                      1.   345678 – 789 =    _______             (Time taken to solve: _______)  Let’s PLug-in
                      2.  567 x 55 =       _______                 (Time taken to solve: _______)  State whether these statements are True or False.   __________
                      3.  100 x 9 + 890 – 67 =   _______                                      1.   Area chart displays the data trends over a period of time.   __________
                                 (Time taken to solve: _______)                                                   __________
                                                                                              3.   Plot area contains the actual chart and its other components.
                      4.  22/11 + 20 – 4 x 2 =   _______       (Time taken to solve: _______)  2.   A chart helps us to represent data pictorially.   __________
                                                                                              4.   Excel provides eight categories of charts.
                      Do you know how computer solves these sums and how quickly it does it? Let's find out in this chapter.
                                                                                              In the previous chapter, you have learned about different types of charts in Excel. In this chapter you
                     A computer takes data from a user and produces result as information. Although the words data
                     and information are often used interchangeably, but there is an important distinction between the
                     information.                                                             are going to learn how to sort and filter data. You will also learn about conditional formatting.
                     two words. In the strict sense, data consists of the raw numbers that computers organise to produce
                                                                                                SORTING DATA
                     From an early age, we are introduced to the concept of numbers and counting. Toddlers learn at an
                                                                                              to organise the data in ascending or descending order. Excel allows you to sort both numeric and
                                                               Let's Plug-in links back to    Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data means
                     early age that they can carry two cookies, one in each hand. Kindergarteners start counting by twos
                                                                                              textual data. You can sort the data according to a particular column as well as a range of data. To sort
                     and fives. Invariably, we use the decimal number system. Our number system is based on 10, most
                     likely because we have 10 fingers. Let us learn more about the number system.
                                                               previous knowledge before      Step 1:  Select a column or range of data to be sorted. In this case, we have selected the range
                              Tech Fact                                                       data, follow these steps:
                                                                                                 A3:D8.
                      numeral system.                                                          Step 2:  Click on the Sort & Filter command from Editing group under the Home tab. A dropdown
                     •   The numerical digits, we use today, i.e., 1, 2 and 3 are based on the Hindu-Arabic
                                                                   starting the lesson.          list appears.
                                                                                               Step 3:  Click on the Sort A to Z (for text) and Sort Smallest to Largest (for numbers) to sort the
                     •   Different names for the number 0 include zero, nought, naught, nil, zilch and zip.
                                                                                                 data in ascending order.
                                       Number System  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   Factopedia
                                                                                                        In Hospitals
                   are 10 number keys.  *  (  )   provides a tip     excitement to learning           Doctors  use computers to
                         ! 1  @ 2  # 3  $ 4  % 5  ^ 6  & 7  8  9  0                                  create  and study  medical
                   On a keyboard, there are two sets of number keys. One set is above the alphabet   to help the   by providing some   reports of the patients.
                   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
                                                                                              was very big in
                   is on.  Num  Lock  /  *  –  Tech Hint  students in the   more interesting   The first computer
                                                                                              size, almost the
                         7  8  Pg Up 9                                    information.        size of a room.
                         Home  +  To activate the      lab.
                         4  5  6  numeric keypad:   Num Lock                                                   In Shops

                         1  2  Pg Dn 3  Num Lock key                                                         Shopkeepers use
                         End  Enter                                                          Charles Babbage   computers to create bills
                              0 Ins  Del .      Tech Fact presents                            is known as    and maintain records of
                                                                                              the father of   the items in the shop.
                      Spacebar Key
                    Spacebar key is used to give a blank spaces when we type words, letters or   a fact about    computer.
                    numbers. It is the longest key on the keyboard.
                                                     the topic.                                       Let’s Back-Up
                                      my school                                                     Ÿ   Things made  by  man are called  man-made
                      myschool  Spacebar key
                                                                                                     things.
                                                                                                    natural things.
                                                                                            Shakuntala Devi
                                                                                                    Ÿ   Things that  are created  naturally are called
                                                                                            was an Indian   Ÿ   Machines make our work easier.
                                                                                           writer and mental
                                                                                                   Ÿ  Computer is a very useful machine.
                           Tech Fact                                                       calculator, known   Ÿ   We can do many things on the computer like
                                                                                            as  the "Human
                     When we type, we see a blinking line on the screen.                    Computer".   letters, etc.
                     It is called the Cursor.
                                                                                                    solve  sums,  play games, listen to music, type
                                   Cursor
                                     The Keyboard and The Mouse  25
                                                                                          14  Touchpad PLUS (Version 2.1)-I
                                                                              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.
                                                                                         Introduction to Artificial Intelligence
                                                                                                69
                                        61
                                  Reasoning and Critical Thinking
   1   2   3   4   5   6   7   8   9   10   11